deitydb: entity_relationships: 52 rows where relationship_type = "has

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

52 rows where relationship_type = "has_member"

descending

✎ 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
14	Dioscuri ENT_DIOSCURI	has_member	Castor ENT_CASTOR	high	Castor is one of the Dioscuri.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
15	Dioscuri ENT_DIOSCURI	has_member	Polydeuces ENT_POLYDEUCES	high	Polydeuces is one of the Dioscuri.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
67	Moirai ENT_MOIRAI	has_member	Clotho ENT_CLOTHO	high	Clotho is one of the Moirai.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
68	Moirai ENT_MOIRAI	has_member	Lachesis ENT_LACHESIS	high	Lachesis is one of the Moirai.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
69	Moirai ENT_MOIRAI	has_member	Atropos ENT_ATROPOS	high	Atropos is one of the Moirai.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
70	Charites ENT_CHARITES	has_member	Aglaia ENT_AGLAIA	high	Aglaia is one of the Charites.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
71	Charites ENT_CHARITES	has_member	Euphrosyne ENT_EUPHROSYNE	high	Euphrosyne is one of the Charites.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
72	Charites ENT_CHARITES	has_member	Thalia Grace ENT_THALIA_GRACE	high	Thalia is one of the Charites.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
73	Muses ENT_MUSES	has_member	Calliope ENT_CALLIOPE	high	Calliope is one of the Muses.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
74	Muses ENT_MUSES	has_member	Clio ENT_CLIO	high	Clio is one of the Muses.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
75	Muses ENT_MUSES	has_member	Erato ENT_ERATO	high	Erato is one of the Muses.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
76	Muses ENT_MUSES	has_member	Euterpe ENT_EUTERPE	high	Euterpe is one of the Muses.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
77	Muses ENT_MUSES	has_member	Melpomene ENT_MELPOMENE	high	Melpomene is one of the Muses.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
78	Muses ENT_MUSES	has_member	Polyhymnia ENT_POLYHYMNIA	high	Polyhymnia is one of the Muses.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
79	Muses ENT_MUSES	has_member	Terpsichore ENT_TERPSICHORE	high	Terpsichore is one of the Muses.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
80	Muses ENT_MUSES	has_member	Thalia Muse ENT_THALIA_MUSE	high	Thalia Muse is one of the Muses.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
81	Muses ENT_MUSES	has_member	Urania Muse ENT_URANIA_MUSE	high	Urania Muse is one of the Muses.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
82	Anemoi ENT_ANEMOI	has_member	Boreas ENT_BOREAS	high	Boreas is one of the Anemoi.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
83	Anemoi ENT_ANEMOI	has_member	Zephyrus ENT_ZEPHYRUS	high	Zephyrus is one of the Anemoi.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
84	Anemoi ENT_ANEMOI	has_member	Notus ENT_NOTUS	high	Notus is one of the Anemoi.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
85	Anemoi ENT_ANEMOI	has_member	Eurus ENT_EURUS	high	Eurus is one of the Anemoi.	Theoi Greek Gods category index SRC_THEOI_GODS	reviewed
527	Watchers ENT_ISR_WATCHERS	has_member	Azazel ENT_ISR_AZAZEL	medium	Azazel is one of the fallen Watchers in Enochic tradition.	1 Enoch SRC_1_ENOCH	reviewed
545	Watchers ENT_ISR_WATCHERS	has_member	Shemihazah ENT_ISR_SHEMIHAZAH	high	Shemihazah is a leader of the Watchers.	1 Enoch SRC_1_ENOCH	reviewed
592	Pleroma ENT_GNO_PLEROMA	has_member	Aeons ENT_GNO_AEONS	high	Aeons collectively belong to the Pleroma.	Bentley Layton, The Gnostic Scriptures SRC_LAYTON_GNOSTIC	reviewed
620	Four Luminaries ENT_SET_FOUR_LUMINARIES	has_member	Daveithe ENT_SET_DAVEITHE	high	Daveithe is one of the Four Luminaries.	Nag Hammadi Library SRC_NHC	reviewed
621	Four Luminaries ENT_SET_FOUR_LUMINARIES	has_member	Eleleth ENT_SET_ELELETH	high	Eleleth is one of the Four Luminaries.	Nag Hammadi Library SRC_NHC	reviewed
622	Four Luminaries ENT_SET_FOUR_LUMINARIES	has_member	Harmozel ENT_SET_HARMOZEL	high	Harmozel is one of the Four Luminaries.	Nag Hammadi Library SRC_NHC	reviewed
624	Four Luminaries ENT_SET_FOUR_LUMINARIES	has_member	Oroiael ENT_SET_OROIAEL	high	Oroiael is one of the Four Luminaries.	Nag Hammadi Library SRC_NHC	reviewed
665	Hebdomad ENT_OPH_HEBDOMAD	has_member	Adonaios ENT_OPH_ADONAIOS	high	Adonaios appears among archontic ruler lists associated with the seven.	Bentley Layton, The Gnostic Scriptures SRC_LAYTON_GNOSTIC	reviewed
675	Hebdomad ENT_OPH_HEBDOMAD	has_member	Astaphaios ENT_OPH_ASTAPHAIOS	high	Astaphaios appears among archontic ruler lists associated with the seven.	Bentley Layton, The Gnostic Scriptures SRC_LAYTON_GNOSTIC	reviewed
676	Hebdomad ENT_OPH_HEBDOMAD	has_member	Eloaios ENT_OPH_ELOAIOS	high	Eloaios appears among archontic ruler lists associated with the seven.	Bentley Layton, The Gnostic Scriptures SRC_LAYTON_GNOSTIC	reviewed
678	Hebdomad ENT_OPH_HEBDOMAD	has_member	Horaios ENT_OPH_HORAIOS	high	Horaios appears among archontic ruler lists associated with the seven.	Bentley Layton, The Gnostic Scriptures SRC_LAYTON_GNOSTIC	reviewed
679	Hebdomad ENT_OPH_HEBDOMAD	has_member	Iao ENT_OPH_IAO	high	Iao appears among archontic ruler lists associated with the seven.	Bentley Layton, The Gnostic Scriptures SRC_LAYTON_GNOSTIC	reviewed
680	Hebdomad ENT_OPH_HEBDOMAD	has_member	Oraios ENT_OPH_ORAIOS	high	Oraios appears among archontic ruler lists associated with the seven.	Bentley Layton, The Gnostic Scriptures SRC_LAYTON_GNOSTIC	reviewed
686	Hebdomad ENT_OPH_HEBDOMAD	has_member	Sabaoth ENT_OPH_SABAOTH	high	Sabaoth appears among archontic ruler lists associated with the seven.	Bentley Layton, The Gnostic Scriptures SRC_LAYTON_GNOSTIC	reviewed
687	Hebdomad ENT_OPH_HEBDOMAD	has_member	Sabaoth ENT_GNO_SABAOTH	high	Sabaoth appears among archontic ruler lists associated with the seven.	Bentley Layton, The Gnostic Scriptures SRC_LAYTON_GNOSTIC	reviewed
881	Amesha Spentas ENT_ZOR_AMESHA_SPENTAS	has_member	Ameretat ENT_ZOR_AMERETAT	high	Ameretat is one of the Amesha Spentas.	Mary Boyce, Zoroastrians SRC_BOYCE_ZOROASTRIANS	reviewed
883	Amesha Spentas ENT_ZOR_AMESHA_SPENTAS	has_member	Asha Vahishta ENT_ZOR_ASHA_VAHISHTA	high	Asha Vahishta is one of the Amesha Spentas.	Mary Boyce, Zoroastrians SRC_BOYCE_ZOROASTRIANS	reviewed
895	Amesha Spentas ENT_ZOR_AMESHA_SPENTAS	has_member	Haurvatat ENT_ZOR_HAURVATAT	high	Haurvatat is one of the Amesha Spentas.	Mary Boyce, Zoroastrians SRC_BOYCE_ZOROASTRIANS	reviewed
898	Amesha Spentas ENT_ZOR_AMESHA_SPENTAS	has_member	Khshathra Vairya ENT_ZOR_KHSHATHRA	high	Khshathra Vairya is one of the Amesha Spentas.	Mary Boyce, Zoroastrians SRC_BOYCE_ZOROASTRIANS	reviewed
904	Amesha Spentas ENT_ZOR_AMESHA_SPENTAS	has_member	Spenta Armaiti ENT_ZOR_SPENTA_ARMATI	high	Spenta Armaiti is one of the Amesha Spentas.	Mary Boyce, Zoroastrians SRC_BOYCE_ZOROASTRIANS	reviewed
906	Amesha Spentas ENT_ZOR_AMESHA_SPENTAS	has_member	Vohu Manah ENT_ZOR_VOHU_MANAH	high	Vohu Manah is one of the Amesha Spentas.	Mary Boyce, Zoroastrians SRC_BOYCE_ZOROASTRIANS	reviewed
1038	Sefirot ENT_JM_SEFIROT	has_member	Binah ENT_JM_BINAH	high	Binah is a sephirah.	Zohar SRC_ZOHAR	reviewed
1046	Sefirot ENT_JM_SEFIROT	has_member	Hokhmah ENT_JM_HOKHMAH	high	Hokhmah is a sephirah.	Zohar SRC_ZOHAR	reviewed
1047	Sefirot ENT_JM_SEFIROT	has_member	Keter ENT_JM_KETER	high	Keter is a sephirah.	Zohar SRC_ZOHAR	reviewed
2541	Sefirot ENT_JM_SEFIROT	has_member	Chesed ENT_JM_CHESED	high	Chesed is the fourth of the ten Sefirot.	Zohar SRC_ZOHAR	reviewed	Jewish Mystical Medieval PER_JM_MEDIEVAL
2542	Sefirot ENT_JM_SEFIROT	has_member	Gevurah ENT_JM_GEVURAH	high	Gevurah is the fifth of the ten Sefirot.	Zohar SRC_ZOHAR	reviewed	Jewish Mystical Medieval PER_JM_MEDIEVAL
2543	Sefirot ENT_JM_SEFIROT	has_member	Tiferet ENT_JM_TIFERET	high	Tiferet is the sixth of the ten Sefirot.	Zohar SRC_ZOHAR	reviewed	Jewish Mystical Medieval PER_JM_MEDIEVAL
2544	Sefirot ENT_JM_SEFIROT	has_member	Netzach ENT_JM_NETZACH	high	Netzach is the seventh of the ten Sefirot.	Zohar SRC_ZOHAR	reviewed	Jewish Mystical Medieval PER_JM_MEDIEVAL
2545	Sefirot ENT_JM_SEFIROT	has_member	Hod ENT_JM_HOD	high	Hod is the eighth of the ten Sefirot.	Zohar SRC_ZOHAR	reviewed	Jewish Mystical Medieval PER_JM_MEDIEVAL
2546	Sefirot ENT_JM_SEFIROT	has_member	Yesod ENT_JM_YESOD	high	Yesod is the ninth of the ten Sefirot.	Zohar SRC_ZOHAR	reviewed	Jewish Mystical Medieval PER_JM_MEDIEVAL
2547	Sefirot ENT_JM_SEFIROT	has_member	Malkhut ENT_JM_MALKHUT	high	Malkhut is the tenth of the ten Sefirot.	Zohar SRC_ZOHAR	reviewed	Jewish Mystical Medieval PER_JM_MEDIEVAL

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

Relationships

52 rows where relationship_type = "has_member"

Advanced export