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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: relationship_type, source_id

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
2469 Flora ENT_ITA_FLORA aligned_with Ceres ENT_ROM_CERES medium Flora and Ceres are complementary Roman agricultural deities: Ceres presides over grain cultivation and the staple crops; Flora presides over the flowering plants and spring bloom that announces the growing season. Their Floralia (28 April) and the Cerealia (19 April) fall within days of each other in the Roman festival calendar, and both are associated with abundance, fertility, and the plebeian festival calendar. Ovid (Fasti 4-5) treats their festivals consecutively, implying a conceptual pairing. The alignment is functional rather than mythological: they are not identified as the same deity but belong to the same domain cluster of vegetation and fertility. Ovid Fasti 4 (Cerealia) and 5 (Floralia). Ovid, Fasti SRC_OVID_FASTI reviewed Archaic Italic (c. 900–509 BCE) PER_ITA_ARCHAIC
3372 The Indigitamenta ENT_ROM_INDIGITAMENTA presided_over_by Ceres ENT_ROM_CERES medium The agricultural indigitamenta were invoked by the flamen of Ceres. Servius, In Vergilii Carmina Commentarii (Commentary on Virgil), c. 400 CE SRC_SERVIUS_COMMENTARY reviewed  
3379 Seia ENT_ROM_SEIA presided_over_by Ceres ENT_ROM_CERES medium Grain-protecting goddess in the sphere of Ceres. Georg Wissowa, Religion und Kultus der Römer (2nd ed., Munich, 1912) SRC_WISSOWA_RKR reviewed  
3380 Robigus ENT_ROM_ROBIGUS presided_over_by Ceres ENT_ROM_CERES medium Averts rust from the crop of Ceres. Ovid, Fasti SRC_OVID_FASTI 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]);