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

Kuntien liikelaitosten rahoituslaskelmat 2002-2006

Kuntien liikelaitosten rahoituslaskelmat 2002-2006

Tables

Column Descriptions

Dim rahoitusera, T150 ktt152 2002 2006 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 100 and maximum value is 8400.
label string The label for the dimension value. Column label has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0100 ± Liikeylijäämä (-al... and first 25 characters of maximum string: 8400 - Rahavarat 1.1....

Dim rahoitusera, T150 ktt152 2002 2006 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 100 and maximum value is 8400.
label string The label for the dimension value. Column label has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0100 ± Liikeylijäämä (-al... and first 25 characters of maximum string: 8400 - Rahavarat 1.1....
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, T150 ktt152 2002 2006 fi px, Full history

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

Dim alue, T150 ktt152 2002 2006 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 95 rows, out of which 21 are empty, making the null percent 22.11. Minimum value is 49 and maximum value is 936.
label string The label for the dimension value. Column label has 95 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 049 Espoo and maximum string is 936 Virrat.

Dim alue, T150 ktt152 2002 2006 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 95 rows, out of which 21 are empty, making the null percent 22.11. Minimum value is 49 and maximum value is 936.
label string The label for the dimension value. Column label has 95 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 049 Espoo and maximum string is 936 Virrat.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tehtava, T150 ktt152 2002 2006 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 21 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 750.
label string The label for the dimension value. Column label has 21 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: 750 Taseyksikkönä käsitel...
orig_extractdate string The date when the data was originally fetched from the source.

Dim tehtava, T150 ktt152 2002 2006 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 21 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 750.
label string The label for the dimension value. Column label has 21 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: 750 Taseyksikkönä käsitel...

Fact, T150 ktt152 2002 2006 fi px, Full history

Column Type Comment
alue string Datasource did not contain a description for Alue. Column alue has 329175 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 049 and maximum string is 936.
rahoitusera int Datasource did not contain a description for Rahoitusera. Column rahoitusera has 329175 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 100 and maximum value is 8400.
tehtava int Datasource did not contain a description for Tehtava. Column tehtava has 329175 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 750.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 329175 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2006.
kuntien_liikelaitosten_rahoituslaskelmat int Datasource did not contain a description for Kuntien_liikelaitosten_rahoituslaskelmat. Column kuntien_liikelaitosten_rahoituslaskelmat has 329175 rows, out of which 311468 are empty, making the null percent 94.62. Minimum value is -234876 and maximum value is 968475.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, T150 ktt152 2002 2006 fi px, Latest

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

Fact, T150 ktt152 2002 2006 fi px, Latest

Column Type Comment
alue string Datasource did not contain a description for Alue. Column alue has 329175 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 049 and maximum string is 936.
rahoitusera int Datasource did not contain a description for Rahoitusera. Column rahoitusera has 329175 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 100 and maximum value is 8400.
tehtava int Datasource did not contain a description for Tehtava. Column tehtava has 329175 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 750.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 329175 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2006.
kuntien_liikelaitosten_rahoituslaskelmat int Datasource did not contain a description for Kuntien_liikelaitosten_rahoituslaskelmat. Column kuntien_liikelaitosten_rahoituslaskelmat has 329175 rows, out of which 311468 are empty, making the null percent 94.62. Minimum value is -234876 and maximum value is 968475.

Additional Info

Last Updated July 20, 2019
Created July 13, 2019