11 d 7 -- Enterprises by industry and size class in personnel (enterprise unit), 2017

Tables

Dim size category of personnel, Statfin yrti pxt 11d7 px, Full historyTSV
Dimension Size_category_of_personnel (Henkilöstön suuruusluokka)
Dim size category of personnel, Statfin yrti pxt 11d7 px, LatestTSV
Dimension Size_category_of_personnel (Henkilöstön suuruusluokka)
Dim tol 2008, Statfin yrti pxt 11d7 px, Full historyTSV
Dimension TOL_2008 (Toimiala (TOL 2008))
Dim tol 2008, Statfin yrti pxt 11d7 px, LatestTSV
Dimension TOL_2008 (Toimiala (TOL 2008))
Fact, Statfin yrti pxt 11d7 px, Full historyTSV
Enterprises by industry and size class in personnel (enterprise unit) by Size category of personnel, TOL 2008, Year and Information
Fact, Statfin yrti pxt 11d7 px, LatestTSV
Enterprises by industry and size class in personnel (enterprise unit) by Size category of personnel, TOL 2008, Year and Information

Column Descriptions

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

Column	Type	Comment
code	int	The code for the dimension value. Column code has 101 rows, out of which 20 are empty, making the null percent 19.80. Minimum value is 1 and maximum value is 96.
label	string	The label for the dimension value. Column label has 101 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Crop and animal produc... and first 25 characters of maximum string: Unknown...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim size category of personnel, Statfin yrti pxt 11d7 px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 10 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 1000-.
label	string	The label for the dimension value. Column label has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 to 4 persons and maximum string is 1 000 or more persons.
orig_extractdate	string	The date when the data was originally fetched from the source.

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

Column	Type	Comment
code	int	The code for the dimension value. Column code has 101 rows, out of which 20 are empty, making the null percent 19.80. Minimum value is 1 and maximum value is 96.
label	string	The label for the dimension value. Column label has 101 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Crop and animal produc... and first 25 characters of maximum string: Unknown...

Dim size category of personnel, Statfin yrti pxt 11d7 px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 10 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 1000-.
label	string	The label for the dimension value. Column label has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 to 4 persons and maximum string is 1 000 or more persons.

Fact, Statfin yrti pxt 11d7 px, Full history

Column	Type	Comment
size_category_of_personnel	string	Datasource did not contain a description for Size_category_of_personnel. Column size_category_of_personnel has 1010 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 1000-.
tol_2008	int	Datasource did not contain a description for TOL_2008. Column tol_2008 has 1010 rows, out of which 200 are empty, making the null percent 19.80. Minimum value is 1 and maximum value is 96.
year	int	Datasource did not contain a description for Year. Column year has 1010 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 1010 rows, out of which 120 are empty, making the null percent 11.88. 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 1010 rows, out of which 309 are empty, making the null percent 30.59. 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 1010 rows, out of which 120 are empty, making the null percent 11.88. Minimum value is 4 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 1010 rows, out of which 309 are empty, making the null percent 30.59. Minimum value is 21 and maximum value is 58107674.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin yrti pxt 11d7 px, Latest

Column	Type	Comment
size_category_of_personnel	string	Datasource did not contain a description for Size_category_of_personnel. Column size_category_of_personnel has 1010 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 1000-.
tol_2008	int	Datasource did not contain a description for TOL_2008. Column tol_2008 has 1010 rows, out of which 200 are empty, making the null percent 19.80. Minimum value is 1 and maximum value is 96.
year	int	Datasource did not contain a description for Year. Column year has 1010 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 1010 rows, out of which 120 are empty, making the null percent 11.88. 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 1010 rows, out of which 309 are empty, making the null percent 30.59. 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 1010 rows, out of which 120 are empty, making the null percent 11.88. Minimum value is 4 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 1010 rows, out of which 309 are empty, making the null percent 30.59. Minimum value is 21 and maximum value is 58107674.

Additional Info

Last Updated	September 20, 2019
Created	August 5, 2019