deitydb: entities: 5 rows where entity_class = "demon" and tradition = "Jewish Mystical"

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 = "demon" and tradition = "Jewish Mystical"

descending

✎ View and edit SQL

This data as json, CSV (advanced)

entity_id ▼	canonical_name	tradition	entity_type	category	primary_domains	cult_scope	primary_period	evidence_confidence	review_status	inclusion_basis	earth_association_score	chthonic_flag	serpent_flag	short_note	entity_class
ENT_JM_AGRAT	Agrat bat Mahlat	Jewish Mystical	Demon	Demon queen	the night; the dancing-demons of the air	Jewish		B	candidate_verified_name	Rabbinic/Zoharic demon-queen	0	1	0	A queen of demons who rides the night air with myriads of destroying spirits.	demon
ENT_JM_ESTRIE	Estrie	Jewish Mystical	Demon	Adversarial being	blood-drinking; shape-shifting; night; harm to infants	folk		C	candidate_verified_name	Abrahamic folk supernatural beings (v1.72.0)	0	0	0	A shape-shifting, blood-drinking female demon of medieval (esp. Franco-German) Jewish folklore, attested chiefly in Sefer Hasidim; the name likely derives from the Latin strix/strigae and the figure is sparsely documented.	demon
ENT_JM_KETEV_MERIRI	Ketev Meriri	Jewish Mystical	Demon	Plague demon	the noonday plague; bitter destruction	Jewish		A	candidate_verified_name	Rabbinic demon	0	1	0	The bitter noonday demon of pestilence (Psalm 91:6; Lamentations Rabbah).	demon
ENT_JM_LILITH	Lilith	Jewish Mystical	Demoness	Adversarial Being	demoness; night; infant death; Adam's first wife; sexual danger; Sheol		PER_JM_MEDIEVAL	A		Isaiah 34:14 (lilit, hapax legomenon); Babylonian Talmud (Eruvin 100b, Niddah 24b); Alphabet of Ben Sira; Zohar				Female demon; first attested as "lilit" in Isaiah 34:14 (night creature of the desolation). The Babylonian Talmud (Eruvin 100b) describes a nocturnal spirit with wings who harms men sleeping alone. The Alphabet of Ben Sira (9th–11th c. CE) develops the narrative of Lilith as Adam's first wife who refused to lie beneath him, spoke the ineffable name, and flew to the Red Sea to consort with demons. In Kabbalistic literature (Zohar, Zohar Chadash) Lilith becomes the consort of Samael, queen of the demonic realm, and the dark counterpart of the Shekhinah — embodying the "left side" of the divine feminine.	demon
ENT_JM_NAAMAH	Naamah	Jewish Mystical	Demon	Demon queen	seduction; the troubling of men in sleep	Jewish		B	candidate_verified_name	Zoharic demon-queen	0	1	0	A demoness of seduction, one of the queens of the qliphoth alongside Lilith.	demon

Advanced export

JSON shape: default, array, newline-delimited, object

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

Entities

5 rows where entity_class = "demon" and tradition = "Jewish Mystical"

Advanced export