007 -- Establishments by industry and size category of turnover 2013-2017

Tables

Dim data, Statfinpas alyr pxt 007 201700 px, Full historyTSV
Dimension Data (Tiedot)
Dim data, Statfinpas alyr pxt 007 201700 px, LatestTSV
Dimension Data (Tiedot)
Dim industry tol 2008, Statfinpas alyr pxt 007 201700 px, Full historyTSV
Dimension Industry_TOL_2008 (Toimiala (TOL 2008))
Dim industry tol 2008, Statfinpas alyr pxt 007 201700 px, LatestTSV
Dimension Industry_TOL_2008 (Toimiala (TOL 2008))
Dim size category of turnover, Statfinpas alyr pxt 007 201700 px, Full historyTSV
Dimension Size_category_of_turnover (Liikevaihdon suuruusluokka)
Dim size category of turnover, Statfinpas alyr pxt 007 201700 px, LatestTSV
Dimension Size_category_of_turnover (Liikevaihdon suuruusluokka)
Dim year, Statfinpas alyr pxt 007 201700 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfinpas alyr pxt 007 201700 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfinpas alyr pxt 007 201700 px, Full historyTSV
Establishments by industry and size category of turnover 2015 by Industry (TOL 2008), Size category of turnover, Data and Year
Fact, Statfinpas alyr pxt 007 201700 px, LatestTSV
Establishments by industry and size category of turnover 2015 by Industry (TOL 2008), Size category of turnover, Data and Year

Column Descriptions

Fact, Statfinpas alyr pxt 007 201700 px, Full history

Column	Type	Comment
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 3200 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.
size_category_of_turnover	int	Datasource did not contain a description for Size_category_of_turnover. Column size_category_of_turnover has 3200 rows, out of which 400 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 3200 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 3200 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_turnover_2015	int	Datasource did not contain a description for Establishments_by_industry_and_size_category_of_turnover_2015. Column establishments_by_industry_and_size_category_of_turnover_2015 has 3200 rows, out of which 209 are empty, making the null percent 6.53. Minimum value is 0 and maximum value is 411193869.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, Statfinpas alyr pxt 007 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 year, Statfinpas alyr pxt 007 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.

Fact, Statfinpas alyr pxt 007 201700 px, Latest

Column	Type	Comment
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 3200 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.
size_category_of_turnover	int	Datasource did not contain a description for Size_category_of_turnover. Column size_category_of_turnover has 3200 rows, out of which 400 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 3200 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 3200 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_turnover_2015	int	Datasource did not contain a description for Establishments_by_industry_and_size_category_of_turnover_2015. Column establishments_by_industry_and_size_category_of_turnover_2015 has 3200 rows, out of which 209 are empty, making the null percent 6.53. Minimum value is 0 and maximum value is 411193869.

Dim industry tol 2008, Statfinpas alyr pxt 007 201700 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: X INDUSTRY UNKNOWN...
orig_extractdate	string	The date when the data was originally fetched from the source.

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

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: X INDUSTRY UNKNOWN...

Dim size category of turnover, Statfinpas alyr pxt 007 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 0 - 39 and maximum string is 10 000 -.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim size category of turnover, Statfinpas alyr pxt 007 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 0 - 39 and maximum string is 10 000 -.

Dim data, Statfinpas alyr pxt 007 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 data, Statfinpas alyr pxt 007 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	July 21, 2019
Created	July 13, 2019