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 = "spirit" and tradition = "Finnish"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: entity_type

tradition 1

  • Finnish · 3 ✖

entity_class 1

  • spirit · 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_FINN_ILMATAR Ilmatar   Finnish air spirit / water mother / cosmogonic deity Primordial Deity air; water; creation; cosmogony; virgin mother; primordial sea       A           Cosmogonic deity of Finnish mythology; "Daughter of the Air" (Ilmatar = "air woman"). The Kalevala opens with her creation myth (Runo 1): Ilmatar, a virgin spirit of the air, descended to the primordial sea and lay floating on its surface. A teal (sea-duck) came to nest on her knee and laid seven eggs — six of gold, one of iron. When Ilmatar moved, the eggs fell and broke: the lower half of the eggshell became the earth, the upper half the vault of heaven, the yolk became the sun, the white became the moon, and the speckled fragments became the stars. Ilmatar then shaped the earth's features with her hands. She carried Väinämöinen in her womb for 700 years before he was born into the sea. She is the primal mother of Finnish cosmogony, combining the functions of virgin cosmic deity and world-shaper. Also called Luonnotar ("Nature Woman") in some variants. Pentikäinen (1999) pp. 55-80; Kalevala Runo 1. spirit
ENT_FINN_KALMA Kalma   Finnish Spirit Death / decay personification death; decay; the grave   regional   B candidate_verified_name European regional polytheism deepening (v1.77.0) 0 0 0 Personification of death and the stench of decay, associated with graves and the rotting corpse in Finnic tradition. spirit
ENT_FINN_SURMA Surma   Finnish Spirit Death personification violent death; sudden death   regional   C candidate_verified_name European regional polytheism deepening (v1.77.0) 0 0 0 Personification of violent or sudden death, a monstrous gatekeeping power associated with the threshold of Tuonela. 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]);