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 object_entity_id = "ENT_PYTHON"

✎ 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
10 Apollo ENT_APOLLO slays Python ENT_PYTHON high Apollo defeats Python at Delphi. Theoi Greek Gods category index SRC_THEOI_GODS reviewed  
1486 Illuyanka ENT_HTT_ILLUYANKA received_as Python ENT_PYTHON low The Illuyanka myth (Hittite) and the Apollo/Python tradition both belong to the broader Near Eastern "storm/solar deity defeats serpent to claim a sacred site" pattern, which appears also in Baal/Lotan (Ugaritic), Marduk/Tiamat (Babylonian), and Zeus/Typhon (Greek). Illuyanka is defeated by Tarhunna (the storm god) with help from the goddess Inaras and a mortal, paralleling the multi-agent defeats in other serpent-combat myths. The transmission to the specifically solar Apollo/Python form is indirect — probably via the same broad transmission pathway as other Near Eastern→Greek myth contacts in the Archaic period. Confidence low because Apollo (not the storm god) is the serpent's defeater in the Greek version, and no direct textual link between Illuyanka and Python is demonstrable. Harry A. Hoffner Jr., Hittite Myths, 2nd ed. (Society of Biblical Literature, 1998) SRC_HOFFNER_HITTITE_MYTHS reviewed Archaic Period PER_GRK_ARCHAIC

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