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

Kuntien meno- ja tuloerittelyitä 2011

Kuntien meno- ja tuloerittelyitä 2011

Tables

Column Descriptions

Fact, T100 ktt18 2011 fi px, Latest

Column Type Comment
alue string Datasource did not contain a description for Alue. Column alue has 82110 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 and maximum string is 992.
menolajitulolajiinvestointiera int Datasource did not contain a description for Menolajitulolajiinvestointiera. Column menolajitulolajiinvestointiera has 82110 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 9949.
tehtava int Datasource did not contain a description for Tehtava. Column tehtava has 82110 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 2.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 82110 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2011.
kuntien_meno_ja_tuloerittelyita_2011 int Datasource did not contain a description for Kuntien_meno_ja_tuloerittelyita_2011. Column kuntien_meno_ja_tuloerittelyita_2011 has 82110 rows, out of which 46390 are empty, making the null percent 56.50. Minimum value is -82 and maximum value is 5669103.

Fact, T100 ktt18 2011 fi px, Full history

Column Type Comment
alue string Datasource did not contain a description for Alue. Column alue has 82110 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 and maximum string is 992.
menolajitulolajiinvestointiera int Datasource did not contain a description for Menolajitulolajiinvestointiera. Column menolajitulolajiinvestointiera has 82110 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 9949.
tehtava int Datasource did not contain a description for Tehtava. Column tehtava has 82110 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 2.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 82110 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2011.
kuntien_meno_ja_tuloerittelyita_2011 int Datasource did not contain a description for Kuntien_meno_ja_tuloerittelyita_2011. Column kuntien_meno_ja_tuloerittelyita_2011 has 82110 rows, out of which 46390 are empty, making the null percent 56.50. Minimum value is -82 and maximum value is 5669103.
orig_extractdate string The date when the data was originally fetched from the source.

Dim alue, T100 ktt18 2011 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 357 rows, out of which 21 are empty, making the null percent 5.88. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 357 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 Alajärvi and maximum string is 992 Äänekoski.
orig_extractdate string The date when the data was originally fetched from the source.

Dim alue, T100 ktt18 2011 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 357 rows, out of which 21 are empty, making the null percent 5.88. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 357 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 Alajärvi and maximum string is 992 Äänekoski.

Dim menolajitulolajiinvestointiera, T100 ktt18 2011 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 115 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 9949.
label string The label for the dimension value. Column label has 115 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0000 Käyttömenojen menol... and first 25 characters of maximum string: 9949 Muiden osakkeiden j...

Dim menolajitulolajiinvestointiera, T100 ktt18 2011 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 115 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 9949.
label string The label for the dimension value. Column label has 115 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0000 Käyttömenojen menol... and first 25 characters of maximum string: 9949 Muiden osakkeiden j...
orig_extractdate string The date when the data was originally fetched from the source.

Dim tehtava, T100 ktt18 2011 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 2 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 2.
label string The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 001 Muu kuin liiketoimin... and first 25 characters of maximum string: 002 Liiketoiminta...

Dim tehtava, T100 ktt18 2011 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 2 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 2.
label string The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 001 Muu kuin liiketoimin... and first 25 characters of maximum string: 002 Liiketoiminta...
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 25, 2019
Created July 24, 2019