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_ADONIS"

✎ 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
1503 Adonis ENT_ADONIS reception_of Dumuzi/Tammuz ENT_MES_DUMUZI_TAMMUZ low Adonis as the Greek reception of the Mesopotamian Dumuzi/Tammuz dying vegetation deity tradition, via Phoenician Adon intermediary. Walter Burkert, The Orientalizing Revolution: Near Eastern Influence on Greek Culture in the Early Archaic Age (Harvard University Press, 1992) SRC_BURKERT_ORIENT_REV reviewed Archaic Period PER_GRK_ARCHAIC
3493 Adonis ENT_ADONIS reception_of Adonis ENT_PHO_ADONIS high [REVERSED v2.1.60: reception_of subject must be the LATER/receiving form. Greek Adonis (the name is Semitic adon, "lord") is the Greek reception of the Phoenician dying consort of Astarte at Byblos (Philo of Byblos apud Eusebius, PE 1.10), not vice versa.] The Greek Adonis derives from the Phoenician adon ("lord") of the Byblos cult. Philo of Byblos, Phoenician History (Sanchuniathon), via Eusebius, Praeparatio Evangelica 1.9-10 SRC_PHILO_BYBLOS needs_review  

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