entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_JM_LAILIEL"
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_JM_LAILIEL_ENOCH3 | Lailiel ENT_JM_LAILIEL | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | 3 Enoch (The Hebrew Book of Enoch) | Enoch 14 | e snow, Matariel who is appointed over the rain, Shimshiel who is appointed over the day, Lailiel who is appointed over the night, Galgalliel who is appointed over the globe of the sun, 'Ophanniel who is appointed over the globe of the moon, Kokbiel who is appointed over the planets, Rahatiel who is appointed over the constellations, | (5) And they all fell prostrate, when they saw me. | Hugo Odeberg | 1928 | https://archive.org/details/ksigaxiienochorthehebrewbookofenoch_202012 | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | OCR scan, located by name; verify chapter against a clean edition. |
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]);