001 -- Output and employment by major region 2000-2017*, preliminary

Tables

Dim area, Statfin altp pxt 001 px, Full historyTSV
Dimension Area (Alue)
Dim area, Statfin altp pxt 001 px, LatestTSV
Dimension Area (Alue)
Dim data, Statfin altp pxt 001 px, Full historyTSV
Dimension Data (Tiedot)
Dim data, Statfin altp pxt 001 px, LatestTSV
Dimension Data (Tiedot)
Dim transaction, Statfin altp pxt 001 px, Full historyTSV
Dimension Transaction (Taloustoimi)
Dim transaction, Statfin altp pxt 001 px, LatestTSV
Dimension Transaction (Taloustoimi)
Dim year, Statfin altp pxt 001 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin altp pxt 001 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin altp pxt 001 px, Full historyTSV
Output and employment by major region 2000-2017*, preliminary by Transaction, Area, Data and Year
Fact, Statfin altp pxt 001 px, LatestTSV
Output and employment by major region 2000-2017*, preliminary by Transaction, Area, Data and Year

Column Descriptions

Dim area, Statfin altp pxt 001 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.

Fact, Statfin altp pxt 001 px, Latest

Column	Type	Comment
transaction	string	Datasource did not contain a description for Transaction. Column transaction has 756 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 KVAKI.
area	int	Datasource did not contain a description for Area. Column area has 756 rows, out of which 216 are empty, making the null percent 28.57. Minimum value is 1 and maximum value is 5.
data	string	Datasource did not contain a description for Data. Column data has 756 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 756 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 2017.
output_and_employment_by_major_region_20002017_preliminary	int	Datasource did not contain a description for Output_and_employment_by_major_region_20002017_preliminary. Column output_and_employment_by_major_region_20002017_preliminary has 756 rows, out of which 36 are empty, making the null percent 4.76. Minimum value is 48 and maximum value is 5508213.

Dim transaction, Statfin altp pxt 001 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 B1GPHT and maximum string is KVAKI.
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: B1GPHT Value added, gross... and first 25 characters of maximum string: KVAKI Mean population (pe...

Dim transaction, Statfin altp pxt 001 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 B1GPHT and maximum string is KVAKI.
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: B1GPHT Value added, gross... and first 25 characters of maximum string: KVAKI Mean population (pe...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim data, Statfin altp pxt 001 px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 2 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.
label	string	The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is At previous year`s prices and maximum string is Current prices.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, Statfin altp pxt 001 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 18 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 2017.
label	int	The label for the dimension value. Column label has 18 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 2017.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, Statfin altp pxt 001 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 18 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 2017.
label	int	The label for the dimension value. Column label has 18 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 2017.

Dim data, Statfin altp pxt 001 px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 2 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.
label	string	The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is At previous year`s prices and maximum string is Current prices.

Dim area, Statfin altp pxt 001 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.

Fact, Statfin altp pxt 001 px, Full history

Column	Type	Comment
transaction	string	Datasource did not contain a description for Transaction. Column transaction has 756 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 KVAKI.
area	int	Datasource did not contain a description for Area. Column area has 756 rows, out of which 216 are empty, making the null percent 28.57. Minimum value is 1 and maximum value is 5.
data	string	Datasource did not contain a description for Data. Column data has 756 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 756 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 2017.
output_and_employment_by_major_region_20002017_preliminary	int	Datasource did not contain a description for Output_and_employment_by_major_region_20002017_preliminary. Column output_and_employment_by_major_region_20002017_preliminary has 756 rows, out of which 36 are empty, making the null percent 4.76. Minimum value is 48 and maximum value is 5508213.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	July 21, 2019
Created	July 20, 2019