id |
int |
Data source did not contain a description for id. Column id has 340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 79226 and maximum value is 529825. |
nimi_fi |
string |
Data source did not contain a description for nimi_fi. Column nimi_fi has 340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Agricolahalli... and first 25 characters of maximum string: Padelhalli Padeluxe Pirkk... |
nimi_se |
string |
Data source did not contain a description for nimi_se. Column nimi_se has 340 rows, out of which 252 are empty, making the null percent 74.12. Minimum string is and maximum string is Rettig Sport Center. |
nimi_en |
string |
Data source did not contain a description for nimi_en. Column nimi_en has 340 rows, out of which 148 are empty, making the null percent 43.53. Minimum string is and maximum string is Toijalan Monitoimihalli. |
sahkoposti |
string |
Data source did not contain a description for sahkoposti. Column sahkoposti has 340 rows, out of which 129 are empty, making the null percent 37.94. Minimum string is and maximum string is info@padeluxe.fi. |
www |
string |
Data source did not contain a description for www. Column www has 340 rows, out of which 29 are empty, making the null percent 8.53. Minimum string is and maximum string is https://www.padeluxe.fi/. |
puhelinnum |
string |
Data source did not contain a description for puhelinnum. Column puhelinnum has 340 rows, out of which 62 are empty, making the null percent 18.24. Minimum string is and maximum string is 050 326 1511. |
koulun_lii |
string |
Data source did not contain a description for koulun_lii. Column koulun_lii has 340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ? and maximum string is T. |
vapaa_kayt |
string |
Data source did not contain a description for vapaa_kayt. Column vapaa_kayt has 340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ? and maximum string is T. |
rakennusvu |
int |
Data source did not contain a description for rakennusvu. Column rakennusvu has 340 rows, out of which 41 are empty, making the null percent 12.06. Minimum value is 1927 and maximum value is 2018. |
peruskorja |
int |
Data source did not contain a description for peruskorja. Column peruskorja has 340 rows, out of which 294 are empty, making the null percent 86.47. Minimum value is 1981 and maximum value is 2018. |
omistaja |
string |
Data source did not contain a description for omistaja. Column omistaja has 340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tietoa and maximum string is Yritys. |
yllapitaja |
string |
Data source did not contain a description for yllapitaja. Column yllapitaja has 340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tietoa and maximum string is Yksityinen / yritys. |
katuosoite |
string |
Data source did not contain a description for katuosoite. Column katuosoite has 340 rows, out of which 3 are empty, making the null percent 0.88. Minimum string is and maximum string is Jasperintie 301. |
postinumer |
int |
Data source did not contain a description for postinumer. Column postinumer has 340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 180 and maximum value is 99600. |
postitoimi |
string |
Data source did not contain a description for postitoimi. Column postitoimi has 340 rows, out of which 15 are empty, making the null percent 4.41. Minimum string is and maximum string is Pirkkala. |
kunta_nimi |
string |
Data source did not contain a description for kunta_nimi. Column kunta_nimi has 340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Pirkkala. |
kuntanumer |
int |
Data source did not contain a description for kuntanumer. Column kuntanumer has 340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10 and maximum value is 992. |
kuntaosa |
string |
Data source did not contain a description for kuntaosa. Column kuntaosa has 340 rows, out of which 274 are empty, making the null percent 80.59. Minimum string is and maximum string is Parola. |
tyyppikood |
int |
Data source did not contain a description for tyyppikood. Column tyyppikood has 340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2210. |
tyyppi_nim |
string |
Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Liikuntahalli. |
muokattu_v |
date |
Data source did not contain a description for muokattu_v. Column is empty. |
katsomo_ka |
int |
Data source did not contain a description for katsomo_ka. Column katsomo_ka has 340 rows, out of which 246 are empty, making the null percent 72.35. Minimum value is 60 and maximum value is 3500. |
esteettomy |
string |
Data source did not contain a description for esteettomy. Column esteettomy has 340 rows, out of which 325 are empty, making the null percent 95.59. Minimum string is and maximum string is on. |
yleiso_wc |
boolean |
Data source did not contain a description for yleiso_wc. |
kentan_lev |
int |
Data source did not contain a description for kentan_lev. Column kentan_lev has 340 rows, out of which 55 are empty, making the null percent 16.18. Minimum value is 7 and maximum value is 79. |
kentan_pit |
int |
Data source did not contain a description for kentan_pit. Column kentan_pit has 340 rows, out of which 54 are empty, making the null percent 15.88. Minimum value is 17 and maximum value is 100. |
korkeus_m |
int |
Data source did not contain a description for korkeus_m. Column korkeus_m has 340 rows, out of which 104 are empty, making the null percent 30.59. Minimum value is 2 and maximum value is 26. |
pinta_ala |
int |
Data source did not contain a description for pinta_ala. Column pinta_ala has 340 rows, out of which 14 are empty, making the null percent 4.12. Minimum value is 170 and maximum value is 8415. |
pintamater |
string |
Data source did not contain a description for pintamater. Column pintamater has 340 rows, out of which 33 are empty, making the null percent 9.71. Minimum string is and maximum string is Tekonurmi. |
sulkapallo |
int |
Data source did not contain a description for sulkapallo. Column sulkapallo has 340 rows, out of which 177 are empty, making the null percent 52.06. Minimum value is 0 and maximum value is 12. |
kiipeilyse |
boolean |
Data source did not contain a description for kiipeilyse. |
telinevoim |
boolean |
Data source did not contain a description for telinevoim. |
jalkapallo |
int |
Data source did not contain a description for jalkapallo. Column jalkapallo has 340 rows, out of which 311 are empty, making the null percent 91.47. Minimum value is 0 and maximum value is 1. |
squashkent |
int |
Data source did not contain a description for squashkent. Column squashkent has 340 rows, out of which 307 are empty, making the null percent 90.29. Minimum value is 0 and maximum value is 2. |
lisatieto |
string |
Data source did not contain a description for lisatieto. Column lisatieto has 340 rows, out of which 120 are empty, making the null percent 35.29. First 25 characters of minimum string: ... and first 25 characters of maximum string: iso sali, seisomakatsomo,... |
ottelukell |
boolean |
Data source did not contain a description for ottelukell. |
kasipallok |
int |
Data source did not contain a description for kasipallok. Column kasipallok has 340 rows, out of which 216 are empty, making the null percent 63.53. Minimum value is 0 and maximum value is 4. |
koripallok |
int |
Data source did not contain a description for koripallok. Column koripallok has 340 rows, out of which 108 are empty, making the null percent 31.76. Minimum value is 0 and maximum value is 5. |
tenniskent |
int |
Data source did not contain a description for tenniskent. Column tenniskent has 340 rows, out of which 188 are empty, making the null percent 55.29. Minimum value is 0 and maximum value is 4. |
salibandyk |
int |
Data source did not contain a description for salibandyk. Column salibandyk has 340 rows, out of which 169 are empty, making the null percent 49.71. Minimum value is 1 and maximum value is 3. |
lentopallo |
int |
Data source did not contain a description for lentopallo. Column lentopallo has 340 rows, out of which 97 are empty, making the null percent 28.53. Minimum value is 0 and maximum value is 5. |
kioski |
boolean |
Data source did not contain a description for kioski. |
kiekonheit |
int |
Data source did not contain a description for kiekonheit. Column kiekonheit has 340 rows, out of which 325 are empty, making the null percent 95.59. Minimum value is 0 and maximum value is 1. |
moukarinhe |
int |
Data source did not contain a description for moukarinhe. Column moukarinhe has 340 rows, out of which 334 are empty, making the null percent 98.24. Constant value is 1. |
pituus_ja |
int |
Data source did not contain a description for pituus_ja. Column pituus_ja has 340 rows, out of which 306 are empty, making the null percent 90.00. Minimum value is 0 and maximum value is 2. |
seivashypp |
int |
Data source did not contain a description for seivashypp. Column seivashypp has 340 rows, out of which 318 are empty, making the null percent 93.53. Minimum value is 0 and maximum value is 1. |
ryhmaliiku |
int |
Data source did not contain a description for ryhmaliiku. Column ryhmaliiku has 340 rows, out of which 317 are empty, making the null percent 93.24. Minimum value is 1 and maximum value is 3. |
korkeushyp |
int |
Data source did not contain a description for korkeushyp. Column korkeushyp has 340 rows, out of which 324 are empty, making the null percent 95.29. Minimum value is 0 and maximum value is 1. |
etusuorien |
int |
Data source did not contain a description for etusuorien. Column etusuorien has 340 rows, out of which 318 are empty, making the null percent 93.53. Minimum value is 0 and maximum value is 5. |
juoksurada |
string |
Data source did not contain a description for juoksurada. Column juoksurada has 340 rows, out of which 320 are empty, making the null percent 94.12. Minimum string is and maximum string is Muovi / synteettinen. |
sisaradan |
int |
Data source did not contain a description for sisaradan. Column sisaradan has 340 rows, out of which 310 are empty, making the null percent 91.18. Minimum value is 30 and maximum value is 200. |
keihaanhei |
int |
Data source did not contain a description for keihaanhei. Column keihaanhei has 340 rows, out of which 322 are empty, making the null percent 94.71. Minimum value is 0 and maximum value is 1. |
kiertavien |
int |
Data source did not contain a description for kiertavien. Column kiertavien has 340 rows, out of which 335 are empty, making the null percent 98.53. Minimum value is 0 and maximum value is 4. |
kuulantyon |
int |
Data source did not contain a description for kuulantyon. Column kuulantyon has 340 rows, out of which 323 are empty, making the null percent 95.00. Minimum value is 0 and maximum value is 1. |
futsal_ken |
int |
Data source did not contain a description for futsal_ken. Column futsal_ken has 340 rows, out of which 240 are empty, making the null percent 70.59. Minimum value is 1 and maximum value is 3. |
tulostaulu |
boolean |
Data source did not contain a description for tulostaulu. |
pintamate0 |
string |
Data source did not contain a description for pintamate0. Column pintamate0 has 340 rows, out of which 203 are empty, making the null percent 59.71. First 25 characters of minimum string: ... and first 25 characters of maximum string: World Padel Tour -tason t... |
geom_geojson |
string |
Geometry in GeoJSON format. |
geom_geotext |
string |
Geometry as GeoText. Column geom_geotext has 340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (19.95282141889321 ... and first 25 characters of maximum string: POINT (23.645723826165746... |
geom_center_x |
float |
Longitude of center. Column geom_center_x has 340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.95 and maximum value is 30.94. |
geom_center_y |
float |
Latitude of center. Column geom_center_y has 340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.83 and maximum value is 67.65. |
geom_type |
string |
Geometry type. Column geom_type has 340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT. |
orig_extractdate |
string |
The date when the data was originally fetched from the source. |