entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_WEL_NISIEN"

✎ 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_NISIEN_MABINO Nisien ENT_WEL_NISIEN The Mabinogion SRC_MABINOGION The Mabinogion The Mabinogion and cause his family to be friends when their wrath was at the highest; and this one was Nissyen; but the other would cause strife between his two brothers when they were most at peace. And as they sat thus, they beheld thirteen ships coming from the south of Ireland, and making towards them, and they came with a swift motion, the wind being behind them, and they neared them rapidly. "I see ships afar," said the king, "coming swiftly towards the land. 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]);