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 subject_entity_id = "ENT_HTT_ALALU"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: confidence, review_status

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
2107 Alalu ENT_HTT_ALALU rules Sovereignty ENT_SOVEREIGNTY high Hoffner, Hittite Myths — Song of Kumarbi: "In former times Alalu was king in heaven. Alalu sat upon the throne and the mighty Anu... bowed down at his feet." Alalu was the primordial king of heaven for nine years. Harry A. Hoffner Jr., Hittite Myths, 2nd ed. (Society of Biblical Literature, 1998) SRC_HOFFNER_HITTITE_MYTHS approved  
2108 Alalu ENT_HTT_ALALU dwells_in Underworld ENT_UNDERWORLD high Hoffner, Hittite Myths — Song of Kumarbi: after being defeated by Anu in the ninth year, Alalu "went down to the dark earth (the underworld)" where he took refuge. Harry A. Hoffner Jr., Hittite Myths, 2nd ed. (Society of Biblical Literature, 1998) SRC_HOFFNER_HITTITE_MYTHS approved  
2109 Alalu ENT_HTT_ALALU opposes Teshub ENT_HTT_TESHUB medium Hoffner, Hittite Myths — Song of Kumarbi: the Kumarbi Cycle stages a succession war through the chain Alalu → Anu → Kumarbi → Teshub; Alalu's displacement is the first act in the conflict that Teshub ultimately resolves as the ruling storm god. Harry A. Hoffner Jr., Hittite Myths, 2nd ed. (Society of Biblical Literature, 1998) SRC_HOFFNER_HITTITE_MYTHS approved  
5965 Alalu ENT_HTT_ALALU member_of The Hittite Pantheon ENT_HTT_PANTHEON high Alalu is the first divine king in the Hurrian-Hittite succession myth. Harry A. Hoffner Jr., Hittite Myths, 2nd ed. (Society of Biblical Literature, 1998) SRC_HOFFNER_HITTITE_MYTHS 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]);