entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_HERACLES"

✎ 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_HERACLES_HH Heracles ENT_HERACLES Homeric Hymns (7th-5th century BCE); trans. M.L. West, Homeric Hymns (Loeb Classical Library 496, Harvard 2003) SRC_HOMERIC_HYMNS Homeric Hymn 15 lines 1-8 I will sing of Heracles, the son of Zeus and much the mightiest of men on earth. Alcmena bare him in Thebes, the city of lovely dances, when the dark-clouded Son of Cronos had lain with her. Once he used to wander over unmeasured tracts of land and sea at the bidding of King Eurystheus, and himself did many deeds of violence and endured many; but now he lives happily in the glorious home of snowy Olympus, and has neat-ankled Hebe for his wife. (l. Hugh G. Evelyn-White 1914 https://www.gutenberg.org/ebooks/348 primary-verbatim   2026-06-17 deterministic verbatim extraction + substring gate (Gutenberg #348) 1 0    

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