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 object_entity_id = "ENT_URA_KHALDI"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: relationship_type, confidence

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
2356 Arubani ENT_URA_ARUBANI spouse_of Khaldi ENT_URA_KHALDI medium Arubani is designated "the deity of Khaldi" in Urartian inscriptions and is associated with him as his divine consort. The pairing mirrors the broader Hurrian theological pattern where the supreme deity (Teshub) has a consort (Hepat). Confidence medium: the spousal relationship is inferred from the inscriptional association rather than being explicitly stated as marriage in the surviving Urartian texts. Piotrovsky (1969) pp. 100-102. 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 Kingdom of Urartu PER_URA_IRON_AGE
4394 Bagmashtu ENT_URA_BAGMASHTU spouse_of Khaldi ENT_URA_KHALDI medium At Musasir, dedications name 'Khaldi and his wife Bagmashtu'. 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  
4403 The Spear of Khaldi ENT_URA_SPEAR_KHALDI guardian_of Khaldi ENT_URA_KHALDI high The spear is the cult weapon of Khaldi, stored in his temples as the instrument of his victories. 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]);