1. Home
  2. Datasets
  3. Kuntien käyttötalous 2009
To download the data set, please sign up or log in

Kuntien käyttötalous 2009

Kuntien käyttötalous 2009

Tables

Column Descriptions

Dim alue, T120 ktt16 2009 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 370 rows, out of which 22 are empty, making the null percent 5.95. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 370 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 alue, T120 ktt16 2009 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 370 rows, out of which 22 are empty, making the null percent 5.95. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 370 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 tehtavaluokka, T120 ktt16 2009 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 57 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 110 and maximum value is 700.
label string The label for the dimension value. Column label has 57 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 110 Yleishallinto and maximum string is 700 Käyttötalous yhteensä.

Fact, T120 ktt16 2009 fi px, Latest

Column Type Comment
alue int Datasource did not contain a description for Alue. Column alue has 864690 rows, out of which 51414 are empty, making the null percent 5.95. Minimum value is 5 and maximum value is 992.
kustannus_tuottoera int Datasource did not contain a description for Kustannus_tuottoera. Column kustannus_tuottoera has 864690 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 6970.
tehtavaluokka int Datasource did not contain a description for Tehtavaluokka. Column tehtavaluokka has 864690 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 110 and maximum value is 700.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 864690 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2009.
kuntien_kayttotalous_2009 int Datasource did not contain a description for Kuntien_kayttotalous_2009. Column kuntien_kayttotalous_2009 has 864690 rows, out of which 635371 are empty, making the null percent 73.48. Minimum value is -1169 and maximum value is 32184064.

Dim kustannus tuottoera, T120 ktt16 2009 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 41 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 6970.
label string The label for the dimension value. Column label has 41 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 KUSTANNUKSET... and first 25 characters of maximum string: 6970 Muut laskennalliset ...
orig_extractdate string The date when the data was originally fetched from the source.

Dim kustannus tuottoera, T120 ktt16 2009 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 41 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 6970.
label string The label for the dimension value. Column label has 41 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 KUSTANNUKSET... and first 25 characters of maximum string: 6970 Muut laskennalliset ...

Fact, T120 ktt16 2009 fi px, Full history

Column Type Comment
alue int Datasource did not contain a description for Alue. Column alue has 864690 rows, out of which 51414 are empty, making the null percent 5.95. Minimum value is 5 and maximum value is 992.
kustannus_tuottoera int Datasource did not contain a description for Kustannus_tuottoera. Column kustannus_tuottoera has 864690 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 6970.
tehtavaluokka int Datasource did not contain a description for Tehtavaluokka. Column tehtavaluokka has 864690 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 110 and maximum value is 700.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 864690 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2009.
kuntien_kayttotalous_2009 int Datasource did not contain a description for Kuntien_kayttotalous_2009. Column kuntien_kayttotalous_2009 has 864690 rows, out of which 635371 are empty, making the null percent 73.48. Minimum value is -1169 and maximum value is 32184064.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tehtavaluokka, T120 ktt16 2009 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 57 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 110 and maximum value is 700.
label string The label for the dimension value. Column label has 57 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 110 Yleishallinto and maximum string is 700 Käyttötalous yhteensä.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 21, 2019
Created July 19, 2019