deitydb: entity_citations: 1 row where entity_id = "ENT_GOE

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_GOE_VASSAGO"

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_GOE_VASSAGO_GOET	Vassago ENT_GOE_VASSAGO	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 Vassago	The Third Spirit is a Mighty Prince, being of the same nature as Agares. He is called Vassago. This Spirit is of a Good Nature, and his office is to declare things Past and to Come, and to discover all things Hid or Lost. And he governeth 26 Legions of Spirits, and this is his Seal. (4.) SAMIGINA, or GAMIGIN.—The Fourth Spirit is Samigina, a Great Marquis.	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]);