entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_SAINT_MICHAEL_CHR"

✎ View and edit SQL

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_SAINT_MICHAEL_CHR_DIONYS Michael the Archangel ENT_SAINT_MICHAEL_CHR Pseudo-Dionysius, Celestial Hierarchy SRC_PSEUDO_DIONYSIUS_CELESTIAL_HIERARCHY Pseudo-Dionysius, The Celestial Hierarchy The Celestial Hierarchy IX.2 Hence, the Word of God has assigned our Hierarchy to Angels, by naming Michael as Ruler of the Jewish people, and others over other nations. John Parker 1897 https://archive.org/details/theworksofdionys00dionuoft primary-verbatim   2026-07-02 re-source v2.1.59: verbatim substring gate (whitespace-normalized; OCR double-spacing collapsed) against the archive.org scan of Parker 1897, The Works of Dionysius the Areopagite (theworksofdionys00dionuoft), pp. 37-38, fetched 2026-07-01 1 0    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]);