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

2 rows where subject_entity_id = "ENT_FINN_AHTI"

✎ View and edit SQL

This data as json, CSV (advanced)

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
2406 Ahti ENT_FINN_AHTI aligned_with Poseidon ENT_POSEIDON low Ahti and Poseidon are the supreme sea deities of the Finnish and Greek traditions respectively — both rule the aquatic realm, both have a palace beneath the waters, and both require propitiation by fishermen and sailors who depend on the sea's bounty. In the Kalevala, Ahti rules the underwater domain Ahtola alongside his consort Vellamo; in Runo 5, the hero Väinämöinen encounters Ahti in the sea. This structural parallel between sea-ruling divine figures is recognized in comparative mythology. Confidence low: the alignment is typological (shared domain and role) rather than genetic or historically transmitted; Finnish and Greek traditions had no direct contact, and the parallel reflects independent parallel evolution of sea-deity roles rather than any common origin or reception chain. Kalevala, Runo 5. 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
5664 Ahti ENT_FINN_AHTI member_of The Finnish/Kalevala Pantheon ENT_FINN_PANTHEON high Ahti, god of waters, is a member of the Finnic pantheon. 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]);