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)'}
6 rows where subject_entity_id = "ENT_CAN_ASTARTE"
This data as json, CSV (advanced)
Suggested facets: relationship_type, confidence, source_id
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 503 | Astarte ENT_CAN_ASTARTE | patron_of | Fertility ENT_FERTILITY | medium | Astarte is associated with fertility and sexuality. | Dictionary of Deities and Demons in the Bible SRC_UGARIT_DDD | reviewed | |
| 510 | Astarte ENT_CAN_ASTARTE | patron_of | Love ENT_LOVE | medium | Astarte belongs to Northwest Semitic love/fertility goddess traditions. | Dictionary of Deities and Demons in the Bible SRC_UGARIT_DDD | reviewed | |
| 1369 | Astarte ENT_CAN_ASTARTE | reception_of | Inanna/Ishtar ENT_MES_INANNA_ISHTAR | medium | Astarte as Canaanite reception of Mesopotamian Ishtar; love/war attributes, iconography, and name cognate. | Dictionary of Deities and Demons in the Bible SRC_UGARIT_DDD | reviewed | Canaanite Bronze Age PER_CAN_BRONZE_AGE |
| 1384 | Astarte ENT_CAN_ASTARTE | received_as | Aphrodite ENT_APHRODITE | medium | Phoenician Astarte transmitted to Greek Aphrodite via Cyprus, where the Phoenician cult of Astarte at Paphos was continuous into the Greek period. Herodotus (Hist. 1.105) identifies the Aphrodite sanctuary at Ascalon as the oldest and calls it Phoenician in origin. DDD_BIBLE s.v. "Astarte" reviews the Greek reception. Both goddesses rule love, beauty, and warfare; Aphrodite's war aspect (prominent in Cyprus and Sparta) reflects the Canaanite love/war dual role that has no Olympian parallel. | Dictionary of Deities and Demons in the Bible SRC_DDD_BIBLE | reviewed | Archaic Period PER_GRK_ARCHAIC |
| 1518 | Astarte ENT_CAN_ASTARTE | received_as | Al-Uzza ENT_ARA_AL_UZZA | medium | Al-Uzza is the north Arabian continuation of the Semitic love/Venus goddess tradition that runs from Mesopotamian Inanna/Ishtar through Canaanite Astarte. The common elements are: (1) association with the planet Venus as the morning/evening star; (2) love and war function (Al-Uzza is invoked for protection in battle as well as for love); (3) association with sacred trees (Al-Uzza's sanctuary at Nakhla included sacred trees). The Nabataean Al-Uzza is sometimes depicted with the Aphrodite iconography that derives from Astarte. The transmission is most plausible through Phoenician-Arabian contact and the common Semitic religious substrate. Confidence medium: functional and iconographic parallels are strong; direct textual documentation of the Astarte→Al-Uzza transmission is limited. | John F. Healey, The Religion of the Nabataeans: A Conspectus (Leiden: Brill, 2001) SRC_HEALEY_NABATAEAN_RELIGION | reviewed | Pre-Islamic Arabia (Jahiliyyah) PER_ARA_PRE_ISLAMIC |
| 1539 | Astarte ENT_CAN_ASTARTE | received_as | Athtar ENT_SAB_ATHTAR | low | The South Arabian Athtar and the Canaanite Astarte/Ugaritic ʿAttar share the same etymological root (the proto-Semitic *ʿAttar- base) and the planet Venus as their primary celestial association. The Ugaritic ʿAttar (masculine) who temporarily sits on Baal's throne and is deemed too small for it (KTU 1.6 I 53-65) represents the masculine form of the Venus deity that South Arabian Athtar preserves. The gender divergence — Astarte is female, Athtar is male — reflects either an early Semitic tradition that was later feminized in the Levantine context, or independent masculine and feminine developments from a common ancestral deity. Cross (1973) treats them as related variants of the same root deity. Confidence low: the name cognate is certain; the precise transmission direction and mechanism are debated. | Frank Moore Cross, Canaanite Myth and Hebrew Epic (Harvard University Press, 1973) SRC_CROSS_CANAANITE_MYTH | reviewed | Sabaean and South Arabian Period PER_SABAEAN |
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]);