Baselight
Sign In

Employment In Foreign Affiliates Of Domestic Enterprises

Eurostat code: egi_em2 ยท (2010 - 2021)

@eurostat.egi_em2

Employment In Foreign Affiliates Of Domestic Enterprises - Unpivoted
@eurostat.egi_em2.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.

  • 9.27 KB
  • 566 rows
  • 7 columns
freq

Freq

nace_r2

Nace R2

indic_sb

Indic Sb

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualIndustry, construction and services (except public administration, defense, compulsory social security)Persons employed - numberPercentage of totalAustria201018.01
AnnualIndustry, construction and services (except public administration, defense, compulsory social security)Persons employed - numberPercentage of totalBelgium20107.32
AnnualIndustry, construction and services (except public administration, defense, compulsory social security)Persons employed - numberPercentage of totalCyprus20109.78
AnnualIndustry, construction and services (except public administration, defense, compulsory social security)Persons employed - numberPercentage of totalCzechia20100.92
AnnualIndustry, construction and services (except public administration, defense, compulsory social security)Persons employed - numberPercentage of totalGermany201015.82
AnnualIndustry, construction and services (except public administration, defense, compulsory social security)Persons employed - numberPercentage of totalDenmark201025.06
AnnualIndustry, construction and services (except public administration, defense, compulsory social security)Persons employed - numberPercentage of totalGreece20103.34
AnnualIndustry, construction and services (except public administration, defense, compulsory social security)Persons employed - numberPercentage of totalSpain20106.81
AnnualIndustry, construction and services (except public administration, defense, compulsory social security)Persons employed - numberPercentage of totalFinland201025.13
AnnualIndustry, construction and services (except public administration, defense, compulsory social security)Persons employed - numberPercentage of totalFrance201024.44

CREATE TABLE tidy (
  "freq" VARCHAR,
  "nace_r2" VARCHAR,
  "indic_sb" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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