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_BAAL_HAMMON"
This data as json, CSV (advanced)
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 1516 | Baal Hammon ENT_PHO_BAAL_HAMMON | received_as | Saturn ENT_ROM_SATURN | medium | Diodorus Siculus 20.14 explicitly calls the god of Carthage to whom children were sacrificed "Kronos," using the Greek name for Saturn. In Roman North Africa, Baal Hammon was worshipped as Saturnus Africanus; thousands of votive stelae to Saturnus from Roman North Africa continue the Baal Hammon tradition. Tertullian (Apology 9) identifies "Saturnus" as the North African deity who receives child sacrifice. The molk rite — child sacrifice to Baal Hammon — persisted in the Saturnus Africanus cult in vestigial forms. The identification reflects shared chthonic and agricultural associations: both Saturn/Kronos and Baal Hammon are associated with time, the cycles of harvest, and the demands of divine sovereignty. Confidence medium because the theological mapping is partially opportunistic (Roman interpretatio) rather than purely functional. | Glenn Markoe, Phoenicians (London: British Museum Press / University of California Press, 2000) SRC_MARKOE_PHOENICIANS | reviewed | Roman Imperial PER_ROM_IMPERIAL |
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]);