1. Home
  2. Datasets
  3. 005 -- Gross and added value ...
To download the data set, please sign up or log in

005 -- Gross and added value of establishments by industry and region 2013-2017

005 -- Gross and added value of establishments by industry and region 2013-2017

Tables

Column Descriptions

Fact, Statfinpas alyr pxt 005 201700 px, Latest

Column Type Comment
industry_tol_2008 int The Standard Industrial Classification 2008 (Statistics Finland, Handbooks 4, Helsinki 2008) is used as the industrial classification. The Standard Industrial Classification 2008 is based on the EU s standard industrial classification NACE Rev. 2 so that the 4-digit level of NACE was specified for national needs with a fifth digit. . Column industry_tol_2008 has 42000 rows, out of which 10500 are empty, making the null percent 25.00. Minimum value is 10 and maximum value is 82.
region int Region. . Column region has 42000 rows, out of which 4000 are empty, making the null percent 9.52. Minimum value is 1 and maximum value is 21.
data string Datasource did not contain a description for Data. Column data has 42000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Eumuktuotbruttoarvo and maximum string is Henkilotp.
year int Statistical reference year. . Column year has 42000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2013 and maximum value is 2017.
gross_and_added_value_of_establishments_by_industry_and_region_2016 int Datasource did not contain a description for Gross_and_added_value_of_establishments_by_industry_and_region_2016. Column gross_and_added_value_of_establishments_by_industry_and_region_2016 has 42000 rows, out of which 4601 are empty, making the null percent 10.95. Minimum value is -293282 and maximum value is 309322326.

Dim industry tol 2008, Statfinpas alyr pxt 005 201700 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 80 rows, out of which 20 are empty, making the null percent 25.00. Minimum value is 10 and maximum value is 82.
label string The label for the dimension value. Column label has 80 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 Manufacture of food pr... and first 25 characters of maximum string: X INDUSTRY UNKNOWN...

Fact, Statfinpas alyr pxt 005 201700 px, Full history

Column Type Comment
industry_tol_2008 int The Standard Industrial Classification 2008 (Statistics Finland, Handbooks 4, Helsinki 2008) is used as the industrial classification. The Standard Industrial Classification 2008 is based on the EU s standard industrial classification NACE Rev. 2 so that the 4-digit level of NACE was specified for national needs with a fifth digit. . Column industry_tol_2008 has 42000 rows, out of which 10500 are empty, making the null percent 25.00. Minimum value is 10 and maximum value is 82.
region int Region. . Column region has 42000 rows, out of which 4000 are empty, making the null percent 9.52. Minimum value is 1 and maximum value is 21.
data string Datasource did not contain a description for Data. Column data has 42000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Eumuktuotbruttoarvo and maximum string is Henkilotp.
year int Statistical reference year. . Column year has 42000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2013 and maximum value is 2017.
gross_and_added_value_of_establishments_by_industry_and_region_2016 int Datasource did not contain a description for Gross_and_added_value_of_establishments_by_industry_and_region_2016. Column gross_and_added_value_of_establishments_by_industry_and_region_2016 has 42000 rows, out of which 4601 are empty, making the null percent 10.95. Minimum value is -293282 and maximum value is 309322326.
orig_extractdate string The date when the data was originally fetched from the source.

Dim data, Statfinpas alyr pxt 005 201700 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Eumuktuotbruttoarvo and maximum string is Henkilotp.
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: Gross value of production... and first 25 characters of maximum string: Total number of personnel...

Dim data, Statfinpas alyr pxt 005 201700 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Eumuktuotbruttoarvo and maximum string is Henkilotp.
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: Gross value of production... and first 25 characters of maximum string: Total number of personnel...
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfinpas alyr pxt 005 201700 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2013 and maximum value is 2017.
label int 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. Minimum value is 2013 and maximum value is 2017.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfinpas alyr pxt 005 201700 px, Latest

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

Dim region, Statfinpas alyr pxt 005 201700 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 01 Uusimaa and maximum string is ZZ Unknown.

Dim region, Statfinpas alyr pxt 005 201700 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 01 Uusimaa and maximum string is ZZ Unknown.
orig_extractdate string The date when the data was originally fetched from the source.

Dim industry tol 2008, Statfinpas alyr pxt 005 201700 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 80 rows, out of which 20 are empty, making the null percent 25.00. Minimum value is 10 and maximum value is 82.
label string The label for the dimension value. Column label has 80 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 Manufacture of food pr... and first 25 characters of maximum string: X INDUSTRY UNKNOWN...
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