deitydb: entity_citations: 1 row where entity_id = "ENT_SET

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_SET_YABEL"

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_SET_YABEL_NHC	Yabel ENT_SET_YABEL	Marvin Meyer (ed.), The Nag Hammadi Scriptures: The Revised and Updated Translation of Sacred Gnostic Texts (HarperOne, 2007) SRC_NAG_HAMMADI_SCRIPTURES	The Nag Hammadi Library (Robinson, ed.)	Apocryphon of John, NHC II,1	The fourth one is Yabel. The fifth one is Adonaiou, who is called Sabaoth. The sixth one is Cain, whom the generations of men call the sun. The seventh is Abel. The eighth is Abrisene. The ninth is Yobel. The tenth is Armoupieel. The eleventh is Melceir-Adonein.	J. M. Robinson et al.	1990	http://gnosis.org/naghamm/apocjn.html	primary-verbatim		2026-06-25	name-anchored + substring gate against gnosis.org Robinson NHL text; trimmed to clause/sentence boundary	1	1	In-copyright modern translation - brief excerpt for scholarly identification, located by name; verify against the published 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]);