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)'}
2 rows where source_id = "SRC_CICERO_DE_NATURA"
This data as json, CSV (advanced)
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 2914 | Fides ENT_ROM_FIDES | aligned_with | Jupiter ENT_ROM_JUPITER | medium | Fides is closely linked to Jupiter as guarantor of oaths (Dius Fidius). | Cicero, De Natura Deorum (45 BCE) SRC_CICERO_DE_NATURA | reviewed | |
| 8039 | Thoth ENT_EGY_THOTH | equated_with | Hermes ENT_HERMES | high | Ancient equation, in Cicero's enumeration of the several Mercurii (= Greek Hermes): "A fifth, whom we call, in their language, Thoth, as with them the first month of the year is called, is he whom the people of Pheneum worship, and who is said to have killed Argus, to have fled for it into Egypt, and to have given laws and learning to the Egyptians." (De Natura Deorum 3.56; trans. Yonge, PG #14988, verified verbatim 2026-07-01, bracketed footnote number stripped). Cf. the Thoth->Hermes Trismegistus chain already in the DB. Encoded equated_with per policy. [v2.1.60] | Cicero, De Natura Deorum (45 BCE) SRC_CICERO_DE_NATURA | needs_review | Hellenistic Period PER_GRK_HELLENISTIC |
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]);