deitydb: entity_citations: 1 row where entity_id = "ENT_GOE

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_GOE_ORIAS"

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_ORIAS_GOET	Orias ENT_GOE_ORIAS	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 Orias	The Fifty-ninth Spirit is Oriax, or Orias. He is a Great Marquis, and appeareth in the Form of a Lion, riding upon a Horse Mighty and Strong, with a Serpent's Tail; and he holdeth in his Right Hand two Great Serpents hissing. His Office is to teach the Virtues of the Stars, and to know the Mansions of the Planets, and how to understand their Virtues.	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]);