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)'}

4 rows where subject_entity_id = "ENT_URA_TEISHEBA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_id

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
2351 Teisheba ENT_URA_TEISHEBA reception_of Teshub ENT_HTT_TESHUB high Urartian Teisheba is the direct reception of Hurrian Teshub through the Hurro-Urartian linguistic inheritance. The names correspond by regular sound change (Hurrian Teš(u)b → Urartian Teišeba), both are storm-thunder deities in the second rank of their divine triads, both are associated with the bull, and both command military conflict alongside their supreme deity. The Hurro-Urartian language family relationship (the two languages are closely related) makes this the most linguistically secure deity-to-deity connection in the Urartian layer. Zimansky (1985) pp. 68-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
2352 Teisheba ENT_URA_TEISHEBA patron_of Storm ENT_STORM high Teisheba is explicitly the storm and thunder deity of Urartu, called "lord of the sky" in Urartian inscriptions. The city Teishebaini ("city of Teisheba," modern Karmir Blur) takes its name from his storm-deity function. He is the direct successor of Hurrian Teshub in the Urartian theological system. Piotrovsky (1969) pp. 95-100. 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
2353 Teisheba ENT_URA_TEISHEBA aligned_with Tarhunna ENT_HTT_TARHUNNA high Teisheba and Hittite Tarhunna are parallel thunder deities of neighbouring Anatolian traditions — both derive from the same deep Anatolian storm-deity complex (Proto-Anatolian *tarḫu-, "to conquer/prevail"). They occupy the same second-rank position in their divine triads and share the bull iconography. The alignment reflects the broad Anatolian storm-deity tradition that also includes Ugaritic Baal, Mesopotamian Adad, and later Zeus. Zimansky (1985) p. 69. 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
4391 Teisheba ENT_URA_TEISHEBA member_of The Supreme Triad of Urartu ENT_URA_TRIAD high Teisheba is the second-ranked storm-god of the supreme 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

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