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

19 rows where entity_class = "hero" and tradition = "Arthurian"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: entity_type, category

tradition 1

  • Arthurian · 19 ✖

entity_class 1

  • hero · 19 ✖
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_ART_AGRAVAIN Agravain   Arthurian Knight Knight of the Round Table kinship; intrigue; the exposure of the adultery   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Brother of Gawain who with Mordred exposes the affair, triggering the collapse. hero
ENT_ART_BEDIVERE Bedivere   Arthurian Knight Knight of the Round Table loyalty; the return of Excalibur   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Companion who casts Excalibur back into the lake at Arthur's end. hero
ENT_ART_BORS Bors   Arthurian Knight Knight of the Round Table chivalry; piety; the Grail quest   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Cousin of Lancelot and the only Grail achiever to return to Camelot. hero
ENT_ART_ELAINE_ASTOLAT Elaine of Astolat   Arthurian Legendary figure Legendary lover unrequited love; tragic death   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 The lily maid of Astolat who dies of unrequited love for Lancelot. hero
ENT_ART_ELAINE_CORBENIC Elaine of Corbenic   Arthurian Legendary figure Grail lineage the Grail lineage; the conception of Galahad   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Daughter of Pelles who conceives Galahad with Lancelot to fulfill prophecy. hero
ENT_ART_GAHERIS Gaheris   Arthurian Knight Knight of the Round Table kinship; the Orkney feud; vengeance   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Brother of Gawain who slays Morgause; later killed by Lancelot. hero
ENT_ART_GALAHAD Galahad   Arthurian Knight Knight of the Round Table perfect chastity; the Grail quest; holiness   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Son of Lancelot and Elaine of Corbenic, the sinless knight who achieves the Grail. hero
ENT_ART_GARETH Gareth   Arthurian Knight Knight of the Round Table chivalry; the proving of worth; kinship   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Brother of Gawain who proves his knighthood; slain inadvertently by Lancelot. hero
ENT_ART_GAWAIN Gawain   Arthurian Knight Knight of the Round Table chivalry; courtesy; kinship loyalty; the test of honor   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Eldest son of Lot and Morgause and nephew of Arthur; tested by the Green Knight. hero
ENT_ART_GREEN_KNIGHT The Green Knight   Arthurian Legendary figure Otherworldly challenger the beheading game; the test of honor; the otherworld   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Green otherworldly challenger (Bertilak enchanted) who tests Gawain's honor in the beheading game. hero
ENT_ART_KAY Kay   Arthurian Knight Knight of the Round Table the seneschalship; blunt speech   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Arthur's foster-brother and seneschal, brusque but loyal. hero
ENT_ART_LADY_OF_THE_LAKE The Lady of the Lake   Arthurian Enchantress Otherworldly figure magic; the otherworld; the giving of Excalibur   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Otherworldly enchantress (Nimue/Viviane) who gives Excalibur, fosters Lancelot, and enchants Merlin. hero
ENT_ART_LAMORAK Lamorak   Arthurian Knight Knight of the Round Table prowess; the Pellinore-Orkney feud; courtly love   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Son of Pellinore; his affair with Morgause leads to murder by the Orkney brothers. hero
ENT_ART_LANCELOT Lancelot   Arthurian Knight Knight of the Round Table chivalry; prowess; courtly love; the adultery with Guinevere   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 The foremost knight, whose love for Guinevere brings the realm to ruin. hero
ENT_ART_MERLIN Merlin   Arthurian Sorcerer Prophet-mage magic; prophecy; counsel; the founding of the realm   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Prophet-magician who engineers Arthur's begetting and establishes the Round Table; in Robert de Boron, fathered by a devil and baptized. hero
ENT_ART_MORDRED Mordred   Arthurian Knight Legendary traitor treachery; usurpation; the destruction of the realm   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Begotten by Arthur upon Morgause; slays and is slain by Arthur at Camlann. hero
ENT_ART_MORGAN_LE_FAY Morgan le Fay   Arthurian Enchantress Sorceress magic; healing; enmity toward the court   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Magical half-sister of Arthur, both healer at Avalon and adversary of the court. hero
ENT_ART_PERCEVAL Perceval   Arthurian Knight Knight of the Round Table the Grail quest; innocence; chivalric formation   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 The naive young knight (Parzival) who comes to the Grail castle; one of the Grail achievers. hero
ENT_ART_TRISTAN Tristan   Arthurian Knight Knight of the Round Table chivalry; the tragic love for Isolde   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Cornish knight whose love for Isolde parallels the Lancelot-Guinevere affair. 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]);