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

5 rows where entity_class = "deity" and tradition = "Mandaean"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category, earth_association_score, chthonic_flag

tradition 1

  • Mandaean · 5 ✖

entity_class 1

  • deity · 5 ✖
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_MAN_HAYYI_RABBI Hayyi Rabbi   Mandaean Supreme deity High Deity great life; supreme source; lightworld   Mandaean   A candidate_verified_name Mandaean core entity 0 0 0 The Great Life, supreme source in Mandaean religion. deity
ENT_MAN_HIBIL_ZIWA Hibil Ziwa   Mandaean Lightworld savior Revealer Figure light; descent; salvation; underworld journey   Mandaean   A candidate_verified_name Mandaean lightworld entity 0 1 0 Radiant Hibil, savior/redeemer figure associated with descent and rescue. deity
ENT_MAN_KRUN Krun   Mandaean Underworld king Primordial dark king the lowest darkness; the oldest of the dark powers   Mandaean   A candidate_verified_name Chief underworld king 0 1 0 Krun, the "mountain of flesh," the oldest and greatest of the kings of the World of Darkness. deity
ENT_MAN_MANDA_D_HAYYI Manda d-Hayyi   Mandaean Revealer/savior Revealer Figure knowledge of life; revelation; salvation; instruction   Mandaean   A candidate_verified_name Mandaean revealer entity 0 0 0 Knowledge of Life; major revealer and savior figure. deity
ENT_MAN_PTAHIL Ptahil   Mandaean Demiurge/world-maker Creator Deity world-maker; lower creation; material world   Mandaean   A candidate_verified_name Mandaean demiurgic entity 5 1 0 Lower world-maker associated with material creation. deity

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