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

Kuntien käyttötalous 2006-2014

Kuntien käyttötalous 2006-2014

Tables

Column Descriptions

Dim tehtavaluokka, T030 ktt tau 103 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 61 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 61 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.

Dim tehtavaluokka, T030 ktt tau 103 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 61 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 61 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ä.

Dim vuosi, T030 ktt tau 103 px, Latest

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

Dim kustannus tuottoera, T030 ktt tau 103 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: Aineet, tarvikkeet ja tav... and first 25 characters of maximum string: Muut laskennalliset tulot...

Dim kustannus tuottoera, T030 ktt tau 103 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: Aineet, tarvikkeet ja tav... and first 25 characters of maximum string: Muut laskennalliset tulot...
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, T030 ktt tau 103 px, Full history

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

Fact, T030 ktt tau 103 px, Full history

Column Type Comment
alue string Koko maa, Manner-Suomi ja maakunnat . Column alue has 495198 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 and maximum string is 21.
tehtavaluokka int Datasource did not contain a description for Tehtavaluokka. Column tehtavaluokka has 495198 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.
kustannus_tuottoera int Datasource did not contain a description for Kustannus_tuottoera. Column kustannus_tuottoera has 495198 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.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 495198 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2006 and maximum value is 2014.
kuntien_kayttotalous int Datasource did not contain a description for Kuntien_kayttotalous. Column kuntien_kayttotalous has 495198 rows, out of which 201150 are empty, making the null percent 40.62. Minimum value is -2781 and maximum value is 38600863.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T030 ktt tau 103 px, Latest

Column Type Comment
alue string Koko maa, Manner-Suomi ja maakunnat . Column alue has 495198 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 and maximum string is 21.
tehtavaluokka int Datasource did not contain a description for Tehtavaluokka. Column tehtavaluokka has 495198 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.
kustannus_tuottoera int Datasource did not contain a description for Kustannus_tuottoera. Column kustannus_tuottoera has 495198 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.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 495198 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2006 and maximum value is 2014.
kuntien_kayttotalous int Datasource did not contain a description for Kuntien_kayttotalous. Column kuntien_kayttotalous has 495198 rows, out of which 201150 are empty, making the null percent 40.62. Minimum value is -2781 and maximum value is 38600863.

Dim alue, T030 ktt tau 103 px, Full history

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

Dim alue, T030 ktt tau 103 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 22 rows, out of which 2 are empty, making the null percent 9.09. Minimum value is 1 and maximum value is 21.
label string The label for the dimension value. Column label has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahvenanmaa and maximum string is Itä-Uusimaa.

Additional Info

Last Updated July 14, 2019
Created July 13, 2019