entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_BOREAS"
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_BOREAS_HOMER_ | Boreas ENT_BOREAS | 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 | Homer, Iliad | Homer, Iliad | haeans, but waves do not thunder on the shore more loudly when driven before the blast of Boreas, nor do the flames of a forest fire roar more fiercely when it is well alight upon the mountains, nor does the wind bellow with ruder music as it tears on through the tops of when it is blowing its hardest, than the terrible shout which the Trojans and Achaeans raised as they sprang upon one another. | Samuel Butler | 1898 | https://www.gutenberg.org/ebooks/2199 | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | English prose translation located by name; locus is the Greek line-numbering — consult the original. | https://www.perseus.tufts.edu/hopper/text?doc=Perseus:text:1999.01.0133 |
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]);