entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_WEL_RHIANNON"
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_WEL_RHIANNON_MABINO | Rhiannon ENT_WEL_RHIANNON | The Mabinogion SRC_MABINOGION | The Mabinogion | The Mabinogion | nwen; and concerning the seven years' banquet in Harlech, and the singing of the birds of Rhiannon, and the sojourning of the head for the space of fourscore years. MANAWYDDAN THE SON OF LLYR HERE IS THE THIRD PORTION OF THE MABINOGI When the seven men of whom we spoke above had buried the head of Bendigeid Vran, in the White Mount in London, with its face towards France; Manawyddan gazed upon the town of London, and upon his companions, and heaved a great | Lady Charlotte Guest | 1877 | https://www.gutenberg.org/ebooks/5160 | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | English translation located by name within the work; verify locus. |
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]);