entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_AEOLUS"

✎ 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_AEOLUS_HOMER Aeolus ENT_AEOLUS 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 Odyssey X.1-79 "Thence we went on to the Aeolian island where lives Aeolus son of Hippotas, dear to the immortal gods. It is an island that floats (as it were) upon the sea,83 iron bound with a wall that girds it. Now, Aeolus has six daughters and six lusty sons, so he made the sons marry the daughters, and they all live with their dear father and mother, feasting and enjoying every conceivable kind of luxury. 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]);