entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_CEL_ELATHA"
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_ELATHA_CATHMA | Elatha ENT_CEL_ELATHA | 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) | They said that it would be appropriate for them to give the kingship to Bres the son of Elatha, to their own adopted son, and that giving him the kingship would knit the Fomorians' alliance with them, since his father Elatha mac Delbaith was king of the Fomoire. Now the conception of Bres came about in this way. | 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]);