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

9 rows where entity_class = "ruler" and tradition = "Arthurian"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: entity_type, category

tradition 1

  • Arthurian · 9 ✖

entity_class 1

  • ruler · 9 ✖
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_ARTHUR King Arthur   Arthurian King Legendary king kingship; war; the Round Table; the once and future king   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Legendary king of the Britons who founds the Round Table at Camelot and is borne to Avalon after Camlann. ruler
ENT_ART_FISHER_KING The Fisher King   Arthurian King Grail guardian guardianship of the Grail; the wasteland and its healing   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Maimed guardian of the Grail (Pelles/Anfortas) whose wound mirrors the wasteland. ruler
ENT_ART_GUINEVERE Guinevere   Arthurian Queen Legendary queen queenship; courtly love; the affair with Lancelot   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Wife of Arthur whose love for Lancelot precipitates the fall of the realm. ruler
ENT_ART_IGRAINE Igraine   Arthurian Queen Legendary noblewoman noble lineage; the begetting of Arthur   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Wife of Gorlois then Uther; mother of Arthur, Morgan, and Morgause. ruler
ENT_ART_ISOLDE Isolde   Arthurian Queen Legendary lover tragic love; the love potion; courtly devotion   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Irish princess and queen of Cornwall, fated lover of Tristan. ruler
ENT_ART_KING_LOT King Lot   Arthurian King Legendary king kingship; war; the Orkney lineage   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 King of Orkney, husband of Morgause and father of Gawain and his brothers. ruler
ENT_ART_MORGAUSE Morgause   Arthurian Queen Legendary noblewoman queenship; the begetting of Mordred; the Orkney lineage   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Half-sister of Arthur, wife of Lot, mother of the Orkney knights and of Mordred. ruler
ENT_ART_PELLINORE Pellinore   Arthurian King Knight of the Round Table kingship; the Questing Beast; the feud   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 King who pursues the Questing Beast, slays Lot, and fathers Lamorak. ruler
ENT_ART_UTHER_PENDRAGON Uther Pendragon   Arthurian King Legendary king kingship; war; the begetting of Arthur   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 King who, disguised by Merlin as Gorlois, begets Arthur upon Igraine at Tintagel. ruler

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