entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_GOE_VUAL"
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_GOE_VUAL_GOET | Vual ENT_GOE_VUAL | The Lesser Key of Solomon (Lemegeton), Book I: Ars Goetia; ed. S. L. MacGregor Mathers & Aleister Crowley (1904) SRC_LEMEGETON | The Lesser Key of Solomon (Ars Goetia) | entry for Vual | The Forty-seventh Spirit is Uvall, or Vual, or Voval. He is a Duke, Great, Mighty, and Strong; and appeareth in the Form of a Mighty Dromedary at the first, but after a while at the Command of the Exorcist he putteth on Human Shape, and speaketh the Egyptian Tongue, but not perfectly. His Office is to procure the Love of Woman, and to tell Things Past, Present, and to Come. | S. L. MacGregor Mathers & A. Crowley | 1904 | https://www.gutenberg.org/ebooks/72679 | primary-verbatim | Early-modern grimoire (the Goetia descriptions); a learned-magic literary tradition, not a mainstream cult. | 2026-06-18 | name-anchored entry extraction + substring gate (Gutenberg #72679) | 1 | 0 |
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]);