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

✎ 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
516 Yam ENT_CAN_YAM patron_of Water ENT_WATER high Yam is the sea/water power. Dictionary of Deities and Demons in the Bible SRC_UGARIT_DDD reviewed  
1374 Yam ENT_CAN_YAM received_as Leviathan ENT_ISR_LEVIATHAN medium Yam (Ugaritic Sea/Judge-River) as storm god's chaos adversary parallels Yahweh's combat with sea and sea-monsters in Psalm 74:13–14 ("You divided the sea ... you broke the heads of the sea monsters"), Isaiah 51:9–10, Job 38. Hebrew poetry conflates chaos sea and chaos monster (Leviathan/Rahab), absorbing Yam's role as cosmic antagonist of the storm deity. Distinct from the Lotan→Leviathan chain: this transmits the storm-god/sea combat function, not the serpent's name. Day 1985 pp. 31–87 treats the Yam tradition in Israelite texts. John Day, God's Conflict with the Dragon and the Sea (Cambridge University Press, 1985) SRC_DAY_GODS_CONFLICT reviewed Exilic and Post-Exilic PER_ISR_EXILIC

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