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

006 -- Gross and added value of establishments by industry, region and size category 2013-2017

006 -- Gross and added value of establishments by industry, region and size category 2013-2017

Tables

Column Descriptions

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

Column Type Comment
code string The code for the dimension value. Column code has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is X.
label string The label for the dimension value. Column label has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: A AGRICULTURE, FORESTRY A... and first 25 characters of maximum string: X INDUSTRY UNKNOWN...
orig_extractdate string The date when the data was originally fetched from the source.

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

Column Type Comment
code string The code for the dimension value. Column code has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is X.
label string The label for the dimension value. Column label has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: A AGRICULTURE, FORESTRY A... and first 25 characters of maximum string: X INDUSTRY UNKNOWN...

Dim size category of personnel, Statfinpas alyr pxt 006 201700 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 8 rows, out of which 1 are empty, making the null percent 12.50. Minimum value is 1 and maximum value is 7.
label string The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ...4 and maximum string is 200...

Dim year, Statfinpas alyr pxt 006 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 year, Statfinpas alyr pxt 006 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 size category of personnel, Statfinpas alyr pxt 006 201700 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 8 rows, out of which 1 are empty, making the null percent 12.50. Minimum value is 1 and maximum value is 7.
label string The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ...4 and maximum string is 200...
orig_extractdate string The date when the data was originally fetched from the source.

Dim data, Statfinpas alyr pxt 006 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 data, Statfinpas alyr pxt 006 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...

Fact, Statfinpas alyr pxt 006 201700 px, Full history

Column Type Comment
industry_tol_2008 string 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 84000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is X.
region int Region. . Column region has 84000 rows, out of which 8000 are empty, making the null percent 9.52. Minimum value is 1 and maximum value is 21.
size_category_of_personnel int Datasource did not contain a description for Size_category_of_personnel. Column size_category_of_personnel has 84000 rows, out of which 10500 are empty, making the null percent 12.50. Minimum value is 1 and maximum value is 7.
data string Datasource did not contain a description for Data. Column data has 84000 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 84000 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_region_and_size_category_2016 int Datasource did not contain a description for Gross_and_added_value_of_establishments_by_industry_region_and_size_category_2016. Column gross_and_added_value_of_establishments_by_industry_region_and_size_category_2016 has 84000 rows, out of which 33858 are empty, making the null percent 40.31. Minimum value is -277301 and maximum value is 309322326.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas alyr pxt 006 201700 px, Latest

Column Type Comment
industry_tol_2008 string 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 84000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is X.
region int Region. . Column region has 84000 rows, out of which 8000 are empty, making the null percent 9.52. Minimum value is 1 and maximum value is 21.
size_category_of_personnel int Datasource did not contain a description for Size_category_of_personnel. Column size_category_of_personnel has 84000 rows, out of which 10500 are empty, making the null percent 12.50. Minimum value is 1 and maximum value is 7.
data string Datasource did not contain a description for Data. Column data has 84000 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 84000 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_region_and_size_category_2016 int Datasource did not contain a description for Gross_and_added_value_of_establishments_by_industry_region_and_size_category_2016. Column gross_and_added_value_of_establishments_by_industry_region_and_size_category_2016 has 84000 rows, out of which 33858 are empty, making the null percent 40.31. Minimum value is -277301 and maximum value is 309322326.

Dim region, Statfinpas alyr pxt 006 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 region, Statfinpas alyr pxt 006 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.

Additional Info

Last Updated July 21, 2019
Created July 13, 2019