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

Kuntien tuloslaskelmat 1997-2000 (Ahvenanmaan kuntien tiedot vain vuosilta 1999 ja 2000)

Kuntien tuloslaskelmat 1997-2000 (Ahvenanmaan kuntien tiedot vain vuosilta 1999 ja 2000)

Tables

Column Descriptions

Dim kunta, T170 ktt111 1997 2000 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 453 rows, out of which 1 are empty, making the null percent 0.22. Minimum value is 4 and maximum value is 992.
label string The label for the dimension value. Column label has 453 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alahärmä and maximum string is Äänekoski.

Dim tuotto kuluera, T170 ktt111 1997 2000 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 10100 and maximum value is 19000.
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: 10100 + myyntituotot... and first 25 characters of maximum string: 19000 = tilikauden ylijää...
orig_extractdate string The date when the data was originally fetched from the source.

Dim tuotto kuluera, T170 ktt111 1997 2000 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 10100 and maximum value is 19000.
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: 10100 + myyntituotot... and first 25 characters of maximum string: 19000 = tilikauden ylijää...

Fact, T170 ktt111 1997 2000 fi px, Latest

Column Type Comment
kunta int Datasource did not contain a description for Kunta. Column kunta has 68856 rows, out of which 152 are empty, making the null percent 0.22. Minimum value is 4 and maximum value is 992.
tuotto_kuluera int Datasource did not contain a description for Tuotto_kuluera. Column tuotto_kuluera has 68856 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10100 and maximum value is 19000.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 68856 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1997 and maximum value is 2000.
kuntien_tuloslaskelmat int Datasource did not contain a description for Kuntien_tuloslaskelmat. Column kuntien_tuloslaskelmat has 68856 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -83657439 and maximum value is 57531352.

Dim vuosi, T170 ktt111 1997 2000 fi px, Full history

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

Dim vuosi, T170 ktt111 1997 2000 fi px, Latest

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

Fact, T170 ktt111 1997 2000 fi px, Full history

Column Type Comment
kunta int Datasource did not contain a description for Kunta. Column kunta has 68856 rows, out of which 152 are empty, making the null percent 0.22. Minimum value is 4 and maximum value is 992.
tuotto_kuluera int Datasource did not contain a description for Tuotto_kuluera. Column tuotto_kuluera has 68856 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10100 and maximum value is 19000.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 68856 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1997 and maximum value is 2000.
kuntien_tuloslaskelmat int Datasource did not contain a description for Kuntien_tuloslaskelmat. Column kuntien_tuloslaskelmat has 68856 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -83657439 and maximum value is 57531352.
orig_extractdate string The date when the data was originally fetched from the source.

Dim kunta, T170 ktt111 1997 2000 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 453 rows, out of which 1 are empty, making the null percent 0.22. Minimum value is 4 and maximum value is 992.
label string The label for the dimension value. Column label has 453 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alahärmä and maximum string is Äänekoski.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated June 13, 2019
Created June 12, 2019