Joensuu
Identity
- Nation
- Finland
- Local region
- Pohjois-Karjala
- 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 |
| Sauli Kettunen | Player | Finland | 1990-08-25 |
| Tuomas Kettunen | Player | Finland | 2000-08-17 |
| Teemu Hallikainen | Player | Finland | 1988-12-05 |
| Aapi Helvelahti | Staff | Finland | 1993-03-17 |
| Juuso Auvinen | Player | Finland | 1994-04-22 |
| Risto Kahelin | Player | Finland | 1994-12-16 |
| Nuutti Tykkyläinen | Player | Finland | 1999-07-19 |
| Miika Vainikainen | Player | Finland | 1998-10-13 |
| Paavo Jarva | Staff | Finland | 1996-07-17 |
| Niko Niemeläinen | Player | Finland | 2004-07-26 |
| Joel Puolakanaho | Player | Finland | 2002-11-13 |
| Matias Kellokumpu | Player | Finland | 2001-02-04 |
| 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.