entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_HTT_KAMRUSEPA"
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_KAMRUSEPA_HITTIT | Kamrusepa ENT_HTT_KAMRUSEPA | Harry A. Hoffner Jr., Hittite Myths, 2nd ed. (Society of Biblical Literature, 1998) SRC_HOFFNER_HITTITE_MYTHS | Hoffner, Hittite Myths | Hoffner, Hittite Myths | Kamrusepa Myths 33 11. The Voyage of the Immortal Human Soul 33 12. When the Storm God Thunders Frightfully 34 13. Fragments of Myths about Lost and Found Deities 37 HURRIAN MYTHS AO 14. The Song of Kumarbi 42 15. The Song of the God LAMMA A6 16. The Song of Silver A8 17. The Song of Hedammu 50 18. The Song of Ullikummi 55 18a. The Song of Release 65 TALES INVOLVING DEITIES AND MORTALS 81 19. A Tale of Two Cities: Kanesh and Zalpa 81 20. | 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]);