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 period_id = "PER_MES_UR_III"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: subject_entity_id, relationship_type

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
1591 Nanna/Sin ENT_MES_NANNA_SIN spouse_of Ningal ENT_MES_NINGAL high Nanna/Sin and Ningal are the divine couple of Ur; their pairing is consistently attested in Ur III hymns to Nanna; Ningal has her own temple (the e-kiš-nu-gál) within Nanna's temple complex at Ur; she is named as his consort in the Lamentation over the Destruction of Ur (ETCSL 2.2.2) and in multiple Nanna hymns. Electronic Text Corpus of Sumerian Literature SRC_ETCSL reviewed Ur III / Sumerian Renaissance PER_MES_UR_III
1592 Ningal ENT_MES_NINGAL spouse_of Nanna/Sin ENT_MES_NANNA_SIN high Ningal as the divine consort of Nanna/Sin at Ur; she intercedes with the divine assembly on Ur's behalf in the Lamentation over the Destruction of Ur, acting as the protective mother of the city and its people. Electronic Text Corpus of Sumerian Literature SRC_ETCSL reviewed Ur III / Sumerian Renaissance PER_MES_UR_III
1593 Ningal ENT_MES_NINGAL parent_of Inanna/Ishtar ENT_MES_INANNA_ISHTAR high Ningal is explicitly named as the mother of Inanna in Sumerian hymns; the parentage Nanna + Ningal → Inanna is the standard Sumerian tradition. Ningal's maternal role provides Inanna with both a lunar/celestial father (Nanna) and a divine mother who intercedes before the gods. Electronic Text Corpus of Sumerian Literature SRC_ETCSL reviewed Ur III / Sumerian Renaissance PER_MES_UR_III
1594 Ningal ENT_MES_NINGAL parent_of Utu/Shamash ENT_MES_UTU_SHAMASH high Ningal is named as the mother of Utu/Shamash (the sun god) alongside Inanna in Sumerian hymns; Nanna and Ningal are the divine parents of both the moon's primary associated celestial bodies (sun and Venus/morning star). Electronic Text Corpus of Sumerian Literature SRC_ETCSL reviewed Ur III / Sumerian Renaissance PER_MES_UR_III

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]);