Third Country Nationals Refused Entry At The External Borders - Annual Data (rounded)

Eurostat code: migr_eirfs · (2008 - 2024)

@eurostat.migr_eirfs

Table List

2 tables(1.93 MB)

Third Country Nationals Refused Entry At The External Borders - Annual Data (rounded) - Raw

Third Country Nationals Refused Entry At The External Borders - Annual Data (rounded) - Unpivoted

Third Country Nationals Refused Entry At The External Borders - Annual Data (rounded) - Unpivoted

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

838.13 KB
3271884 rows
8 columns

freq Freq	border Border	unit Unit	reason Reason	citizen Citizen	geo Geo	time_period Time Period
Annual	Air	Person	An alert has been issued	Andorra	Austria	2008
Annual	Air	Person	An alert has been issued	Andorra	Belgium	2008
Annual	Air	Person	An alert has been issued	Andorra	Bulgaria	2008
Annual	Air	Person	An alert has been issued	Andorra	Switzerland	2008
Annual	Air	Person	An alert has been issued	Andorra	Cyprus	2008
Annual	Air	Person	An alert has been issued	Andorra	Czechia	2008
Annual	Air	Person	An alert has been issued	Andorra	Germany	2008
Annual	Air	Person	An alert has been issued	Andorra	Denmark	2008
Annual	Air	Person	An alert has been issued	Andorra	Estonia	2008
Annual	Air	Person	An alert has been issued	Andorra	Greece	2008


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

Share link

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