Relationships

2,079 typed, source-backed relationships between entities. Each row records a directed relationship (subject → type → object) with a justifying source and rationale note. See relationship_types for the full controlled vocabulary of 70 relationship types. Key types: reception_of / received_as (transmission across traditions), equated_with (interpretatio graeca / analogues), parent_of (genealogy), member_of (collective membership), emanates_from (Gnostic/Neoplatonic structure).

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)'}

2 rows where subject_entity_id = "ENT_ZOR_SPENTA_ARMATI"

✎ View and edit SQL

This data as json, CSV (advanced)

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
889 Spenta Armaiti ENT_ZOR_SPENTA_ARMATI patron_of Earth ENT_EARTH high Spenta Armaiti is associated with earth and devotion. Avesta SRC_AVESTA reviewed  
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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]);