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_AMERETAT"

✎ 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
896 Ameretat ENT_ZOR_AMERETAT embodies Immortality ENT_IMMORTALITY high Ameretat embodies immortality. Avesta SRC_AVESTA reviewed  
2412 Ameretat ENT_ZOR_AMERETAT aligned_with Zoe ENT_GNO_ZOE medium Ameretat ("Immortality" — from Avestan a-mereta, "without death") is the Amesha Spenta of immortality and plants: his physical correlate is vegetation (which embodies perpetual renewal and thus the principle of deathlessness), and he governs the blessed immortality awaiting the righteous at the renovation of the world (Frashokereti). Gnostic Zoe ("Life") appears as one of the divine luminaries/aeons in Sethian Gnostic texts including the Apocryphon of John (NHC II,1: Zoe is one of the four lights), On the Origin of the World (NHC II,5: Zoe is the divine life principle), and Trimorphic Protennoia. The semantic alignment is the most direct available between an Amesha Spenta and a Gnostic aeon: Ameretat = "without-death" = immortality = life without end; Zoe = "Life." Both function within emanatory divine hierarchies as the positive life-principle standing in opposition to death and darkness (Ameretat opposes Zairika, the demoness of aging; Zoe stands against the death-principle in material creation). Confidence medium: the correspondence is semantic and structural but the traditions developed independently; the Gnostic Zoe's cosmological function differs from Ameretat's eschatological role. Layton (1987) pp. 23-51; Boyce (1982) p. 79. 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]);