Third Country Nationals Found To Be Illegally Present - Annual Data (rounded)

Eurostat code: migr_eipre · (2008 - 2024)

@eurostat.migr_eipre

Table List

2 tables(8.86 MB)

Third Country Nationals Found To Be Illegally Present - Annual Data (rounded) - Raw

Third Country Nationals Found To Be Illegally Present - Annual Data (rounded) - Unpivoted

Third Country Nationals Found To Be Illegally Present - Annual Data (rounded) - Raw

@eurostat.migr_eipre.raw

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

5.55 MB
3892104 rows
25 columns

freq Freq	reason Reason	apprehen Apprehen	citizen Citizen	sex Sex	age Age	unit Unit	geo Geo
Annual	Illegal entry	Between border crossing points - at land	Andorra	Females	Total	Person	Austria
Annual	Illegal entry	Between border crossing points - at land	Andorra	Females	Total	Person	Belgium
Annual	Illegal entry	Between border crossing points - at land	Andorra	Females	Total	Person	Bulgaria
Annual	Illegal entry	Between border crossing points - at land	Andorra	Females	Total	Person	Switzerland
Annual	Illegal entry	Between border crossing points - at land	Andorra	Females	Total	Person	Cyprus
Annual	Illegal entry	Between border crossing points - at land	Andorra	Females	Total	Person	Czechia
Annual	Illegal entry	Between border crossing points - at land	Andorra	Females	Total	Person	Germany
Annual	Illegal entry	Between border crossing points - at land	Andorra	Females	Total	Person	Denmark
Annual	Illegal entry	Between border crossing points - at land	Andorra	Females	Total	Person	Estonia
Annual	Illegal entry	Between border crossing points - at land	Andorra	Females	Total	Person	Greece


CREATE TABLE raw (
  "freq" VARCHAR,
  "reason" VARCHAR,
  "apprehen" VARCHAR,
  "citizen" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "unit" 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.