Baselight
Sign In

Domestic Employment In Foreign Final Use (FIGARO Application)

Eurostat code: naio_10_fgdfe ยท (2010 - 2022)

@eurostat.naio_10_fgdfe

Domestic Employment In Foreign Final Use (FIGARO Application) - Unpivoted
@eurostat.naio_10_fgdfe.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.

  • 8.64 MB
  • 1329224 rows
  • 7 columns
freq

Freq

nace_r2

Nace R2

c_dest

C Dest

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAgriculture, forestry and fishingArgentinaPersonsAustria201077.098
AnnualAgriculture, forestry and fishingArgentinaPersonsBelgium201021.816
AnnualAgriculture, forestry and fishingArgentinaPersonsBulgaria2010169.61
AnnualAgriculture, forestry and fishingArgentinaPersonsCyprus20101.309
AnnualAgriculture, forestry and fishingArgentinaPersonsCzechia201038.714
AnnualAgriculture, forestry and fishingArgentinaPersonsGermany2010173.525
AnnualAgriculture, forestry and fishingArgentinaPersonsDenmark201053.982
AnnualAgriculture, forestry and fishingArgentinaPersonsEstonia201010.615
AnnualAgriculture, forestry and fishingArgentinaPersonsGreece201064.577
AnnualAgriculture, forestry and fishingArgentinaPersonsSpain2010479.557

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

Share link

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