001 -- Environmental protection expenditure accounts 2014 - 2015

Tables

Dim the classification of environmental protection activities, Statfinpas ympsm pxt 001 201500 px, Full historyTSV
Dimension The_classification_of_environmental_protection_activities (Ympäristönsuojelumenoluokka)
Dim the classification of sectors, Statfinpas ympsm pxt 001 201500 px, Full historyTSV
Dimension The_Classification_of_Sectors (Sektori)
Dim the classification of sectors, Statfinpas ympsm pxt 001 201500 px, LatestTSV
Dimension The_Classification_of_Sectors (Sektori)
Dim transaction classification of environmental protection expenditures accounts, Statfinpas ympsm pxt 001 201500 px, Full historyTSV
Dimension Transaction_classification_of_environmental_protection_expenditures_accounts (Ympäristönsuojelumenojen taloustoimi-luokka)
Dim transaction classification of environmental protection expenditures accounts, Statfinpas ympsm pxt 001 201500 px, LatestTSV
Dimension Transaction_classification_of_environmental_protection_expenditures_accounts (Ympäristönsuojelumenojen taloustoimi-luokka)
Dim year, Statfinpas ympsm pxt 001 201500 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfinpas ympsm pxt 001 201500 px, Full historyTSV
Environmental protection expenditure accounts by The classification of environmental protection activities, The Classification of Sectors, Transaction classification of environmental protection expenditures accounts and Year
Fact, Statfinpas ympsm pxt 001 201500 px, LatestTSV
Environmental protection expenditure accounts by The classification of environmental protection activities, The Classification of Sectors, Transaction classification of environmental protection expenditures accounts and Year

Column Descriptions

Dim transaction classification of environmental protection expenditures accounts, Statfinpas ympsm pxt 001 201500 px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is YMPSM_INV and maximum string is YMPSM_PAY.
label	string	The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Final consumption expendi... and first 25 characters of maximum string: Transfers paid...

Dim transaction classification of environmental protection expenditures accounts, Statfinpas ympsm pxt 001 201500 px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is YMPSM_INV and maximum string is YMPSM_PAY.
label	string	The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Final consumption expendi... and first 25 characters of maximum string: Transfers paid...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, Statfinpas ympsm pxt 001 201500 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 2014 and maximum value is 2015.
label	int	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. Minimum value is 2014 and maximum value is 2015.

Dim the classification of sectors, Statfinpas ympsm pxt 001 201500 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 7 rows, out of which 3 are empty, making the null percent 42.86. Minimum value is 1 and maximum value is 5.
label	string	The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 36-39 Corporations as spe... and first 25 characters of maximum string: Rest of the world...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim the classification of sectors, Statfinpas ympsm pxt 001 201500 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 7 rows, out of which 3 are empty, making the null percent 42.86. Minimum value is 1 and maximum value is 5.
label	string	The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 36-39 Corporations as spe... and first 25 characters of maximum string: Rest of the world...

Fact, Statfinpas ympsm pxt 001 201500 px, Latest

Column	Type	Comment
the_classification_of_environmental_protection_activities	int	Environmental protection expenditures accounts, CEPA-classification . Column the_classification_of_environmental_protection_activities has 224 rows, out of which 112 are empty, making the null percent 50.00. Minimum value is 2 and maximum value is 3.
the_classification_of_sectors	int	The Classification of Sectors is a basic classification applied to economic and social statistics for classifying decision-making units into equivalent categories according to activity, financing mode, owner type and legal form. The main sectors are non-financial corporations, financial corporations, general government, households and non-profit institutions serving households, and the rest of the world. . Column the_classification_of_sectors has 224 rows, out of which 96 are empty, making the null percent 42.86. Minimum value is 1 and maximum value is 5.
transaction_classification_of_environmental_protection_expenditures_accounts	string	Transaction classification of environmental protection expenditures accounts . Column transaction_classification_of_environmental_protection_expenditures_accounts has 224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is YMPSM_INV and maximum string is YMPSM_PAY.
year	int	Statistical year is the calendar year a set of statistics concerns. . Column year has 224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2014 and maximum value is 2015.
environmental_protection_expenditure_accounts	int	Datasource did not contain a description for Environmental_protection_expenditure_accounts. Column environmental_protection_expenditure_accounts has 224 rows, out of which 126 are empty, making the null percent 56.25. Minimum value is -37 and maximum value is 1349.

Fact, Statfinpas ympsm pxt 001 201500 px, Full history

Column	Type	Comment
the_classification_of_environmental_protection_activities	int	Environmental protection expenditures accounts, CEPA-classification . Column the_classification_of_environmental_protection_activities has 224 rows, out of which 112 are empty, making the null percent 50.00. Minimum value is 2 and maximum value is 3.
the_classification_of_sectors	int	The Classification of Sectors is a basic classification applied to economic and social statistics for classifying decision-making units into equivalent categories according to activity, financing mode, owner type and legal form. The main sectors are non-financial corporations, financial corporations, general government, households and non-profit institutions serving households, and the rest of the world. . Column the_classification_of_sectors has 224 rows, out of which 96 are empty, making the null percent 42.86. Minimum value is 1 and maximum value is 5.
transaction_classification_of_environmental_protection_expenditures_accounts	string	Transaction classification of environmental protection expenditures accounts . Column transaction_classification_of_environmental_protection_expenditures_accounts has 224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is YMPSM_INV and maximum string is YMPSM_PAY.
year	int	Statistical year is the calendar year a set of statistics concerns. . Column year has 224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2014 and maximum value is 2015.
environmental_protection_expenditure_accounts	int	Datasource did not contain a description for Environmental_protection_expenditure_accounts. Column environmental_protection_expenditure_accounts has 224 rows, out of which 126 are empty, making the null percent 56.25. Minimum value is -37 and maximum value is 1349.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim the classification of environmental protection activities, Statfinpas ympsm pxt 001 201500 px, Full history

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

Additional Info

Last Updated	July 14, 2019
Created	July 13, 2019