entity_citations

Data license: MIT · Data source: jebboone/deitydb

2 rows where entity_id = "ENT_MAN_SAURIEL"

✎ 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_MAN_SAURIEL_DAVIDSON Sauriel ENT_MAN_SAURIEL 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 (New York: Free Press, 1967) s.v. "Sauriel" Sauriel (Sauriil, Suriel, Sowrill)-an angel of death, so designated in Drower, The Canonical Prayerbook of the Mandaeans, where Sauriel is referred to as "Sauriel the Releaser."       secondary Davidson's entry on the Mandaean angel of death. 2026-09-18 full-text extraction (pdftotext, two-column scan); headword entry located and read; only OCR-clean, non-column-bled spans accepted; brief attributed excerpt of the entry's definition (in-copyright dictionary, house precedent SRC_DAVIDSON_ANGELS); contiguous-substring gate passed 3 1 secondary dictionary entry; confirm the entry in the printed Davidson  
CIT_MAN_SAURIEL_SEC Sauriel ENT_MAN_SAURIEL Ginza Rba SRC_GINZA_RBA Ginza Rba per cited source         primary-uncited     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]);