009 -- General government establishments by industry and general government type in 2013 to 2017

Tables

Dim data, Statfinpas alyr pxt 009 201700 px, Full historyTSV
Dimension Data (Tiedot)
Dim data, Statfinpas alyr pxt 009 201700 px, LatestTSV
Dimension Data (Tiedot)
Dim general government type, Statfinpas alyr pxt 009 201700 px, Full historyTSV
Dimension General_government_type (Julkisyhteisötyyppi)
Dim general government type, Statfinpas alyr pxt 009 201700 px, LatestTSV
Dimension General_government_type (Julkisyhteisötyyppi)
Dim industry tol 2008, Statfinpas alyr pxt 009 201700 px, Full historyTSV
Dimension Industry_TOL_2008 (Toimiala (TOL 2008))
Dim industry tol 2008, Statfinpas alyr pxt 009 201700 px, LatestTSV
Dimension Industry_TOL_2008 (Toimiala (TOL 2008))
Dim year, Statfinpas alyr pxt 009 201700 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfinpas alyr pxt 009 201700 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfinpas alyr pxt 009 201700 px, Full historyTSV
General government establishments by industry and general government type in 2013 to 2017 by Industry (TOL 2008), General government type, Data and Year
Fact, Statfinpas alyr pxt 009 201700 px, LatestTSV
General government establishments by industry and general government type in 2013 to 2017 by Industry (TOL 2008), General government type, Data and Year

Column Descriptions

Dim data, Statfinpas alyr pxt 009 201700 px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Palkansaajat_toimipaikka and maximum string is Tplukumaara.
label	string	The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Number of establishments... and first 25 characters of maximum string: Wage and salary earners /...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim general government type, Statfinpas alyr pxt 009 201700 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 11 and maximum value is 99.
label	string	The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 11 State... and first 25 characters of maximum string: 99 Other public organizat...

Dim industry tol 2008, Statfinpas alyr pxt 009 201700 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 48 rows, out of which 20 are empty, making the null percent 41.67. Minimum value is 1 and maximum value is 93.
label	string	The label for the dimension value. Column label has 48 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: S OTHER SERVICE ACTIVITIE...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim general government type, Statfinpas alyr pxt 009 201700 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 11 and maximum value is 99.
label	string	The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 11 State... and first 25 characters of maximum string: 99 Other public organizat...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim data, Statfinpas alyr pxt 009 201700 px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Palkansaajat_toimipaikka and maximum string is Tplukumaara.
label	string	The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Number of establishments... and first 25 characters of maximum string: Wage and salary earners /...

Dim year, Statfinpas alyr pxt 009 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 009 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 industry tol 2008, Statfinpas alyr pxt 009 201700 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 48 rows, out of which 20 are empty, making the null percent 41.67. Minimum value is 1 and maximum value is 93.
label	string	The label for the dimension value. Column label has 48 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: S OTHER SERVICE ACTIVITIE...

Fact, Statfinpas alyr pxt 009 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 5040 rows, out of which 2100 are empty, making the null percent 41.67. Minimum value is 1 and maximum value is 93.
general_government_type	int	Datasource did not contain a description for General_government_type. Column general_government_type has 5040 rows, out of which 720 are empty, making the null percent 14.29. Minimum value is 11 and maximum value is 99.
data	string	Datasource did not contain a description for Data. Column data has 5040 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Palkansaajat_toimipaikka and maximum string is Tplukumaara.
year	int	Statistical reference year. . Column year has 5040 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.
general_government_establishments_by_industry_and_general_government_type_in_2013_to_2017	int	Datasource did not contain a description for General_government_establishments_by_industry_and_general_government_type_in_2013_to_2017. Column general_government_establishments_by_industry_and_general_government_type_in_2013_to_2017 has 5040 rows, out of which 2010 are empty, making the null percent 39.88. Minimum value is 1 and maximum value is 626900.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfinpas alyr pxt 009 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 5040 rows, out of which 2100 are empty, making the null percent 41.67. Minimum value is 1 and maximum value is 93.
general_government_type	int	Datasource did not contain a description for General_government_type. Column general_government_type has 5040 rows, out of which 720 are empty, making the null percent 14.29. Minimum value is 11 and maximum value is 99.
data	string	Datasource did not contain a description for Data. Column data has 5040 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Palkansaajat_toimipaikka and maximum string is Tplukumaara.
year	int	Statistical reference year. . Column year has 5040 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.
general_government_establishments_by_industry_and_general_government_type_in_2013_to_2017	int	Datasource did not contain a description for General_government_establishments_by_industry_and_general_government_type_in_2013_to_2017. Column general_government_establishments_by_industry_and_general_government_type_in_2013_to_2017 has 5040 rows, out of which 2010 are empty, making the null percent 39.88. Minimum value is 1 and maximum value is 626900.

Additional Info

Last Updated	July 21, 2019
Created	July 13, 2019