deitydb: entity_citations: 1 row where entity_id = "ENT_CEL

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_CEL_CREDNE"

descending

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_CREDNE_CATHMA	Credne ENT_CEL_CREDNE	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)	So with Credne the brazier helping him, Dian Cecht the physician put on him a silver hand that moved as well as any other hand. p.27 Now the Tuatha De Danann lost many men in the battle, including Edleo mac Allai, and Ernmas, and Fiacha, and Tuirill Bicreo. Then those of the Fir Bolg who escaped from the battle fled to the Fomoire, and they settled in Arran and in Islay and in Man and in Rathlin.	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

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