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) - Raw

@eurostat.migr_eirfs.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

1.11 MB
259637 rows
23 columns

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


CREATE TABLE raw (
  "freq" VARCHAR,
  "border" VARCHAR,
  "unit" VARCHAR,
  "reason" VARCHAR,
  "citizen" VARCHAR,
  "geo" VARCHAR,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE,
  "n_2024" DOUBLE
);

Share link

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