entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_WEL_LLWYD"
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_LLWYD_MABINO | Llwyd ap Cil Coed ENT_WEL_LLWYD | The Mabinogion SRC_MABINOGION | The Mabinogion | The Mabinogion | "I am Llwyd the son of Kilcoed, and I cast the charm over the seven Cantrevs of Dyved. And it was to avenge Gwawl the son of Clud, from the friendship I had towards him, that I cast the charm. And upon Pryderi did I revenge Gwawl the son of Clud, for the game of Badger in the Bag, that Pwyll Pen Annwvyn played upon him, which he did unadvisedly in the Court of Heveydd Hen. | 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]);