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

✎ 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
903 Khshathra Vairya ENT_ZOR_KHSHATHRA embodies Sovereignty ENT_SOVEREIGNTY medium Khshathra Vairya embodies desirable dominion or ideal rule. Avesta SRC_AVESTA reviewed  
2409 Khshathra Vairya ENT_ZOR_KHSHATHRA aligned_with Michael ENT_ISR_MICHAEL medium Khshathra Vairya ("Desirable Dominion") is the Amesha Spenta of divine sovereignty and the ideal kingdom — the celestial realm that Ahura Mazda's sovereignty constitutes, with sky (heaven) as his physical correlate and metal (the material of weapons, coins, and royal power) as his material correlate. Michael is the archangel of divine sovereignty and the champion of God's people in Second Temple Judaism: Daniel 10:13,21 names him "one of the chief princes" and "your prince"; Daniel 12:1 calls him "the great prince who has charge of your people." Both Khshathra and Michael are specifically associated with divine warfare and the protection/maintenance of the divine kingdom against adversarial powers (Angra Mainyu / the demonic; the nations that threaten Israel). The Khshathra/Michael alignment is the most frequently cited Amesha Spenta-archangel sovereign/warrior parallel. Boyce (1982) pp. 76-79; cf. Collins, Daniel (1993) pp. 374-376. 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]);