entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_AMPHITRITE"
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_AMPHITRITE_HOMER_ | Amphitrite ENT_AMPHITRITE | 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, Odyssey | Homer, Odyssey | On the one hand there are some overhanging rocks against which the deep blue waves of Amphitrite beat with terrific fury; the blessed gods call these rocks the Wanderers. Here not even a bird may pass, no, not even the timid doves that bring ambrosia to Father Jove, but the sheer rock always carries off one of them, and Father Jove has to send another to make up their number; no ship that ever yet came to these rocks has got away again, but the waves and w | Samuel Butler | 1900 | https://www.gutenberg.org/ebooks/1727 | 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.0135 |
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]);