1. Home
  2. Datasets
  3. Expenditure and income type ...
To download the data set, please sign up or log in

Expenditure and income type specifications, municipalities 2017

Expenditure and income type specifications, municipalities 2017

Tables

Column Descriptions

Dim region, T010 kta 16 2017 px, Full history

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

Fact, T010 kta 16 2017 px, Latest

Column Type Comment
region int Datasource did not contain a description for Region. Column region has 14306 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992.
item string Datasource did not contain a description for Item. Column item has 14306 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: aineet_tarvikkeet_ja_tava... and first 25 characters of maximum string: sakot_ja_uhkasakot...
year int Datasource did not contain a description for Year. Column year has 14306 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2017.
expenditure_and_income_type_specifications_municipalities_2017 int Datasource did not contain a description for Expenditure_and_income_type_specifications_municipalities_2017. Column expenditure_and_income_type_specifications_municipalities_2017 has 14306 rows, out of which 622 are empty, making the null percent 4.35. Minimum value is -22 and maximum value is 998759.

Dim region, T010 kta 16 2017 px, Latest

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

Dim item, T010 kta 16 2017 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 46 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: aineet_tarvikkeet_ja_tava... and first 25 characters of maximum string: sakot_ja_uhkasakot...
label string The label for the dimension value. Column label has 46 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Accommodation and food se... and first 25 characters of maximum string: Fines and penalties...

Dim item, T010 kta 16 2017 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 46 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: aineet_tarvikkeet_ja_tava... and first 25 characters of maximum string: sakot_ja_uhkasakot...
label string The label for the dimension value. Column label has 46 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Accommodation and food se... and first 25 characters of maximum string: Fines and penalties...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T010 kta 16 2017 px, Full history

Column Type Comment
region int Datasource did not contain a description for Region. Column region has 14306 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992.
item string Datasource did not contain a description for Item. Column item has 14306 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: aineet_tarvikkeet_ja_tava... and first 25 characters of maximum string: sakot_ja_uhkasakot...
year int Datasource did not contain a description for Year. Column year has 14306 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2017.
expenditure_and_income_type_specifications_municipalities_2017 int Datasource did not contain a description for Expenditure_and_income_type_specifications_municipalities_2017. Column expenditure_and_income_type_specifications_municipalities_2017 has 14306 rows, out of which 622 are empty, making the null percent 4.35. Minimum value is -22 and maximum value is 998759.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 20, 2019
Created August 5, 2019