entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_GANYMEDE"

✎ 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_GANYMEDE_HOMER Ganymede ENT_GANYMEDE 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 XX.231-235 as the most beautiful o Erichthonius begat Tros, king of the Trojans, and Tros had three noble sons, Ilus, Assaracus, and Ganymede who was comeliest of mortal men; wherefore the gods carried him off to be Jove's cup-bearer, for his beauty's sake, that he might dwell among the immortals. Ilus begat Laomedon, and Laomedon begat Tithonus, Priam, Lampus, Clytius, and Hiketaon of the stock of Mars. 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

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