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. Richmond Lattimore (Iliad, Univ. of Chicago 1951) and trans. Emily Wilson (Odyssey, Norton 2017) 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]);