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 source_id = "SRC_WYATT_RELIGIOUS_TEXTS"

✎ 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
1530 Dagon ENT_CAN_DAGON parent_of Baal Hadad ENT_CAN_BAAL medium KTU 1.5 VI 24 (Baal Cycle, Ugarit) calls Baal "son of Dagon" (bn dgn). This parentage is attested in several Ugaritic texts alongside the alternative tradition that makes El Baal's father; Cross (1973) and Wyatt (2002) treat the Dagon-paternity as authentic, noting that Dagon's older Levantine authority made him a plausible divine father for the younger storm deity. The identification of Dagon as the "father" of the storm god parallels the Mesopotamian pattern where older grain/sky deities are the fathers of more active storm deities. N. Wyatt, Religious Texts from Ugarit, 2nd ed. (Sheffield Academic Press, 2002) SRC_WYATT_RELIGIOUS_TEXTS reviewed Canaanite Bronze Age PER_CAN_BRONZE_AGE
1531 Baal Hadad ENT_CAN_BAAL child_of Dagon ENT_CAN_DAGON medium Baal as "son of Dagon" per KTU 1.5 VI 24; alternate tradition also makes El his father. Medium confidence reflects the textual ambiguity. N. Wyatt, Religious Texts from Ugarit, 2nd ed. (Sheffield Academic Press, 2002) SRC_WYATT_RELIGIOUS_TEXTS reviewed Canaanite Bronze Age PER_CAN_BRONZE_AGE

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