006 -- Output and employment by major region 2000-2016*, 30 industries

Tables

Dim area, Statfin altp pxt 006 px, Full historyTSV
Dimension Area (Alue)
Dim area, Statfin altp pxt 006 px, LatestTSV
Dimension Area (Alue)
Dim industry, Statfin altp pxt 006 px, Full historyTSV
Dimension Industry (Toimiala)
Dim industry, Statfin altp pxt 006 px, LatestTSV
Dimension Industry (Toimiala)
Dim transaction, Statfin altp pxt 006 px, Full historyTSV
Dimension Transaction (Taloustoimi)
Dim transaction, Statfin altp pxt 006 px, LatestTSV
Dimension Transaction (Taloustoimi)
Fact, Statfin altp pxt 006 px, Full historyTSV
Output and employment by major region 2000-2016*, 30 industries by Transaction, Area, Industry, Sector, Data and Year
Fact, Statfin altp pxt 006 px, LatestTSV
Output and employment by major region 2000-2016*, 30 industries by Transaction, Area, Industry, Sector, Data and Year

Column Descriptions

Fact, Statfin altp pxt 006 px, Full history

Column	Type	Comment
transaction	string	Datasource did not contain a description for Transaction. Column transaction has 243474 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is B1GPHT and maximum string is P51TOT.
area	int	Datasource did not contain a description for Area. Column area has 243474 rows, out of which 69564 are empty, making the null percent 28.57. Minimum value is 1 and maximum value is 5.
industry	int	Datasource did not contain a description for Industry. Column industry has 243474 rows, out of which 188496 are empty, making the null percent 77.42. Minimum value is 0 and maximum value is 85.
sector	string	Datasource did not contain a description for Sector. Column sector has 243474 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is S1 and maximum string is S13.
data	string	Datasource did not contain a description for Data. Column data has 243474 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is CP and maximum string is FP_PRE.
year	int	Datasource did not contain a description for Year. Column year has 243474 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2000 and maximum value is 2016.
output_and_employment_by_major_region_20002016_30_industries	int	Datasource did not contain a description for Output_and_employment_by_major_region_20002016_30_industries. Column output_and_employment_by_major_region_20002016_30_industries has 243474 rows, out of which 85914 are empty, making the null percent 35.29. Minimum value is -95 and maximum value is 4316900.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin altp pxt 006 px, Latest

Column	Type	Comment
transaction	string	Datasource did not contain a description for Transaction. Column transaction has 243474 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is B1GPHT and maximum string is P51TOT.
area	int	Datasource did not contain a description for Area. Column area has 243474 rows, out of which 69564 are empty, making the null percent 28.57. Minimum value is 1 and maximum value is 5.
industry	int	Datasource did not contain a description for Industry. Column industry has 243474 rows, out of which 188496 are empty, making the null percent 77.42. Minimum value is 0 and maximum value is 85.
sector	string	Datasource did not contain a description for Sector. Column sector has 243474 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is S1 and maximum string is S13.
data	string	Datasource did not contain a description for Data. Column data has 243474 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is CP and maximum string is FP_PRE.
year	int	Datasource did not contain a description for Year. Column year has 243474 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2000 and maximum value is 2016.
output_and_employment_by_major_region_20002016_30_industries	int	Datasource did not contain a description for Output_and_employment_by_major_region_20002016_30_industries. Column output_and_employment_by_major_region_20002016_30_industries has 243474 rows, out of which 85914 are empty, making the null percent 35.29. Minimum value is -95 and maximum value is 4316900.

Dim area, Statfin altp pxt 006 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 7 rows, out of which 2 are empty, making the null percent 28.57. Minimum value is 1 and maximum value is 5.
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. Minimum string is Extra-regio territory and maximum string is Åland.

Dim industry, Statfin altp pxt 006 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 31 rows, out of which 24 are empty, making the null percent 77.42. Minimum value is 0 and maximum value is 85.
label	string	The label for the dimension value. Column label has 31 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 Agriculture and huntin... and first 25 characters of maximum string: 97_98 Household service a...

Dim area, Statfin altp pxt 006 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 7 rows, out of which 2 are empty, making the null percent 28.57. Minimum value is 1 and maximum value is 5.
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. Minimum string is Extra-regio territory and maximum string is Åland.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim industry, Statfin altp pxt 006 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 31 rows, out of which 24 are empty, making the null percent 77.42. Minimum value is 0 and maximum value is 85.
label	string	The label for the dimension value. Column label has 31 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 Agriculture and huntin... and first 25 characters of maximum string: 97_98 Household service a...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim transaction, Statfin altp pxt 006 px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is B1GPHT and maximum string is P51TOT.
label	string	The label for the dimension value. Column label has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: B1GPHT Value added, gross... and first 25 characters of maximum string: P51TOT Gross fixed capita...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim transaction, Statfin altp pxt 006 px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is B1GPHT and maximum string is P51TOT.
label	string	The label for the dimension value. Column label has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: B1GPHT Value added, gross... and first 25 characters of maximum string: P51TOT Gross fixed capita...

Additional Info

Last Updated	July 22, 2019
Created	July 19, 2019