entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_WEL_GWYTHYR"
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_GWYTHYR_MABINO | Gwythyr ENT_WEL_GWYTHYR | The Mabinogion SRC_MABINOGION | The Mabinogion | The Mabinogion | on of Eri." A little while before this, Creiddylad the daughter of Lludd Llaw Ereint, and Gwythyr the son of Greidawl, were betrothed. And before she had become his bride, Gwyn ap Nudd came and carried her away by force; and Gwythyr the son of Greidawl gathered his host together, and went to fight with Gwyn ap Nudd. But Gwyn overcame him, and captured Greid the son of Eri, and Glinneu the son of Taran, and Gwrgwst Ledlwm, and Dynvarth his son. | 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]);