entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_WEL_TEYRNON"
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_TEYRNON_MABINO | Teyrnon ENT_WEL_TEYRNON | The Mabinogion SRC_MABINOGION | The Mabinogion | The Mabinogion | Kulvanawyd the son of Goryon, and Llenlleawg Wyddel from the headland of Ganion, and Dyvynwal Moel, and Dunard king of the North, Teirnon Twryf Bliant, and Tegvan Gloff, and Tegyr Talgellawg, Gwrdinal the son of Ebrei, and Morgant Hael, Gwystyl the son of Rhun the son of Nwython, and Llwyddeu the son of Nwython, and Gwydre the son of Llwyddeu (Gwenabwy the daughter of [Kaw] was his mother, Hueil his uncle stabbed him, and hatred was between Hueil and Arthu | 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]);