1. Home
  2. Datasets
  3. Kuntien meno- ja ...
To download the data set, please sign up or log in

Kuntien meno- ja tuloerittelyitä 2002-2005

Kuntien meno- ja tuloerittelyitä 2002-2005

Tables

Column Descriptions

Dim tehtava, T160 ktt18 2002 2005 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, T160 ktt18 2002 2005 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 471 rows, out of which 22 are empty, making the null percent 4.67. Minimum value is 4 and maximum value is 992.
label string The label for the dimension value. Column label has 471 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 tehtava, T160 ktt18 2002 2005 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...

Fact, T160 ktt18 2002 2005 fi px, Latest

Column Type Comment
alue string Datasource did not contain a description for Alue. Column alue has 361728 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 361728 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 6969.
tehtava int Datasource did not contain a description for Tehtava. Column tehtava has 361728 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 361728 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2005.
kuntien_meno_ja_tuloerittelyita int Datasource did not contain a description for Kuntien_meno_ja_tuloerittelyita. Column kuntien_meno_ja_tuloerittelyita has 361728 rows, out of which 185535 are empty, making the null percent 51.29. Minimum value is -225 and maximum value is 3642780.

Dim alue, T160 ktt18 2002 2005 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 471 rows, out of which 22 are empty, making the null percent 4.67. Minimum value is 4 and maximum value is 992.
label string The label for the dimension value. Column label has 471 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 vuosi, T160 ktt18 2002 2005 fi px, Full history

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

Fact, T160 ktt18 2002 2005 fi px, Full history

Column Type Comment
alue string Datasource did not contain a description for Alue. Column alue has 361728 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 361728 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 6969.
tehtava int Datasource did not contain a description for Tehtava. Column tehtava has 361728 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 361728 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2005.
kuntien_meno_ja_tuloerittelyita int Datasource did not contain a description for Kuntien_meno_ja_tuloerittelyita. Column kuntien_meno_ja_tuloerittelyita has 361728 rows, out of which 185535 are empty, making the null percent 51.29. Minimum value is -225 and maximum value is 3642780.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, T160 ktt18 2002 2005 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2005.
label int The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2005.

Dim menolajitulolajiinvestointiera, T160 ktt18 2002 2005 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 96 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 6969.
label string The label for the dimension value. Column label has 96 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0370 Eläkevakuutusmaksut and maximum string is 6969 Muut vyörytystulot.

Dim menolajitulolajiinvestointiera, T160 ktt18 2002 2005 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 96 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 6969.
label string The label for the dimension value. Column label has 96 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0370 Eläkevakuutusmaksut and maximum string is 6969 Muut vyörytystulot.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 22, 2019
Created August 5, 2019