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

✎ View and edit SQL

This data as json, CSV (advanced)

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
1630 Tinia ENT_ETR_TINIA spouse_of Uni ENT_ETR_UNI high Tinia and Uni are paired as the supreme couple of the Etruscan pantheon, cognate with Zeus/Hera and Jupiter/Juno; the triad Tinia-Uni-Menrva mirrors the Roman Capitoline Triad, which was an Etruscan import; de Grummond (2006) pp. 51-62 De Grummond, Nancy Thomson. Etruscan Myth, Sacred History, and Legend (University of Pennsylvania Museum, 2006) SRC_DEGRUMMOND_ETRUSCAN reviewed Archaic Etruscan PER_ETR_ARCHAIC
2493 Tinia ENT_ETR_TINIA embodies Storm ENT_STORM high Tinia is the Etruscan sky and thunder god who hurls the lightning bolts; the Piacenza Liver maps his celestial domain and he heads the council that casts the three kinds of thunderbolt. De Grummond, Nancy Thomson. Etruscan Myth, Sacred History, and Legend (University of Pennsylvania Museum, 2006) SRC_DEGRUMMOND_ETRUSCAN reviewed  
2494 Tinia ENT_ETR_TINIA patron_of Sovereignty ENT_SOVEREIGNTY high Tinia is the supreme god of the Etruscan pantheon (the Etruscan Jupiter), head of the divine council and of the Capitoline-style triad with Uni and Menrva. De Grummond, Nancy Thomson. Etruscan Myth, Sacred History, and Legend (University of Pennsylvania Museum, 2006) SRC_DEGRUMMOND_ETRUSCAN 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]);