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

✎ 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
7816 The Isles of the Blest (Fortunate Isles) ENT_GRR_ISLES_BLEST presided_over_by Cronus ENT_CRONUS medium In Hesiod's account (and Pindar Ol. 2), Cronus rules over the Isles of the Blest where the heroic dead dwell apart from Hades' realm. Hesiod, Works and Days (c. 700 BCE), trans. Evelyn-White SRC_HESIOD_WORKS_DAYS reviewed  
7818 The Isles of the Blest (Fortunate Isles) ENT_GRR_ISLES_BLEST identified_with Elysium (Elysian Fields) ENT_GRR_ELYSIUM medium The Isles of the Blest and Elysium are the two principal Greek paradise-abodes, frequently conflated in later sources as the destination of the blessed. Hesiod, Works and Days (c. 700 BCE), trans. Evelyn-White SRC_HESIOD_WORKS_DAYS 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]);