entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_POETRY"

✎ 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_POETRY_THEOG Poetry ENT_POETRY Hesiod, Theogony and Works and Days SRC_HESIOD_THEOGONY Hesiod, Theogony lines 75-103 These things, then, the Muses sang who dwell on Olympus, nine daughters begotten by great Zeus, Cleio and Euterpe, Thaleia, Melpomene and Terpsichore, and Erato and Polyhymnia and Urania and Calliope, who is the chiefest of them all, for she attends on worshipful princes: whomsoever of heaven-nourished princes the daughters of great Zeus honour, and behold him at his birth, they pour sweet dew upon his tongue, and from his lips flow gracious words. 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

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