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-07
Jaakko Reponen Player Finland 1983-02-26
Lasse Vornanen Staff Finland 1979-06-02
Kari Kuikka Player Finland 1985-04-06
Ville Mäkinen Player Finland 1991-07-17
Johannes Mononen Player Finland 1991-05-04
Topi Sormunen Player Finland 1993-10-06
Teemu Hallikainen Player Finland 1988-12-05
Valtteri Nykänen Player Finland 1993-03-23
Solomon Duah Player Finland 1993-01-07
Aapi Helvelahti Player Finland 1993-03-17
Risto Kahelin Player Finland 1995-12-09

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.