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

4 rows where source_id = "SRC_DESCENT_ISHTAR"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: subject_entity_id, object_entity_id, confidence

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
7850 Irkalla (Kur) ENT_RLMX_IRKALLA ruled_by Ereshkigal ENT_MES_ERESHKIGAL high Ereshkigal is queen of Irkalla/Kur, the Mesopotamian netherworld (Descent of Ishtar). The Descent of Ishtar to the Netherworld (Akkadian), trans. S. Dalley, Myths from Mesopotamia (Oxford University Press, 2000) SRC_DESCENT_ISHTAR reviewed  
7853 Ganzir ENT_RLMX_GANZIR belongs_to_realm Irkalla (Kur) ENT_RLMX_IRKALLA high Ganzir is the gate/threshold belonging to the netherworld Irkalla (was 'part_of', which is not a valid relationship_type; belongs_to_realm is attested for place-within-realm). The Descent of Ishtar to the Netherworld (Akkadian), trans. S. Dalley, Myths from Mesopotamia (Oxford University Press, 2000) SRC_DESCENT_ISHTAR reviewed  
7855 Dilmun ENT_RLMX_DILMUN associated_with Enki/Ea ENT_MES_ENKI_EA high Enki provides fresh water to Dilmun in the myth Enki and Ninhursag, making it the pure land. The Descent of Ishtar to the Netherworld (Akkadian), trans. S. Dalley, Myths from Mesopotamia (Oxford University Press, 2000) SRC_DESCENT_ISHTAR reviewed  
7856 Dilmun ENT_RLMX_DILMUN opposes Irkalla (Kur) ENT_RLMX_IRKALLA medium Dilmun, the deathless pure land, stands in mythic contrast to the netherworld of death. The Descent of Ishtar to the Netherworld (Akkadian), trans. S. Dalley, Myths from Mesopotamia (Oxford University Press, 2000) SRC_DESCENT_ISHTAR 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]);