Relationships
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)'}
45 rows where source_id = "SRC_3_ENOCH"
This data as json, CSV (advanced)
Suggested facets: relationship_type, object_entity_id, confidence
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 1440 | Enoch ENT_ENOCH | received_as | Metatron ENT_JM_METATRON | high | 3 Enoch (Sefer Hekhalot) chapters 3–15 narrate the transformation of Enoch the antediluvian patriarch into the angel Metatron, who is enthroned in heaven, given a robe of glory and a crown, and named "the Youth" (Na'ar), "Prince of the Divine Presence," and "Lesser YHWH." Rabbi Ishmael asks: "Who are you?" and Metatron replies: "I am Enoch son of Jared." The transformation is complete — the human patriarch has been received into Jewish mysticism as the highest of all angelic beings. This is the central transmission of the Second Temple Enoch tradition into Hekhalot and Kabbalistic mysticism. | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | Late Antiquity PER_LATE_ANTIQUE |
| 1441 | Metatron ENT_JM_METATRON | reception_of | Enoch ENT_ENOCH | high | Metatron as the Jewish mystical reception of the Enoch patriarch; 3 Enoch explicitly identifies Metatron as the transformed Enoch; the human visionary becomes the supreme angelic mediator. | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | Late Antiquity PER_LATE_ANTIQUE |
| 2814 | Anafiel ENT_JM_ANAFIEL | aligned_with | Metatron ENT_JM_METATRON | medium | Anafiel is the throne-prince set above Metatron in 3 Enoch. | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3964 | Ruchiel ENT_JM_RUCHIEL | presides_over | Wind ENT_WIND | high | Prince over the wind | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3965 | Zaphiel ENT_JM_ZAPHIEL | presides_over | Storm ENT_STORM | high | Prince over the storm-wind | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3966 | Raamiel ENT_JM_RAAMIEL | presides_over | Storm ENT_STORM | medium | Prince over the thunders | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3967 | Raasiel ENT_JM_RAASIEL | presides_over | Earth ENT_EARTH | medium | Prince over the earthquake | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3968 | Matariel ENT_JM_MATARIEL | presides_over | Water ENT_WATER | medium | Prince over the rain | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3969 | Shamshiel ENT_JM_SHAMSHIEL | presides_over | Sun ENT_SUN | medium | Prince over the day | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3970 | Lailiel ENT_JM_LAILIEL | presides_over | Darkness ENT_DARKNESS | medium | Prince over the night | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3971 | Galgaliel ENT_JM_GALGALIEL | presides_over | Sun ENT_SUN | high | Prince of the globe of the sun | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3972 | Ophanniel ENT_JM_OPHANNIEL | presides_over | Moon ENT_MOON | high | Prince of the globe of the moon | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3974 | Baraqiel ENT_ISR_BARAQIEL | presides_over | Storm ENT_STORM | medium | In 3 Enoch 14 also the prince over the lightnings | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3975 | Baradiel ENT_JM_BARADIEL | mediated_by | Metatron ENT_JM_METATRON | medium | Cosmic princes tremble before the enthroned Metatron in 3 Enoch 14 | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3976 | Ruchiel ENT_JM_RUCHIEL | mediated_by | Metatron ENT_JM_METATRON | medium | Cosmic princes under Metatron in 3 Enoch 14 | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3977 | Zaamiel ENT_JM_ZAAMIEL | mediated_by | Metatron ENT_JM_METATRON | medium | Cosmic princes under Metatron in 3 Enoch 14 | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3978 | Ziqiel ENT_JM_ZIQIEL | mediated_by | Metatron ENT_JM_METATRON | medium | Cosmic princes under Metatron in 3 Enoch 14 | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3979 | Ziiel ENT_JM_ZIIEL | mediated_by | Metatron ENT_JM_METATRON | medium | Cosmic princes under Metatron in 3 Enoch 14 | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3980 | Zaphiel ENT_JM_ZAPHIEL | mediated_by | Metatron ENT_JM_METATRON | medium | Cosmic princes under Metatron in 3 Enoch 14 | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3981 | Raamiel ENT_JM_RAAMIEL | mediated_by | Metatron ENT_JM_METATRON | medium | Cosmic princes under Metatron in 3 Enoch 14 | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3982 | Raasiel ENT_JM_RAASIEL | mediated_by | Metatron ENT_JM_METATRON | medium | Cosmic princes under Metatron in 3 Enoch 14 | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3983 | Shalgiel ENT_JM_SHALGIEL | mediated_by | Metatron ENT_JM_METATRON | medium | Cosmic princes under Metatron in 3 Enoch 14 | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3984 | Matariel ENT_JM_MATARIEL | mediated_by | Metatron ENT_JM_METATRON | medium | Cosmic princes under Metatron in 3 Enoch 14 | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3985 | Shamshiel ENT_JM_SHAMSHIEL | mediated_by | Metatron ENT_JM_METATRON | medium | Cosmic princes under Metatron in 3 Enoch 14 | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3986 | Lailiel ENT_JM_LAILIEL | mediated_by | Metatron ENT_JM_METATRON | medium | Cosmic princes under Metatron in 3 Enoch 14 | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3987 | Galgaliel ENT_JM_GALGALIEL | mediated_by | Metatron ENT_JM_METATRON | medium | Cosmic princes under Metatron in 3 Enoch 14 | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3988 | Ophanniel ENT_JM_OPHANNIEL | mediated_by | Metatron ENT_JM_METATRON | medium | Cosmic princes under Metatron in 3 Enoch 14 | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3989 | Rahatiel ENT_JM_RAHATIEL | mediated_by | Metatron ENT_JM_METATRON | medium | Cosmic princes under Metatron in 3 Enoch 14 | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3990 | Kerubiel ENT_JM_KERUBIEL | presides_over | Cherubim ENT_JM_CHERUBIM | high | Prince set over the cherubim | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3991 | Seraphiel ENT_JM_SERAPHIEL | presides_over | Seraphim ENT_JM_SERAPHIM | high | Prince set over the seraphim | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3992 | Hayliel ENT_JM_HAYLIEL | presides_over | Chayyot ENT_JM_CHAYYOT | high | Prince set over the chayyot | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3993 | Rikbiel ENT_JM_RIKBIEL | presides_over | Ophanim ENT_JM_OPHANIM | high | Prince over the wheels (ophanim) of the chariot | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3994 | Rikbiel ENT_JM_RIKBIEL | presides_over | Merkabah ENT_JM_MERKABAH | high | Prince over the wheels of the Merkabah | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3995 | Soperiel Mehayye ENT_JM_SOPERIEL_MEHAYYE | presides_over | Judgment ENT_JUDGMENT | medium | Seals the verdicts of the living in the heavenly assize | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3996 | Soperiel Memeth ENT_JM_SOPERIEL_MEMETH | presides_over | Death ENT_DEATH | high | Scribe who seals the records of the dead | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3997 | Soqedhozi ENT_JM_SOQEDHOZI | presides_over | Judgment ENT_JUDGMENT | high | Weighs the merits of humankind | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3998 | Radueriel ENT_JM_RADUERIEL | mediates | Metatron ENT_JM_METATRON | medium | Scribal retinue of the throne alongside Metatron | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 3999 | Anpiel ENT_JM_ANPIEL | guardian_of | Merkabah ENT_JM_MERKABAH | medium | Holds the keys of the heavenly palaces of the throne | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 4000 | Hadraniel ENT_JM_HADRANIEL | guardian_of | Merkabah ENT_JM_MERKABAH | medium | Gatekeeper-prince of the way to the Merkabah | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 4001 | Naariel ENT_JM_NAARIEL | mediated_by | Metatron ENT_JM_METATRON | medium | Throne-prince of the seventh heaven under Metatron | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 7857 | The Seven Heavens (Vilon, Raqia, Shehaqim, Zebul, Maon, Makhon, Araboth) ENT_RLMX_SEVEN_HEAVENS | dwelling_of | The Seven Hekhalot (Heavenly Palaces) ENT_RLMX_SEVEN_HEKHALOT | high | The seven hekhalot are situated within Araboth, the seventh of the seven heavens. | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 7861 | The Seven Heavens (Vilon, Raqia, Shehaqim, Zebul, Maon, Makhon, Araboth) ENT_RLMX_SEVEN_HEAVENS | dwelling_of | Throne ENT_THRONE | high | Araboth, the seventh heaven, houses the Throne of Glory. | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 7862 | The Seven Heavens (Vilon, Raqia, Shehaqim, Zebul, Maon, Makhon, Araboth) ENT_RLMX_SEVEN_HEAVENS | associated_with | The Seven Firmaments (Raqia of Sefer ha-Razim) ENT_JM_SEVEN_FIRMAMENTS | medium | The rabbinic/Merkavah seven heavens parallel but are distinct from the seven firmaments of Sefer ha-Razim. | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 7863 | The Seven Heavens (Vilon, Raqia, Shehaqim, Zebul, Maon, Makhon, Araboth) ENT_RLMX_SEVEN_HEAVENS | aligned_with | Atziluth ENT_JM_ATZILUTH | low | Both are vertical hierarchies of the Jewish-mystical cosmos; the four Kabbalistic worlds are a later systematization overlapping the heavens schema. | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed | |
| 7864 | The Seven Heavens (Vilon, Raqia, Shehaqim, Zebul, Maon, Makhon, Araboth) ENT_RLMX_SEVEN_HEAVENS | opposes | Gehenna ENT_JM_GEHENNA | medium | The ascending heavens stand opposite Gehenna, the lower realm of punishment, in Jewish cosmology. | 3 Enoch / Sefer Hekhalot SRC_3_ENOCH | reviewed |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);