entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_LETO"
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_LETO_THEOG | Leto ENT_LETO | Hesiod, Theogony and Works and Days SRC_HESIOD_THEOGONY | Hesiod, Theogony | lines 404-452 | Again, Phoebe came to the desired embrace of Coeus. Then the goddess through the love of the god conceived and brought forth dark-gowned Leto, always mild, kind to men and to the deathless gods, mild from the beginning, gentlest in all Olympus. Also she bare Asteria of happy name, whom Perses once led to his great house to be called his dear wife. And she conceived and bare Hecate whom Zeus the son of Cronos honoured above all. | 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]);