001 -- Environmental goods and services 2012-2017

Tables

Dim data, Statfin ylt pxt 001 px, Full historyTSV
Dimension Data (Tiedot)
Dim data, Statfin ylt pxt 001 px, LatestTSV
Dimension Data (Tiedot)
Dim environmental goods and services class, Statfin ylt pxt 001 px, Full historyTSV
Dimension Environmental_goods_and_services_class (Ympäristöliiketoimintaluokka)
Dim environmental goods and services class, Statfin ylt pxt 001 px, LatestTSV
Dimension Environmental_goods_and_services_class (Ympäristöliiketoimintaluokka)
Dim industry tol2008, Statfin ylt pxt 001 px, Full historyTSV
Dimension Industry_TOL2008 (Toimiala (TOL2008))
Dim industry tol2008, Statfin ylt pxt 001 px, LatestTSV
Dimension Industry_TOL2008 (Toimiala (TOL2008))
Dim year, Statfin ylt pxt 001 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin ylt pxt 001 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin ylt pxt 001 px, Full historyTSV
Environmental goods and services by Year, Industry (TOL2008), Environmental goods and services class and Data
Fact, Statfin ylt pxt 001 px, LatestTSV
Environmental goods and services by Year, Industry (TOL2008), Environmental goods and services class and Data

Column Descriptions

Dim environmental goods and services class, Statfin ylt pxt 001 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 24 rows, out of which 1 are empty, making the null percent 4.17. Minimum value is 1 and maximum value is 243.
label	string	The label for the dimension value. Column label has 24 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 10-16 Management of natur... and first 25 characters of maximum string: 16 Other resource managem...

Dim year, Statfin ylt pxt 001 px, Latest

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

Dim data, Statfin ylt pxt 001 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 YLT_ARVONLISAYS and maximum string is YLT_HTV.
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: Employment of environment... and first 25 characters of maximum string: Value added of environmen...

Dim data, Statfin ylt pxt 001 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 YLT_ARVONLISAYS and maximum string is YLT_HTV.
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: Employment of environment... and first 25 characters of maximum string: Value added of environmen...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim environmental goods and services class, Statfin ylt pxt 001 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 24 rows, out of which 1 are empty, making the null percent 4.17. Minimum value is 1 and maximum value is 243.
label	string	The label for the dimension value. Column label has 24 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 10-16 Management of natur... and first 25 characters of maximum string: 16 Other resource managem...
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin ylt pxt 001 px, Latest

Column	Type	Comment
year	int	Statistical year . Column year has 63360 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2012 and maximum value is 2017.
industry_tol2008	int	Industry (TOL2008-classification) . Column industry_tol2008 has 63360 rows, out of which 12672 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 99.
environmental_goods_and_services_class	int	Environmental goods and services class (Classification of Environmental Goods and Services, 2014) . Column environmental_goods_and_services_class has 63360 rows, out of which 2640 are empty, making the null percent 4.17. Minimum value is 1 and maximum value is 243.
data	string	Values of the Data-variable. . Column data has 63360 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is YLT_ARVONLISAYS and maximum string is YLT_HTV.
environmental_goods_and_services	int	Datasource did not contain a description for Environmental_goods_and_services. Column environmental_goods_and_services has 63360 rows, out of which 56739 are empty, making the null percent 89.55. Minimum value is 0 and maximum value is 136393.

Fact, Statfin ylt pxt 001 px, Full history

Column	Type	Comment
year	int	Statistical year . Column year has 63360 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2012 and maximum value is 2017.
industry_tol2008	int	Industry (TOL2008-classification) . Column industry_tol2008 has 63360 rows, out of which 12672 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 99.
environmental_goods_and_services_class	int	Environmental goods and services class (Classification of Environmental Goods and Services, 2014) . Column environmental_goods_and_services_class has 63360 rows, out of which 2640 are empty, making the null percent 4.17. Minimum value is 1 and maximum value is 243.
data	string	Values of the Data-variable. . Column data has 63360 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is YLT_ARVONLISAYS and maximum string is YLT_HTV.
environmental_goods_and_services	int	Datasource did not contain a description for Environmental_goods_and_services. Column environmental_goods_and_services has 63360 rows, out of which 56739 are empty, making the null percent 89.55. Minimum value is 0 and maximum value is 136393.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim industry tol2008, Statfin ylt pxt 001 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 110 rows, out of which 22 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 99.
label	string	The label for the dimension value. Column label has 110 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 Crop and animal produc... and first 25 characters of maximum string: 99 Activities of extrater...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim industry tol2008, Statfin ylt pxt 001 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 110 rows, out of which 22 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 99.
label	string	The label for the dimension value. Column label has 110 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 Crop and animal produc... and first 25 characters of maximum string: 99 Activities of extrater...

Dim year, Statfin ylt pxt 001 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2012 and maximum value is 2017.
label	int	The label for the dimension value. Column label has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2012 and maximum value is 2017.
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