1. Home
  2. Datasets
  3. Helsingin rakennustuotanto ...
To download the data set, please sign up or log in

Helsingin rakennustuotanto käyttötarkoituksen mukaan

Helsingin rakennustuotanto käyttötarkoituksen mukaan

Tables

Column Descriptions

Fact, Helsingin Rakennustuotanto Kayttotarkoituksen Mukaan

Column Type Comment
alue int Datasource did not contain a description for Alue. Column alue has 505305 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 910000000 and maximum value is 919999999.
kayttotarkoitus int Datasource did not contain a description for Kayttotarkoitus. Column kayttotarkoitus has 505305 rows, out of which 26595 are empty, making the null percent 5.26. Minimum value is 1 and maximum value is 18.
toimenpide string Datasource did not contain a description for Toimenpide. Column toimenpide has 505305 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is 2.
yksikko int Datasource did not contain a description for Yksikko. Column yksikko has 505305 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 3.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 505305 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2003 and maximum value is 2017.
h1_helsingin_rakennustuotanto_kayttotarkoituksen_mukaan_2003 int Datasource did not contain a description for H1_Helsingin_rakennustuotanto_kayttotarkoituksen_mukaan_2003. Column h1_helsingin_rakennustuotanto_kayttotarkoituksen_mukaan_2003 has 505305 rows, out of which 35642 are empty, making the null percent 7.05. Minimum value is 0 and maximum value is 3695118.
orig_extractdate string The date when the data was originally fetched from the source.

Dim Alue, Helsingin Rakennustuotanto Kayttotarkoituksen Mukaan

Column Type Comment
code int The code for the dimension value. Column code has 197 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 910000000 and maximum value is 919999999.
label string The label for the dimension value. Column label has 197 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 091 100 Sörnäinen (Ent.) and maximum string is 091 997 Esikaupungit.
orig_extractdate string The date when the data was originally fetched from the source.

Dim Toimenpide, Helsingin Rakennustuotanto Kayttotarkoituksen Mukaan

Column Type Comment
code int The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Laajennukset and maximum string is Yhteensä.
orig_extractdate string The date when the data was originally fetched from the source.

Dim Kayttotarkoitus, Helsingin Rakennustuotanto Kayttotarkoituksen Mukaan

Column Type Comment
code int The code for the dimension value. Column code has 19 rows, out of which 1 are empty, making the null percent 5.26. Minimum value is 1 and maximum value is 18.
label string The label for the dimension value. Column label has 19 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 1 Yhden asunnon talot (... and first 25 characters of maximum string: X Käyttötarkoitus tuntema...
orig_extractdate string The date when the data was originally fetched from the source.

Dim Vuosi, Helsingin Rakennustuotanto Kayttotarkoituksen Mukaan

Column Type Comment
code int The code for the dimension value. Column code has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2003 and maximum value is 2017.
label int The label for the dimension value. Column label has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2003 and maximum value is 2017.
orig_extractdate string The date when the data was originally fetched from the source.

Dim Yksikko, Helsingin Rakennustuotanto Kayttotarkoituksen Mukaan

Column Type Comment
code string The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is 3.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kerrosala and maximum string is Tilavuus.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created February 3, 2019