entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_APOLLO"

✎ 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_APOLLO_HH3 Apollo ENT_APOLLO Homeric Hymns (7th-5th century BCE); trans. M.L. West, Homeric Hymns (Loeb Classical Library 496, Harvard 2003) SRC_HOMERIC_HYMNS Homeric Hymn 3 (To Apollo) lines 1-4 I will remember and not be unmindful of Apollo who shoots afar. As he goes through the house of Zeus, the gods tremble before him and all spring up from their seats when he draws near, as he bends his bright bow. Hugh G. Evelyn-White 1914 https://en.wikisource.org/wiki/Hesiod,_the_Homeric_Hymns_and_Homerica/Hymn_III_(To_Apollo) primary-verbatim   2026-06-17 verbatim web-retrieval from public-domain Loeb edition (Wikisource) 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]);