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

2 rows where subject_entity_id = "ENT_ETH_MAKEDA"

✎ View and edit SQL

This data as json, CSV (advanced)

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
7092 Makeda, Queen of Sheba ENT_ETH_MAKEDA member_of Saints of the Ethiopian Tewahedo Church ENT_ETH_SAINTS medium Makeda is the foundational figure of the Kebra Nagast cycle revered in Ethiopian Christian tradition. E. A. Wallis Budge (trans.), The Queen of Sheba and Her Only Son Menyelek (Kebra Nagast) (London, 1922) SRC_BUDGE_KEBRA_NAGAST reviewed  
7098 Makeda, Queen of Sheba ENT_ETH_MAKEDA associated_with Solomon ENT_ISR_SOLOMON high In the Kebra Nagast Makeda (the Ethiopian Queen of Sheba) visits Solomon and bears his son Menelik I; the figure is a reception/expansion of the biblical Queen of Sheba's visit (1 Kings 10). Retargeted from reception_of to associated_with because Makeda is a reception of the biblical Queen of Sheba (no such DB entity exists), not of Solomon. ENT_ISR_SOLOMON verified to exist. E. A. Wallis Budge (trans.), The Queen of Sheba and Her Only Son Menyelek (Kebra Nagast) (London, 1922) SRC_BUDGE_KEBRA_NAGAST 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]);