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

9 rows where source_id = "SRC_MACKEY_FREEMASONRY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: subject_entity_id, relationship_type, object_entity_id, confidence

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
7655 The Great Architect of the Universe (G.A.O.T.U.) ENT_MAS_GAOTU member_of The Masonic Lodge (Craft Freemasonry) ENT_MAS_LODGE high G.A.O.T.U. is the deity invoked in Craft Masonic ritual; anchors to the lodge hub. Albert G. Mackey, An Encyclopaedia of Freemasonry and Its Kindred Sciences (1874; rev. eds.) SRC_MACKEY_FREEMASONRY reviewed  
7656 Hiram Abiff ENT_MAS_HIRAM_ABIFF member_of The Masonic Lodge (Craft Freemasonry) ENT_MAS_LODGE high Hiram Abiff is the central legendary figure of Craft Masonry's Third Degree. Albert G. Mackey, An Encyclopaedia of Freemasonry and Its Kindred Sciences (1874; rev. eds.) SRC_MACKEY_FREEMASONRY reviewed  
7657 Jachin (the pillar) ENT_MAS_JACHIN member_of The Masonic Lodge (Craft Freemasonry) ENT_MAS_LODGE high The pillar Jachin is a core symbolic object of the Masonic lodge. Albert G. Mackey, An Encyclopaedia of Freemasonry and Its Kindred Sciences (1874; rev. eds.) SRC_MACKEY_FREEMASONRY reviewed  
7658 Boaz (the pillar) ENT_MAS_BOAZ member_of The Masonic Lodge (Craft Freemasonry) ENT_MAS_LODGE high The pillar Boaz is a core symbolic object of the Masonic lodge. Albert G. Mackey, An Encyclopaedia of Freemasonry and Its Kindred Sciences (1874; rev. eds.) SRC_MACKEY_FREEMASONRY reviewed  
7659 Jahbulon ENT_MAS_JAHBULON member_of The Masonic Lodge (Craft Freemasonry) ENT_MAS_LODGE medium Jahbulon belongs to Royal Arch Masonry, a continuation of the Craft lodge system. Albert G. Mackey, An Encyclopaedia of Freemasonry and Its Kindred Sciences (1874; rev. eds.) SRC_MACKEY_FREEMASONRY reviewed  
7663 Jachin (the pillar) ENT_MAS_JACHIN paired_with Boaz (the pillar) ENT_MAS_BOAZ high Jachin and Boaz are the inseparable twin pillars of Solomon's porch in Masonic symbolism. Albert G. Mackey, An Encyclopaedia of Freemasonry and Its Kindred Sciences (1874; rev. eds.) SRC_MACKEY_FREEMASONRY reviewed  
7664 Hiram Abiff ENT_MAS_HIRAM_ABIFF associated_with Solomon ENT_ISR_SOLOMON high The Hiramic legend casts Hiram Abiff as master-builder of King Solomon's Temple. Albert G. Mackey, An Encyclopaedia of Freemasonry and Its Kindred Sciences (1874; rev. eds.) SRC_MACKEY_FREEMASONRY reviewed  
7665 Jachin (the pillar) ENT_MAS_JACHIN associated_with Solomon ENT_ISR_SOLOMON medium The pillars Jachin and Boaz stood at the porch of Solomon's Temple in the legend the lodge draws on. Albert G. Mackey, An Encyclopaedia of Freemasonry and Its Kindred Sciences (1874; rev. eds.) SRC_MACKEY_FREEMASONRY reviewed  
7666 The Great Architect of the Universe (G.A.O.T.U.) ENT_MAS_GAOTU reception_of Demiurge ENT_HER_DEMIURGE medium The Masonic image of God as cosmic Architect/Craftsman receives the Hermetic-Platonic demiurgic-craftsman conception of the divine maker. Albert G. Mackey, An Encyclopaedia of Freemasonry and Its Kindred Sciences (1874; rev. eds.) SRC_MACKEY_FREEMASONRY 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]);