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 entity_class = "ruler" and tradition = "Islamic"

✎ View and edit SQL

This data as json, CSV (advanced)

tradition 1

  • Islamic · 3 ✖

entity_class 1

  • ruler · 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_ISL_ABU_BAKR Abu Bakr   Islamic Caliph Islamic companion first Rashidun caliph; closest companion of the Prophet; first adult male convert   regional   A candidate_verified_name Mainstream Abrahamic backbone deepening (v1.72.0) 0 0 0 Abu Bakr al-Siddiq, the Prophet's closest companion and father-in-law, who became the first Rightly-Guided Caliph (632-634 CE). ruler
ENT_ISL_UMAR Umar ibn al-Khattab   Islamic Caliph Islamic companion second Rashidun caliph; expansion of the state; justice and administration   regional   A candidate_verified_name Mainstream Abrahamic backbone deepening (v1.72.0) 0 0 0 Umar ibn al-Khattab al-Faruq, the second Rightly-Guided Caliph (634-644 CE), under whom the early conquests greatly expanded, renowned for his austere justice. ruler
ENT_ISL_UTHMAN Uthman ibn Affan   Islamic Caliph Islamic companion third Rashidun caliph; the standardized Quran; early convert   regional   A candidate_verified_name Mainstream Abrahamic backbone deepening (v1.72.0) 0 0 0 Uthman ibn Affan, the third Rightly-Guided Caliph (644-656 CE), credited with commissioning the standardized written compilation of the Quran, and a son-in-law of the Prophet. ruler

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