entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_IRL_MIACH"

✎ 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_IRL_MIACH_CMT Miach ENT_IRL_MIACH Cath Maige Tuired (The Second Battle of Mag Tuired), ed. E. A. Gray (ITS, 1982) SRC_CATH_MAIGE_TUIRED Cath Maige Tuired (The Second Battle of Mag Tuired) Cath Maige Tuired That seemed evil to his son Miach. He went to the hand which had been struck off Dian-cecht , and he said ‘joint to joint of it and sinew to sinew,’ and be healed Nuada in thrice three days and Whitley Stokes 1891 https://celt.ucc.ie/published/T300010.html primary-verbatim   2026-06-26 name + substring gate against Stokes CMT (CELT) 1 1 Named in Cath Maige Tuired (Stokes/CELT); verify section.  

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