entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_GOE_MALPHAS"

✎ 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_GOE_MALPHAS_GOET Malphas ENT_GOE_MALPHAS 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 Malphas The Thirty-ninth Spirit is Malphas. He appeareth at first like a Crow, but after he will put on Human Shape at the request of the Exorcist, and speak with a hoarse Voice. He is a Mighty President and Powerful. He can build Houses and High Towers, and can bring to thy Knowledge Enemies' Desires and Thoughts, and that which they have done. He giveth Good Familiars. 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

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