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)'}
4 rows where subject_entity_id = "ENT_CAN_EL"
This data as json, CSV (advanced)
Suggested facets: confidence, source_id
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 508 | El ENT_CAN_EL | patron_of | Sovereignty ENT_SOVEREIGNTY | high | El functions as senior divine authority and father of gods. | Dictionary of Deities and Demons in the Bible SRC_UGARIT_DDD | reviewed | |
| 517 | El ENT_CAN_EL | rules | Divine Assembly ENT_DIVINE_ASSEMBLY | high | El presides over the divine council/assembly. | Dictionary of Deities and Demons in the Bible SRC_UGARIT_DDD | reviewed | |
| 521 | El ENT_CAN_EL | spouse_of | Athirat/Asherah ENT_CAN_ASHERAH | high | El and Athirat/Asherah are paired as senior divine couple in Northwest Semitic tradition. | Dictionary of Deities and Demons in the Bible SRC_UGARIT_DDD | reviewed | |
| 1376 | El ENT_CAN_EL | received_as | Yahweh ENT_ISR_YAHWEH | medium | Ugaritic El's divine epithets (El Elyon, El Shaddai, El Olam) appear in Genesis 14:18–22, Exodus 6:3, and Genesis 21:33 as Yahweh's own names, active before the revelation of the name Yahweh. Cross 1973 pp. 1–75 demonstrates that Yahweh began as a southern storm-warrior deity who absorbed El's cosmic role as "father of years" (ʾab šnm), "creator of creatures" (bny bnwt), and head of the divine council (pḥr ʿIlm). The shared divine council (bene elim / Bene Elohim) structure confirms the absorption. | Frank Moore Cross, Canaanite Myth and Hebrew Epic (Harvard University Press, 1973) SRC_CROSS_CANAANITE_MYTH | reviewed | Exilic and Post-Exilic PER_ISR_EXILIC |
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]);