entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_JM_SHALGIEL"

✎ View and edit SQL

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_SHALGIEL_ENOCH3 Shalgiel ENT_JM_SHALGIEL 3 Enoch / Sefer Hekhalot SRC_3_ENOCH 3 Enoch (The Hebrew Book of Enoch) Enoch 14 amiel who is appointed over the thunders, Ra‘ashiel who is appointed over the earthquake, Shalgiel who is appointed over the 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, | 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

CSV options: 

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]);