entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_KOUROTROPHOS"
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_KOUROTROPHOS_HH | Kourotrophos ENT_KOUROTROPHOS | Homeric Hymns (7th-5th century BCE); trans. M.L. West, Homeric Hymns (Loeb Classical Library 496, Harvard 2003) SRC_HOMERIC_HYMNS | Homeric Hymn 30 | lines 1-16 | I will sing of well-founded Earth, mother of all, eldest of all beings. She feeds all creatures that are in the world, all that go upon the goodly land, and all that are in the paths of the seas, and all that fly: all these are fed of her store. Through you, O queen, men are blessed in their children and blessed in their harvests, and to you it belongs to give means of life to mortal men and to take it away. | 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
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]);