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

3 rows where object_entity_id = "ENT_NOR_ANDVARI"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: relationship_type, confidence

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
7544 Reginn ENT_GSAGA_REGINN associated_with Andvari ENT_NOR_ANDVARI high Reginn and Fafnir's family seizes Andvari's cursed gold and ring, the hoard Sigurd later wins (Byock, Saga of the Volsungs). Byock, Jesse L. (trans.), The Saga of the Volsungs: The Norse Epic of Sigurd the Dragon Slayer (Penguin Classics) SRC_BYOCK_VOLSUNGS reviewed  
7545 Fafnir ENT_GSAGA_FAFNIR guardian_of Andvari ENT_NOR_ANDVARI medium Fafnir broods on Glittering Heath over the cursed hoard originally extorted from the dwarf Andvari. Byock, Jesse L. (trans.), The Saga of the Volsungs: The Norse Epic of Sigurd the Dragon Slayer (Penguin Classics) SRC_BYOCK_VOLSUNGS reviewed  
7546 Sigurd ENT_GSAGA_SIGURD associated_with Andvari ENT_NOR_ANDVARI high By slaying Fafnir, Sigurd wins Andvari's cursed gold and ring Andvaranaut, transmitting the curse through the cycle. Byock, Jesse L. (trans.), The Saga of the Volsungs: The Norse Epic of Sigurd the Dragon Slayer (Penguin Classics) SRC_BYOCK_VOLSUNGS 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]);