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 object_entity_id = "ENT_ISL_AZRAIL"
This data as json, CSV (advanced)
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 1009 | Malak al-Mawt ENT_ISL_MALAK_AL_MAWT | identified_with | Azrail ENT_ISL_AZRAIL | medium | Azrail is a later/common name for the Angel of Death. | Hadith general reference layer SRC_HADITH_GENERAL | reviewed | |
| 1432 | Angel of Death ENT_ISR_ANGEL_OF_DEATH | received_as | Azrail ENT_ISL_AZRAIL | medium | The Islamic angel Azrail (Izra'il, the Angel of Death) is the named reception of the Israelite/Jewish Angel of Death tradition. The name Azrael appears in post-Talmudic Jewish literature; the Quran refers to "the angel of death appointed over you" (32:11) without naming him; the name Azrail becomes standard in Islamic theological and hadith tradition. The functional role (taking souls at death) is continuous from the Israelite Angel of Death through Talmudic tradition to the Islamic Azrail. | Hadith general reference layer SRC_HADITH_GENERAL | reviewed | Early Islam PER_ISL_EARLY |
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]);