deitydb: entity_citations: 1 row where entity_id = "ENT_CHR

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_CHR_CHERUBIM"

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_CHR_CHERUBIM_DIONYS	Cherubim ENT_CHR_CHERUBIM	Pseudo-Dionysius, Celestial Hierarchy SRC_PSEUDO_DIONYSIUS_CELESTIAL_HIERARCHY	Pseudo-Dionysius, The Celestial Hierarchy	Pseudo-Dionysius, The Celestial Hierarchy	Concerning the Seraphim and Cherubim and Thrones, and concerning their first Hierarchy. SECTION I. WE, whilst admitting this as the arrangement of the holy Hierarchies, affirm, that every appellation of the celestial Minds denotes the Godlike characteristic of each; and those who know Hebrew affirm, that the holy designation of the Seraphim denotes either that they are kindling or burning; and that of Che rubim, a fulness of knowledge or stream of wisdom.	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]);