Baselight
Sign In

Third-country Nationals Who Have Left The Territory To A Third Country By Type Of Agreement Procedure And Citizenship

Eurostat code: migr_eirt_agr ยท (2014 - 2023)

@eurostat.migr_eirt_agr

Third-country Nationals Who Have Left The Territory To A Third Country By Type Of Agreement Procedure And Citizenship - Unpivoted
@eurostat.migr_eirt_agr.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.

  • 57.59 KB
  • 115224 rows
  • 7 columns
freq

Freq

return

Return

citizen

Citizen

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualReturned under EU Readmission Agreement (EURA)AndorraPersonBulgaria2014
AnnualReturned under EU Readmission Agreement (EURA)AndorraPersonCroatia2014
AnnualReturned under EU Readmission Agreement (EURA)AndorraPersonHungary2014
AnnualReturned under EU Readmission Agreement (EURA)AndorraPersonPortugal2014
AnnualReturned under EU Readmission Agreement (EURA)AndorraPersonSlovenia2014
AnnualReturned under EU Readmission Agreement (EURA)AndorraPersonSlovakia2014
AnnualReturned under EU Readmission Agreement (EURA)United Arab EmiratesPersonBulgaria2014
AnnualReturned under EU Readmission Agreement (EURA)United Arab EmiratesPersonCroatia2014
AnnualReturned under EU Readmission Agreement (EURA)United Arab EmiratesPersonHungary2014
AnnualReturned under EU Readmission Agreement (EURA)United Arab EmiratesPersonPortugal2014

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

Share link

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