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)'}
2 rows where source_id = "SRC_MESHA_STELE"
This data as json, CSV (advanced)
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 2306 | Kemosh ENT_MOA_KEMOSH | patron_of | War ENT_WAR | high | Mesha Stele: Kemosh commands military campaigns ("Go, take Nebo"), receives the ḥērem spoils of battle, and is credited with both Moab's defeat (divine anger) and its victory (divine favour). The closest ancient parallel to a divine war commander in a national-deity context. | The Mesha Stele (Moabite Stone), c. 840 BCE; ed. John A. Dearman, Studies in the Mesha Inscription and Moab (Scholars Press / ASOR, Atlanta, 1989) SRC_MESHA_STELE | reviewed | Iron Age Transjordanian PER_TRANSJORDAN_IRON_AGE |
| 2307 | Ashtar-Kemosh ENT_MOA_ASHTAR_KEMOSH | cult_form_of | Kemosh ENT_MOA_KEMOSH | medium | The compound name Ashtar-Kemosh (Mesha Stele line 17) most plausibly represents Kemosh in a specific warrior/destructive cult manifestation — the same deity in his ḥērem (sacred destruction) aspect. The Ashtar element (Ugaritic Athtar, the warrior Venus) qualifies Kemosh's function in the context of sacred battle. Dearman (1989) pp. 118-120. | The Mesha Stele (Moabite Stone), c. 840 BCE; ed. John A. Dearman, Studies in the Mesha Inscription and Moab (Scholars Press / ASOR, Atlanta, 1989) SRC_MESHA_STELE | reviewed | Iron Age Transjordanian PER_TRANSJORDAN_IRON_AGE |
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]);