entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_ORESTES"

✎ 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_ORESTES_HOMER_ Orestes ENT_ORESTES 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 See what a good thing it is for a man to leave a son behind him to do as Orestes did, who killed false Aegisthus the murderer of his noble father. You too, then-for you are a tall smart-looking fellow-show your mettle and make yourself a name in story." "Nestor son of Neleus," answered Telemachus, "honour to the Achaean name, the Achaeans applaud Orestes and his name will live through all time for he has avenged his father nobly. 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

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