entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_CEL_INDECH"
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_INDECH_CATHMA | Indech ENT_CEL_INDECH | 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 Fomoire had a warrior named Ochtriallach, the son of the Fomorian king Indech mac De Domnann. He suggested that every single man they had should bring a stone from the stones of the river Drowes to cast into the well Slaine in Achad Abla to the west of Mag Tuired, to the east of Lough Arrow. They went, and every man put a stone into the well. For that reason the cairn is called Ochtriallach's Cairn. | 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]);