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

✎ 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
905 Asha Vahishta ENT_ZOR_ASHA_VAHISHTA embodies Truth ENT_TRUTH high Asha Vahishta embodies truth/order/righteousness. Avesta SRC_AVESTA reviewed  
2408 Asha Vahishta ENT_ZOR_ASHA_VAHISHTA aligned_with Uriel ENT_ISR_URIEL medium Asha Vahishta ("Best Truth") is the Amesha Spenta of cosmic truth, righteousness, and fire — his physical correlate is Atar (sacred fire), and his domain encompasses the maintenance of cosmic moral and natural order (asha, cognate with Vedic rta). The primary liturgical fire in Zoroastrian temples is dedicated to Asha Vahishta. Uriel ("Fire/Light of God") is the archangel of divine fire and light in Second Temple Judaism: 1 Enoch 20:2 assigns him oversight of "the world and Tartarus"; 4 Ezra 4:1 identifies him as the angel who instructs Ezra in divine mysteries. Both figures govern the domain of divine light/fire as cosmic ordering principle, and both serve as mediators of divine truth to prophets (Zarathustra-Vohu Manah; Ezra-Uriel). The Asha/Uriel alignment is one of the most frequently cited specific Amesha Spenta-archangel parallels in comparative religion scholarship. Boyce, A History of Zoroastrianism (1982) Vol. II, pp. 72-76; Russell, Zoroastrianism in Armenia (1987) pp. 138-142. Mary Boyce, Zoroastrians SRC_BOYCE_ZOROASTRIANS reviewed Second Temple Period PER_ISR_SECOND_TEMPLE

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