deitydb: entity_citations: 1 row where entity_id = "ENT_LAT

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_LAT_AZAEL"

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_LAT_AZAEL_TESTSO	Azael ENT_LAT_AZAEL	F. C. Conybeare, “The Testament of Solomon,” Jewish Quarterly Review 11 (1898): 1–45 SRC_TESTAMENT_SOLOMON	The Testament of Solomon	The Testament of Solomon	questioned him, and said: "And by what name 1 ?" And he answered: "That of the archangel Azael." And I summoned the archangel Azael, and set a seal on the demon, and commanded him to seize great stones, and toss them up to the workmen on the higher parts of the Temple. And, being compelled, the demon began to do what he was bidden to do. 1. Cp. Acts iv. 7. 34.	F. C. Conybeare	1898	https://www.esotericarchives.com/solomon/testamen.htm	primary-verbatim		2026-06-18	name-anchored (note-keyword scored) + substring gate; locus per attestation	1	1	Conybeare 1898 translation (clean digital edition), located by name; verify the verse number against the 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]);