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 object_entity_id = "ENT_ISR_NEPHILIM"
This data as json, CSV (advanced)
Suggested facets: relationship_type, rationale, source_id
| relationship_id ▼ | subject_entity_id | relationship_type | object_entity_id | confidence | rationale | source_id | review_status | period_id |
|---|---|---|---|---|---|---|---|---|
| 2422 | Shemihazah ENT_ISR_SHEMIHAZAH | parent_of | Nephilim ENT_ISR_NEPHILIM | high | 1 Enoch 7:2: "And they became pregnant, and they bore great giants... And when they had grown up, they turned against those who nourished them..." The Nephilim are specifically the offspring of Shemihazah's group of Watchers — 1 Enoch 7:1 names the women "they took" under Shemihazah's leadership. In 1 Enoch 10:12, God tells Michael to bind "Shemihazah and his associates, who have intermixed with women so as to have defiled themselves with them." The parent_of relationship captures Shemihazah's role as the primary Watcher whose congress with human women produced the Nephilim. | 1 Enoch SRC_1_ENOCH | reviewed | Second Temple Period PER_ISR_SECOND_TEMPLE |
| 2423 | Watchers ENT_ISR_WATCHERS | parent_of | Nephilim ENT_ISR_NEPHILIM | high | 1 Enoch 6-7: the 200 Watchers collectively father the Nephilim giants through their unions with human women. The parent_of relationship from the Watchers collective to the Nephilim collective captures this fundamental generative relationship in the Enochic cosmological drama. | 1 Enoch SRC_1_ENOCH | reviewed | Second Temple Period PER_ISR_SECOND_TEMPLE |
| 2798 | Ohyah ENT_ISR_OHYAH | member_of | Nephilim ENT_ISR_NEPHILIM | high | The giants of the Book of Giants are the Nephilim. | The Book of Giants (4Q203, 1Q23 etc.), Dead Sea Scrolls; also the Manichaean Book of Giants SRC_DSS_BOOK_OF_GIANTS | reviewed | |
| 2799 | Hahyah ENT_ISR_HAHYAH | member_of | Nephilim ENT_ISR_NEPHILIM | high | The giants of the Book of Giants are the Nephilim. | The Book of Giants (4Q203, 1Q23 etc.), Dead Sea Scrolls; also the Manichaean Book of Giants SRC_DSS_BOOK_OF_GIANTS | reviewed | |
| 2800 | Mahaway ENT_ISR_MAHAWAY | member_of | Nephilim ENT_ISR_NEPHILIM | high | The giants of the Book of Giants are the Nephilim. | The Book of Giants (4Q203, 1Q23 etc.), Dead Sea Scrolls; also the Manichaean Book of Giants SRC_DSS_BOOK_OF_GIANTS | reviewed |
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]);