1. Home
  2. Datasets
  3. 001 -- Finnish affiliates ...
To download the data set, please sign up or log in

001 -- Finnish affiliates abroad by country group in 2010-2017

001 -- Finnish affiliates abroad by country group in 2010-2017

Tables

Column Descriptions

Dim year, Statfin stu pxt 001 px, Full history

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

Dim year, Statfin stu pxt 001 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2017.
label int 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 value is 2010 and maximum value is 2017.

Fact, Statfin stu pxt 001 px, Full history

Column Type Comment
country_group string Maaryhmän nimi suomeksi. . Column country_group has 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AA_OS and maximum string is AFR.
year int Tilastovuosi on se kalenterivuosi, jota tilasto koskee. Ajanjakso, yleensä kalenterivuosi, jonka aikaisesta kirjanpidosta tehdään yrityksen tilinpäätös. . Column year has 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2017.
characteristics string Datasource did not contain a description for Characteristics. Column characteristics has 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Henkilosto and maximum string is Ofats_count.
finnish_affiliates_abroad_by_country_group_in_20102017 int Datasource did not contain a description for Finnish_affiliates_abroad_by_country_group_in_20102017. Column finnish_affiliates_abroad_by_country_group_in_20102017 has 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 191930.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin stu pxt 001 px, Latest

Column Type Comment
country_group string Maaryhmän nimi suomeksi. . Column country_group has 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AA_OS and maximum string is AFR.
year int Tilastovuosi on se kalenterivuosi, jota tilasto koskee. Ajanjakso, yleensä kalenterivuosi, jonka aikaisesta kirjanpidosta tehdään yrityksen tilinpäätös. . Column year has 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2017.
characteristics string Datasource did not contain a description for Characteristics. Column characteristics has 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Henkilosto and maximum string is Ofats_count.
finnish_affiliates_abroad_by_country_group_in_20102017 int Datasource did not contain a description for Finnish_affiliates_abroad_by_country_group_in_20102017. Column finnish_affiliates_abroad_by_country_group_in_20102017 has 280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 191930.

Dim characteristics, Statfin stu pxt 001 px, Full history

Column Type Comment
code string 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 string is Henkilosto and maximum string is Ofats_count.
label string 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. First 25 characters of minimum string: Gross investments in tang... and first 25 characters of maximum string: Number of affiliates...
orig_extractdate string The date when the data was originally fetched from the source.

Dim characteristics, Statfin stu pxt 001 px, Latest

Column Type Comment
code string 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 string is Henkilosto and maximum string is Ofats_count.
label string 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. First 25 characters of minimum string: Gross investments in tang... and first 25 characters of maximum string: Number of affiliates...

Dim country group, Statfin stu pxt 001 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AA_OS and maximum string is AFR.
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 Africa and maximum string is Central and South America.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 14, 2019
Created July 13, 2019