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

11 d 5 -- Enterprises by industry (enterprise unit), 2017

11 d 5 -- Enterprises by industry (enterprise unit), 2017

Tables

Column Descriptions

Fact, Statfin yrti pxt 11d5 px, Full history

Column Type Comment
tol_2008 int Datasource did not contain a description for TOL_2008. Column tol_2008 has 1685 rows, out of which 20 are empty, making the null percent 1.19. Minimum value is 1 and maximum value is 96090.
year int Datasource did not contain a description for Year. Column year has 1685 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2017.
number_of_enterprises_enterprises int Datasource did not contain a description for Number_of_enterprises_enterprises. Column number_of_enterprises_enterprises has 1685 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 364209.
turnover_enterprises_1000_euro int Liikevaihto koostuu yrityksen varsinaiseen toimintaan kuuluvien tuotteiden ja palvelujen myyntituotoista, joista on vähennetty annetut alennukset, arvonlisävero ja muut välittömästi myynnin määrään perustuvat verot. . Column turnover_enterprises_1000_euro has 1685 rows, out of which 137 are empty, making the null percent 8.13. Minimum value is 0 and maximum value is 397171174.
number_of_personnel_staff_year_enterprises int Datasource did not contain a description for Number_of_personnel_staff_year_enterprises. Column number_of_personnel_staff_year_enterprises has 1685 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 1452933.
sum_of_salaries_enterprises_1000_euro int Datasource did not contain a description for Sum_of_salaries_enterprises_1000_euro. Column sum_of_salaries_enterprises_1000_euro has 1685 rows, out of which 137 are empty, making the null percent 8.13. Minimum value is 0 and maximum value is 58107674.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tol 2008, Statfin yrti pxt 11d5 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 1685 rows, out of which 20 are empty, making the null percent 1.19. Minimum value is 1 and maximum value is 96090.
label string The label for the dimension value. Column label has 1685 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01110 Growing of cereals ... and first 25 characters of maximum string: Unknown...

Dim tol 2008, Statfin yrti pxt 11d5 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 1685 rows, out of which 20 are empty, making the null percent 1.19. Minimum value is 1 and maximum value is 96090.
label string The label for the dimension value. Column label has 1685 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01110 Growing of cereals ... and first 25 characters of maximum string: Unknown...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin yrti pxt 11d5 px, Latest

Column Type Comment
tol_2008 int Datasource did not contain a description for TOL_2008. Column tol_2008 has 1685 rows, out of which 20 are empty, making the null percent 1.19. Minimum value is 1 and maximum value is 96090.
year int Datasource did not contain a description for Year. Column year has 1685 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2017.
number_of_enterprises_enterprises int Datasource did not contain a description for Number_of_enterprises_enterprises. Column number_of_enterprises_enterprises has 1685 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 364209.
turnover_enterprises_1000_euro int Liikevaihto koostuu yrityksen varsinaiseen toimintaan kuuluvien tuotteiden ja palvelujen myyntituotoista, joista on vähennetty annetut alennukset, arvonlisävero ja muut välittömästi myynnin määrään perustuvat verot. . Column turnover_enterprises_1000_euro has 1685 rows, out of which 137 are empty, making the null percent 8.13. Minimum value is 0 and maximum value is 397171174.
number_of_personnel_staff_year_enterprises int Datasource did not contain a description for Number_of_personnel_staff_year_enterprises. Column number_of_personnel_staff_year_enterprises has 1685 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 1452933.
sum_of_salaries_enterprises_1000_euro int Datasource did not contain a description for Sum_of_salaries_enterprises_1000_euro. Column sum_of_salaries_enterprises_1000_euro has 1685 rows, out of which 137 are empty, making the null percent 8.13. Minimum value is 0 and maximum value is 58107674.

Additional Info

Last Updated September 20, 2019
Created August 5, 2019