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

006 -- Operating economy, joint municipal authorities

006 -- Operating economy, joint municipal authorities

Tables

Column Descriptions

Dim expensesrevenues, Statfin kta pxt 006 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.

Dim region, Statfin kta pxt 006 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 2 and maximum value is 3.
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: Joint municipalities of M... and first 25 characters of maximum string: Joint municipalities tota...
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfin kta pxt 006 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.

Fact, Statfin kta pxt 006 px, Latest

Column Type Comment
region int Datasource did not contain a description for Region. Column region has 13608 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 3.
expensesrevenues string Datasource did not contain a description for Expensesrevenues. Column expensesrevenues has 13608 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 13608 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 13608 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_joint_municipal_authorities int Datasource did not contain a description for Operating_economy_joint_municipal_authorities. Column operating_economy_joint_municipal_authorities has 13608 rows, out of which 1296 are empty, making the null percent 9.52. Minimum value is -1852 and maximum value is 15816625.

Dim region, Statfin kta pxt 006 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 2 and maximum value is 3.
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: Joint municipalities of M... and first 25 characters of maximum string: Joint municipalities tota...

Dim year, Statfin kta pxt 006 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 006 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 activity category, Statfin kta pxt 006 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 activity category, Statfin kta pxt 006 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...

Fact, Statfin kta pxt 006 px, Full history

Column Type Comment
region int Datasource did not contain a description for Region. Column region has 13608 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 3.
expensesrevenues string Datasource did not contain a description for Expensesrevenues. Column expensesrevenues has 13608 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 13608 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 13608 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_joint_municipal_authorities int Datasource did not contain a description for Operating_economy_joint_municipal_authorities. Column operating_economy_joint_municipal_authorities has 13608 rows, out of which 1296 are empty, making the null percent 9.52. Minimum value is -1852 and maximum value is 15816625.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019