entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_HTT_ALALU"
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_HTT_ALALU_HITTIT | Alalu ENT_HTT_ALALU | Harry A. Hoffner Jr., Hittite Myths, 2nd ed. (Society of Biblical Literature, 1998) SRC_HOFFNER_HITTITE_MYTHS | Hoffner, Hittite Myths | Hoffner, Hittite Myths | Alalu, driven from his throne by Anu, is the father of Kumarbi, who in turn drives Anu from his throne. Furthermore, when Kumarbi emasculates Anu to forestall his own removal by any descendant of Anu, he inadvertently makes his own belly the womb for Anu's seed, which pro- duces Tessub, Tasmisu, the Aranzah River, and several other gods. | H. A. Hoffner Jr. | 1998 | None | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | In-copyright translation — brief flagged excerpt; verify. |
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]);