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 = "Zoroastrian"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: entity_type, category, primary_period, inclusion_basis

tradition 1

  • Zoroastrian · 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_ZOR_FRASHAOSHTRA Frashaoshtra   Zoroastrian Fravashi Revered soul Frashaoshtra; yazata; Zoroastrian worship   Zoroastrian Avestan period A candidate_verified_name Avesta (Yasht) primary attestation 1 0 0 Fravashi of Frashaoshtra, son of Hvova, a foremost disciple of Zoroaster (Farvardin Yasht). spirit
ENT_ZOR_GAOKERENA Gaokerena   Zoroastrian Cosmic plant Mythical Plant Gaokerena; Zoroastrian cosmology; Bundahishn   Zoroastrian Sasanian/Pahlavi A candidate_verified_name Bundahishn primary attestation 1 0 0 The Gokard (Gaokerena), the white-Haoma tree of all germs in the cosmic sea, whose sap confers immortality at the renovation (Bundahishn). spirit
ENT_ZOR_GAVAEVODATA Gavaevodata   Zoroastrian Primeval ox Mythical Being Gavaevodata; Zoroastrian cosmology; Bundahishn   Zoroastrian Sasanian/Pahlavi A candidate_verified_name Bundahishn primary attestation 1 0 0 Gavaevodata, the sole-created (primeval) ox slain at the origin, from whose body the plants and animals arose (Bundahishn). spirit
ENT_ZOR_GOPATSHAH Gopatshah   Zoroastrian Bull-man Mythical Being Gopatshah; Zoroastrian cosmology; Bundahishn   Zoroastrian Sasanian/Pahlavi A candidate_verified_name Bundahishn primary attestation 1 0 0 Gopatshah, the ox-bodied man among the Zoroastrian immortals who keeps the seashore (Bundahishn). spirit
ENT_ZOR_HADHAYANS Hadhayans   Zoroastrian Mythical ox Mythical Being Hadhayans; Zoroastrian cosmology; Bundahishn   Zoroastrian Sasanian/Pahlavi A candidate_verified_name Bundahishn primary attestation 1 0 0 The ox Hadhayosh (Sarsaok), which carried mankind between the regions and from whose fat the drink of immortality is prepared at the renovation (Bundahishn). spirit
ENT_ZOR_JAMASPA Jamaspa   Zoroastrian Fravashi Revered soul Jamaspa; yazata; Zoroastrian worship   Zoroastrian Avestan period A candidate_verified_name Avesta (Yasht) primary attestation 1 0 0 Fravashi of Jamaspa, sage counsellor of Kavi Vishtaspa and disciple of Zoroaster (Farvardin Yasht). spirit
ENT_ZOR_SAENA Saena   Zoroastrian Fravashi Revered soul Saena; yazata; Zoroastrian worship   Zoroastrian Avestan period A candidate_verified_name Avesta (Yasht) primary attestation 1 0 0 The Fravashi of the holy Saena, son of Ahum-stut, who first appeared on earth with a hundred disciples (Farvardin Yasht). 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]);