Joensuu

Identity

Nation
Finland
Local region
Eastern Finland
Coordinates
62.601089, 29.763531
Altitude
0
Population band
7
Attraction
12
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 —
Joensuun keskuskenttä 3,000 3,000 Grass 1934-01-01
Mehtimäen tekonurmi 500 500 Synthetic soft 2013-01-01

People born here

Name Kind Nationality Born
Olli-Pekka Itälä Player Finland 1977-11-07
Lasse Vornanen Staff Finland 1979-06-02
Johannes Mononen Staff 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
Aapi Helvelahti Player Finland 1993-03-17
Risto Kahelin Player Finland 1995-08-09
Tuukka Kurki Player Finland 1999-04-23
Nuutti Tykkyläinen Player Finland 1999-07-19
Miika Vainikainen Player Finland 1998-10-13
Paavo Jarva Player Finland 1996-09-16
Niko Niemeläinen Player Finland 2000-03-27

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.