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 entity_class to filter by kind (19 controlled values: deity, angel, demon, aeon, sefirah, spirit, monster, hero, etc.). category is free text (1,148 values) and is not a reliable filter. 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 (934 distinct values; see entity_class for the controlled grouping)'}
category
{'description': 'Free-text functional category (1,148 distinct values, not normalised — filter on entity_class instead)'}
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, 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]);