Baselight

Third Country Nationals Ordered To Leave By Citizenship, Age And Sex - Quarterly Data (rounded)

Eurostat code: migr_eiord1 ยท (2018-Q1 - 2024-Q4)

@eurostat.migr_eiord1

Third Country Nationals Ordered To Leave By Citizenship, Age And Sex - Quarterly Data (rounded) - Unpivoted
@eurostat.migr_eiord1.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.

  • 802.72 KB
  • 2895027 rows
  • 8 columns
freq

Freq

citizen

Citizen

age

Age

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

QuarterlyAndorraTotalFemalesPersonBelgium2018-Q1
QuarterlyAndorraTotalFemalesPersonDenmark2018-Q1
QuarterlyAndorraTotalFemalesPersonIreland2018-Q1
QuarterlyAndorraTotalFemalesPersonLuxembourg2018-Q1
QuarterlyAndorraTotalFemalesPersonMalta2018-Q1
QuarterlyAndorraTotalFemalesPersonRomania2018-Q1
QuarterlyAndorraTotalFemalesPersonSlovenia2018-Q1
QuarterlyAndorraTotalMalesPersonBelgium2018-Q1
QuarterlyAndorraTotalMalesPersonDenmark2018-Q1
QuarterlyAndorraTotalMalesPersonIreland2018-Q1

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

Share link

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