entity_citations
Data license: MIT · Data source: jebboone/deitydb
2 rows where entity_id = "ENT_REN_PHUL"
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_REN_PHUL_DAVIDSON | Phul ENT_REN_PHUL | 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. "Phul" | Phul (Phuel)-lord of the moon and ruler of 7 of the Olympian Provinces. | secondary | Davidson's entry on the Olympic spirit of the Moon. | 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_PHUL_SEC | Phul ENT_REN_PHUL | 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 23) | 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]);