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

3 rows where subject_entity_id = "ENT_ISR_SHEMIHAZAH"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: confidence

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
565 Shemihazah ENT_ISR_SHEMIHAZAH teaches Forbidden Knowledge ENT_FORBIDDEN_KNOWLEDGE medium Shemihazah is associated with the Watchers’ forbidden oath/descent complex. 1 Enoch SRC_1_ENOCH reviewed  
571 Shemihazah ENT_ISR_SHEMIHAZAH member_of Watchers ENT_ISR_WATCHERS high Shemihazah is a leader/member of the Watchers. 1 Enoch SRC_1_ENOCH reviewed  
2422 Shemihazah ENT_ISR_SHEMIHAZAH parent_of Nephilim ENT_ISR_NEPHILIM high 1 Enoch 7:2: "And they became pregnant, and they bore great giants... And when they had grown up, they turned against those who nourished them..." The Nephilim are specifically the offspring of Shemihazah's group of Watchers — 1 Enoch 7:1 names the women "they took" under Shemihazah's leadership. In 1 Enoch 10:12, God tells Michael to bind "Shemihazah and his associates, who have intermixed with women so as to have defiled themselves with them." The parent_of relationship captures Shemihazah's role as the primary Watcher whose congress with human women produced the Nephilim. 1 Enoch SRC_1_ENOCH reviewed Second Temple Period PER_ISR_SECOND_TEMPLE

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