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

5 rows where subject_entity_id = "ENT_MES_NERGAL"

✎ 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
456 Nergal ENT_MES_NERGAL spouse_of Ereshkigal ENT_MES_ERESHKIGAL medium Nergal and Ereshkigal are paired in underworld mythology. Jeremy Black and Anthony Green, Gods, Demons and Symbols of Ancient Mesopotamia SRC_BLACK_GREEN_MESO reviewed  
487 Nergal ENT_MES_NERGAL rules Underworld ENT_UNDERWORLD high Nergal is the Mesopotamian sovereign of the underworld (consort of Ereshkigal), associated with death, plague, and the realm of the dead. Jeremy Black and Anthony Green, Gods, Demons and Symbols of Ancient Mesopotamia SRC_BLACK_GREEN_MESO reviewed  
489 Nergal ENT_MES_NERGAL causes_affliction Disease ENT_DISEASE medium Nergal is associated with plague and destructive disease. Jeremy Black and Anthony Green, Gods, Demons and Symbols of Ancient Mesopotamia SRC_BLACK_GREEN_MESO reviewed  
498 Nergal ENT_MES_NERGAL patron_of War ENT_WAR high Nergal is associated with war and destructive force. Jeremy Black and Anthony Green, Gods, Demons and Symbols of Ancient Mesopotamia SRC_BLACK_GREEN_MESO reviewed  
7852 Nergal ENT_MES_NERGAL rules Irkalla (Kur) ENT_RLMX_IRKALLA high Nergal becomes consort and co-ruler of the netherworld with Ereshkigal. Jeremy Black and Anthony Green, Gods, Demons and Symbols of Ancient Mesopotamia SRC_BLACK_GREEN_MESO 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]);