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
Lasse Vornanen Staff Finland 1979-06-02
Johannes Mononen Staff Finland 1991-05-04
Topi Sormunen Player Finland 1993-10-06
Sauli Kettunen Player Finland 1990-08-25
Tuomas Kettunen Player Finland 2000-08-17
Teemu Hallikainen Player Finland 1988-12-05
Valtteri Nykänen Player Finland 1993-03-23
Aapi Helvelahti Staff Finland 1993-03-17
Risto Kahelin Player Finland 1994-12-16
Tuukka Kurki Player Finland 1999-04-23
Nuutti Tykkyläinen Player Finland 1999-07-19
Jere Hiltunen Player Finland 1999-06-11
Joona Hiltunen Player Finland 1999-06-11
Miika Vainikainen Player Finland 1998-10-13
Paavo Jarva Player Finland 1996-07-17
Niko Niemeläinen Player Finland 2004-07-26
Joel Puolakanaho Player Finland 2002-11-13
Jere Kähkönen Player Finland 1998-05-16
Matias Kellokumpu Player Finland 2001-02-04
Aleksi Nissinen Player Finland 2000-04-21
Tuomo Tolonen Player Finland 1998-06-17
Nuutti Kaikkonen Player Finland 2003-04-10
Aake Yletyinen Player Finland 2002-08-21
Miro Turunen Player Finland 2003-01-31

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.