entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_PHO_MELQART"

✎ 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_PHO_MELQART_HDT Melqart ENT_PHO_MELQART Herodotus, Histories (c. 430 BCE) SRC_HERODOTUS_HISTORIES Herodotus, Histories Book 2.44 I moreover, desiring to know something certain of these matters so far as might be, made a voyage also to Tyre of Phenicia, hearing that in that place there was a holy temple of Heracles; and I saw that it was richly furnished with many votive offerings besides, and especially there were in it two pillars, 47 the one of pure gold and the other of an emerald stone of such size as to shine by night: 48 and having come to speech with the priests of the god, G. C. Macaulay 1890 https://www.gutenberg.org/ebooks/2707 primary-verbatim Herodotus reports foreign cults via Greek interpretatio (a Greek observer, not an insider source). 2026-06-17 deterministic verbatim extraction by book.chapter + substring gate (Gutenberg #2707/#2456) 1 0    

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]);