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'}

1 row where entity_class = "sage" and tradition = "Finnish"

✎ View and edit SQL

This data as json, CSV (advanced)

tradition 1

  • Finnish · 1 ✖

entity_class 1

  • sage · 1 ✖
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_VAINAMOINEN Väinämöinen   Finnish shaman-bard / culture hero / primordial sage Hero music; poetry; wisdom; shamanism; magic; creation; seas; kantele       A           The central figure of the Kalevala; eternal sage, primordial shaman, and culture hero of Finnish mythology. Son of Ilmatar, the air spirit who floated on the primordial sea. Väinämöinen spent 700 years in his mother's womb before emerging as an already-old man with full wisdom. He is the greatest singer in the world — his kantele (Finnish harp, which he carves from a pike's jaw) has magical power over nature and humans. The Kalevala's main narrative follows Väinämöinen's quest for the Sampo (a magical mill), his contests of wisdom and music, his descent to the realm of the dead (Tuonela) to retrieve knowledge, and his conflicts with the sorceress Louhi. He is a paradigmatic shaman figure in the tradition described by Eliade — capable of soul-journey, magical singing, and cosmogonic action. At the end of the Kalevala (Runo 50) he departs in his boat to a realm between sky and earth, promising to return when needed. Pentikäinen (1999) pp. 148-220; Kalevala Runos 1-3, 16-17, 26-30. sage

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