deitydb: entity_citations: 2 rows where entity_id = "ENT_REN

Data license: MIT · Data source: jebboone/deitydb

2 rows where entity_id = "ENT_REN_PHALEG"

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_REN_PHALEG_DAVIDSON	Phaleg ENT_REN_PHALEG	Gustav Davidson, A Dictionary of Angels, Including the Fallen Angels (The Free Press / Macmillan, New York, 1967) SRC_DAVIDSON_ANGELS	Gustav Davidson, A Dictionary of Angels, Including the Fallen Angels (New York: Free Press, 1967)	s.v. "Phalec (Phaleg)"	Phalec is also the governing spirit of the planet Mars (and hence often referred to, as he is by Cornelius Agrippa, as the war lord). Of the 106 Olympic Provinces, Phalec has dominion over 35.				secondary	Davidson's entry on the Olympic spirit of Mars (headword spelled Phalec).	2026-09-18	full-text extraction (pdftotext, two-column scan); headword entry located and read; only OCR-clean, non-column-bled spans accepted; brief attributed excerpt of the entry's definition (in-copyright dictionary, house precedent SRC_DAVIDSON_ANGELS); contiguous-substring gate passed	3	1	secondary dictionary entry; confirm the entry in the printed Davidson
CIT_REN_PHALEG_SEC	Phaleg ENT_REN_PHALEG	Arbatel de magia veterum (Basel, 1575) — the seven Olympic Spirits SRC_ARBATEL	Arbatel de magia veterum (Basel: Pietro Perna, 1575); Latin text as printed in Joseph H. Peterson (ed./trans.), Arbatel: Concerning the Magic of the Ancients (Lake Worth: Ibis, 2009)	Aphorism 16 (cf. Aphorism 19)	Visibilia autem eorum Astra sunt ARATRON, BETHOR, PHALEG, OCH, HAGITH, OPHIEL, PHVL.				primary-verbatim	Primary attestation: the Arbatel names this Olympic Spirit among the seven visible "stars" (Aphorism 16) and treats it in its own aphorism.	2026-09-18	full-text extraction (pdftotext) of Peterson's parallel edition; the LATIN 1575 text (public domain) is quoted, not Peterson's copyrighted translation; only OCR-clean Latin sentences were accepted (passages with ae->'re' OCR corruption rejected); contiguous-substring gate passed	2	1	Latin primary verbatim; confirm aphorism number against the 1575 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]);