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 subject_entity_id = "ENT_MANICH_LIVING_SPIRIT"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: relationship_type, source_id

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
974 Living Spirit ENT_MANICH_LIVING_SPIRIT savior_of Primal Man ENT_MANICH_PRIMAL_MAN high Living Spirit rescues Primal Man from Darkness. Manichaean Kephalaia SRC_MANICHAEAN_KEPHALAIA reviewed  
976 Living Spirit ENT_MANICH_LIVING_SPIRIT savior_of Salvation ENT_SALVATION high Living Spirit rescues Primal Man and participates in salvation history. Manichaean Kephalaia SRC_MANICHAEAN_KEPHALAIA reviewed  
6433 Living Spirit ENT_MANICH_LIVING_SPIRIT member_of Manichaean Pantheon (Lightworld Hierarchy) ENT_MANICH_PANTHEON high The Living Spirit (Mihryazd), Evocation of the Second Creation who rescues Primal Man; member of the Lightworld hierarchy. Samuel N. C. Lieu, Manichaeism in the Later Roman Empire and Medieval China SRC_LIEU_MANICHAEISM reviewed  
6454 Living Spirit ENT_MANICH_LIVING_SPIRIT emanates_from Mother of Life ENT_MANICH_MOTHER_LIFE high Second Creation: in response to Primal Man's prayer the Father (with the Mother of Life) evokes the Living Spirit to descend and rescue him. Lieu. Samuel N. C. Lieu, Manichaeism in the Later Roman Empire and Medieval China SRC_LIEU_MANICHAEISM 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]);