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

Eurostat code: migr_eipre$dv_1221

@eurostat.migr_eipre_dv_1221

Table List

2 tables(29.85 KB)

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_dv_1221.raw

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

17.78 KB
794 rows
18 columns

freq Freq	reason Reason	apprehen Apprehen	citizen Citizen	sex Sex	age Age	unit Unit	geo Geo	n_2021 2021	n_2022 2022	n_2023 2023	n_2024 2024
Annual	Illegal entry	Between border crossing points - at land	Total	Total	Less than 18 years	Person	Austria
Annual	Illegal entry	Between border crossing points - at land	Total	Total	Less than 18 years	Person	Belgium
Annual	Illegal entry	Between border crossing points - at land	Total	Total	Less than 18 years	Person	Bulgaria	210	1075	635	1295
Annual	Illegal entry	Between border crossing points - at land	Total	Total	Less than 18 years	Person	Switzerland
Annual	Illegal entry	Between border crossing points - at land	Total	Total	Less than 18 years	Person	Cyprus			845
Annual	Illegal entry	Between border crossing points - at land	Total	Total	Less than 18 years	Person	Czechia
Annual	Illegal entry	Between border crossing points - at land	Total	Total	Less than 18 years	Person	Germany
Annual	Illegal entry	Between border crossing points - at land	Total	Total	Less than 18 years	Person	Denmark
Annual	Illegal entry	Between border crossing points - at land	Total	Total	Less than 18 years	Person	Estonia
Annual	Illegal entry	Between border crossing points - at land	Total	Total	Less than 18 years	Person	Greece	795	1010	1545


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