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

2 rows where subject_entity_id = "ENT_ITA_PICUS"

✎ 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
2460 Picus ENT_ITA_PICUS parent_of Faunus ENT_ITA_FAUNUS high Virgil Aeneid 7.48: "Fauno Picus pater" — Picus is the father of Faunus, making Picus the first generation of the Latin divine genealogy. This sequence (Picus → Faunus → Latinus → Lavinia ← Aeneas) is the genealogical spine of Virgil's Latium foundation myth. Virgil Aeneid 7.45-48. Virgil, Aeneid (19 BCE) SRC_VIRGIL_AENEID reviewed Archaic Italic (c. 900–509 BCE) PER_ITA_ARCHAIC
2462 Picus ENT_ITA_PICUS aligned_with Mars ENT_ROM_MARS medium The Picus Martius (woodpecker of Mars) is the specifically sacred bird of Mars in Roman augury. Ovid (Fasti 3.37-54) makes this connection explicit: the woodpecker is Mars's sacred bird because of its pecking/hammering action (associated with the war god's energy) and because the woodpecker Picus shares Mars's prophetic augural role. Pliny (NH 10.20) notes that Roman augury treated the woodpecker's behavior as directly communicating divine will. The identification of Picus the deity with Picus the bird of Mars suggests that the deity Picus may originally have been the personification or hypostasis of Mars's augural bird — i.e., Picus is the divine patron of the woodpecker's augural speech. Confidence medium: the connection is functional/cultic rather than a narrative identification. Ovid, Fasti SRC_OVID_FASTI reviewed Archaic Italic (c. 900–509 BCE) PER_ITA_ARCHAIC

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