1. Home
  2. Datasets
  3. 003 -- Operating economy, ...
To download the data set, please sign up or log in

003 -- Operating economy, municipalities

003 -- Operating economy, municipalities

Tables

Column Descriptions

Dim region, Statfin kta pxt 003 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 21 rows, out of which 2 are empty, making the null percent 9.52. Minimum value is 1 and maximum value 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 activity category, Statfin kta pxt 003 px, Latest

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...

Dim expensesrevenues, Statfin kta pxt 003 px, Full history

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 region, Statfin kta pxt 003 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 21 rows, out of which 2 are empty, making the null percent 9.52. Minimum value is 1 and maximum value 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.

Fact, Statfin kta pxt 003 px, Full history

Column Type Comment
region string Datasource did not contain a description for Region. Column region has 142884 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 142884 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 142884 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 142884 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2015 and maximum value is 2017.
operating_economy_municipalities int Datasource did not contain a description for Operating_economy_municipalities. Column operating_economy_municipalities has 142884 rows, out of which 13608 are empty, making the null percent 9.52. Minimum value is -3012 and maximum value is 41450139.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfin kta pxt 003 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2015 and maximum value is 2017.
label int The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2015 and maximum value is 2017.

Dim activity category, Statfin kta pxt 003 px, Full history

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, Statfin kta pxt 003 px, Full history

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

Dim expensesrevenues, Statfin kta pxt 003 px, Latest

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.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019