entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_CASTOR"

✎ 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_CASTOR_HOMER Castor ENT_CASTOR 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 Odyssey Iliad III.236-244 "And I saw Leda the wife of Tyndarus, who bore him two famous sons, Castor breaker of horses, and Pollux the mighty boxer. Both these heroes are lying under the earth, though they are still alive, for by a special dispensation of Jove, they die and come to life again, each one of them every other day throughout all time, and they have the rank of gods. 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). [book unresolved; located in full work] https://www.perseus.tufts.edu/hopper/text?doc=Perseus:text:1999.01.0133

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