Relationships
Data license: MIT · Data source: jebboone/deitydb
- subject_entity_id
- {'description': 'The entity initiating or holding the relationship'}
- relationship_type
- {'description': 'Typed relationship from the controlled vocabulary (see relationship_types table)'}
- object_entity_id
- {'description': 'The entity receiving or targeted by the relationship'}
- confidence
- {'description': 'high / medium / low / speculative'}
- rationale
- {'description': 'Scholarly justification for the relationship, with source citations'}
- source_id
- {'description': 'Primary source justifying this relationship'}
- period_id
- {'description': 'Historical period in which this relationship is attested (null = all periods)'}
8 rows where object_entity_id = "ENT_GNO_SOPHIA"
This data as json, CSV (advanced)
Suggested facets: subject_entity_id, relationship_type, confidence, source_id, period_id
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 647 | Achamoth ENT_VAL_ACHAMOTH | identified_with | Sophia ENT_GNO_SOPHIA | high | Achamoth is the lower Sophia in Valentinian myth. | Bentley Layton, The Gnostic Scriptures SRC_LAYTON_GNOSTIC | reviewed | |
| 1447 | Shekhinah ENT_JM_SHEKHINAH | reception_of | Sophia ENT_GNO_SOPHIA | medium | Shekhinah as possible reception of the Gnostic Sophia's exiled-feminine-divine structure; exile/fall and longing for restoration are shared narrative elements. | Gershom Scholem, Kabbalah SRC_SCHOLEM_KABBALAH | reviewed | Jewish Mystical Medieval PER_JM_MEDIEVAL |
| 2410 | Spenta Armaiti ENT_ZOR_SPENTA_ARMATI | aligned_with | Sophia ENT_GNO_SOPHIA | medium | Spenta Armaiti ("Holy Devotion" / "Bounteous Piety") is the sole feminine Amesha Spenta — described as the daughter of Ahura Mazda in Yasna 45.4, governing the domains of earth (her physical correlate), piety, and holy devotion. She represents the divine feminine principle within the Zoroastrian divine emanation structure, combining wisdom-as-devotion with earth-mother function. Gnostic Sophia ("Wisdom") is the supreme feminine divine aeon in both Valentinian and Sethian Gnostic cosmologies (Apocryphon of John, NHC II,1; Trimorphic Protennoia, NHC XIII,1): the last of the Pleroma aeons in Valentinianism, whose unsanctioned creative act precipitates material creation; the divine mother figure whose consort/fall is cosmogonically central. The alignment is grounded in their shared status as the feminine divine wisdom/devotion figure within an emanatory divine hierarchy (Ahura Mazda → 6 Amesha Spentas; Supreme Father → 30 aeons). Confidence medium: the parallel is structural/typological; the Gnostic Sophia's role is more cosmogonically catastrophic than Spenta Armaiti's, and the traditions developed independently. Layton, The Gnostic Scriptures (1987) pp. 267-303; Boyce (1982) p. 71. | Nag Hammadi Library SRC_NHC | reviewed | Gnostic and Neoplatonic (2nd–4th c.) PER_GNO_2ND_4TH |
| 2438 | Yaldabaoth ENT_GNO_YALDABAOTH | opposes | Sophia ENT_GNO_SOPHIA | medium | Yaldabaoth, as the product of Sophia's/Achamoth's imperfect creation, is structurally opposed to Sophia throughout the Gnostic cosmological drama: Sophia's divine spark (pneuma) is trapped within the material creation that Yaldabaoth rules, and the task of the Gnostic savior is to release this pneuma from Yaldabaoth's material prison. In Sethian texts (Apocryphon of John, NHC II,1; Hypostasis of the Archons, NHC II,4), Yaldabaoth's rule is the antagonist to Sophia's redemptive movement. Confidence medium: the relationship is structural/thematic throughout Gnostic cosmology; the specific narrative interactions vary by text. | Nag Hammadi Library SRC_NHC | reviewed | Gnostic and Neoplatonic (2nd–4th c.) PER_GNO_2ND_4TH |
| 2595 | Yaldabaoth ENT_GNO_YALDABAOTH | emanates_from | Sophia ENT_GNO_SOPHIA | high | Sophia brings forth Yaldabaoth alone, without her consort or the Spirit's consent; he is her malformed offspring. | Apocryphon of John (The Secret Book of John), NHC II,1 / III,1 / IV,1 and BG 8502,2; c. 2nd c. CE, Egypt SRC_APOCRYPHON_JOHN | reviewed | Gnostic and Neoplatonic (2nd–4th c.) PER_GNO_2ND_4TH |
| 2617 | Pistis Sophia ENT_PS_PISTIS_SOPHIA | identified_with | Sophia ENT_GNO_SOPHIA | high | Pistis Sophia is the Askew Codex form of the Gnostic aeon Sophia. | Pistis Sophia (Askew Codex), c. 3rd-4th c. CE, Egypt SRC_PISTIS_SOPHIA | reviewed | Gnostic and Neoplatonic (2nd–4th c.) PER_GNO_2ND_4TH |
| 2637 | Helena (Ennoia) ENT_SIM_HELENA | aligned_with | Sophia ENT_GNO_SOPHIA | high | The fallen, imprisoned, and redeemed Helena/Ennoia is the earliest form of the fallen-Wisdom (Sophia) myth. | Irenaeus of Lyons, Adversus Haereses (Against Heresies), c. 180 CE; ed. Rousseau & Doutreleau, SC 263-264, 293-294, 210-211 (Cerf, 1979-2002) SRC_IRENAEUS_AH | reviewed | Gnostic and Neoplatonic (2nd–4th c.) PER_GNO_2ND_4TH |
| 2684 | Enthymesis ENT_VAL_ENTHYMESIS | emanates_from | Sophia ENT_GNO_SOPHIA | high | Enthymesis is the formless passion-offspring of Sophia's desire to grasp the Father. | Irenaeus of Lyons, Adversus Haereses (Against Heresies), c. 180 CE; ed. Rousseau & Doutreleau, SC 263-264, 293-294, 210-211 (Cerf, 1979-2002) SRC_IRENAEUS_AH | reviewed | Gnostic and Neoplatonic (2nd–4th c.) PER_GNO_2ND_4TH |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "entity_relationships" (
[relationship_id] INTEGER PRIMARY KEY,
[subject_entity_id] TEXT REFERENCES [entities]([entity_id]),
[relationship_type] TEXT REFERENCES [relationship_types]([relationship_type]),
[object_entity_id] TEXT REFERENCES [entities]([entity_id]),
[confidence] TEXT,
[rationale] TEXT,
[source_id] TEXT REFERENCES [sources]([source_id]),
[review_status] TEXT,
[period_id] TEXT REFERENCES [periods]([period_id])
);
CREATE INDEX [idx_entity_relationships_period_id]
ON [entity_relationships] ([period_id]);
CREATE INDEX [idx_entity_relationships_source_id]
ON [entity_relationships] ([source_id]);
CREATE INDEX [idx_entity_relationships_object_entity_id]
ON [entity_relationships] ([object_entity_id]);
CREATE INDEX [idx_entity_relationships_relationship_type]
ON [entity_relationships] ([relationship_type]);
CREATE INDEX [idx_entity_relationships_subject_entity_id]
ON [entity_relationships] ([subject_entity_id]);