deitydb: entities: 13 rows where entity_class = "deity" and tradition = "Finnish"

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

13 rows where entity_class = "deity" and tradition = "Finnish"

descending

✎ View and edit SQL

This data as json, CSV (advanced)

entity_id ▼	canonical_name	tradition	entity_type	category	primary_domains	cult_scope	evidence_confidence	review_status	inclusion_basis	earth_association_score	chthonic_flag	serpent_flag	short_note	entity_class
ENT_FINN_AHTI	Ahti	Finnish	sea deity / lord of the waters	Sea Deity	sea; water; fish; fishing; underwater realm; rivers; lakes		A						Sea deity and lord of the waters in Finnish and Karelian folk religion; also called Ahto. Agricola's 1551 Psalter names Ahti explicitly in the Häme deity list as the deity of water and fish: "Ahti gave fish and water creatures." He rules the underwater realm Ahtola from its palace on the sea floor. His wife is Vellamo ("the calm one"), who governs the surface of water and is described as a great fish-woman or mermaid. Fishermen made offerings to Ahti and invoked him before setting out. In the Kalevala (Runo 42-49), Ahti/Ahto appears in connection with the quest for the Sampo and the contest with Louhi. He is an ambiguous deity — generous when properly propitiated but dangerous and jealous of his waters. The name Ahti may connect to the Estonian and Finnic sea/water deity tradition (cf. Estonian Ahti). Pentikäinen (1999) pp. 105-120; Kalevala Runo 42.	deity
ENT_FINN_ILMARINEN	Ilmarinen	Finnish	God	Smith god / culture hero	smithing; metalworking; weather; fire	regional	A	candidate_verified_name	European regional polytheism deepening (v1.77.0)	0	0	0	The eternal smith of the Kalevala who hammered out the dome of the sky and forged the Sampo, the magical mill of plenty, for Louhi of Pohjola.	deity
ENT_FINN_MIELIKKI	Mielikki	Finnish	forest goddess / patroness of bears	Nature Deity	forest; bears; animals; healing; hunting; woodland abundance		A						Goddess of the forest and patroness of bears in Finnish and Karelian folk religion; wife of Tapio, co-ruler of the forest realm Tapiola. Bears occupy the highest sacred status in Finnish folk religion — they are "Otava" (the Great Bear), Tapio's cattle — and Mielikki is their special protector and keeper. The bear hunt was a major ritual complex, and hunter invocations to Mielikki were essential for a successful bear kill and for the proper return of the bear's spirit to Tapiola. Kalevala Runo 14 includes an extended invocation to Mielikki to release game from her forest storehouse: "O Mielikki, forest's mistress, fair-faced mistress of the woodland" (Bosley trans., Runo 14:213). Also called Tellervo (her daughter) and Luonnotar in some variants. Mielikki's name is connected to the Finnish word mieluinen ("pleasant, beloved"). Her healing aspects relate to the bear's fat, used as medicine. Pentikäinen (1999) pp. 145-158.	deity
ENT_FINN_NYYRIKKI	Nyyrikki	Finnish	God	Forest god	forest; hunting; game	regional	B	candidate_verified_name	European regional polytheism deepening (v1.77.0)	0	0	0	Forest god, son of Tapio, who guides hunters and marks the paths of game through the woods.	deity
ENT_FINN_PEKKO	Pellon Pekko (Pekko)	Finnish	God	Crop / barley god	barley; crops; brewing; agriculture	regional	B	candidate_verified_name	European regional polytheism deepening (v1.77.0)	0	0	0	God of barley and the fields named in Agricola's list (Pellon Pekko), invoked for the growth of grain and the making of beer.	deity
ENT_FINN_PELLERVO	Pellervo (Sampsa)	Finnish	God	Vegetation / sowing god	vegetation; sowing; agriculture; fertility of fields	regional	B	candidate_verified_name	European regional polytheism deepening (v1.77.0)	0	0	0	Sampsa Pellervoinen, the sower-spirit of the Kalevala who scatters seed and makes the trees and crops grow over the land.	deity
ENT_FINN_RAUNI	Rauni	Finnish	Goddess	Fertility goddess / consort	fertility; thunder; harvest	regional	C	candidate_verified_name	European regional polytheism deepening (v1.77.0)	0	0	0	An obscure figure from Agricola's list traditionally read as the consort of the thunder-god Ukko, associated with fertility and the harvest.	deity
ENT_FINN_TAPIO	Tapio	Finnish	lord of the forest / hunting deity	Nature Deity	forest; hunting; game animals; wilderness; woodland abundance		A						Lord of the forest and patron of hunters in Finnish and Karelian folk religion. Rules the forest realm Tapiola (Finnish "Tapio's domain" — the name survives in the Helsinki suburb Tapiola). Mikael Agricola's 1551 Psalter includes Tapio in the Häme deity list: "Tapio [gave] forest birds and animals." Hunters invoked Tapio before entering the forest and made offerings to him to ensure game abundance. The Kalevala (Runo 14, 32, 46) includes invocations to Tapio for a successful hunt. Tapio is described with a beard of lichen and a hat of leaves, emerging from the forest like a forest spirit. His wife is Mielikki, who holds direct authority over the game animals, especially bears. Tapio embodies the forest not as hostile wilderness but as the domain of abundance and sustenance if approached with proper respect and ritual. Pentikäinen (1999) pp. 140-160; Agricola 1551.	deity
ENT_FINN_TELLERVO	Tellervo	Finnish	Goddess	Forest spirit	forest; woodland creatures	regional	B	candidate_verified_name	European regional polytheism deepening (v1.77.0)	0	0	0	Maiden of the forest, daughter of Tapio, who herds and protects the cattle and game of the woodland.	deity
ENT_FINN_TUONETAR	Tuonetar	Finnish	Goddess	Death goddess / underworld queen	death; the underworld	regional	B	candidate_verified_name	European regional polytheism deepening (v1.77.0)	0	0	0	Queen of the dead and consort of Tuoni, mistress of the household of Tuonela who serves the dead the drink of the underworld.	deity
ENT_FINN_TUONI	Tuoni	Finnish	God	Death god / underworld ruler	death; the underworld	regional	A	candidate_verified_name	European regional polytheism deepening (v1.77.0)	0	0	0	Lord of the dead who rules Tuonela, the dark land of the dead reached across the river of Tuoni.	deity
ENT_FINN_UKKO	Ukko	Finnish	thunder god / sky father	Thunder Deity	thunder; rain; sky; crops; weather; harvest; lightning		A						Supreme deity and thunder god of the Finnish pantheon; name means "old man" (also cf. Estonian Uku, Sami Hovrengaellies). The most important deity in Finnish folk religion. Mikael Agricola's 1551 Psalter is the earliest written attestation: Agricola lists Ukko as the first of the Häme (Tavastian) deities: "Ukko ruled weather and the air / and gave rain when summer was dry." The Kalevala invokes Ukko repeatedly as the highest divine authority — Runo 2:323-328 calls on him explicitly: "Ukko, thou of gods the highest" (Bosley trans.). He gives rain, controls storms, and governs the harvest. His wife is Akka or Rauni (the Rowan tree deity, possibly a loanword). Ukko is cognate with the Baltic thunder deity Perkūnas and the broader Indo-European thunder deity pattern (Thor/Perun/Zeus/Indra). Pentikäinen (1999) pp. 121-140.	deity
ENT_FINN_VELLAMO	Vellamo	Finnish	Goddess	Sea goddess	sea; water; fish	regional	A	candidate_verified_name	European regional polytheism deepening (v1.77.0)	0	0	0	Goddess of the sea and waters, wife of Ahti, who keeps the fish and is invoked by fishermen in the Kalevala.	deity

Advanced export

JSON shape: default, array, newline-delimited, object

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

Entities

13 rows where entity_class = "deity" and tradition = "Finnish"

Advanced export