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

Kuntien meno- ja tuloerittelyitä 2006

Kuntien meno- ja tuloerittelyitä 2006

Tables

Column Descriptions

Dim tehtava, T150 ktt18 2006 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 liiketoimint... and first 25 characters of maximum string: 002 Liiketoiminta...
orig_extractdate string The date when the data was originally fetched from the source.

Dim alue, T150 ktt18 2006 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 453 rows, out of which 22 are empty, making the null percent 4.86. Minimum value is 4 and maximum value is 992.
label string The label for the dimension value. Column label has 453 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 004 Alahärmä and maximum string is 992 Äänekoski.
orig_extractdate string The date when the data was originally fetched from the source.

Dim menolajitulolajiinvestointiera, T150 ktt18 2006 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 112 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 370 and maximum value is 9949.
label string The label for the dimension value. Column label has 112 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0370 Eläkevakuutusmaksut... and first 25 characters of maximum string: 9949 Muiden osakkeiden ja...
orig_extractdate string The date when the data was originally fetched from the source.

Dim alue, T150 ktt18 2006 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 453 rows, out of which 22 are empty, making the null percent 4.86. Minimum value is 4 and maximum value is 992.
label string The label for the dimension value. Column label has 453 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 004 Alahärmä and maximum string is 992 Äänekoski.

Dim menolajitulolajiinvestointiera, T150 ktt18 2006 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 112 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 370 and maximum value is 9949.
label string The label for the dimension value. Column label has 112 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0370 Eläkevakuutusmaksut... and first 25 characters of maximum string: 9949 Muiden osakkeiden ja...

Fact, T150 ktt18 2006 fi px, Latest

Column Type Comment
alue string Datasource did not contain a description for Alue. Column alue has 101472 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 004 and maximum string is 992.
menolajitulolajiinvestointiera int Datasource did not contain a description for Menolajitulolajiinvestointiera. Column menolajitulolajiinvestointiera has 101472 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 370 and maximum value is 9949.
tehtava int Datasource did not contain a description for Tehtava. Column tehtava has 101472 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 101472 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2006.
kuntien_meno_ja_tuloerittelyita_2006 int Datasource did not contain a description for Kuntien_meno_ja_tuloerittelyita_2006. Column kuntien_meno_ja_tuloerittelyita_2006 has 101472 rows, out of which 56500 are empty, making the null percent 55.68. Minimum value is -104 and maximum value is 3877578.

Fact, T150 ktt18 2006 fi px, Full history

Column Type Comment
alue string Datasource did not contain a description for Alue. Column alue has 101472 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 004 and maximum string is 992.
menolajitulolajiinvestointiera int Datasource did not contain a description for Menolajitulolajiinvestointiera. Column menolajitulolajiinvestointiera has 101472 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 370 and maximum value is 9949.
tehtava int Datasource did not contain a description for Tehtava. Column tehtava has 101472 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 101472 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2006.
kuntien_meno_ja_tuloerittelyita_2006 int Datasource did not contain a description for Kuntien_meno_ja_tuloerittelyita_2006. Column kuntien_meno_ja_tuloerittelyita_2006 has 101472 rows, out of which 56500 are empty, making the null percent 55.68. Minimum value is -104 and maximum value is 3877578.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tehtava, T150 ktt18 2006 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 liiketoimint... and first 25 characters of maximum string: 002 Liiketoiminta...

Additional Info

Last Updated September 22, 2019
Created June 11, 2019