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

Eräitä tietoja kuntien taloudesta 1993-1997 (vuosi 1997 sisältää vain Ahvenanmaan kuntien tiedot)

Eräitä tietoja kuntien taloudesta 1993-1997 (vuosi 1997 sisältää vain Ahvenanmaan kuntien tiedot)

Tables

Column Descriptions

Dim kunta, T190 ktt19 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 kunta, T190 ktt19 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.

Fact, T190 ktt19 1993 1997 fi px, Full history

Column Type Comment
kunta int Datasource did not contain a description for Kunta. Column kunta has 67800 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.
tieto int Datasource did not contain a description for Tieto. Column tieto has 67800 rows, out of which 2260 are empty, making the null percent 3.33. Minimum value is 1101490 and maximum value is 8409390.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 67800 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.
eraita_tietoja_kuntien_taloudesta int Datasource did not contain a description for Eraita_tietoja_kuntien_taloudesta. Column eraita_tietoja_kuntien_taloudesta has 67800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 558643.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tieto, T190 ktt19 1993 1997 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 30 rows, out of which 1 are empty, making the null percent 3.33. Minimum value is 1101490 and maximum value is 8409390.
label string The label for the dimension value. Column label has 30 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 1101490 vaalit, menot yht... and first 25 characters of maximum string: 8409390 kirjasto, pienten...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T190 ktt19 1993 1997 fi px, Latest

Column Type Comment
kunta int Datasource did not contain a description for Kunta. Column kunta has 67800 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.
tieto int Datasource did not contain a description for Tieto. Column tieto has 67800 rows, out of which 2260 are empty, making the null percent 3.33. Minimum value is 1101490 and maximum value is 8409390.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 67800 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.
eraita_tietoja_kuntien_taloudesta int Datasource did not contain a description for Eraita_tietoja_kuntien_taloudesta. Column eraita_tietoja_kuntien_taloudesta has 67800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 558643.

Dim tieto, T190 ktt19 1993 1997 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 30 rows, out of which 1 are empty, making the null percent 3.33. Minimum value is 1101490 and maximum value is 8409390.
label string The label for the dimension value. Column label has 30 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 1101490 vaalit, menot yht... and first 25 characters of maximum string: 8409390 kirjasto, pienten...

Dim vuosi, T190 ktt19 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.

Additional Info

Last Updated July 20, 2019
Created July 19, 2019