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

4 rows where object_entity_id = "ENT_EGY_ATUM"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: relationship_type, confidence, source_id

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
1566 Shu ENT_EGY_SHU child_of Atum ENT_EGY_ATUM high Shu as the firstborn of Atum; Pyramid Texts establish Shu (air/light) and Tefnut (moisture) as the first created beings, products of Atum's self-generation on the primordial mound. 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
1567 Tefnut ENT_EGY_TEFNUT child_of Atum ENT_EGY_ATUM high Tefnut as the twin of Shu and second offspring of Atum; Pyramid Texts and Coffin Texts consistently pair Shu and Tefnut as the first created divine pair produced by Atum. 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
3837 Iusaaset ENT_EGY_IUSAASET consort_of Atum ENT_EGY_ATUM high The hand of Atum, his feminine creative complement Richard H. Wilkinson, The Complete Gods and Goddesses of Ancient Egypt SRC_WILKINSON_EGYPTIAN_GODS reviewed  
4107 Nebethetepet ENT_EGY_NEBETHETEPET paired_with Atum ENT_EGY_ATUM medium Nebethetepet personifies the creative hand / female complement of Atum, not a spouse in the ordinary sense. Richard H. Wilkinson, The Complete Gods and Goddesses of Ancient Egypt SRC_WILKINSON_EGYPTIAN_GODS reviewed  

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