entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_LAT_DECAN_SAPHATHORAEL"
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_LAT_DECAN_SAPHATHORAEL_TESTSO | Saphathorael ENT_LAT_DECAN_SAPHATHORAEL | F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON | The Testament of Solomon | The Testament of Solomon | The twelfth said: "I am called Saphathorael, and I inspire partisanship in men, and delight in causing them to stumble. If any one will write on paper these names of angels, Iaco, Iealo, Ioelet, Sabaoth, Ithoth, Bae, and having folded it up, wear it round his neck or against his ear, I at once retreat and dissipate the drunken fit." 84. The thirteenth said: "I am called Bobel (sic), and I cause nervous illness by my assaults. | F. C. Conybeare | 1898 | https://www.esotericarchives.com/solomon/testamen.htm | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | Conybeare 1898 translation (clean digital edition), located by name; verify the verse number against the edition. |
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]);