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

6 rows where object_entity_id = "ENT_ISR_RAPHAEL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: relationship_type, confidence, source_id, review_status

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
1790 Raphael the Archangel ENT_SAINT_RAPHAEL_CHR reception_of Raphael ENT_ISR_RAPHAEL high Christian tradition receives the Second Temple Raphael (Tobit; 1 Enoch 9-10) as the healing archangel Raphael. Dictionary of Deities and Demons in the Bible SRC_DDD_CHRISTIAN approved  
2411 Haurvatat ENT_ZOR_HAURVATAT aligned_with Raphael ENT_ISR_RAPHAEL medium Haurvatat ("Wholeness / Health") is the Amesha Spenta of completeness, health, and perfection — his physical correlate is water (the element of purification and life-sustaining wholeness), and his domain encompasses both bodily health and the soteriological completeness of the righteous at the end of time. The name haurvatat is from the root *hauru- "whole, healthy." Raphael ("God has healed") is the healing archangel in Second Temple Jewish tradition: Tobit 12:14-15 identifies Raphael as "one of the seven angels who stand ready and enter before the glory of the Lord" and the angel who healed Tobit's blindness and protected Sarah from the demon Asmodeus; 1 Enoch 10:4-7 assigns Raphael the task of healing the earth after the Watchers' corruption of humanity. Both Haurvatat and Raphael govern the domain of wholeness/health as a divine principle, and both function within a 7-member divine council (6 Amesha Spentas + Ahura Mazda; 7 archangels). The Haurvatat/Raphael alignment is the most frequently noted specific Amesha Spenta-archangel healing parallel in the scholarly literature. Boyce (1982) pp. 77-78; Russell (1987) p. 141. Mary Boyce, Zoroastrians SRC_BOYCE_ZOROASTRIANS reviewed Second Temple Period PER_ISR_SECOND_TEMPLE
2415 Remiel ENT_ISR_REMIEL aligned_with Raphael ENT_ISR_RAPHAEL medium Remiel and Raphael are functionally aligned as the eschatological/soteriological pair within the seven-archangel council: Raphael is the angel of healing and is assigned to heal the earth after the Watchers' corruption (1 Enoch 10:7), while Remiel is assigned to preside over "those who rise" — the resurrection of the righteous (1 Enoch 20:8; 2 Baruch 55:3). Both operate in the domain of restoring creation after corruption/death. The alignment reflects the structural pairing of healing-and-resurrection within the divine council. 1 Enoch SRC_1_ENOCH reviewed Second Temple Period PER_ISR_SECOND_TEMPLE
2783 Asmodeus ENT_ISR_ASMODEUS imprisoned_by Raphael ENT_ISR_RAPHAEL high Raphael binds Asmodeus in Egypt (Tobit 8:3). Book of Tobit SRC_TOBIT reviewed  
7182 Tobias son of Tobit ENT_STJ_TOBIAS guided_by Raphael ENT_ISR_RAPHAEL high Tobias is guided on his journey by the disguised archangel Raphael (existing ENT_ISR_RAPHAEL) in the Book of Tobit. The Apocrypha (NRSV) — Tobit, Judith, 1-2 Maccabees, additions to Daniel (Susanna), and related deuterocanonical books SRC_APOCRYPHA_NRSV reviewed  
7183 Sarah (of Tobit) ENT_STJ_SARAH_OF_TOBIT rescued_by Raphael ENT_ISR_RAPHAEL high Raphael binds the demon Asmodeus and frees Sarah, enabling her marriage (Book of Tobit). The Apocrypha (NRSV) — Tobit, Judith, 1-2 Maccabees, additions to Daniel (Susanna), and related deuterocanonical books SRC_APOCRYPHA_NRSV reviewed  

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