entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_HERMAPHRODITUS"
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_HERMAPHRODITUS_OVIDM | Hermaphroditus ENT_HERMAPHRODITUS | Ovid, Metamorphoses, c. 8 CE SRC_OVID_METAMORPHOSES | Ovid, Metamorphoses | Ovid, Metamorphoses | , becoming jealous of her sister, was transformed into a sun-flower; and how Salmacis and Hermaphroditus had become united into one body. After this, through the agency of Bacchus, the sisters are transformed into bats, and their webs are changed into vines. | Henry T. Riley | 1851 | https://www.gutenberg.org/ebooks/21765 | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | English translation located by name; the locus is the Latin line-numbering — consult the original. | https://www.perseus.tufts.edu/hopper/text?doc=Perseus:text:1999.02.0029 |
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]);