entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_CEL_MACHA"

✎ 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_CEL_MACHA_CATHMA Macha ENT_CEL_MACHA 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 (The Second Battle of Mag Tuired) p.61 Then Nuadu Silverhand and Macha the daughter of Ernmas fell at the hands of Balor grandson of Net. Casmael fell at the hands of Ochtriallach son of Indech. Lug and Balor of the piercing eye met in the battle. The latter had a destructive eye which was never opened except on a battlefield. Four men would raise the lid of the eye by a polished ring in its lid. Whitley Stokes 1891 https://celt.ucc.ie/published/T300010.html primary-verbatim   2026-06-18 name-anchored (note-keyword scored) + substring gate; locus per attestation 1 1 Located by name; 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]);