119 h -- Use of environmental protection services for companies, 2014-2016

Tables

Dim standard industrial classification tol 2008, Statfin ympsm pxt 119h px, Full historyTSV
Dimension Standard_Industrial_Classification_TOL_2008 (Toimiala (TOL2008))
Dim standard industrial classification tol 2008, Statfin ympsm pxt 119h px, LatestTSV
Dimension Standard_Industrial_Classification_TOL_2008 (Toimiala (TOL2008))
Dim the classification of environmental protection activities, Statfin ympsm pxt 119h px, Full historyTSV
Dimension The_classification_of_environmental_protection_activities (Ympäristönsuojelumenoluokka)
Dim the classification of environmental protection activities, Statfin ympsm pxt 119h px, LatestTSV
Dimension The_classification_of_environmental_protection_activities (Ympäristönsuojelumenoluokka)
Dim transaction, Statfin ympsm pxt 119h px, Full historyTSV
Dimension Transaction (Taloustoimi)
Dim transaction, Statfin ympsm pxt 119h px, LatestTSV
Dimension Transaction (Taloustoimi)
Dim year, Statfin ympsm pxt 119h px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin ympsm pxt 119h px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin ympsm pxt 119h px, Full historyTSV
Use of environmental protection services for companies by Standard Industrial Classification TOL 2008, Transaction, Year, The classification of environmental protection activities and Information
Fact, Statfin ympsm pxt 119h px, LatestTSV
Use of environmental protection services for companies by Standard Industrial Classification TOL 2008, Transaction, Year, The classification of environmental protection activities and Information

Column Descriptions

Fact, Statfin ympsm pxt 119h px, Latest

Column	Type	Comment
standard_industrial_classification_tol_2008	int	The industrial classification divides units into industry classes based on their main economic activity. The main economic activity is the one that produces a majority of the unit's value added.The classification used is the Finnish national classification (TOL) derived from the statistical classification of economic activities in the European Community (NACE). . Column standard_industrial_classification_tol_2008 has 780 rows, out of which 180 are empty, making the null percent 23.08. Minimum value is 7 and maximum value is 35.
transaction	string	Datasource did not contain a description for Transaction. Column transaction has 780 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_K.
year	int	Statistical year is the calendar year a set of statistics concerns. . Column year has 780 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 2016.
the_classification_of_environmental_protection_activities	int	Environmental protection expenditures accounts, CEPA-classification . Column the_classification_of_environmental_protection_activities has 780 rows, out of which 312 are empty, making the null percent 40.00. Minimum value is 1 and maximum value is 3.
environmental_protection_expenditure_milj_euros	int	Datasource did not contain a description for Environmental_protection_expenditure_milj_euros. Column environmental_protection_expenditure_milj_euros has 780 rows, out of which 242 are empty, making the null percent 31.03. Minimum value is 0 and maximum value is 253.

Dim transaction, Statfin ympsm pxt 119h px, Full history

Column	Type	Comment
code	string	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 string is YMPSM_INV and maximum string is YMPSM_K.
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. Minimum string is Consumption and maximum string is Investments.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim the classification of environmental protection activities, Statfin ympsm pxt 119h px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 5 rows, out of which 2 are empty, making the null percent 40.00. Minimum value is 1 and maximum value is 3.
label	string	The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Protection of ambient ... and first 25 characters of maximum string: 04-09 Other environmental...

Fact, Statfin ympsm pxt 119h px, Full history

Column	Type	Comment
standard_industrial_classification_tol_2008	int	The industrial classification divides units into industry classes based on their main economic activity. The main economic activity is the one that produces a majority of the unit's value added.The classification used is the Finnish national classification (TOL) derived from the statistical classification of economic activities in the European Community (NACE). . Column standard_industrial_classification_tol_2008 has 780 rows, out of which 180 are empty, making the null percent 23.08. Minimum value is 7 and maximum value is 35.
transaction	string	Datasource did not contain a description for Transaction. Column transaction has 780 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_K.
year	int	Statistical year is the calendar year a set of statistics concerns. . Column year has 780 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 2016.
the_classification_of_environmental_protection_activities	int	Environmental protection expenditures accounts, CEPA-classification . Column the_classification_of_environmental_protection_activities has 780 rows, out of which 312 are empty, making the null percent 40.00. Minimum value is 1 and maximum value is 3.
environmental_protection_expenditure_milj_euros	int	Datasource did not contain a description for Environmental_protection_expenditure_milj_euros. Column environmental_protection_expenditure_milj_euros has 780 rows, out of which 242 are empty, making the null percent 31.03. Minimum value is 0 and maximum value is 253.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim the classification of environmental protection activities, Statfin ympsm pxt 119h px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 5 rows, out of which 2 are empty, making the null percent 40.00. Minimum value is 1 and maximum value is 3.
label	string	The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Protection of ambient ... and first 25 characters of maximum string: 04-09 Other environmental...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, Statfin ympsm pxt 119h 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 2014 and maximum value is 2016.
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 2014 and maximum value is 2016.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, Statfin ympsm pxt 119h 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 2014 and maximum value is 2016.
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 2014 and maximum value is 2016.

Dim standard industrial classification tol 2008, Statfin ympsm pxt 119h px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 26 rows, out of which 6 are empty, making the null percent 23.08. Minimum value is 7 and maximum value is 35.
label	string	The label for the dimension value. Column label has 26 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 07 Mining of metal ores... and first 25 characters of maximum string: 35 Electricity, gas, stea...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim standard industrial classification tol 2008, Statfin ympsm pxt 119h px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 26 rows, out of which 6 are empty, making the null percent 23.08. Minimum value is 7 and maximum value is 35.
label	string	The label for the dimension value. Column label has 26 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 07 Mining of metal ores... and first 25 characters of maximum string: 35 Electricity, gas, stea...

Dim transaction, Statfin ympsm pxt 119h px, Latest

Column	Type	Comment
code	string	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 string is YMPSM_INV and maximum string is YMPSM_K.
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. Minimum string is Consumption and maximum string is Investments.

Additional Info

Last Updated	September 22, 2019
Created	August 6, 2019