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

Kuntien talousarviot 2010 (poislukien liiketoiminta)

Kuntien talousarviot 2010 (poislukien liiketoiminta)

Tables

Column Descriptions

Fact, T500 ktt13b 2010 fi px, Full history

Column Type Comment
alue int Datasource did not contain a description for Alue. Column alue has 15288 rows, out of which 924 are empty, making the null percent 6.04. Minimum value is 5 and maximum value is 992.
tunnusluku string Datasource did not contain a description for Tunnusluku. Column tunnusluku has 15288 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 15288 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2010.
kuntien_talousarviot_2010_poislukien_liiketoiminta int Datasource did not contain a description for Kuntien_talousarviot_2010_poislukien_liiketoiminta. Column kuntien_talousarviot_2010_poislukien_liiketoiminta has 15288 rows, out of which 3059 are empty, making the null percent 20.01. Minimum value is -24729688 and maximum value is 33061225.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T500 ktt13b 2010 fi px, Latest

Column Type Comment
alue int Datasource did not contain a description for Alue. Column alue has 15288 rows, out of which 924 are empty, making the null percent 6.04. Minimum value is 5 and maximum value is 992.
tunnusluku string Datasource did not contain a description for Tunnusluku. Column tunnusluku has 15288 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 15288 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2010.
kuntien_talousarviot_2010_poislukien_liiketoiminta int Datasource did not contain a description for Kuntien_talousarviot_2010_poislukien_liiketoiminta. Column kuntien_talousarviot_2010_poislukien_liiketoiminta has 15288 rows, out of which 3059 are empty, making the null percent 20.01. Minimum value is -24729688 and maximum value is 33061225.

Dim alue, T500 ktt13b 2010 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 364 rows, out of which 22 are empty, making the null percent 6.04. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 364 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 alue, T500 ktt13b 2010 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 364 rows, out of which 22 are empty, making the null percent 6.04. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 364 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 tunnusluku, T500 ktt13b 2010 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.

Dim tunnusluku, T500 ktt13b 2010 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 (...

Additional Info

Last Updated July 30, 2019
Created July 30, 2019