Baselight
Sign In

Employment In Foreign Controlled Enterprises

Eurostat code: egi_em1 ยท (2008 - 2022)

@eurostat.egi_em1

Employment In Foreign Controlled Enterprises - Unpivoted
@eurostat.egi_em1.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.

  • 10.95 KB
  • 798 rows
  • 7 columns
freq

Freq

nace_r2

Nace R2

indic_sb

Indic Sb

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualTotal business economy; repair of computers, personal and household goods; except financial and insurance activitiesPersons employed - numberPercentage of totalAustria200818.67
AnnualTotal business economy; repair of computers, personal and household goods; except financial and insurance activitiesPersons employed - numberPercentage of totalBelgium200815.13
AnnualTotal business economy; repair of computers, personal and household goods; except financial and insurance activitiesPersons employed - numberPercentage of totalBulgaria200813.17
AnnualTotal business economy; repair of computers, personal and household goods; except financial and insurance activitiesPersons employed - numberPercentage of totalCyprus20084.65
AnnualTotal business economy; repair of computers, personal and household goods; except financial and insurance activitiesPersons employed - numberPercentage of totalCzechia200827.35
AnnualTotal business economy; repair of computers, personal and household goods; except financial and insurance activitiesPersons employed - numberPercentage of totalGermany200812.03
AnnualTotal business economy; repair of computers, personal and household goods; except financial and insurance activitiesPersons employed - numberPercentage of totalDenmark200815.31
AnnualTotal business economy; repair of computers, personal and household goods; except financial and insurance activitiesPersons employed - numberPercentage of totalEstonia200835.25
AnnualTotal business economy; repair of computers, personal and household goods; except financial and insurance activitiesPersons employed - numberPercentage of totalSpain20089.13
AnnualTotal business economy; repair of computers, personal and household goods; except financial and insurance activitiesPersons employed - numberPercentage of totalFinland200815.69

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.