entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_AGANIPPE"
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_AGANIPPE_PAUS | Aganippe ENT_AGANIPPE | 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 | Book 9, ch. 29.5 | And at Helicon, on the left as you go to the grove of the Muses, is the fountain Aganippe. Aganippe was they say the daughter of Termesus, the river which flows round Helicon, and, if you go straight for the grove, you will come to an image of Eupheme carved in stone. She is said to have been the nurse of the Muses. | A. R. Shilleto | 1886 | https://www.gutenberg.org/ebooks/68946 | primary-verbatim | 2026-06-17 | book.chapter located + name-anchored in chapter + substring gate (Gutenberg #68946/#68680); section-level locus per attestation — audit pending | 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]);