1. Home
  2. Datasets
  3. 004 -- Establishments by ...
To download the data set, please sign up or log in

004 -- Establishments by industry and size category of personnel 2013-2017

004 -- Establishments by industry and size category of personnel 2013-2017

Tables

Column Descriptions

Fact, Statfinpas alyr pxt 004 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 16480 rows, out of which 3200 are empty, making the null percent 19.42. Minimum value is 0 and maximum value is 96.
size_category_of_personnel int Datasource did not contain a description for Size_category_of_personnel. Column size_category_of_personnel has 16480 rows, out of which 2060 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 16480 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Henkmaara and maximum string is Lv_hlo.
year int Statistical reference year. . Column year has 16480 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.
establishments_by_industry_and_size_category_of_personnel_2015 int Datasource did not contain a description for Establishments_by_industry_and_size_category_of_personnel_2015. Column establishments_by_industry_and_size_category_of_personnel_2015 has 16480 rows, out of which 2778 are empty, making the null percent 16.86. Minimum value is 0 and maximum value is 411193869.

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

Column Type Comment
code int The code for the dimension value. Column code has 103 rows, out of which 20 are empty, making the null percent 19.42. Minimum value is 0 and maximum value is 96.
label string The label for the dimension value. Column label has 103 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 00 Industry unknown and maximum string is X INDUSTRY UNKNOWN.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas alyr pxt 004 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 16480 rows, out of which 3200 are empty, making the null percent 19.42. Minimum value is 0 and maximum value is 96.
size_category_of_personnel int Datasource did not contain a description for Size_category_of_personnel. Column size_category_of_personnel has 16480 rows, out of which 2060 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 16480 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Henkmaara and maximum string is Lv_hlo.
year int Statistical reference year. . Column year has 16480 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.
establishments_by_industry_and_size_category_of_personnel_2015 int Datasource did not contain a description for Establishments_by_industry_and_size_category_of_personnel_2015. Column establishments_by_industry_and_size_category_of_personnel_2015 has 16480 rows, out of which 2778 are empty, making the null percent 16.86. Minimum value is 0 and maximum value is 411193869.
orig_extractdate string The date when the data was originally fetched from the source.

Dim data, Statfinpas alyr pxt 004 201700 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 Henkmaara and maximum string is Lv_hlo.
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. Minimum string is Number of establishments and maximum string is Turnover/person EUR 1,000.
orig_extractdate string The date when the data was originally fetched from the source.

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

Column Type Comment
code int The code for the dimension value. Column code has 103 rows, out of which 20 are empty, making the null percent 19.42. Minimum value is 0 and maximum value is 96.
label string The label for the dimension value. Column label has 103 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 00 Industry unknown and maximum string is X INDUSTRY UNKNOWN.

Dim year, Statfinpas alyr pxt 004 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 data, Statfinpas alyr pxt 004 201700 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 Henkmaara and maximum string is Lv_hlo.
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. Minimum string is Number of establishments and maximum string is Turnover/person EUR 1,000.

Additional Info

Last Updated September 20, 2019
Created August 5, 2019