entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_ASIA"
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_ASIA_THEOG | Asia ENT_ASIA | Hesiod, Theogony and Works and Days SRC_HESIOD_THEOGONY | Hesiod, Theogony | lines 346-370 | Also she brought forth a holy company of daughters who with the lord Apollo and the Rivers have youths in their keeping-to this charge Zeus appointed them-Peitho, and Admete, and Ianthe, and Electra, and Doris, and Prymno, and Urania divine in form, Hippo, Clymene, Rhodea, and Callirrhoe, Zeuxo and Clytie, and Idyia, and Pasithoe, Plexaura, and Galaxaura, and lovely Dione, Melobosis and Thoe and handsome Polydora, Cerceis lovely of form, and soft eyed | Hugh G. Evelyn-White | 1914 | https://www.gutenberg.org/ebooks/348 | primary-verbatim | 2026-06-17 | deterministic verbatim extraction + substring gate (Gutenberg #348, line-numbered) | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);