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

2 rows where subject_entity_id = "ENT_ISR_RAGUEL"

✎ 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
2413 Raguel ENT_ISR_RAGUEL aligned_with Michael ENT_ISR_MICHAEL high Raguel and Michael are co-members of the seven-archangel council in 1 Enoch 20, both standing before God as holy executors of divine will — Michael over the righteous nation and punishing Shemihazah (10:11), Raguel over the vengeance applied to the luminaries when they transgress (20:4). In 1 Enoch 9:1, the four archangels Uriel, Raphael, Michael, and Gabriel see the affliction of the earth and take the petition before God; Raguel operates in a parallel domain. The alignment is that of co-membership in the divine council with distinct functional domains. 1 Enoch SRC_1_ENOCH reviewed Second Temple Period PER_ISR_SECOND_TEMPLE
2414 Raguel ENT_ISR_RAGUEL opposes Watchers ENT_ISR_WATCHERS medium Raguel's function as the archangel who "takes vengeance on the world of the luminaries" (1 Enoch 20:4) places him in a corrective/punitive relationship to the Watchers, who transgressed their cosmic mandate by descending and intermingling with humanity. While Michael is specifically assigned the punishment of Shemihazah and Raphael is assigned to bind Azazel, Raguel's domain of vengeance over transgressors of cosmic order encompasses the broader Watcher transgression. Confidence medium: the opposition is inferred from his functional domain, not from a specific narrative of direct confrontation with the Watchers. 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]);