To download the data set, please sign up or log in

Lipas 2270 squash halli

Lipas 2270 squash halli

Tables

Column Descriptions

Lipas 2270 Squash Halli, Lipaslipas 2270 Squash Halli

Column Type Comment
id int Data source did not contain a description for id. Column id has 78 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 89219 and maximum value is 528753.
nimi_fi string Data source did not contain a description for nimi_fi. Column nimi_fi has 78 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 3A-Sport Squash-halli... and first 25 characters of maximum string: Vaasan Tennis Center - Sq...
nimi_se string Data source did not contain a description for nimi_se. Column nimi_se has 78 rows, out of which 51 are empty, making the null percent 65.38. First 25 characters of minimum string: ... and first 25 characters of maximum string: Hotel Korpilampis squash-...
nimi_en string Data source did not contain a description for nimi_en. Column nimi_en has 78 rows, out of which 46 are empty, making the null percent 58.97. First 25 characters of minimum string: ... and first 25 characters of maximum string: Urheilutalon sguash kentä...
sahkoposti string Data source did not contain a description for sahkoposti. Column sahkoposti has 78 rows, out of which 20 are empty, making the null percent 25.64. Minimum string is and maximum string is tc@vaasantenniscenter.com.
www string Data source did not contain a description for www. Column www has 78 rows, out of which 3 are empty, making the null percent 3.85. First 25 characters of minimum string: ... and first 25 characters of maximum string: www.vaasantenniscenter.co...
puhelinnum string Data source did not contain a description for puhelinnum. Column puhelinnum has 78 rows, out of which 8 are empty, making the null percent 10.26. Minimum string is and maximum string is 044-978 2100.
koulun_lii string Data source did not contain a description for koulun_lii. Column koulun_lii has 78 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 F.
vapaa_kayt string Data source did not contain a description for vapaa_kayt. Column vapaa_kayt has 78 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ?.
rakennusvu int Data source did not contain a description for rakennusvu. Column rakennusvu has 78 rows, out of which 16 are empty, making the null percent 20.51. Minimum value is 1970 and maximum value is 2017.
peruskorja int Data source did not contain a description for peruskorja. Column peruskorja has 78 rows, out of which 72 are empty, making the null percent 92.31. Minimum value is 2001 and maximum value is 2014.
omistaja string Data source did not contain a description for omistaja. Column omistaja has 78 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 78 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 78 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aakkulantie 23 and maximum string is Bragentie.
postinumer int Data source did not contain a description for postinumer. Column postinumer has 78 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 240 and maximum value is 99800.
postitoimi string Data source did not contain a description for postitoimi. Column postitoimi has 78 rows, out of which 1 are empty, making the null percent 1.28. Minimum string is and maximum string is Vaasa.
kunta_nimi string Data source did not contain a description for kunta_nimi. Column kunta_nimi has 78 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 Vaasa.
kuntanumer int Data source did not contain a description for kuntanumer. Column kuntanumer has 78 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 78 rows, out of which 60 are empty, making the null percent 76.92. Minimum string is and maximum string is Hietalahti.
tyyppikood int Data source did not contain a description for tyyppikood. Column tyyppikood has 78 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2270.
tyyppi_nim string Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 78 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Squash-halli.
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 78 rows, out of which 75 are empty, making the null percent 96.15. Minimum value is 50 and maximum value is 100.
squashkent int Data source did not contain a description for squashkent. Column squashkent has 78 rows, out of which 4 are empty, making the null percent 5.13. Minimum value is 1 and maximum value is 10.
kentan_pit int Data source did not contain a description for kentan_pit. Column kentan_pit has 78 rows, out of which 77 are empty, making the null percent 98.72. Constant value is 10.
kentan_lev float Data source did not contain a description for kentan_lev. Column kentan_lev has 78 rows, out of which 77 are empty, making the null percent 98.72. Constant value is 6.50.
lisatieto string Data source did not contain a description for lisatieto. Column lisatieto has 78 rows, out of which 56 are empty, making the null percent 71.79. First 25 characters of minimum string: ... and first 25 characters of maximum string: Kentällä voi pelata myös ...
salibandyk int Data source did not contain a description for salibandyk. Column salibandyk has 78 rows, out of which 72 are empty, making the null percent 92.31. Minimum value is 1 and maximum value is 2.
kioski boolean Data source did not contain a description for kioski.
lentopallo int Data source did not contain a description for lentopallo. Column lentopallo has 78 rows, out of which 77 are empty, making the null percent 98.72. Constant value is 2.
tenniskent int Data source did not contain a description for tenniskent. Column tenniskent has 78 rows, out of which 69 are empty, making the null percent 88.46. Minimum value is 2 and maximum value is 13.
yleiso_wc boolean Data source did not contain a description for yleiso_wc.
tulostaulu boolean Data source did not contain a description for tulostaulu.
sulkapallo int Data source did not contain a description for sulkapallo. Column sulkapallo has 78 rows, out of which 65 are empty, making the null percent 83.33. Minimum value is 2 and maximum value is 11.
pintamater string Data source did not contain a description for pintamater. Column pintamater has 78 rows, out of which 67 are empty, making the null percent 85.90. Minimum string is and maximum string is Parketti.
pinta_ala int Data source did not contain a description for pinta_ala. Column pinta_ala has 78 rows, out of which 29 are empty, making the null percent 37.18. Minimum value is 60 and maximum value is 624.
pintamate0 string Data source did not contain a description for pintamate0. Column pintamate0 has 78 rows, out of which 20 are empty, making the null percent 25.64. Minimum string is and maximum string is Puu.
korkeus_m int Data source did not contain a description for korkeus_m. Column korkeus_m has 78 rows, out of which 47 are empty, making the null percent 60.26. Minimum value is 4 and maximum value is 12.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 78 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 (21.48085495079124 ... and first 25 characters of maximum string: POINT (21.63127088070476 ...
geom_center_x float Longitude of center. Column geom_center_x has 78 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.48 and maximum value is 29.74.
geom_center_y float Latitude of center. Column geom_center_y has 78 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.15 and maximum value is 68.65.
geom_type string Geometry type. Column geom_type has 78 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.

Additional Info

Last Updated May 5, 2019
Created September 23, 2018