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 entity_class to filter by kind (19 controlled values: deity, angel, demon, aeon, sefirah, spirit, monster, hero, etc.). category is free text (1,148 values) and is not a reliable filter. 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 (934 distinct values; see entity_class for the controlled grouping)'}
category
{'description': 'Free-text functional category (1,148 distinct values, not normalised — filter on entity_class instead)'}
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'}

10 rows where entity_class = "demon" and tradition = "Mesopotamian"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: entity_type, category, cult_scope, evidence_confidence, earth_association_score, chthonic_flag

tradition 1

  • Mesopotamian · 10 ✖

entity_class 1

  • demon · 10 ✖
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_MES_ASAG Asag   Mesopotamian Demon Disease demon disease; the stones; chaos   Mesopotamian   A candidate_verified_name Demon slain by Ninurta 0 1 0 Asag (Asakku), the monstrous demon of disease slain by Ninurta in the Lugale. demon
ENT_MES_HUMUTTABAL Humut-tabal   Mesopotamian Demon Underworld official the ferry of the underworld   regional   B candidate_verified_name Underworld Vision of an Assyrian Prince 0 1 0 The ferryman of the underworld ("Bring-hither-quickly"), a servant in Ereshkigal's court (Underworld Vision of an Assyrian Prince). demon
ENT_MES_LAMASHTU Lamashtu   Mesopotamian Demoness Dangerous Demon child-harming; disease; childbirth danger; demoness   Mesopotamian   A candidate_verified_name Mesopotamian demoness 3 0 0 Dangerous demoness associated with harm to infants and mothers. demon
ENT_MES_LILITU Lilitu   Mesopotamian Demon Night demoness the night; the wind; the seduction of men   Mesopotamian   B candidate_verified_name Night demoness (Lilith ancestor) 0 1 0 Lilitu (with Lilu and Ardat-lili), a night/wind demoness, a forerunner of the later Lilith. demon
ENT_MES_NAMTAR Namtar   Mesopotamian Demon Death/plague demon fate; death; plague; the vizier of Ereshkigal   Mesopotamian   A candidate_verified_name Vizier of the underworld 0 1 0 Namtar ("Fate"), the demon of death and plague, vizier of Ereshkigal. demon
ENT_MES_PAZUZU Pazuzu   Mesopotamian Demon Protective Demon wind demon; protection; disease; apotropaic power   Assyrian/Babylonian   A candidate_verified_name Mesopotamian demon 1 0 0 Demonic wind being used apotropaically, especially against Lamashtu. demon
ENT_MES_RABISU Rabisu   Mesopotamian Demon class Spirit-Demon Class lurking demon; ambush; affliction   Akkadian   A candidate_verified_name Mesopotamian demon class 3 0 0 Lurking demon associated with ambush or affliction. demon
ENT_MES_SULAK Sulak   Mesopotamian Demon Disease demon the latrine; sudden seizure   regional   B candidate_verified_name Babylonian Diagnostic Handbook 0 1 0 A lion-shaped demon "the lurker of the privy," who strikes the solitary with seizure (stroke). demon
ENT_MES_UGALLU Ugallu   Mesopotamian Demon Apotropaic demon storm; protection of the threshold   Mesopotamian   B candidate_verified_name Apotropaic lion-demon 0 1 0 The "Big Weather-Beast," a lion-headed storm demon used apotropaically at doorways. demon
ENT_MES_UTUKKU Utukku   Mesopotamian Spirit/demon class Spirit-Demon Class spirit; demon; affliction; haunting   Mesopotamian   A candidate_verified_name Mesopotamian spirit/demon class 3 0 0 Class of spirits or demons, sometimes harmful. demon

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