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

16 rows where entity_class = "hero" and tradition = "Celtic/Irish"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: entity_type, category, evidence_confidence

tradition 1

  • Celtic/Irish · 16 ✖

entity_class 1

  • hero · 16 ✖
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_IRH_CESAIR Cesair   Celtic/Irish legendary_figure legendary_figure first settler of Ireland; pre-Flood arrival   devotional   C candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Granddaughter of Noah and leader of the first (pre-Flood) settlement in the Lebor Gabála Érenn. hero
ENT_IRH_CONCHOBAR Conchobar mac Nessa   Celtic/Irish hero hero king of the Ulaid; Emain Macha   devotional   B candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Legendary king of Ulster at Emain Macha in the Ulster Cycle. hero
ENT_IRH_CU_CHULAINN Cú Chulainn   Celtic/Irish hero hero warrior; champion of Ulster; the ríastrad (warp-spasm)   devotional   B candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Central hero of the Ulster Cycle; son/earthly aspect of the god Lugh. Attested throughout the Táin (Kinsella). hero
ENT_IRH_DEIRDRE Deirdre   Celtic/Irish hero hero tragic heroine; Longes mac nUislenn   devotional   B candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Heroine of 'The Exile of the Sons of Uisliu', a remscél of the Táin. hero
ENT_IRH_DIARMUID Diarmuid Ua Duibhne   Celtic/Irish hero hero fian warrior; the love-spot (ball seirce)   devotional   B candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Fenian warrior and foster-son of Aengus; elopes with Gráinne. hero
ENT_IRH_EMER Emer   Celtic/Irish hero hero wife of Cú Chulainn; the six gifts   devotional   C candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Wife of Cú Chulainn, wooed in Tochmarc Emire. hero
ENT_IRH_FERGUS Fergus mac Róich   Celtic/Irish hero hero exiled Ulster champion; virility   devotional   B candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Former king of Ulster exiled to Connacht, a leading warrior of the Táin. hero
ENT_IRH_FINTAN Fintan mac Bóchra   Celtic/Irish legendary_figure legendary_figure shapeshifting sage; the salmon; long memory   devotional   C candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Husband of Cesair who survives the Flood and ages through the eras as a witness-sage (Lebor Gabála; dindshenchas). hero
ENT_IRH_FIONN Fionn mac Cumhaill   Celtic/Irish hero hero fian-leader; seer; the salmon of knowledge   devotional   B candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Central hero of the Fenian Cycle, leader of the Fianna (Ó hÓgáin). hero
ENT_IRH_GRAINNE Gráinne   Celtic/Irish hero hero heroine; betrothed of Fionn; the elopement   devotional   B candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Daughter of Cormac mac Airt who elopes with Diarmuid (Tóraigheacht Dhiarmada agus Ghráinne). hero
ENT_IRH_MEDB Medb   Celtic/Irish hero hero queen of Connacht; sovereignty; instigator of the Táin   devotional   B candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Queen of Connacht whose cattle-raid drives the Táin; carries sovereignty-goddess overtones (Kinsella; Ó hÓgáin). hero
ENT_IRH_NEMED Nemed   Celtic/Irish legendary_figure legendary_figure invasion leader; ancestor of later peoples   devotional   C candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Leader of the third invasion and ancestor of the Fir Bolg and Tuatha Dé in the Lebor Gabála Érenn. hero
ENT_IRH_OISIN Oisín   Celtic/Irish hero hero poet-warrior; Tír na nÓg   devotional   B candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Son of Fionn, poet of the Fianna and namesake of the Ossianic Cycle; visits Tír na nÓg. hero
ENT_IRH_PARTHOLON Partholón   Celtic/Irish legendary_figure legendary_figure invasion leader; second settlement of Ireland   devotional   C candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Leader of the second invasion of Ireland in the Lebor Gabála Érenn. hero
ENT_IRH_SCATHACH Scáthach   Celtic/Irish hero hero warrior-woman; martial instructor; Alba/Skye   devotional   C candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Warrior-woman who trains Cú Chulainn and grants the gáe bolga (Tochmarc Emire). hero
ENT_IRH_TUAN Tuan mac Cairill   Celtic/Irish legendary_figure legendary_figure shapeshifting survivor; witness to the invasions   devotional   C candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Sole survivor of Partholón's people who lives through many animal forms and recounts the invasions (Scel Tuain). 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]);