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

7 rows where entity_class = "spirit" and tradition = "Christian demonology"

✎ View and edit SQL

This data as json, CSV (advanced)

tradition 1

  • Christian demonology · 7 ✖

entity_class 1

  • spirit · 7 ✖
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_DEMX_CARNIVEAN Carnivean   Christian demonology Possessing spirit Demon obscenity; shamelessness   devotional   C candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Demon of obscenity/shamelessness in Michaelis' Admirable History (1612), of the first hierarchy (Powers), opposed by St. John the Evangelist. Attested essentially only in Michaelis. spirit
ENT_DEMX_CARREAU Carreau   Christian demonology Possessing spirit Demon hardness of heart; mercilessness   devotional   C candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Demon of mercilessness/hardness of heart in Michaelis' Admirable History (1612), of the first hierarchy (Powers), opposed by St. Vincent. Attested essentially only in Michaelis. spirit
ENT_DEMX_GRESIL Gresil   Christian demonology Possessing spirit Demon impurity; uncleanness   devotional   C candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Demon of impurity/uncleanness in Michaelis' Admirable History (1612), of the second hierarchy (Thrones), opposed by St. Bernard. Attested essentially only in Michaelis. spirit
ENT_DEMX_OEILLET Oeillet   Christian demonology Possessing spirit Demon breaking the vow of poverty; cupidity   devotional   C candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Demon who tempts against the vow of poverty (riches/cupidity) in Michaelis' Admirable History (1612), of the third hierarchy (Dominions), opposed by St. Martin. Attested essentially only in Michaelis. spirit
ENT_DEMX_ROSIER Rosier   Christian demonology Possessing spirit Demon carnal love; seduction   devotional   C candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Demon of carnal love/seduction in Michaelis' Admirable History (1612), of the third hierarchy (Dominions), opposed by St. Basil. Attested essentially only in Michaelis. spirit
ENT_DEMX_SONNEILLON Sonneillon   Christian demonology Possessing spirit Demon hatred   devotional   C candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Demon of hatred in Michaelis' Admirable History (1612), of the second hierarchy, whose opposing saint is St. Stephen. Attested essentially only in Michaelis. spirit
ENT_DEMX_VERRINE Verrine   Christian demonology Possessing spirit Demon impatience   devotional   C candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Demon of impatience named in Michaelis' Admirable History (1612) as a possessor at Aix; ranked among the second hierarchy, with St. Dominic given as his adversary saint. Attested essentially only in Michaelis. spirit

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