entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_ISR_GADREEL"
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_ISR_GADREEL_ENOCH1 | Gadreel ENT_ISR_GADREEL | 1 Enoch SRC_1_ENOCH | The Book of Enoch (1 Enoch) | Enoch 69:6: | And the third was ‘named Gadreel: he it is who showed the children of men all the _ blows of death, and he led astray Eve, and showed [the weapons _of death to the sons of men] the shield and the coat of mail, and | the sword for battle, and all the weapons of death to the children of men. 7. And from his hand they have proceeded against those who dwell on the earth from that day and for evermore. | R. H. Charles | 1912 | https://archive.org/details/bookofenochor1en00char | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | OCR scan, located by name; verify chapter. |
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]);