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

Kuntien rahoituslaskelmat 1993-1997 (vuosi 1997 sisältää vain Ahvenanmaan kuntien tiedot)

Kuntien rahoituslaskelmat 1993-1997 (vuosi 1997 sisältää vain Ahvenanmaan kuntien tiedot)

Tables

Column Descriptions

Dim kunta, T190 ktt112 1993 1997 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 452 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4 and maximum value is 992.
label string The label for the dimension value. Column label has 452 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.

Dim kunta, T190 ktt112 1993 1997 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 452 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4 and maximum value is 992.
label string The label for the dimension value. Column label has 452 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, T190 ktt112 1993 1997 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 51 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 5500.
label string The label for the dimension value. Column label has 51 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 verotulot... and first 25 characters of maximum string: 5500 siitä: käyttöomaisuu...
orig_extractdate string The date when the data was originally fetched from the source.

Dim rahoitusera, T190 ktt112 1993 1997 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 51 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 5500.
label string The label for the dimension value. Column label has 51 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 verotulot... and first 25 characters of maximum string: 5500 siitä: käyttöomaisuu...

Dim vuosi, T190 ktt112 1993 1997 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 1993 and maximum value is 1997.
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 1993 and maximum value is 1997.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, T190 ktt112 1993 1997 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 1993 and maximum value is 1997.
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 1993 and maximum value is 1997.

Fact, T190 ktt112 1993 1997 fi px, Latest

Column Type Comment
kunta int Datasource did not contain a description for Kunta. Column kunta has 115260 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4 and maximum value is 992.
rahoitusera int Datasource did not contain a description for Rahoitusera. Column rahoitusera has 115260 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 5500.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 115260 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1993 and maximum value is 1997.
kuntien_rahoituslaskelmat int Datasource did not contain a description for Kuntien_rahoituslaskelmat. Column kuntien_rahoituslaskelmat has 115260 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -1020974 and maximum value is 20438386.

Fact, T190 ktt112 1993 1997 fi px, Full history

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

Additional Info

Last Updated July 14, 2019
Created July 14, 2019