entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_PERSEUS"
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_PERSEUS_HOMER | Perseus ENT_PERSEUS | 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 | Iliad | Iliad XIV.319-320 | Never yet have I been so overpowered by passion neither for goddess nor mortal woman as I am at this moment for yourself-not even when I was in love with the wife of Ixion who bore me Pirithous, peer of gods in counsel, nor yet with Danae the daintily-ancled daughter of Acrisius, who bore me the famed hero Perseus. | Samuel Butler | 1898 | https://www.gutenberg.org/ebooks/2199 | primary-verbatim | 2026-06-17 | quote is a verbatim substring of the PD text; located within the cited book by name-anchor + substring gate | 1 | 1 | English prose translation auto-located within the cited Book by name-match; the locus is the Greek line-numbering — consult the original (linked). | https://www.perseus.tufts.edu/hopper/text?doc=Perseus:text:1999.01.0133 |
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]);