entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_CAERUS"
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_CAERUS_PAUSAN | Caerus ENT_CAERUS | Pausanias, Description of Greece (c. 143-176 CE); trans. W.H.S. Jones (Loeb Classical Library, Harvard 1918-1935) SRC_PAUSANIAS_DESCRIPTION | Pausanias, Description of Greece | Pausanias, Description of Greece | And there are two altars very near the entrance to the race-course, one they say of Hermes the Athlete, and the other of Opportunity. Ion the Chian has I know written an Hymn to Opportunity, in which he traces his genealogy, and makes him the youngest son of Zeus. And near the treasure of the Sicyonians is an altar of Hercules, either one of the Curetes, or the son of Alcmena, for both traditions are current. | A. R. Shilleto | 1886 | https://www.gutenberg.org/ebooks/68946 | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | English translation (A. R. Shilleto, Bohn ed., Gutenberg #68946/#68680) located by name; verify book.chapter. | https://www.perseus.tufts.edu/hopper/text?doc=Perseus:text:1999.01.0159 |
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]);