entity_citations

Data license: MIT · Data source: jebboone/deitydb

2 rows where entity_id = "ENT_JM_ZAPHKIEL"

✎ 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_ZAPHKIEL_2NDRY Zaphkiel ENT_JM_ZAPHKIEL Gustav Davidson, A Dictionary of Angels, Including the Fallen Angels (The Free Press / Macmillan, New York, 1967) SRC_DAVIDSON_ANGELS Gustav Davidson, A Dictionary of Angels, Including the Fallen Angels (The Free Press, 1967), s.v. Zaphkiel per cited entry As Zophiel, is the ruler of the order of cherubim (the rabbinic ophanim.       secondary   2026-06-27 secondary-scholarship excerpt; substring-gated against Davidson Dictionary of Angels OCR; 2-column bleed eyeballed out 3 1 In-copyright reference work — brief attributed excerpt for scholarly identification; verify against the print edition.  
CIT_JM_ZAPHKIEL_SEC Zaphkiel ENT_JM_ZAPHKIEL Zohar SRC_ZOHAR Zohar per cited source         primary-uncited   2026-06-27 Track-2 formalization of the entity's existing source attestation (no verbatim quote — pointer + grade + flag) 2 1 Primary source identified but not yet quoted verbatim; the on-page summary is an editorial paraphrase pending verification against this text.  

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