Relationships
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)'}
1 row where subject_entity_id = "ENT_PHO_ESHMUN"
This data as json, CSV (advanced)
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 1512 | Eshmun ENT_PHO_ESHMUN | received_as | Asclepius ENT_ASCLEPIUS | high | The Eshmun→Asclepius identification is extensively documented. The great Eshmun sanctuary north of Sidon — a major healing temple complex with a sacred spring — was described by Greek and Roman writers as an Asclepion, establishing a direct religious identification. The Eshmunazar II sarcophagus inscription (c. 450 BCE) names Eshmun explicitly as Sidon's chief healing deity. Philo of Byblos (c. 100 CE, citing Sanchuniathon) identifies the Phoenician healing deity with Asclepius. Pausanias notes the "Sidonian" character of Asclepius. Both Eshmun and Asclepius preside over healing sanctuaries with sacred springs, receive offerings from the sick, and are described as divine physicians. | Glenn Markoe, Phoenicians (London: British Museum Press / University of California Press, 2000) SRC_MARKOE_PHOENICIANS | reviewed | Classical Period PER_GRK_CLASSICAL |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);