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

5 rows where relationship_type = "guarded_by"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: confidence, source_id

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
7792 Bifröst (the rainbow bridge) ENT_NORR_BIFROST guarded_by Heimdall ENT_NOR_HEIMDALL high Heimdall guards Bifröst at the edge of heaven (Gylfaginning). Snorri Sturluson, Prose Edda SRC_PROSE_EDDA reviewed  
7795 Muspelheim (Múspellsheimr) ENT_NORR_MUSPELHEIM guarded_by Surtr ENT_NOR_SURTR high Surtr stands at the frontier of Muspelheim guarding it with a flaming sword (Gylfaginning). Snorri Sturluson, Prose Edda SRC_PROSE_EDDA reviewed  
7799 Well of Mimir (Mímisbrunnr) ENT_NORR_MIMISBRUNNR guarded_by Mimir ENT_NOR_MIMIR high Mímir keeps the Well of Wisdom; Odin pledged his eye there (Völuspá 28; Gylfaginning). Poetic Edda SRC_POETIC_EDDA reviewed  
7838 Chinvat Bridge ENT_RLMX_CHINVAT guarded_by Rashnu ENT_ZOR_RASHNU high Rashnu the Just is the yazata who weighs souls' deeds at the Chinvat Bridge (Vendidad 19). Vendidad (Videvdad, 'Law against the Demons'), Younger Avesta, ed./trans. J. Darmesteter, SBE 4 SRC_VENDIDAD reviewed  
7859 The Seven Hekhalot (Heavenly Palaces) ENT_RLMX_SEVEN_HEKHALOT guarded_by The Heavenly Host ENT_JM_HEAVENLY_HOST medium Angelic gatekeepers of the Heavenly Host guard the entrances to each of the seven palaces in Hekhalot Rabbati. Hekhalot Rabbati ('The Greater Palaces'), Merkavah text, ed. in P. Schafer, Synopse zur Hekhalot-Literatur SRC_HEKHALOT_RABBATI 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]);