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

4 rows where entity_class = "object" and tradition = "Arthurian"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: entity_type

tradition 1

  • Arthurian · 4 ✖

entity_class 1

  • object · 4 ✖
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_EXCALIBUR Excalibur   Arthurian Relic Legendary sword kingship; war; sovereignty; the otherworld   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 Arthur's sword (Geoffrey's Caliburn), given by the Lady of the Lake and returned to her at his death. object
ENT_ART_GRAIL The Holy Grail   Arthurian Sacred object Holy relic divine grace; revelation; healing; the Eucharist   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 The vessel of the Last Supper brought to Britain by Joseph of Arimathea; object of the great quest. object
ENT_ART_ROUND_TABLE_OBJECT The Round Table   Arthurian Sacred object Order of chivalry fellowship; equality of the knights; the chivalric order   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 The round table made by Merlin so that no knight should sit above another. object
ENT_ART_SIEGE_PERILOUS The Siege Perilous   Arthurian Sacred object Sacred seat the Grail destiny; sanctity; predestination   literary   B candidate_verified_name Arthurian legend / Matter of Britain (v1.78.0) 0 0 0 The empty seat, fatal to the unworthy, reserved for the Grail knight Galahad. object

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