deitydb: entity_citations: 1 row where entity_id = "ENT_CEL

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_CEL_BALOR"

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_BALOR_CATHMA	Balor ENT_CEL_BALOR	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)	The Tuatha De then made an alliance with the Fomoire, and Balor the grandson of Net gave his daughter Ethne to Cian the son of Dian Cecht. And she bore the glorious child, Lug. The Tuatha De came with a great fleet to Ireland to take it by force from the Fir Bolg. Upon reaching the territory of Corcu Belgatan (which is Conmaicne Mara today), they at once burned their boats so that they would not think of fleeing to them.	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]);