deitydb: entity_citations: 1 row where entity_id = "ENT

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_ACASTE"

descending

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_ACASTE_CAT	Acaste ENT_ACASTE	Hesiod, Theogony and Works and Days SRC_HESIOD_THEOGONY	Hesiod, Theogony	Theogony 346-366	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 Pluto, Perseis, Ianeira, Acaste, Xanthe, Petraea the fair, Menestho, and Europa, Metis, and Eurynome, and Telesto saffron-clad, Chryseis and Asia and charming Calypso, Eudora, and Tyche, Amphirho, and Ocyrrhoe, and Styx who is the chiefest of them all.	Hugh G. Evelyn-White	1914	https://www.gutenberg.org/ebooks/348	primary-verbatim		2026-06-26	name + substring gate against Evelyn-White Theogony (Gutenberg #348)	1	1	Named in the catalogue; verify the line/stanza.

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