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

11 ft -- Gross value and value added of establishments of enterprises by industry, region and size category, 2013-2017

11 ft -- Gross value and value added of establishments of enterprises by industry, region and size category, 2013-2017

Tables

Column Descriptions

Fact, Statfin alyr pxt 11ft px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 16800 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 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 16800 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 string Region. . Column region has 16800 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.
henkiloston_suuruusluokka string Datasource did not contain a description for Henkiloston_suuruusluokka. Column henkiloston_suuruusluokka has 16800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-4 and maximum string is 200-.
establishments_of_enterprises_number int Establishments of enterprises (number) . Column establishments_of_enterprises_number has 16800 rows, out of which 4082 are empty, making the null percent 24.30. 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 16800 rows, out of which 7208 are empty, making the null percent 42.90. 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 16800 rows, out of which 7680 are empty, making the null percent 45.71. Minimum value is -88276 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 16800 rows, out of which 7680 are empty, making the null percent 45.71. Minimum value is -277301 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 16800 rows, out of which 7208 are empty, making the null percent 42.90. Minimum value is 0 and maximum value is 771.

Fact, Statfin alyr pxt 11ft px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 16800 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 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 16800 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 string Region. . Column region has 16800 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.
henkiloston_suuruusluokka string Datasource did not contain a description for Henkiloston_suuruusluokka. Column henkiloston_suuruusluokka has 16800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-4 and maximum string is 200-.
establishments_of_enterprises_number int Establishments of enterprises (number) . Column establishments_of_enterprises_number has 16800 rows, out of which 4082 are empty, making the null percent 24.30. 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 16800 rows, out of which 7208 are empty, making the null percent 42.90. 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 16800 rows, out of which 7680 are empty, making the null percent 45.71. Minimum value is -88276 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 16800 rows, out of which 7680 are empty, making the null percent 45.71. Minimum value is -277301 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 16800 rows, out of which 7208 are empty, making the null percent 42.90. Minimum value is 0 and maximum value is 771.
orig_extractdate string The date when the data was originally fetched from the source.

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

Additional Info

Last Updated July 21, 2019
Created July 18, 2019