To download the data set, please sign up or log in

11 fs -- Gross value and value added of establishments of enterprises by industry and re, 2013-2017

11 fs -- Gross value and value added of establishments of enterprises by industry and re, 2013-2017

Tables

Column Descriptions

Fact, Statfin alyr pxt 11fs px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 8400 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.
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 8400 rows, out of which 2100 are empty, making the null percent 25.00. Minimum value is 10 and maximum value is 82.
region string Datasource did not contain a description for Region. Column region has 8400 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MK01 and maximum string is X.
establishments_of_enterprises_number int Establishments of enterprises (number) . Column establishments_of_enterprises_number has 8400 rows, out of which 366 are empty, making the null percent 4.36. Minimum value is 1 and maximum value is 397882.
personnel_in_establishments_of_enterprises_staffyears int Employees comprise wage and salary earners and self-employed persons. Paid employees are converted to annual full-time employees so that, for example, an employee working half-time represents one half of a person and two employees working half-time for one year represent one annual full-time employee. . Column personnel_in_establishments_of_enterprises_staffyears has 8400 rows, out of which 849 are empty, making the null percent 10.11. Minimum value is 0 and maximum value is 1471743.
gross_value_of_output_of_establishments_of_enterprises_eur_1000 int Datasource did not contain a description for Gross_value_of_output_of_establishments_of_enterprises_EUR_1000. Column gross_value_of_output_of_establishments_of_enterprises_eur_1000 has 8400 rows, out of which 1264 are empty, making the null percent 15.05. Minimum value is -94865 and maximum value is 309322326.
value_added_of_output_of_establishments_of_enterprises_eur_1000 int Datasource did not contain a description for Value_added_of_output_of_establishments_of_enterprises_EUR_1000. Column value_added_of_output_of_establishments_of_enterprises_eur_1000 has 8400 rows, out of which 1264 are empty, making the null percent 15.05. Minimum value is -293282 and maximum value is 110485283.
personnel_in_establishments_of_enterprises_staffyearsestablishment int Datasource did not contain a description for Personnel_in_establishments_of_enterprises_staffyearsestablishment. Column personnel_in_establishments_of_enterprises_staffyearsestablishment has 8400 rows, out of which 858 are empty, making the null percent 10.21. Minimum value is 0 and maximum value is 349.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin alyr pxt 11fs px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 8400 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.
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 8400 rows, out of which 2100 are empty, making the null percent 25.00. Minimum value is 10 and maximum value is 82.
region string Datasource did not contain a description for Region. Column region has 8400 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MK01 and maximum string is X.
establishments_of_enterprises_number int Establishments of enterprises (number) . Column establishments_of_enterprises_number has 8400 rows, out of which 366 are empty, making the null percent 4.36. Minimum value is 1 and maximum value is 397882.
personnel_in_establishments_of_enterprises_staffyears int Employees comprise wage and salary earners and self-employed persons. Paid employees are converted to annual full-time employees so that, for example, an employee working half-time represents one half of a person and two employees working half-time for one year represent one annual full-time employee. . Column personnel_in_establishments_of_enterprises_staffyears has 8400 rows, out of which 849 are empty, making the null percent 10.11. Minimum value is 0 and maximum value is 1471743.
gross_value_of_output_of_establishments_of_enterprises_eur_1000 int Datasource did not contain a description for Gross_value_of_output_of_establishments_of_enterprises_EUR_1000. Column gross_value_of_output_of_establishments_of_enterprises_eur_1000 has 8400 rows, out of which 1264 are empty, making the null percent 15.05. Minimum value is -94865 and maximum value is 309322326.
value_added_of_output_of_establishments_of_enterprises_eur_1000 int Datasource did not contain a description for Value_added_of_output_of_establishments_of_enterprises_EUR_1000. Column value_added_of_output_of_establishments_of_enterprises_eur_1000 has 8400 rows, out of which 1264 are empty, making the null percent 15.05. Minimum value is -293282 and maximum value is 110485283.
personnel_in_establishments_of_enterprises_staffyearsestablishment int Datasource did not contain a description for Personnel_in_establishments_of_enterprises_staffyearsestablishment. Column personnel_in_establishments_of_enterprises_staffyearsestablishment has 8400 rows, out of which 858 are empty, making the null percent 10.21. Minimum value is 0 and maximum value is 349.

Dim region, Statfin alyr pxt 11fs px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MK01 and maximum string is X.
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 MK01 Uusimaa and maximum string is Unknown.

Dim region, Statfin alyr pxt 11fs px, Full history

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

Dim year, Statfin alyr pxt 11fs 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 industry tol 2008, Statfin alyr pxt 11fs 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: Unknown...
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfin alyr pxt 11fs 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 industry tol 2008, Statfin alyr pxt 11fs 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: Unknown...

Additional Info

Last Updated September 22, 2019
Created August 6, 2019