deitydb: entity_citations: 2 rows where entity_id = "ENT_REN

Data license: MIT · Data source: jebboone/deitydb

2 rows where entity_id = "ENT_REN_ZAZEL"

descending

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_REN_ZAZEL_AGRIPP	Zazel ENT_REN_ZAZEL	Heinrich Cornelius Agrippa, De occulta philosophia libri tres (1533) — incl. the Scale of Seven (Bk II.10) SRC_AGRIPPA_OCCULTA	Agrippa, Three Books of Occult Philosophy	Agrippa, Three Books of Occult Philosophy		J. F. (1651 English)	1651	https://archive.org/details/threebooksofoccu00agri	primary-uncited		2026-06-26	apparatus-cleanup re-point	1	1	Cleared non-primary quote (TOC/index/footnote/title-page bleed); primary source identified, verbatim quote pending.
CIT_REN_ZAZEL_DAVIDSON	Zazel ENT_REN_ZAZEL	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. "Agiel"	According to Paracelsus' doctrine of Talismans, Agiel is the presiding intelligence (i.e., spirit, angel) of the planet Saturn, acting in concert with the spirit Zazel.				secondary	Zazel named as the spirit of Saturn paired with the intelligence Agiel (Davidson's Agiel entry).	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

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