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

Kuntien tilinpäätökset 2006-2014

Kuntien tilinpäätökset 2006-2014

Tables

Column Descriptions

Fact, Kuntien Tilinpaatokset 2006 2014

Column Type Comment
alue int Koko maa, Manner-Suomi ja maakunnat . Column alue has 29502 rows, out of which 2682 are empty, making the null percent 9.09. Minimum value is 1 and maximum value is 21.
tilinpaatosera int Datasource did not contain a description for Tilinpaatosera. Column tilinpaatosera has 29502 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 210000000 and maximum value is 263008500.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 29502 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_tilinpaatokset int Datasource did not contain a description for Kuntien_tilinpaatokset. Column kuntien_tilinpaatokset has 29502 rows, out of which 3081 are empty, making the null percent 10.44. Minimum value is -27431635 and maximum value is 54181621.
orig_extractdate string The date when the data was originally fetched from the source.

Dim Alue, Kuntien Tilinpaatokset 2006 2014

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 Tilinpaatosera, Kuntien Tilinpaatokset 2006 2014

Column Type Comment
code int The code for the dimension value. Column code has 149 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 210000000 and maximum value is 263008500.
label string The label for the dimension value. Column label has 149 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aineelliset hyödykkeet yh... and first 25 characters of maximum string: Takaukset muiden puolesta...
orig_extractdate string The date when the data was originally fetched from the source.

Dim Vuosi, Kuntien Tilinpaatokset 2006 2014

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.

Additional Info

Last Updated April 12, 2019
Created February 12, 2019