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

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