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

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

3.3 MB
14962757 rows
10 columns

freq Freq	reason Reason	apprehen Apprehen	citizen Citizen	sex Sex	age Age	unit Unit	geo Geo	time_period Time Period
Annual	Total	Total	Andorra	Females	Total	Person	Austria	2008
Annual	Total	Total	Andorra	Females	Total	Person	Belgium	2008
Annual	Total	Total	Andorra	Females	Total	Person	Bulgaria	2008
Annual	Total	Total	Andorra	Females	Total	Person	Cyprus	2008
Annual	Total	Total	Andorra	Females	Total	Person	Czechia	2008
Annual	Total	Total	Andorra	Females	Total	Person	Denmark	2008
Annual	Total	Total	Andorra	Females	Total	Person	Estonia	2008
Annual	Total	Total	Andorra	Females	Total	Person	Greece	2008
Annual	Total	Total	Andorra	Females	Total	Person	European Union - 27 countries (from 2020)	2008
Annual	Total	Total	Andorra	Females	Total	Person	Finland	2008


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

Share link

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