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

Operating economy, municipalities

Operating economy, municipalities

Tables

Column Descriptions

Fact, Operating Economy Municipalities

Column Type Comment
region string Datasource did not contain a description for Region. Column region has 47628 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 and maximum string is 21.
expensesrevenues string Datasource did not contain a description for Expensesrevenues. Column expensesrevenues has 47628 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is aineet_tarvikkeet_tavarat and maximum string is vyorytystuotot.
activity_category int Datasource did not contain a description for Activity_category. Column activity_category has 47628 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 110 and maximum value is 700.
year int Datasource did not contain a description for Year. Column year has 47628 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2015.
operating_economy_municipalities int Datasource did not contain a description for Operating_economy_municipalities. Column operating_economy_municipalities has 47628 rows, out of which 4536 are empty, making the null percent 9.52. Minimum value is -1030 and maximum value is 41450139.
orig_extractdate string The date when the data was originally fetched from the source.

Dim Region, Operating Economy Municipalities

Column Type Comment
code string The code for the dimension value. Column code has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 and maximum string is 21.
label string The label for the dimension value. Column label has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Central Finland and maximum string is Åland.
orig_extractdate string The date when the data was originally fetched from the source.

Dim Expensesrevenues, Operating Economy Municipalities

Column Type Comment
code string The code for the dimension value. Column code has 42 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is aineet_tarvikkeet_tavarat and maximum string is vyorytystuotot.
label string The label for the dimension value. Column label has 42 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Allocated common expenses and maximum string is Allocated common income.
orig_extractdate string The date when the data was originally fetched from the source.

Dim Activity Category, Operating Economy Municipalities

Column Type Comment
code int The code for the dimension value. Column code has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 110 and maximum value is 700.
label string The label for the dimension value. Column label has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Agriculture and forestry... and first 25 characters of maximum string: Operating activities tota...
orig_extractdate string The date when the data was originally fetched from the source.

Dim Year, Operating Economy Municipalities

Column Type Comment
code string The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 2015.
label string The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 2015.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created November 28, 2018