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

6 rows where tradition = "Finnish/Kalevala"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: entity_type

entity_class 3

tradition 1

  • Finnish/Kalevala · 6 ✖
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_FIN_AHTO Ahto   Finnish/Kalevala God Sea Deity sea; water; ruler of the waters   Finnish/Kalevala Finnish oral (recorded 1849) A candidate_verified_name Kalevala primary attestation 1 0 0 King of the waters and the sea-folk in the Kalevala. deity
ENT_FIN_ANTEROVIPUNEN Antero Vipunen   Finnish/Kalevala Giant-sage Giant wisdom; lost words; the dead   Finnish/Kalevala Finnish oral (recorded 1849) A candidate_verified_name Kalevala primary attestation 1 0 0 Antero Vipunen, the dead giant-sage from whom Vainamoinen wins lost magic words (Rune 17). spirit
ENT_FIN_KALEVATAR Kalevatar   Finnish/Kalevala Goddess Goddess daughter of Kaleva; brewing   Finnish/Kalevala Finnish oral (recorded 1849) A candidate_verified_name Kalevala primary attestation 1 0 0 Daughter of Kaleva, who in the Kalevala helps brew the first beer. deity
ENT_FIN_LEMPO Lempo   Finnish/Kalevala Demon Evil Spirit evil; mischief; injury   Finnish/Kalevala Finnish oral (recorded 1849) A candidate_verified_name Kalevala primary attestation 1 0 0 Finnish evil spirit of mischief and harm in the Kalevala. demon
ENT_FIN_LOVIATAR Loviatar   Finnish/Kalevala Goddess Disease Deity disease; plague; the nine diseases   Finnish/Kalevala Finnish oral (recorded 1849) A candidate_verified_name Kalevala primary attestation 1 0 0 Blind daughter of Tuoni, mother of the nine diseases/plagues, in the Kalevala (Rune 45). deity
ENT_FIN_OTSO Otso   Finnish/Kalevala Animal-spirit Sacred Animal the bear; forest; honey   Finnish/Kalevala Finnish oral (recorded 1849) A candidate_verified_name Kalevala primary attestation 1 0 0 Otso, the sacred bear of the forest, the honey-paw, addressed with reverent epithets in the Kalevala. 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]);