Third-country Nationals Who Have Left The Territory By Type Of Return And Citizenship

Eurostat code: migr_eirt_vol · (2011 - 2023)

@eurostat.migr_eirt_vol

Table List

2 tables(206.63 KB)

Third-country Nationals Who Have Left The Territory By Type Of Return And Citizenship - Raw

Third-country Nationals Who Have Left The Territory By Type Of Return And Citizenship - Unpivoted

Third-country Nationals Who Have Left The Territory By Type Of Return And Citizenship - Unpivoted

@eurostat.migr_eirt_vol.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.

87.85 KB
124368 rows
7 columns

freq Freq	return Return	citizen Citizen	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Forced return	Andorra	Person	Norway	2011
Annual	Forced return	United Arab Emirates	Person	Norway	2011
Annual	Forced return	Afghanistan	Person	Norway	2011	103
Annual	Forced return	Antigua and Barbuda	Person	Norway	2011
Annual	Forced return	Albania	Person	Norway	2011	81
Annual	Forced return	Armenia	Person	Norway	2011	14
Annual	Forced return	Angola	Person	Norway	2011	3
Annual	Forced return	Argentina	Person	Norway	2011	3
Annual	Forced return	Asia	Person	Norway	2011	790
Annual	Forced return	Australia	Person	Norway	2011	7


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.