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)'}
2 rows where object_entity_id = "ENT_ISR_NOAH"
This data as json, CSV (advanced)
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 1550 | Utnapishtim ENT_MES_UTNAPISHTIM | received_as | Noah ENT_ISR_NOAH | high | The flood narrative in Genesis 6-9 is the most directly documented Mesopotamian→Israelite literary transmission in the dataset. The parallels between the Atrahasis Epic (c. 1700 BCE) and Gilgamesh Tablet XI on one side, and Genesis on the other, are structural and verbal: both have (1) a divine council decree to destroy humanity; (2) one righteous man warned by the sympathetic deity (Ea/Enki warns Utnapishtim; God warns Noah); (3) construction of a boat and loading of animals and family; (4) the flood; (5) the boat grounding on a mountain; (6) a sequence of birds released to test for dry land (the dove/raven sequence in Genesis 8:6-12 parallels Gilgamesh Tablet XI closely); (7) a sacrificial offering after the flood; (8) a divine oath not to repeat the destruction. Andrew George (OUP 2003) documents the parallels exhaustively in his critical apparatus. The mechanism of transmission is the Babylonian exile (586-538 BCE), when Israelite scribes had direct access to the Atrahasis and Gilgamesh traditions in Babylon. | Andrew R. George, The Babylonian Gilgamesh Epic: Introduction, Critical Edition and Cuneiform Texts, 2 vols. (Oxford University Press, 2003) SRC_GEORGE_GILGAMESH | reviewed | Exilic and Post-Exilic PER_ISR_EXILIC |
| 5135 | Nuh ENT_ISL_NUH | reception_of | Noah ENT_ISR_NOAH | high | The Qur'anic Nuh is the Islamic reception of Noah. | Qur’an SRC_QURAN | reviewed |
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]);