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)'}

1 row where subject_entity_id = "ENT_MES_UTNAPISHTIM"

✎ 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
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

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