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

28 rows where period_id = "PER_CEL_MEDIEVAL_WELSH"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: subject_entity_id, relationship_type, object_entity_id, confidence, source_id

relationship_id ▼ subject_entity_id relationship_type object_entity_id confidence rationale source_id review_status period_id
1602 Lleu Llaw Gyffes ENT_WEL_LLEU_LLAW_GYFFES reception_of Lugh ENT_CEL_LUGH medium Lleu Llaw Gyffes and Irish Lugh Lámhfhada are both cognates of the Gaulish deity *Lugus; all three share: the "many-skilled" / "long arm" epithet, a divine craftsman who answers every skill at once, spear as primary weapon, a fate/destiny narrative involving their birth and naming, and the defeat of a dark antagonist; Green (1992) pp. 131-132; Mac Cana (1970) pp. 53-57; the Welsh Lleu preserves the more archaic narrative framework (three tyngedau, flower-wife) while the Irish Lugh is more extensively attested Miranda Green, Dictionary of Celtic Myth and Legend SRC_GREEN_CELTIC_GODS reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1603 Manawydan ENT_WEL_MANAWYDAN reception_of Manannán mac Lir ENT_CEL_MANANNAN low Manawydan (Welsh) and Manannán mac Lir (Irish) share a common Celtic name-prototype *Manawydanō; in Irish tradition Manannán is an active sea-god and psychopomp; in Welsh tradition Manawydan is a land-based craftsman; the divergence suggests independent development from a common prototype rather than direct textual transmission; Mac Cana (1970) pp. 66-67; Green (1992) pp. 139-140; confidence is low because the character types are quite different despite the name connection Proinsias Mac Cana, Celtic Mythology SRC_MACCANA_CELTIC_MYTH reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1604 Arawn ENT_WEL_ARAWN rules Annwn ENT_WEL_ANNWN high Arawn is presented as king of Annwn in the First Branch; he approaches Pwyll to exchange kingdoms for a year to defeat Hafgan The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1605 Arawn ENT_WEL_ARAWN dwells_in Annwn ENT_WEL_ANNWN high Arawn resides in Annwn; his palace and hunting court are its defining feature in the First Branch The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1606 Gwyn ap Nudd ENT_WEL_GWYN_AP_NUDD rules Annwn ENT_WEL_ANNWN high Gwyn ap Nudd is named as lord of Annwn and the Otherworld dead; Culhwch ac Olwen; Welsh Triads 26; must ride to gather the dead on All Hallows The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1607 Gwyn ap Nudd ENT_WEL_GWYN_AP_NUDD dwells_in Annwn ENT_WEL_ANNWN high Gwyn ap Nudd presides over Annwn; his court is associated with Glastonbury Tor and the Otherworld hunt The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1608 Pwyll ENT_WEL_PWYLL spouse_of Rhiannon ENT_WEL_RHIANNON high Pwyll and Rhiannon marry in the First Branch after he wins her from Gwawl; she chooses him herself The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1609 Rhiannon ENT_WEL_RHIANNON spouse_of Pwyll ENT_WEL_PWYLL high Rhiannon chooses Pwyll as husband in the First Branch; rides to meet him at Gorsedd Arberth The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1610 Pwyll ENT_WEL_PWYLL parent_of Pryderi ENT_WEL_PRYDERI high Pryderi is the son of Pwyll and Rhiannon; named Pryderi (care/anxiety) by Rhiannon after he is found; First Branch The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1611 Rhiannon ENT_WEL_RHIANNON parent_of Pryderi ENT_WEL_PRYDERI high Rhiannon is mother of Pryderi; falsely accused of devouring him; exonerated when Teyrnon Twryf Lliant restores the boy; First Branch The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1612 Brân the Blessed ENT_WEL_BRAN sibling_of Branwen ENT_WEL_BRANWEN high Bran (Brân the Blessed) is brother of Branwen; the Second Branch opens with him on the rock of Harddlech with his sister The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1613 Branwen ENT_WEL_BRANWEN sibling_of Brân the Blessed ENT_WEL_BRAN high Branwen is sister of Brân the Blessed; her marriage to Matholwch of Ireland triggers the tragedy of the Second Branch The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1614 Brân the Blessed ENT_WEL_BRAN sibling_of Manawydan ENT_WEL_MANAWYDAN high Manawydan is named as brother of Bran in the Second Branch; together they lead the retinue to Ireland The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1615 Manawydan ENT_WEL_MANAWYDAN sibling_of Brân the Blessed ENT_WEL_BRAN high Manawydan is brother of Brân; survives the Irish expedition; Second Branch The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1616 Manawydan ENT_WEL_MANAWYDAN sibling_of Branwen ENT_WEL_BRANWEN high Manawydan is named as Branwen's brother in the Second Branch retinue The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1617 Branwen ENT_WEL_BRANWEN sibling_of Manawydan ENT_WEL_MANAWYDAN high Branwen is sister of Manawydan; named together as children of Llŷr; Second Branch The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1618 Manawydan ENT_WEL_MANAWYDAN spouse_of Rhiannon ENT_WEL_RHIANNON high Manawydan takes Rhiannon as wife at Pryderi's suggestion after Pwyll's death; Third Branch — the two marriages frame Rhiannon's sovereignty arc The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1619 Rhiannon ENT_WEL_RHIANNON spouse_of Manawydan ENT_WEL_MANAWYDAN high Rhiannon marries Manawydan in the Third Branch; her second marriage reinforces her sovereignty-goddess function The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1620 Dôn ENT_WEL_DON parent_of Gwydion ENT_WEL_GWYDION high Gwydion is consistently named Gwydion fab Dôn (son of Dôn) in the Fourth Branch; Dôn is the dynastic mother of the northern Welsh divine family The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1621 Dôn ENT_WEL_DON parent_of Aranrhod ENT_WEL_ARANRHOD high Aranrhod is daughter of Dôn; named ferch Dôn (daughter of Dôn) in the Fourth Branch The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1622 Gwydion ENT_WEL_GWYDION sibling_of Aranrhod ENT_WEL_ARANRHOD high Gwydion and Aranrhod are both children of Dôn; siblings in the Fourth Branch; their relationship is central to the tyngedau (fate-bindings) placed on Lleu The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1623 Aranrhod ENT_WEL_ARANRHOD sibling_of Gwydion ENT_WEL_GWYDION high Aranrhod is sister of Gwydion; her three tyngedau on her son Lleu are enacted through conflict with Gwydion; Fourth Branch The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1624 Aranrhod ENT_WEL_ARANRHOD parent_of Lleu Llaw Gyffes ENT_WEL_LLEU_LLAW_GYFFES high Aranrhod is the mother of Lleu; she steps over Math's staff as a virginity test and gives birth; she refuses to acknowledge Lleu and binds three tyngedau (fates) upon him; Fourth Branch The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1625 Math fab Mathonwy ENT_WEL_MATH creator_of Blodeuwedd ENT_WEL_BLODEUWEDD high Math and Gwydion together conjure Blodeuwedd from oak, broom, and meadowsweet to be a wife for Lleu, since Aranrhod's fate-binding prevents him marrying a human woman; Fourth Branch The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1626 Gwydion ENT_WEL_GWYDION creator_of Blodeuwedd ENT_WEL_BLODEUWEDD high Gwydion is co-creator of Blodeuwedd alongside Math; it is Gwydion who later transforms her into an owl as punishment for her betrayal of Lleu; Fourth Branch The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1627 Lleu Llaw Gyffes ENT_WEL_LLEU_LLAW_GYFFES spouse_of Blodeuwedd ENT_WEL_BLODEUWEDD high Blodeuwedd is made as wife for Lleu; the marriage and her betrayal (with Gronw Pebr) form the tragic core of the Fourth Branch The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1628 Blodeuwedd ENT_WEL_BLODEUWEDD spouse_of Lleu Llaw Gyffes ENT_WEL_LLEU_LLAW_GYFFES high Blodeuwedd is wife of Lleu; she arranges his near-death and is transformed into an owl by Gwydion; Fourth Branch The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH
1629 Math fab Mathonwy ENT_WEL_MATH teaches Gwydion ENT_WEL_GWYDION high Math teaches Gwydion the arts of magic; the Fourth Branch frames Gwydion as Math's apprentice and nephew; Mac Cana (1970) pp. 83-86 The Mabinogion SRC_MABINOGION reviewed Medieval Welsh PER_CEL_MEDIEVAL_WELSH

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