entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_OPH_SERPENT"
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_OPH_SERPENT_NHC_ME | Serpent ENT_OPH_SERPENT | Nag Hammadi Library SRC_NHC | The Nag Hammadi Scriptures (Meyer, ed.) | The Nag Hammadi Scriptures (Meyer, ed.) | Phoenixes, Water Serpents, and Bulls of Egypt (121, 27–123, 2) When Sophia Zoe saw that the archons of darkness cursed her friends who were like her, she was angry. She came from the first heaven with all her power and chased the rulers from [their] heavens, and she cast them down into the sinful world so that they might dwell there as evil demons upon the earth. | Marvin Meyer et al. | 2007 | None | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | In-copyright modern translation — brief excerpt for identification, located by name; verify 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]);