Relationships
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)'}
6 rows where period_id = "PER_CAN_BRONZE_AGE"
This data as json, CSV (advanced)
Suggested facets: relationship_type, source_id
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 1366 | Tiamat ENT_MES_TIAMAT | aligned_with | Lotan ENT_CAN_LOTAN | medium | Functional/typological cognate (no attested diffusion of the Mesopotamian deity into the later cult); per Burkert/West the real transmission, where any, runs through Hurrian-Hittite intermediaries. | John Day, God's Conflict with the Dragon and the Sea (Cambridge University Press, 1985) SRC_DAY_GODS_CONFLICT | reviewed | Canaanite Bronze Age PER_CAN_BRONZE_AGE |
| 1367 | Lotan ENT_CAN_LOTAN | aligned_with | Tiamat ENT_MES_TIAMAT | medium | Functional/typological cognate, not an attested reception (the cosmic-sovereignty/chaos parallels route through Hurrian-Hittite intermediaries or are modern comparisons; Burkert, West). | John Day, God's Conflict with the Dragon and the Sea (Cambridge University Press, 1985) SRC_DAY_GODS_CONFLICT | reviewed | Canaanite Bronze Age PER_CAN_BRONZE_AGE |
| 1368 | Inanna/Ishtar ENT_MES_INANNA_ISHTAR | received_as | Astarte ENT_CAN_ASTARTE | medium | Inanna/Ishtar (Mesopotamian love/war goddess) received as Astarte (ʿṯtrt) in Canaanite tradition. Both rule love, fertility, and warfare; name Astarte is cognate with Ashtart/Ishtar. DDD_BIBLE s.v. "Ashtoreth" and "Astarte" traces the Mesopotamian origin and Canaanite reception of the love-war goddess figure. | Dictionary of Deities and Demons in the Bible SRC_UGARIT_DDD | reviewed | Canaanite Bronze Age PER_CAN_BRONZE_AGE |
| 1369 | Astarte ENT_CAN_ASTARTE | reception_of | Inanna/Ishtar ENT_MES_INANNA_ISHTAR | medium | Astarte as Canaanite reception of Mesopotamian Ishtar; love/war attributes, iconography, and name cognate. | Dictionary of Deities and Demons in the Bible SRC_UGARIT_DDD | reviewed | Canaanite Bronze Age PER_CAN_BRONZE_AGE |
| 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
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]);