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

3 rows where object_entity_id = "ENT_EGY_SHU"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: confidence

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
1564 Atum ENT_EGY_ATUM parent_of Shu ENT_EGY_SHU high Pyramid Texts Utterance 600: Atum spat out Shu ("who spat out Shu, who expectorated Tefnut") from Heliopolis. Also PT 527, 1248 describe Atum creating Shu and Tefnut by masturbation (the "hand of Atum" tradition). Atum as the creator of the first divine pair Shu (air) and Tefnut (moisture) is the foundational act of the Heliopolitan cosmogony and the root of the Ennead genealogy. R. O. Faulkner, The Ancient Egyptian Pyramid Texts (Oxford University Press, 1969; repr. Aris & Phillips, 1998) SRC_FAULKNER_PYRAMID_TEXTS reviewed Old Kingdom PER_EGY_OLD_KINGDOM
2269 Anhur ENT_EGY_ANHUR identified_with Shu ENT_EGY_SHU high By the New Kingdom Anhur was theologically compounded with Shu (the air deity who upholds the sky), worshipped as Anhur-Shu at Sebennytos and Thinis. Both share the role of separating heaven from earth. Wilkinson (2003) pp. 106-107. Richard H. Wilkinson, The Complete Gods and Goddesses of Ancient Egypt SRC_WILKINSON_EGYPTIAN_GODS reviewed  
2362 Arensnuphis ENT_MER_ARENSNUPHIS aligned_with Shu ENT_EGY_SHU medium Through the Onuris-Shu theological identification in late Egyptian religion (Anhur/Onuris was regularly equated with Shu as the air deity who holds up the sky), Arensnuphis inherits a secondary alignment with Shu. The chain is: Arensnuphis syncretized_with Anhur, and Anhur identified_with Shu in Egyptian theology. Confidence medium: the alignment is indirect (mediated through the Onuris-Shu equation) rather than a direct ancient statement about Arensnuphis and Shu. Török (1997) p. 477. László Török, The Kingdom of Kush: Handbook of the Napatan-Meroitic Civilization (Handbook of Oriental Studies, Section 1: The Near and Middle East, Vol. 31; E.J. Brill, Leiden / New York / Cologne, 1997) SRC_TÖRÖK_MEROE reviewed Napatan–Meroitic Kingdom of Kush PER_MER_NAPATAN_MEROITIC

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