deitydb: entities: 3 rows where entity_class = "hero" 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'}

3 rows where entity_class = "hero" 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_KULLERVO	Kullervo	Finnish	Hero	Tragic hero	vengeance; fate; ruin	regional	A	candidate_verified_name	European regional polytheism deepening (v1.77.0)	0	0	0	The doomed orphan-slave of the Kalevala whose vengeance and unwitting incest end in his suicide upon his own sword.	hero
ENT_FINN_LEMMINKAINEN	Lemminkäinen	Finnish	Hero	Culture hero / shaman	war; seduction; magic; recklessness	regional	A	candidate_verified_name	European regional polytheism deepening (v1.77.0)	0	0	0	A reckless, amorous warrior-shaman of the Kalevala who is slain and dismembered at the river of Tuonela and revived by his mother.	hero
ENT_FINN_LOUHI	Louhi	Finnish	shamanistic mistress of Pohjola	Adversarial Being	magic; shamanism; the North; Pohjola; cold; shape-shifting; obstruction		A						Mistress of Pohjola (the Far North, "the place of darkness"); the primary antagonist of the Kalevala. Louhi is a powerful shamanistic figure — "the gap-toothed crone of Pohjola" in Lönnrot's text — who controls the resources of the North and drives the Kalevala's main plot conflicts. Väinämöinen and Ilmarinen must negotiate with her for brides and for the Sampo (a magical mill that generates wealth); she demands the construction of the Sampo as bride-price (Runos 5-8, 10-11). When the heroes steal the Sampo back, Louhi pursues them as a great eagle-hawk and destroys the Sampo in the conflict (Runos 42-49). She can also spread plague and disease, and she steals the sun and moon, locking them in the mountain of Pohjola (Runo 47-49). Louhi is not a simple evil figure — she is a legitimate authority in her own domain, a mother protecting her daughters, and a formidable equal to Väinämöinen in magical power. As an adversarial shamanistic ruler she represents the hostile wilderness north of the Finnish homeland. Pentikäinen (1999) pp. 220-260.	hero

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

3 rows where entity_class = "hero" and tradition = "Finnish"

Advanced export