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)'}
3 rows where subject_entity_id = "ENT_URA_SHIVINI"
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 |
|---|---|---|---|---|---|---|---|---|
| 2354 | Shivini ENT_URA_SHIVINI | aligned_with | Utu/Shamash ENT_MES_UTU_SHAMASH | medium | Shivini and Mesopotamian Utu/Shamash are parallel sun deities of neighboring ancient Near Eastern traditions. Both are depicted with a solar disk, both serve as witnesses to oaths and upholders of justice, and both occupy a third-rank position in their divine triads (after the sky deity and storm deity). The alignment reflects the shared ancient Near Eastern theology of the sun as the divine witness of justice. Zimansky (1985) p. 70. | Paul E. Zimansky, Ecology and Empire: The Structure of the Urartian State (Studies in Ancient Oriental Civilization 41; Oriental Institute of the University of Chicago, Chicago, 1985) SRC_ZIMANSKY_URARTU | reviewed | Kingdom of Urartu PER_URA_IRON_AGE |
| 2355 | Shivini ENT_URA_SHIVINI | aligned_with | Sun Goddess of Arinna ENT_HTT_ARINNA | medium | Shivini and the Hittite Sun Goddess of Arinna are parallel Anatolian solar deities. Both are venerated as supreme solar powers in Anatolian Iron Age and Bronze Age religion; the winged sun disk iconography is shared across both traditions. Shivini occupies a structurally similar position in the Urartian triad to the Hittite solar deity in the Hittite pantheon. Zimansky (1985) p. 70; Piotrovsky (1969) p. 97. | Paul E. Zimansky, Ecology and Empire: The Structure of the Urartian State (Studies in Ancient Oriental Civilization 41; Oriental Institute of the University of Chicago, Chicago, 1985) SRC_ZIMANSKY_URARTU | reviewed | Kingdom of Urartu PER_URA_IRON_AGE |
| 4392 | Shivini ENT_URA_SHIVINI | member_of | The Supreme Triad of Urartu ENT_URA_TRIAD | high | Shivini is the third-ranked sun-god completing the Khaldi-Teisheba-Shivini triad. | Boris B. Piotrovsky, The Ancient Civilization of Urartu: An Archaeological Adventure, trans. James Hogarth (Cowles / Cresset Press, New York / London, 1969) SRC_PIOTROVSKY_URARTU | reviewed |
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]);