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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: relationship_type, object_entity_id, confidence, source_id, period_id

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
1507 Melqart ENT_PHO_MELQART reception_of Baal Hadad ENT_CAN_BAAL medium Melqart as the Iron Age Phoenician city-specific reception of the Bronze Age Baal/Hadad storm and kingship deity; the "Baal of Tyre" in Iron Age Israelite texts. Glenn Markoe, Phoenicians (London: British Museum Press / University of California Press, 2000) SRC_MARKOE_PHOENICIANS reviewed Phoenician Iron Age PER_PHO_IRON_AGE
1509 Melqart ENT_PHO_MELQART reception_of Dumuzi/Tammuz ENT_MES_DUMUZI_TAMMUZ low Melqart as a possible Phoenician reception of the Mesopotamian Dumuzi/Tammuz dying-deity tradition via the annual egersis/awakening rite. Glenn Markoe, Phoenicians (London: British Museum Press / University of California Press, 2000) SRC_MARKOE_PHOENICIANS reviewed Phoenician Iron Age PER_PHO_IRON_AGE
1510 Melqart ENT_PHO_MELQART received_as Heracles ENT_HERACLES high The Melqart→Heracles identification is one of the best-documented Phoenician→Greek religious transmissions. Herodotus 2.44 explicitly states that he visited the Tyrian temple of Heracles, notes that it was far older than the Greek Heracles tradition, and concludes that there were "two Heracleses" — clearly distinguishing the Phoenician Melqart from the Greek hero. Melqart's attributes transmitted to Heracles include: (1) the lion-skin (Melqart depicted in lion garb in Phoenician iconography); (2) the club; (3) navigation and founding of colonies (Cadiz/Gadir was a Phoenician colony with a famous Melqart-Heracles sanctuary); (4) the dying-and-apotheosis narrative (Melqart's egersis → Heracles's immolation and apotheosis on Oeta). The identification was standard in the Greek world by the Archaic period. Herodotus, Histories (c. 430 BCE) SRC_HERODOTUS_HISTORIES reviewed Archaic Period PER_GRK_ARCHAIC
6001 Melqart ENT_PHO_MELQART equated_with Heracles ENT_HERACLES high Melqart of Tyre was identified with Heracles throughout the Greco-Roman world (Herodotus 2.44, the 'Tyrian Heracles'). Herodotus, Histories (c. 430 BCE) SRC_HERODOTUS_HISTORIES 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]);