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

001 -- Foreign affiliates by country 2004 - 2017

001 -- Foreign affiliates by country 2004 - 2017

Tables

Column Descriptions

Dim year, Statfin ulkoy pxt 001 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 14 rows, out of which 1 are empty, making the null percent 7.14. Minimum value is 2004 and maximum value is 2017.
label int The label for the dimension value. Column label has 14 rows, out of which 1 are empty, making the null percent 7.14. Minimum value is 2004 and maximum value is 2017.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfin ulkoy pxt 001 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 14 rows, out of which 1 are empty, making the null percent 7.14. Minimum value is 2004 and maximum value is 2017.
label int The label for the dimension value. Column label has 14 rows, out of which 1 are empty, making the null percent 7.14. Minimum value is 2004 and maximum value is 2017.

Dim country, Statfin ulkoy pxt 001 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 19 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AT and maximum string is SS.
label string The label for the dimension value. Column label has 19 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Austria and maximum string is Total.
orig_extractdate string The date when the data was originally fetched from the source.

Dim country, Statfin ulkoy pxt 001 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 19 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AT and maximum string is SS.
label string The label for the dimension value. Column label has 19 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Austria and maximum string is Total.

Fact, Statfin ulkoy pxt 001 px, Full history

Column Type Comment
country string konsernin kansallisuus on perimmäisen omistajatahon (UBO) kotimaa. . Column country has 798 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AT and maximum string is SS.
characteristics string Datasource did not contain a description for Characteristics. Column characteristics has 798 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Henkmaara and maximum string is Liikevaihto.
year int Tilastovuosi on se kalenterivuosi, jota tilasto koskee. Ajanjakso, yleensä kalenterivuosi, jonka aikaisesta kirjanpidosta tehdään yrityksen tilinpäätös. . Column year has 798 rows, out of which 57 are empty, making the null percent 7.14. Minimum value is 2004 and maximum value is 2017.
foreign_affiliates_by_country_2004_2017 int Datasource did not contain a description for Foreign_affiliates_by_country_2004_2017. Column foreign_affiliates_by_country_2004_2017 has 798 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4 and maximum value is 254977.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin ulkoy pxt 001 px, Latest

Column Type Comment
country string konsernin kansallisuus on perimmäisen omistajatahon (UBO) kotimaa. . Column country has 798 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AT and maximum string is SS.
characteristics string Datasource did not contain a description for Characteristics. Column characteristics has 798 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Henkmaara and maximum string is Liikevaihto.
year int Tilastovuosi on se kalenterivuosi, jota tilasto koskee. Ajanjakso, yleensä kalenterivuosi, jonka aikaisesta kirjanpidosta tehdään yrityksen tilinpäätös. . Column year has 798 rows, out of which 57 are empty, making the null percent 7.14. Minimum value is 2004 and maximum value is 2017.
foreign_affiliates_by_country_2004_2017 int Datasource did not contain a description for Foreign_affiliates_by_country_2004_2017. Column foreign_affiliates_by_country_2004_2017 has 798 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4 and maximum value is 254977.

Dim characteristics, Statfin ulkoy 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 Henkmaara and maximum string is Liikevaihto.
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 Employees (FTE) and maximum string is Turnover (million euro).
orig_extractdate string The date when the data was originally fetched from the source.

Dim characteristics, Statfin ulkoy 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 Henkmaara and maximum string is Liikevaihto.
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 Employees (FTE) and maximum string is Turnover (million euro).

Additional Info

Last Updated March 18, 2024
Created July 18, 2019