entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_TIRESIAS"
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_TIRESIAS_HOMER_ | Tiresias ENT_TIRESIAS | Homer, Iliad and Odyssey (c. 750-675 BCE); trans. Samuel Butler (Iliad 1898; Odyssey 1900; Project Gutenberg #2199/#1727) SRC_HOMER_ILIAD_ODYSSEY | Homer, Odyssey | Homer, Odyssey | You must go to the house of Hades and of dread Proserpine to consult the ghost of the blind Theban prophet Teiresias, whose reason is still unshaken. To him alone has Proserpine left his understanding even in death, but the other ghosts flit about aimlessly.' "I was dismayed when I heard this. | Samuel Butler | 1900 | https://www.gutenberg.org/ebooks/1727 | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | English prose translation located by name; locus is the Greek line-numbering — consult the original. | https://www.perseus.tufts.edu/hopper/text?doc=Perseus:text:1999.01.0135 |
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]);