Relationships

2,079 typed, source-backed relationships between entities. Each row records a directed relationship (subject → type → object) with a justifying source and rationale note. See relationship_types for the full controlled vocabulary of 70 relationship types. Key types: reception_of / received_as (transmission across traditions), equated_with (interpretatio graeca / analogues), parent_of (genealogy), member_of (collective membership), emanates_from (Gnostic/Neoplatonic structure).

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_KHALDI"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: confidence, source_id

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
2349 Khaldi ENT_URA_KHALDI patron_of War ENT_WAR high Khaldi is explicitly the war deity in Urartian royal annals — every campaign is conducted "by the greatness of Khaldi" and every victory is dedicated to him. He commands military action and receives the first fruits of conquest. His war-patron function is the most extensively documented aspect of his cult across the entire Urartian inscriptional corpus. Zimansky (1985) pp. 56-80. 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
2350 Khaldi ENT_URA_KHALDI aligned_with Ashur ENT_MES_ASHUR medium Khaldi and Assyrian Ashur are structurally parallel: both are the supreme national war deities of rival Iron Age kingdoms (Urartu and Assyria) in direct competition for domination of the Near East. Both receive dedication of military spoils, command campaigns, and legitimate royal authority through divine choice. The rivalry is documented in Sargon II's eighth campaign letter (714 BCE), where the sacking of Khaldi's Musasir temple is framed as Ashur's victory over Khaldi. Confidence medium: the alignment is structural and adversarial, not an ancient explicit equation. 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
4390 Khaldi ENT_URA_KHALDI member_of The Supreme Triad of Urartu ENT_URA_TRIAD high Khaldi heads the supreme triad as first-ranked national and war god in the Meher Kapisi list. 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

CSV options: 

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]);