deitydb: entity_citations: 1 row where entity_id = "ENT_LAT

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_LAT_ORNIAS"

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_ORNIAS_TESTSO	Ornias ENT_LAT_ORNIAS	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	And behold, when the Temple of the city of Jerusalem was being built, and the artificers were working thereat, Ornias the demon came among them toward sunset; and he took away half of the pay of the chief-deviser's (?) 1 little boy, as well as half his food. He also continued to suck the thumb of his right hand every day. And the child grew thin, although he was very much loved by the king. 1. 3.	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]);