Foreign Affiliates Of The EU Enterprises By Detailed Breakdown Of Country Of The Affiliates (from 2021 Onwards)

Eurostat code: fats_out_part · (2021 - 2022)

@eurostat.fats_out_part

Table List

2 tables(256.97 KB)

Foreign Affiliates Of The EU Enterprises By Detailed Breakdown Of Country Of The Affiliates (from 2021 Onwards) - Raw

Foreign Affiliates Of The EU Enterprises By Detailed Breakdown Of Country Of The Affiliates (from 2021 Onwards) - Unpivoted

Foreign Affiliates Of The EU Enterprises By Detailed Breakdown Of Country Of The Affiliates (from 2021 Onwards) - Unpivoted

@eurostat.fats_out_part.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

132.04 KB
52475 rows
7 columns

freq Freq	nace_r2 Nace R2	indic_sbs Indic Sbs	partner Partner	geo Geo	time_period Time Period	value Value
Annual	Industry, construction and services (except public administration, defense, compulsory social security)	Persons employed - number	Andorra	Austria	2021
Annual	Industry, construction and services (except public administration, defense, compulsory social security)	Persons employed - number	Andorra	Belgium	2021
Annual	Industry, construction and services (except public administration, defense, compulsory social security)	Persons employed - number	Andorra	Bulgaria	2021
Annual	Industry, construction and services (except public administration, defense, compulsory social security)	Persons employed - number	Andorra	Cyprus	2021
Annual	Industry, construction and services (except public administration, defense, compulsory social security)	Persons employed - number	Andorra	Czechia	2021
Annual	Industry, construction and services (except public administration, defense, compulsory social security)	Persons employed - number	Andorra	Germany	2021
Annual	Industry, construction and services (except public administration, defense, compulsory social security)	Persons employed - number	Andorra	Denmark	2021
Annual	Industry, construction and services (except public administration, defense, compulsory social security)	Persons employed - number	Andorra	Estonia	2021
Annual	Industry, construction and services (except public administration, defense, compulsory social security)	Persons employed - number	Andorra	Greece	2021
Annual	Industry, construction and services (except public administration, defense, compulsory social security)	Persons employed - number	Andorra	Spain	2021	364


CREATE TABLE tidy (
  "freq" VARCHAR,
  "nace_r2" VARCHAR,
  "indic_sbs" VARCHAR,
  "partner" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.