entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_MAN_JOHN_BAPTIST"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: verified_on (date)

citation_id ▼ entity_id source_id work_title locus quote translator translation_year source_url evidence_grade evidence_note verified_on verify_method display_order needs_review review_reason original_text_url
CIT_MAN_JOHN_BAPTIST_MANDAE John the Baptist ENT_MAN_JOHN_BAPTIST Mandaean Book of John SRC_MANDAEAN_BOOK_JOHN The Mandaean Book of John The Mandaean Book of John Among the mortal figures who grace its pages, pride of place is given to the chief prophet of the Mandaeans, John, son of Zechariah, who is known to Christians as the Baptist. Häberl & McGrath 2020 None primary-verbatim   2026-06-18 name-anchored (note-keyword scored) + substring gate; locus per attestation 1 1 Open-access translation; located by name; verify.  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "entity_citations" (
   [citation_id] TEXT PRIMARY KEY,
   [entity_id] TEXT REFERENCES [entities]([entity_id]),
   [source_id] TEXT REFERENCES [sources]([source_id]),
   [work_title] TEXT,
   [locus] TEXT,
   [quote] TEXT,
   [translator] TEXT,
   [translation_year] INTEGER,
   [source_url] TEXT,
   [evidence_grade] TEXT,
   [evidence_note] TEXT,
   [verified_on] TEXT,
   [verify_method] TEXT,
   [display_order] INTEGER,
   [needs_review] INTEGER,
   [review_reason] TEXT,
   [original_text_url] TEXT
);
CREATE INDEX [idx_entity_citations_source_id]
    ON [entity_citations] ([source_id]);
CREATE INDEX [idx_entity_citations_entity_id]
    ON [entity_citations] ([entity_id]);