entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_CHR_PRINCIPALITIES"
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_CHR_PRINCIPALITIES_DIONYS | Principalities ENT_CHR_PRINCIPALITIES | Pseudo-Dionysius, Celestial Hierarchy SRC_PSEUDO_DIONYSIUS_CELESTIAL_HIERARCHY | Pseudo-Dionysius, The Celestial Hierarchy | Pseudo-Dionysius, The Celestial Hierarchy | spects the lowest of the Heavenly Hierarchies, the Order of the Angels and Archangels and Principalities is third. CAPUT VII. Concerning the Seraphim and Cherubim and Thrones, and concerning their first Hierarchy. SECTION I. | John Parker | 1897 | https://archive.org/details/theworksofdionys00dionuoft | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | OCR scan, located by name; verify chapter. |
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]);