Unemployment Rates By Sex, Age, Migration Status, Citizenship And Educational Attainment Level

Eurostat code: lfsa_urganedm$dv_1763

@eurostat.lfsa_urganedm_dv_1763

Table List

2 tables(58.26 KB)

Unemployment Rates By Sex, Age, Migration Status, Citizenship And Educational Attainment Level - Raw

Unemployment Rates By Sex, Age, Migration Status, Citizenship And Educational Attainment Level - Unpivoted

Unemployment Rates By Sex, Age, Migration Status, Citizenship And Educational Attainment Level - Unpivoted

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

27.53 KB
12952 rows
10 columns

freq Freq	isced11 Isced11	citizen Citizen	mgstatus Mgstatus	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	All ISCED 2011 levels	Total	Foreign-born (first generation)	From 15 to 24 years	Females	Percentage	Austria	2021	20.9
Annual	All ISCED 2011 levels	Total	Foreign-born (first generation)	From 15 to 24 years	Females	Percentage	Belgium	2021	24.3
Annual	All ISCED 2011 levels	Total	Foreign-born (first generation)	From 15 to 24 years	Females	Percentage	Switzerland	2021	13.3
Annual	All ISCED 2011 levels	Total	Foreign-born (first generation)	From 15 to 24 years	Females	Percentage	Germany	2021	13.1
Annual	All ISCED 2011 levels	Total	Foreign-born (first generation)	From 15 to 24 years	Females	Percentage	Euro area – 20 countries (from 2023)	2021	26.5
Annual	All ISCED 2011 levels	Total	Foreign-born (first generation)	From 15 to 24 years	Females	Percentage	Spain	2021	38.4
Annual	All ISCED 2011 levels	Total	Foreign-born (first generation)	From 15 to 24 years	Females	Percentage	European Union - 27 countries (from 2020)	2021	27.5
Annual	All ISCED 2011 levels	Total	Foreign-born (first generation)	From 15 to 24 years	Females	Percentage	Finland	2021	26.5
Annual	All ISCED 2011 levels	Total	Foreign-born (first generation)	From 15 to 24 years	Females	Percentage	France	2021	31.9
Annual	All ISCED 2011 levels	Total	Foreign-born (first generation)	From 15 to 24 years	Females	Percentage	Italy	2021	41.4


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

Share link

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