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

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

12.08 KB
2931 rows
10 columns

freq Freq	reason Reason	apprehen Apprehen	citizen Citizen	sex Sex	age Age	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	Total	Total	Total	Less than 18 years	Person	Austria	2015	24415
Annual	Total	Total	Total	Total	Less than 18 years	Person	Belgium	2015	930
Annual	Total	Total	Total	Total	Less than 18 years	Person	Bulgaria	2015	505
Annual	Total	Total	Total	Total	Less than 18 years	Person	Switzerland	2015	470
Annual	Total	Total	Total	Total	Less than 18 years	Person	Cyprus	2015	445
Annual	Total	Total	Total	Total	Less than 18 years	Person	Czechia	2015	1445
Annual	Total	Total	Total	Total	Less than 18 years	Person	Germany	2015	74570
Annual	Total	Total	Total	Total	Less than 18 years	Person	Denmark	2015	275
Annual	Total	Total	Total	Total	Less than 18 years	Person	Estonia	2015	30
Annual	Total	Total	Total	Total	Less than 18 years	Person	Greece	2015	84450


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.