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

Kuntien toiminta (ilman sosiaalitointa) 2007

Kuntien toiminta (ilman sosiaalitointa) 2007

Tables

Column Descriptions

Fact, T140 ktt1103 2007 fi px, Latest

Column Type Comment
alue string Datasource did not contain a description for Alue. Column alue has 39420 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 004 and maximum string is 971.
toimintatieto int Datasource did not contain a description for Toimintatieto. Column toimintatieto has 39420 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2081 and maximum value is 7109.
palvelutkapasiteetti int Datasource did not contain a description for Palvelutkapasiteetti. Column palvelutkapasiteetti has 39420 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 7.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 39420 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2007.
kuntien_toiminta_ilman_sosiaalitointa_2007 int Datasource did not contain a description for Kuntien_toiminta_ilman_sosiaalitointa_2007. Column kuntien_toiminta_ilman_sosiaalitointa_2007 has 39420 rows, out of which 26468 are empty, making the null percent 67.14. Minimum value is 0 and maximum value is 497412846.

Fact, T140 ktt1103 2007 fi px, Full history

Column Type Comment
alue string Datasource did not contain a description for Alue. Column alue has 39420 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 004 and maximum string is 971.
toimintatieto int Datasource did not contain a description for Toimintatieto. Column toimintatieto has 39420 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2081 and maximum value is 7109.
palvelutkapasiteetti int Datasource did not contain a description for Palvelutkapasiteetti. Column palvelutkapasiteetti has 39420 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 7.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 39420 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2007.
kuntien_toiminta_ilman_sosiaalitointa_2007 int Datasource did not contain a description for Kuntien_toiminta_ilman_sosiaalitointa_2007. Column kuntien_toiminta_ilman_sosiaalitointa_2007 has 39420 rows, out of which 26468 are empty, making the null percent 67.14. Minimum value is 0 and maximum value is 497412846.
orig_extractdate string The date when the data was originally fetched from the source.

Dim alue, T140 ktt1103 2007 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 438 rows, out of which 22 are empty, making the null percent 5.02. Minimum value is 4 and maximum value is 992.
label string The label for the dimension value. Column label has 438 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 004 Alahärmä and maximum string is 971 Ylihärmä.

Dim alue, T140 ktt1103 2007 fi px, Full history

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

Dim toimintatieto, T140 ktt1103 2007 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 45 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2081 and maximum value is 7109.
label string The label for the dimension value. Column label has 45 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 2081 Esiopetuksen oppilai... and first 25 characters of maximum string: 7109 Kunnan suoraan omist...
orig_extractdate string The date when the data was originally fetched from the source.

Dim toimintatieto, T140 ktt1103 2007 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 45 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2081 and maximum value is 7109.
label string The label for the dimension value. Column label has 45 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 2081 Esiopetuksen oppilai... and first 25 characters of maximum string: 7109 Kunnan suoraan omist...

Dim palvelutkapasiteetti, T140 ktt1103 2007 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 7.
label string The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 001 Kunnan/kuntayhtymän i... and first 25 characters of maximum string: 007 Toiminnan laajuus, to...
orig_extractdate string The date when the data was originally fetched from the source.

Dim palvelutkapasiteetti, T140 ktt1103 2007 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 7.
label string The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 001 Kunnan/kuntayhtymän i... and first 25 characters of maximum string: 007 Toiminnan laajuus, to...

Additional Info

Last Updated July 10, 2019
Created July 9, 2019