Entities

The core table — every entity in the database, spanning gods, angels, demons, aeons, prophets, saints, heroes, spirits, monsters, personified abstractions, cosmological realms, and ritual categories. Use category to filter by functional type (146 values: Underworld Deity, Hero, Adversarial Being, Revealer Figure, etc.). Use tradition to filter by tradition. The short_note column contains a scholarly description with source citations.

Data license: MIT · Data source: jebboone/deitydb

entity_id
{'description': 'Stable identifier (e.g. ENT_GRK_ZEUS, ENT_EGY_OSIRIS, ENT_ISL_MUSA)'}
canonical_name
{'description': 'Primary English name used in the database'}
greek_name
{'description': 'Greek-script name, where applicable'}
tradition
{'description': 'Religious or cultural tradition of origin'}
entity_class
{'description': 'Controlled top-level kind (19 values: deity, angel, demon, aeon, sefirah, spirit, monster, hero, ruler, prophet, sage, saint, scriptural-figure, abstraction, collective, realm, ritual, title, object) — recommended for filtering by kind'}
entity_type
{'description': 'Granular free-text type descriptor (894 distinct values; see entity_class for the controlled grouping)'}
category
{'description': 'Broader functional category (146 values — recommended for filtering)'}
primary_domains
{'description': 'Primary divine domains, comma-separated'}
evidence_confidence
{'description': 'Sourcing quality: A = direct primary-text attestation; B = strong secondary; C = inference; D = speculative'}
chthonic_flag
{'description': 'True if this entity has underworld or chthonic associations'}
serpent_flag
{'description': 'True if this entity has serpent or dragon associations'}
short_note
{'description': 'Scholarly description with source citations'}

8 rows where entity_class = "hero" and tradition = "Celtic/Welsh"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category, evidence_confidence, review_status, inclusion_basis, earth_association_score

tradition 1

  • Celtic/Welsh · 8 ✖

entity_class 1

  • hero · 8 ✖
entity_id ▼ canonical_name greek_name tradition entity_type category primary_domains tags cult_scope primary_period evidence_confidence review_status inclusion_basis earth_association_score chthonic_flag serpent_flag short_note entity_class
ENT_WEL_CERIDWEN Ceridwen   Celtic/Welsh Enchantress Cauldron of Awen the cauldron; inspiration (awen); transformation   mythological   A candidate_verified_name Hanes Taliesin 2 0 0 The keeper of the Cauldron of Awen whose brew and pursuit reborn Gwion as Taliesin; a powerful enchantress (the "goddess of inspiration" framing is largely modern). hero
ENT_WEL_EFNYSIEN Efnysien   Celtic/Welsh Antagonist figure House of Llŷr strife; destruction   mythological   A candidate_verified_name Mabinogi, Second Branch 0 0 0 Son of Euroswydd and Penarddun, half-brother of Brân; the strife-maker who provokes the Irish war and destroys the Cauldron of Rebirth at the cost of his life. hero
ENT_WEL_GWYDION Gwydion   Celtic/Welsh Trickster magician Trickster Figure magic, shapeshifting, trickery, storytelling, creation trickster, magic, shapeshifting, Welsh, Mabinogion     A reviewed primary_text       Gwydion fab Dôn; Fourth Branch; nephew and student of Math; the great magician-trickster of Welsh mythology; conjures an illusory army from mushrooms to trick Pryderi out of his pigs; creates Lleu's wife Blodeuwedd from flowers; the most active and morally ambiguous figure in the Fourth Branch; creates the path of stars called Caer Gwydion (the Milky Way) in Welsh tradition hero
ENT_WEL_LLEU_LLAW_GYFFES Lleu Llaw Gyffes   Celtic/Welsh Solar hero Hero craftsmanship, solar, fate, death-rebirth solar, fate, death-rebirth, Welsh, Mabinogion     A reviewed primary_text       "Lleu of the Skillful Hand"; Fourth Branch; son of Aranrhod (and Gwydion); his mother refuses to acknowledge him and places three tyngedau (magical taboos) on him: no name, no weapons, no human wife; Gwydion circumvents each; killed by Gronw Pebyr (his wife's lover) with the only spear that can harm him; transformed into an eagle; restored to human form by Gwydion; his name cognate with Irish Lugh and Gaulish Lugus — the pan-Celtic "many-skilled" solar hero hero
ENT_WEL_LLWYD Llwyd ap Cil Coed   Celtic/Welsh Enchanter Dyfed enchantment; vengeance   mythological   B candidate_verified_name Mabinogi, Third Branch 0 0 0 The enchanter who lays the wasteland-spell on Dyfed and imprisons Pryderi and Rhiannon, avenging his friend Gwawl. hero
ENT_WEL_MORFRAN Morfran   Celtic/Welsh Divine/heroic figure Children of Ceridwen darkness; ugliness; battle   mythological   B candidate_verified_name Hanes Taliesin; Culhwch 0 0 0 "Great Crow" (also Afagddu, "Utter Darkness"), monstrous son of Ceridwen and Tegid Foel; a survivor of Camlan. hero
ENT_WEL_NISIEN Nisien   Celtic/Welsh Peacemaker figure House of Llŷr peace; concord   mythological   B candidate_verified_name Mabinogi, Second Branch 0 0 0 The peacemaker twin of Efnysien, who could make foes friends. hero
ENT_WEL_PRYDERI Pryderi   Celtic/Welsh Divine hero Hero fate, sovereignty, tragedy, Dyfed fate, Dyfed, tragedy, Welsh, Mabinogion     A reviewed primary_text       Son of Pwyll and Rhiannon; First Branch through Third Branch; the only character to appear in all four branches of the Mabinogi; born under enchantment and immediately stolen; his name means "Care/Anxiety"; a tragic hero figure whose life is framed by magical crises; killed by Gwydion in single combat in the Fourth Branch hero

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "entities" (
   [entity_id] TEXT PRIMARY KEY,
   [canonical_name] TEXT,
   [greek_name] TEXT,
   [tradition] TEXT,
   [entity_type] TEXT,
   [category] TEXT,
   [primary_domains] TEXT,
   [tags] TEXT,
   [cult_scope] TEXT,
   [primary_period] TEXT,
   [evidence_confidence] TEXT,
   [review_status] TEXT,
   [inclusion_basis] TEXT,
   [earth_association_score] INTEGER,
   [chthonic_flag] INTEGER,
   [serpent_flag] INTEGER,
   [short_note] TEXT,
   [entity_class] TEXT REFERENCES [entity_class]([class_id])
);
CREATE INDEX [idx_entities_entity_class]
    ON [entities] ([entity_class]);