Joensuu

Identity

Nation
Finland
Local region
Eastern Finland
Coordinates
62.601089, 29.763531
Altitude
0
Population band
7
Attraction
11
First language
—
Weather index
52

city.weather_index is a raw index. There is no weather lookup table and no weather entity in the export, so the number is shown as it is stored and is not turned into a climate. Population band and attraction are likewise raw source scales. The local region comes from local_region, which is a separate id space from region and is not interchangeable with it. Altitude is in metres.

Clubs

Stadiums

Name Capacity Seating Pitch Built
Rantakylän urheilukeskus 0 0 Unused —
Keskuskenttä 5,400 0 Grass —

People born here

Name Kind Nationality Born
Olli-Pekka Itälä Player Finland 1977-11-06
Jaakko Reponen Player Finland 1983-02-25
Lasse Vornanen Staff Finland 1979-06-01
Kari Kuikka Player Finland 1985-04-05
Ville Mäkinen Player Finland 1991-07-16
Johannes Mononen Player Finland 1991-05-03
Topi Sormunen Player Finland 1993-10-05
Teemu Hallikainen Player Finland 1988-12-04
Valtteri Nykänen Player Finland 1993-03-22
Solomon Duah Player Finland 1993-01-06
Aapi Helvelahti Player Finland 1993-03-16

Born shows the full date where one is recorded and the year alone where only person.year_of_birth is. A person with neither a player nor a staff row is badged unclassified rather than assigned a subtype.