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_FINN_VAINAMOINEN"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: relationship_type, confidence, source_id

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
2343 Ilmatar ENT_FINN_ILMATAR parent_of Väinämöinen ENT_FINN_VAINAMOINEN high Kalevala Runo 1-3 explicitly identifies Ilmatar as the mother of Väinämöinen: she carried him in her womb for 700 years before he was born into the sea. The birth from the virgin air spirit is the foundational event of Finnish cosmogony, linking the world-creation myth directly to the birth of the culture hero. Kalevala Runo 1-3. Elias Lönnrot, The Kalevala (Kalevala taikka vanhoja Karjalan runoja Suomen kansan muinosista ajoista), expanded edition 1849; trans. Keith Bosley (Oxford World's Classics, Oxford University Press, 1989) SRC_KALEVALA reviewed Finnish Traditional / Pre-Christian PER_FINN_TRADITIONAL
2348 Louhi ENT_FINN_LOUHI opposes Väinämöinen ENT_FINN_VAINAMOINEN high Louhi is the principal antagonist of Väinämöinen throughout the Kalevala. She demands the Sampo as bride-price (Runos 5-8), pursues the heroes when they steal it back (Runos 30-38), attacks them as a giant eagle-hawk (Runo 42-43), and finally steals the sun and moon in retaliation (Runo 47). Their opposition structures the Kalevala's main plot arc across more than half the epic. Kalevala Runos 5-8, 10-11, 30-38, 42-49. Elias Lönnrot, The Kalevala (Kalevala taikka vanhoja Karjalan runoja Suomen kansan muinosista ajoista), expanded edition 1849; trans. Keith Bosley (Oxford World's Classics, Oxford University Press, 1989) SRC_KALEVALA reviewed Finnish Traditional / Pre-Christian PER_FINN_TRADITIONAL
5700 Hiisi ENT_FINN_HIISI opposes Väinämöinen ENT_FINN_VAINAMOINEN medium Hiisi is a malevolent force whose creatures obstruct heroes such as Väinämöinen. Mikael Agricola, Se Wsi Testamenti (The New Testament) and Psalttari (Finnish Psalter), 1548/1551; deity list in the Psalter introduction (Rucouskiria, 1544) SRC_AGRICOLA_PRIMER 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]);