entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_WEL_LLEU_LLAW_GYFFES"

✎ 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_LLEU_LLAW_GYFFES_MABINO Lleu Llaw Gyffes ENT_WEL_LLEU_LLAW_GYFFES The Mabinogion SRC_MABINOGION The Mabinogion The Mabinogion rain? Has it not been drenched By nine score tempests? It bears in its branches Llew Llaw Gyffes!" Then the eagle came down until he was on the lowest branch of the tree, and thereupon this Englyn did Gwydion sing:- "Oak that grows beneath the steep; Stately and majestic is its aspect! Shall I not speak it? That Llew will come to my lap?" And the eagle came down upon Gwydion's knee. 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]);