entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_WEL_GOFANNON"

✎ 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_GOFANNON_MABINO Gofannon ENT_WEL_GOFANNON The Mabinogion SRC_MABINOGION The Mabinogion The Mabinogion And the blow whereby he came to his death, was struck by his uncle Govannon. The third fatal blow was it called. As Gwydion lay one morning on his bed awake, he heard a cry in the chest at his feet; and though it was not loud, it was such that he could hear it. Then he arose in haste, and opened the chest: and when he opened it, he beheld an infant boy stretching out his arms from the folds of the scarf, and casting it aside. 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]);