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

Kuntien talousarviot 2008-2009 (poislukien liiketoiminta)

Kuntien talousarviot 2008-2009 (poislukien liiketoiminta)

Tables

Column Descriptions

Dim vuosi, T510 ktt13b 2008 2009 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 2008 and maximum value is 2009.
label int 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. Minimum value is 2008 and maximum value is 2009.
orig_extractdate string The date when the data was originally fetched from the source.

Dim alue, T510 ktt13b 2008 2009 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 443 rows, out of which 22 are empty, making the null percent 4.97. Minimum value is 4 and maximum value is 992.
label string The label for the dimension value. Column label has 443 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 tunnusluku, T510 ktt13b 2008 2009 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 42 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: Asukasluku 31.12.TA - 1...
label string The label for the dimension value. Column label has 42 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: Asukasluku 31.12. TA - 1 ...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T510 ktt13b 2008 2009 fi px, Full history

Column Type Comment
alue int Datasource did not contain a description for Alue. Column alue has 37212 rows, out of which 1848 are empty, making the null percent 4.97. Minimum value is 4 and maximum value is 992.
tunnusluku string Datasource did not contain a description for Tunnusluku. Column tunnusluku has 37212 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: Asukasluku 31.12.TA - 1...
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 37212 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2009.
kuntien_talousarviot_poislukien_liiketoiminta int Datasource did not contain a description for Kuntien_talousarviot_poislukien_liiketoiminta. Column kuntien_talousarviot_poislukien_liiketoiminta has 37212 rows, out of which 10088 are empty, making the null percent 27.11. Minimum value is -24282850 and maximum value is 32053187.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T510 ktt13b 2008 2009 fi px, Latest

Column Type Comment
alue int Datasource did not contain a description for Alue. Column alue has 37212 rows, out of which 1848 are empty, making the null percent 4.97. Minimum value is 4 and maximum value is 992.
tunnusluku string Datasource did not contain a description for Tunnusluku. Column tunnusluku has 37212 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: Asukasluku 31.12.TA - 1...
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 37212 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2009.
kuntien_talousarviot_poislukien_liiketoiminta int Datasource did not contain a description for Kuntien_talousarviot_poislukien_liiketoiminta. Column kuntien_talousarviot_poislukien_liiketoiminta has 37212 rows, out of which 10088 are empty, making the null percent 27.11. Minimum value is -24282850 and maximum value is 32053187.

Dim tunnusluku, T510 ktt13b 2008 2009 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 42 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: Asukasluku 31.12.TA - 1...
label string The label for the dimension value. Column label has 42 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: Asukasluku 31.12. TA - 1 ...

Dim alue, T510 ktt13b 2008 2009 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 443 rows, out of which 22 are empty, making the null percent 4.97. Minimum value is 4 and maximum value is 992.
label string The label for the dimension value. Column label has 443 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, T510 ktt13b 2008 2009 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 2008 and maximum value is 2009.
label int 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. Minimum value is 2008 and maximum value is 2009.

Additional Info

Last Updated September 20, 2019
Created August 4, 2019