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

Kuntien rahoituslaskelmat 1997-1999 (Ahvenanmaan kuntien tiedot vain vuodelta 1999)

Kuntien rahoituslaskelmat 1997-1999 (Ahvenanmaan kuntien tiedot vain vuodelta 1999)

Tables

Column Descriptions

Fact, T170 ktt112 1997 1999 fi px, Full history

Column Type Comment
kunta int Datasource did not contain a description for Kunta. Column kunta has 21744 rows, out of which 48 are empty, making the null percent 0.22. Minimum value is 4 and maximum value is 992.
rahoitusera int Datasource did not contain a description for Rahoitusera. Column rahoitusera has 21744 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21400 and maximum value is 27000.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 21744 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 1999.
kuntien_rahoituslaskelmat int Datasource did not contain a description for Kuntien_rahoituslaskelmat. Column kuntien_rahoituslaskelmat has 21744 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -10177991 and maximum value is 13564645.
orig_extractdate string The date when the data was originally fetched from the source.

Dim kunta, T170 ktt112 1997 1999 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.

Fact, T170 ktt112 1997 1999 fi px, Latest

Column Type Comment
kunta int Datasource did not contain a description for Kunta. Column kunta has 21744 rows, out of which 48 are empty, making the null percent 0.22. Minimum value is 4 and maximum value is 992.
rahoitusera int Datasource did not contain a description for Rahoitusera. Column rahoitusera has 21744 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21400 and maximum value is 27000.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 21744 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 1999.
kuntien_rahoituslaskelmat int Datasource did not contain a description for Kuntien_rahoituslaskelmat. Column kuntien_rahoituslaskelmat has 21744 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -10177991 and maximum value is 13564645.

Dim kunta, T170 ktt112 1997 1999 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 rahoitusera, T170 ktt112 1997 1999 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21400 and maximum value is 27000.
label string The label for the dimension value. Column label has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 21400 vuosikate... and first 25 characters of maximum string: 27000 = toimintapääoman l...

Dim vuosi, T170 ktt112 1997 1999 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 3 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 1999.
label int The label for the dimension value. Column label has 3 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 1999.
orig_extractdate string The date when the data was originally fetched from the source.

Dim rahoitusera, T170 ktt112 1997 1999 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21400 and maximum value is 27000.
label string The label for the dimension value. Column label has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 21400 vuosikate... and first 25 characters of maximum string: 27000 = toimintapääoman l...
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated January 7, 2025
Created July 11, 2019