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

3 rows where tradition = "Spiritualist"

✎ View and edit SQL

This data as json, CSV (advanced)

entity_class 3

tradition 1

  • Spiritualist · 3 ✖
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_SPI_DOORKEEPER The Doorkeeper   Spiritualist Guardian spirit Protective spirit protection; gatekeeping; control of spirit access; guardianship of the medium   literary   C candidate_verified_name Modern-strand deepening (v1.75.0) 0 0 0 A protective guardian spirit in Spiritualist practice who controls which spirits are permitted to approach or communicate through a medium; a role-type whose identity varies by medium. spirit
ENT_SPI_SPIRIT_GUIDES Spirit Guides   Spiritualist Spirit collective Spirit collective discarnate guidance; mediumship; communication with the living; spiritual instruction   literary   C candidate_verified_name Modern-strand deepening (v1.75.0) 0 0 0 The class of discarnate guiding spirits believed to communicate through and assist mediums; a practice-defined category rather than a fixed roster of named beings. collective
ENT_SPI_SUMMERLAND The Summerland   Spiritualist Cosmological realm Cosmological realm afterlife; the spirit world; rest; progress of the soul; the pleasant abode of the dead   literary   C candidate_verified_name Modern-strand deepening (v1.75.0) 0 0 0 The Spiritualist afterlife or spirit world, conceived as a pleasant realm of rest and ongoing moral and spiritual progress; details vary widely across 19th-century Spiritualist sources. realm

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