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

Kuntayhtymien investoinnit 2009

Kuntayhtymien investoinnit 2009

Tables

Column Descriptions

Dim alue, T120 kytt27 2009 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 160 rows, out of which 16 are empty, making the null percent 10.00. Minimum value is 0 and maximum value is 5433.
label string The label for the dimension value. Column label has 160 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 000 Kaikki kuntayhtymät... and first 25 characters of maximum string: 05433 Ylä-Pirkanmaan peru...
orig_extractdate string The date when the data was originally fetched from the source.

Dim menotulolaji, T120 kytt27 2009 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 31 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 3110 and maximum value is 9900.
label string The label for the dimension value. Column label has 31 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 3110 Tietokoneohjelmistoj... and first 25 characters of maximum string: 9900 Investointitulot yht...
orig_extractdate string The date when the data was originally fetched from the source.

Dim alue, T120 kytt27 2009 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 160 rows, out of which 16 are empty, making the null percent 10.00. Minimum value is 0 and maximum value is 5433.
label string The label for the dimension value. Column label has 160 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 000 Kaikki kuntayhtymät... and first 25 characters of maximum string: 05433 Ylä-Pirkanmaan peru...

Dim tehtavaluokka, T120 kytt27 2009 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 38 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 710.
label string The label for the dimension value. Column label has 38 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 110 Yleishallinto... and first 25 characters of maximum string: 710 Investointituloista: ...
orig_extractdate string The date when the data was originally fetched from the source.

Dim tehtavaluokka, T120 kytt27 2009 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 38 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 710.
label string The label for the dimension value. Column label has 38 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 110 Yleishallinto... and first 25 characters of maximum string: 710 Investointituloista: ...

Fact, T120 kytt27 2009 fi px, Full history

Column Type Comment
alue int Datasource did not contain a description for Alue. Column alue has 188480 rows, out of which 18848 are empty, making the null percent 10.00. Minimum value is 0 and maximum value is 5433.
menotulolaji int Datasource did not contain a description for Menotulolaji. Column menotulolaji has 188480 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 3110 and maximum value is 9900.
tehtavaluokka int Datasource did not contain a description for Tehtavaluokka. Column tehtavaluokka has 188480 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 710.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 188480 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2009.
kuntayhtymien_investoinnit_2009 int Datasource did not contain a description for Kuntayhtymien_investoinnit_2009. Column kuntayhtymien_investoinnit_2009 has 188480 rows, out of which 185016 are empty, making the null percent 98.16. Minimum value is 0 and maximum value is 609904.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T120 kytt27 2009 fi px, Latest

Column Type Comment
alue int Datasource did not contain a description for Alue. Column alue has 188480 rows, out of which 18848 are empty, making the null percent 10.00. Minimum value is 0 and maximum value is 5433.
menotulolaji int Datasource did not contain a description for Menotulolaji. Column menotulolaji has 188480 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 3110 and maximum value is 9900.
tehtavaluokka int Datasource did not contain a description for Tehtavaluokka. Column tehtavaluokka has 188480 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 710.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 188480 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2009.
kuntayhtymien_investoinnit_2009 int Datasource did not contain a description for Kuntayhtymien_investoinnit_2009. Column kuntayhtymien_investoinnit_2009 has 188480 rows, out of which 185016 are empty, making the null percent 98.16. Minimum value is 0 and maximum value is 609904.

Dim menotulolaji, T120 kytt27 2009 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 31 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 3110 and maximum value is 9900.
label string The label for the dimension value. Column label has 31 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 3110 Tietokoneohjelmistoj... and first 25 characters of maximum string: 9900 Investointitulot yht...

Additional Info

Last Updated September 22, 2019
Created August 6, 2019