Baselight
Sign In

Third Country Nationals Ordered To Leave - Annual Data (rounded)

Eurostat code: migr_eiord ยท (2008 - 2023)

@eurostat.migr_eiord

Third Country Nationals Ordered To Leave - Annual Data (rounded) - Unpivoted
@eurostat.migr_eiord.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.

  • 351.74 KB
  • 790996 rows
  • 8 columns
freq

Freq

citizen

Citizen

age

Age

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAndorraTotalTotalPersonAustria2008
AnnualAndorraTotalTotalPersonBelgium2008
AnnualAndorraTotalTotalPersonBulgaria2008
AnnualAndorraTotalTotalPersonCyprus2008
AnnualAndorraTotalTotalPersonCzechia2008
AnnualAndorraTotalTotalPersonGermany2008
AnnualAndorraTotalTotalPersonEstonia2008
AnnualAndorraTotalTotalPersonGreece2008
AnnualAndorraTotalTotalPersonSpain2008
AnnualAndorraTotalTotalPersonFinland2008

CREATE TABLE tidy (
  "freq" VARCHAR,
  "citizen" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);