entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_JM_BARATTIEL"

✎ 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_BARATTIEL_3EN Barattiel ENT_JM_BARATTIEL 3 Enoch / Sefer Hekhalot SRC_3_ENOCH 3 Enoch (The Hebrew Book of Enoch) 3 Enoch And Barattiel, the great prince, when he sees HAMON, the great prince, the fearful and honoured, pleasant and terrible one who maketh all the children of heaven to tremble, when the time draweth nigh (that is set) for the saying of the '(Thrice) Holy', as it is written (Isa. Hugo Odeberg 1928 https://archive.org/details/HebrewBookOfEnochenoch3 primary-verbatim   2026-06-25 name-anchored + substring gate against Odeberg 3 Enoch 1 1 Located by name in 3 Enoch (Odeberg); verify the chapter.  

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