001 -- Foreign direct investments by country 2013-

Tables

Dim country, Statfin ssij pxt 001 px, Full historyTSV
Dimension Country (Maa)
Dim country, Statfin ssij pxt 001 px, LatestTSV
Dimension Country (Maa)
Dim data, Statfin ssij pxt 001 px, Full historyTSV
Dimension Data (Tiedot)
Dim data, Statfin ssij pxt 001 px, LatestTSV
Dimension Data (Tiedot)
Dim direction of investment, Statfin ssij pxt 001 px, Full historyTSV
Dimension Direction_of_investment (Sijoituksen suunta)
Dim direction of investment, Statfin ssij pxt 001 px, LatestTSV
Dimension Direction_of_investment (Sijoituksen suunta)
Dim year, Statfin ssij pxt 001 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin ssij pxt 001 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin ssij pxt 001 px, Full historyTSV
Foreign direct investments by country 2013- by Direction of investment, Country, Data and Year
Fact, Statfin ssij pxt 001 px, LatestTSV
Foreign direct investments by country 2013- by Direction of investment, Country, Data and Year

Column Descriptions

Fact, Statfin ssij pxt 001 px, Full history

Column	Type	Comment
direction_of_investment	string	Datasource did not contain a description for Direction_of_investment. Column direction_of_investment has 1500 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is DI and maximum string is DO.
country	string	Datasource did not contain a description for Country. Column country has 1500 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AR and maximum string is ZA.
data	string	Datasource did not contain a description for Data. Column data has 1500 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kanta and maximum string is Tuotto.
year	int	Datasource did not contain a description for Year. Column year has 1500 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.
foreign_direct_investments_by_country_2013	int	Datasource did not contain a description for Foreign_direct_investments_by_country_2013. Column foreign_direct_investments_by_country_2013 has 1500 rows, out of which 275 are empty, making the null percent 18.33. Minimum value is -14953 and maximum value is 105404.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim direction of investment, Statfin ssij 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 DI and maximum string is DO.
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 Inward and maximum string is Outward.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim direction of investment, Statfin ssij 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 DI and maximum string is DO.
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 Inward and maximum string is Outward.

Dim data, Statfin ssij 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 Kanta and maximum string is Tuotto.
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. Minimum string is Flow and maximum string is Income.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim country, Statfin ssij pxt 001 px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 50 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AR and maximum string is ZA.
label	string	The label for the dimension value. Column label has 50 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Argentina and maximum string is South Africa.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim country, Statfin ssij pxt 001 px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 50 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AR and maximum string is ZA.
label	string	The label for the dimension value. Column label has 50 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Argentina and maximum string is South Africa.

Dim data, Statfin ssij 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 Kanta and maximum string is Tuotto.
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. Minimum string is Flow and maximum string is Income.

Dim year, Statfin ssij pxt 001 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, Statfin ssij pxt 001 px, Latest

Column	Type	Comment
direction_of_investment	string	Datasource did not contain a description for Direction_of_investment. Column direction_of_investment has 1500 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is DI and maximum string is DO.
country	string	Datasource did not contain a description for Country. Column country has 1500 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AR and maximum string is ZA.
data	string	Datasource did not contain a description for Data. Column data has 1500 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kanta and maximum string is Tuotto.
year	int	Datasource did not contain a description for Year. Column year has 1500 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.
foreign_direct_investments_by_country_2013	int	Datasource did not contain a description for Foreign_direct_investments_by_country_2013. Column foreign_direct_investments_by_country_2013 has 1500 rows, out of which 275 are empty, making the null percent 18.33. Minimum value is -14953 and maximum value is 105404.

Dim year, Statfin ssij pxt 001 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.

Additional Info

Last Updated	July 21, 2019
Created	July 16, 2019