Tartu

Identity

Nation
Estonia
Local region
—
Coordinates
58.380684, 26.725016
Altitude
186
Population band
7
Attraction
17
First language
—
Weather index
207

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
Tamme staadion 1,638 1,638 Grass 1936-01-01
Tartu Annelinna kunstmurustaadion 738 738 Synthetic soft 2005-01-01
Tamme kunstmuru 1,000 0 Synthetic soft —
Tabivere Gümnaasiumi staadion 0 0 Unused —
Tartu Sepa jalgpallikeskuse kunstmuruväljak 508 0 Synthetic soft 2016-01-01

People born here

Name Kind Nationality Born
Martin Reim Staff Estonia 1971-05-14
Martin Vunk Staff Estonia 1984-08-21
Indrek Koser Staff Estonia 1986-04-29
Kristjan Tiirik Staff Estonia 1982-08-25
Rasmus Tomson Staff Estonia 1985-08-13
Sander Puri Player Estonia 1988-05-07
Taijo Teniste Player Estonia 1988-01-31
Ando Hausenberg Player Estonia 1987-07-10
Mario Hansi Staff Estonia 1987-05-21
Markus Jürgenson Player Estonia 1987-09-09
Vitali Gussev Player Estonia 1983-03-16
Kennet Jädal Player Estonia 1990-05-08
Reio Laabus Player Estonia 1990-03-14
Mikk Laas Player Estonia 1990-09-30
Martin Naggel Player Estonia 1990-05-22
Albert Prosa Player Estonia 1990-10-01
Siim Tenno Player Estonia 1990-08-04
Kristjan Vomm Staff Estonia 1990-07-30
Sergei Korsunov Player Finland 1992-05-22
Sergo Kanajev Player Estonia 1985-07-29
Markus Soomets Player Estonia 2000-03-02
Norbert Hurt Staff Estonia 1983-04-16
Artur Pikk Player Estonia 1993-05-05
Kevin Rääbis Player Estonia 1994-01-02
Martin Jõgi Player Estonia 1995-01-05

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.