entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_WEL_MATH"

✎ View and edit SQL

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_MATH_MABINO Math fab Mathonwy ENT_WEL_MATH The Mabinogion SRC_MABINOGION The Mabinogion The Mabinogion Be thou of glad cheer therefore, and I will compass it." So they went unto Math the son of Mathonwy. "Lord," said Gwydion, "I have heard that there have come to the South some beasts, such as were never known in this island before." "What are they called?" he asked. "Pigs, lord." "And what kind of animals are they?" "They are small animals, and their flesh is better than the flesh of oxen." "They are small, then?" "And they change their names. 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

CSV options: 

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]);