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

003 -- Foreign affiliates in Finland

003 -- Foreign affiliates in Finland

Tables

Column Descriptions

Dim year, Statfin ulkoy pxt 003 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 characteristics, Statfin ulkoy pxt 003 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 Henkiloston_osuus and maximum string is Liikevaihdon_osuus.
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: Employees (FTE)... and first 25 characters of maximum string: Share of turnover (per ce...

Dim characteristics, Statfin ulkoy pxt 003 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 Henkiloston_osuus and maximum string is Liikevaihdon_osuus.
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: Employees (FTE)... and first 25 characters of maximum string: Share of turnover (per ce...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin ulkoy pxt 003 px, Full history

Column Type Comment
year int Tilastovuosi on se kalenterivuosi, jota tilasto koskee. Ajanjakso, yleensä kalenterivuosi, jonka aikaisesta kirjanpidosta tehdään yrityksen tilinpäätös. . Column year has 70 rows, out of which 5 are empty, making the null percent 7.14. Minimum value is 2004 and maximum value is 2017.
characteristics string Datasource did not contain a description for Characteristics. Column characteristics has 70 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Henkiloston_osuus and maximum string is Liikevaihdon_osuus.
foreign_affiliates_in_finland int Datasource did not contain a description for Foreign_affiliates_in_Finland. Column foreign_affiliates_in_finland has 70 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 12 and maximum value is 254977.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin ulkoy pxt 003 px, Latest

Column Type Comment
year int Tilastovuosi on se kalenterivuosi, jota tilasto koskee. Ajanjakso, yleensä kalenterivuosi, jonka aikaisesta kirjanpidosta tehdään yrityksen tilinpäätös. . Column year has 70 rows, out of which 5 are empty, making the null percent 7.14. Minimum value is 2004 and maximum value is 2017.
characteristics string Datasource did not contain a description for Characteristics. Column characteristics has 70 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Henkiloston_osuus and maximum string is Liikevaihdon_osuus.
foreign_affiliates_in_finland int Datasource did not contain a description for Foreign_affiliates_in_Finland. Column foreign_affiliates_in_finland has 70 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 12 and maximum value is 254977.

Dim year, Statfin ulkoy pxt 003 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.

Additional Info

Last Updated July 21, 2019
Created July 16, 2019