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

9 rows where subject_entity_id = "ENT_ISR_WATCHERS"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: relationship_type, confidence, source_id, period_id

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
527 Watchers ENT_ISR_WATCHERS has_member Azazel ENT_ISR_AZAZEL medium Azazel is one of the fallen Watchers in Enochic tradition. 1 Enoch SRC_1_ENOCH reviewed  
537 Watchers ENT_ISR_WATCHERS transmits Forbidden Knowledge ENT_FORBIDDEN_KNOWLEDGE high Watchers transmit forbidden knowledge in Enochic tradition. 1 Enoch SRC_1_ENOCH reviewed  
545 Watchers ENT_ISR_WATCHERS has_member Shemihazah ENT_ISR_SHEMIHAZAH high Shemihazah is a leader of the Watchers. 1 Enoch SRC_1_ENOCH reviewed  
561 Watchers ENT_ISR_WATCHERS member_of Angels ENT_ANGELS high The Watchers are an angelic collective. 1 Enoch SRC_1_ENOCH reviewed  
564 Watchers ENT_ISR_WATCHERS undergoes_process Fall ENT_FALL high The Watchers descend/fall in Enochic tradition. 1 Enoch SRC_1_ENOCH reviewed  
1383 Watchers ENT_ISR_WATCHERS reception_of Apkallu ENT_MES_APKALLU medium Watchers as possible Israelite reception of Mesopotamian Apkallu tradition; antediluvian divine sages who transmit forbidden knowledge before the flood. Jeremy Black and Anthony Green, Gods, Demons and Symbols of Ancient Mesopotamia SRC_BLACK_GREEN_MESO reviewed Exilic and Post-Exilic PER_ISR_EXILIC
1426 Watchers ENT_ISR_WATCHERS received_as Harut ENT_ISL_HARUT medium Quran 2:102 describes Harut and Marut as two angels in Babylon who taught magic to humans, warning them it was a trial. Scholars including Geiger (1833) and Sidersky (1933) connect Harut and Marut to the Watcher tradition of 1 Enoch 6-11: divine beings who descend, transmit forbidden knowledge (sorcery, weaponry, cosmetics) to humanity, and whose activity constitutes a cosmic sin. The Babylonian setting of Quran 2:102 parallels the Apkallu tradition. Confidence medium: the Quran does not explicitly call them fallen angels, and the connection to the Watchers is scholarly reconstruction. Hadith general reference layer SRC_HADITH_GENERAL reviewed Early Islam PER_ISL_EARLY
1428 Watchers ENT_ISR_WATCHERS received_as Marut ENT_ISL_MARUT medium Marut (paired with Harut in Quran 2:102) as the second angel in the Babylonian forbidden-knowledge tradition; same Watcher-parallel rationale as Harut. The pair corresponds to the collective of descending Watchers rather than any individual Watcher. Hadith general reference layer SRC_HADITH_GENERAL reviewed Early Islam PER_ISL_EARLY
2423 Watchers ENT_ISR_WATCHERS parent_of Nephilim ENT_ISR_NEPHILIM high 1 Enoch 6-7: the 200 Watchers collectively father the Nephilim giants through their unions with human women. The parent_of relationship from the Watchers collective to the Nephilim collective captures this fundamental generative relationship in the Enochic cosmological drama. 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]);