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

3 rows where subject_entity_id = "ENT_MES_APKALLU"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: confidence

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
484 Apkallu ENT_MES_APKALLU patron_of Craft ENT_CRAFT medium Apkallu are associated with civilizing knowledge and craft traditions. Jeremy Black and Anthony Green, Gods, Demons and Symbols of Ancient Mesopotamia SRC_BLACK_GREEN_MESO reviewed  
500 Apkallu ENT_MES_APKALLU teaches Wisdom ENT_WISDOM high Apkallu are semi-divine sages associated with wisdom and ritual knowledge. Jeremy Black and Anthony Green, Gods, Demons and Symbols of Ancient Mesopotamia SRC_BLACK_GREEN_MESO reviewed  
1382 Apkallu ENT_MES_APKALLU received_as Watchers ENT_ISR_WATCHERS medium Mesopotamian Apkallu (seven antediluvian sages, semi-divine, sent by Enki to teach civilization) parallel the Watchers/Bene Elohim of Genesis 6:1–4 and 1 Enoch 6–11: both are divine beings from before the flood who transmit special knowledge to humanity and whose activity is associated with the flood as divine punishment. Black and Green (1992) document the Apkallu; Amar Annus (JNES 2010) argues for direct Apkallu→Watcher transmission during the Babylonian exile. Jeremy Black and Anthony Green, Gods, Demons and Symbols of Ancient Mesopotamia SRC_BLACK_GREEN_MESO reviewed Exilic and Post-Exilic PER_ISR_EXILIC

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