entity_citations
Data license: MIT · Data source: jebboone/deitydb
2 rows where entity_id = "ENT_REN_OCH"
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_OCH_DAVIDSON | Och ENT_REN_OCH | 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. "Och" | Och gives 600 years of perfect health (if, that is, the invocant lives that long). Och is also ruler of 28 of the 196 Olympian provinces in which Heaven is divided. | secondary | Davidson's entry on the Olympic spirit of the Sun. | 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_OCH_SEC | Och ENT_REN_OCH | 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 20) | 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]);