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)'}
5 rows where period_id = "PER_ETR_ARCHAIC"
This data as json, CSV (advanced)
Suggested facets: relationship_type, object_entity_id, source_id
| 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 |
| 1631 | Uni ENT_ETR_UNI | spouse_of | Tinia ENT_ETR_TINIA | high | Uni as consort of Tinia; named in Pyrgi tablets as supreme goddess; de Grummond (2006) pp. 51-62 | Pyrgi Gold Tablets (c. 500 BCE) SRC_PYRGI_TABLETS | reviewed | Archaic Etruscan PER_ETR_ARCHAIC |
| 1634 | Jupiter ENT_ROM_JUPITER | syncretized_with | Tinia ENT_ETR_TINIA | high | Roman Jupiter was directly identified with Etruscan Tinia; the Capitoline temple (dedicated 509 BCE) housed the Etruscan-derived triad Jupiter-Juno-Minerva; de Grummond (2006) pp. 55-60; Pallottino (1975) p. 141 | De Grummond, Nancy Thomson. Etruscan Myth, Sacred History, and Legend (University of Pennsylvania Museum, 2006) SRC_DEGRUMMOND_ETRUSCAN | reviewed | Archaic Etruscan PER_ETR_ARCHAIC |
| 1635 | Juno ENT_ROM_JUNO | syncretized_with | Uni ENT_ETR_UNI | high | Roman Juno identified with Etruscan Uni; Juno's name may derive from Uni via Etruscan; the abduction of Uni's statue from Veii to Rome (396 BCE) demonstrates the identification; Pyrgi tablets link Uni to Astarte; de Grummond (2006) pp. 67-72 | Pyrgi Gold Tablets (c. 500 BCE) SRC_PYRGI_TABLETS | reviewed | Archaic Etruscan PER_ETR_ARCHAIC |
| 1636 | Minerva ENT_ROM_MINERVA | syncretized_with | Menrva ENT_ETR_MENRVA | high | Roman Minerva derives directly from Etruscan Menrva; the name Minerva is a Latin adaptation of Menrva; the Capitoline Triad (Jupiter-Juno-Minerva) was introduced to Rome from Etruria; de Grummond (2006) pp. 79-84 | De Grummond, Nancy Thomson. Etruscan Myth, Sacred History, and Legend (University of Pennsylvania Museum, 2006) SRC_DEGRUMMOND_ETRUSCAN | reviewed | Archaic Etruscan PER_ETR_ARCHAIC |
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]);