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

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.

freq Freq	isced11 Isced11	citizen Citizen	mgstatus Mgstatus	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Less than primary, primary and lower secondary education (levels 0-2)	EU27 countries (from 2020) except reporting country	Foreign-born (first generation)	From 15 to 24 years	Females	Percentage	Switzerland	2021	16.6
Annual	Less than primary, primary and lower secondary education (levels 0-2)	EU27 countries (from 2020) except reporting country	Foreign-born (first generation)	From 15 to 24 years	Females	Percentage	Euro area – 20 countries (from 2023)	2021	20.8
Annual	Less than primary, primary and lower secondary education (levels 0-2)	EU27 countries (from 2020) except reporting country	Foreign-born (first generation)	From 15 to 24 years	Females	Percentage	Spain	2021	42.8
Annual	Less than primary, primary and lower secondary education (levels 0-2)	EU27 countries (from 2020) except reporting country	Foreign-born (first generation)	From 15 to 24 years	Females	Percentage	European Union - 27 countries (from 2020)	2021	21.6
Annual	Less than primary, primary and lower secondary education (levels 0-2)	EU27 countries (from 2020) except reporting country	Foreign-born (first generation)	From 15 to 24 years	Females	Percentage	Italy	2021	31.9
Annual	Less than primary, primary and lower secondary education (levels 0-2)	EU27 countries (from 2020) except reporting country	Foreign-born (first generation)	From 15 to 24 years	Males	Percentage	Switzerland	2021	15.7
Annual	Less than primary, primary and lower secondary education (levels 0-2)	EU27 countries (from 2020) except reporting country	Foreign-born (first generation)	From 15 to 24 years	Males	Percentage	Euro area – 20 countries (from 2023)	2021	20.8
Annual	Less than primary, primary and lower secondary education (levels 0-2)	EU27 countries (from 2020) except reporting country	Foreign-born (first generation)	From 15 to 24 years	Males	Percentage	Spain	2021	38.2
Annual	Less than primary, primary and lower secondary education (levels 0-2)	EU27 countries (from 2020) except reporting country	Foreign-born (first generation)	From 15 to 24 years	Males	Percentage	European Union - 27 countries (from 2020)	2021	20.7
Annual	Less than primary, primary and lower secondary education (levels 0-2)	EU27 countries (from 2020) except reporting country	Foreign-born (first generation)	From 15 to 24 years	Males	Percentage	Italy	2021	47.2

freq

Freq

isced11

Isced11

citizen

Citizen

mgstatus

Mgstatus

age

Age

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

Annual

Less than primary, primary and lower secondary education (levels 0-2)

EU27 countries (from 2020) except reporting country

Foreign-born (first generation)

From 15 to 24 years

Females

Percentage

Switzerland

2021

16.6

Annual

Less than primary, primary and lower secondary education (levels 0-2)

EU27 countries (from 2020) except reporting country

Foreign-born (first generation)

From 15 to 24 years

Females

Percentage

Euro area – 20 countries (from 2023)

2021

20.8

Annual

Less than primary, primary and lower secondary education (levels 0-2)

EU27 countries (from 2020) except reporting country

Foreign-born (first generation)

From 15 to 24 years

Females

Percentage

Spain

2021

42.8

Annual

Less than primary, primary and lower secondary education (levels 0-2)

EU27 countries (from 2020) except reporting country

Foreign-born (first generation)

From 15 to 24 years

Females

Percentage

European Union - 27 countries (from 2020)

2021

21.6

Annual

Less than primary, primary and lower secondary education (levels 0-2)

EU27 countries (from 2020) except reporting country

Foreign-born (first generation)

From 15 to 24 years

Females

Percentage

Italy

2021

31.9

Annual

Less than primary, primary and lower secondary education (levels 0-2)

EU27 countries (from 2020) except reporting country

Foreign-born (first generation)

From 15 to 24 years

Males

Percentage

Switzerland

2021

15.7

Annual

Less than primary, primary and lower secondary education (levels 0-2)

EU27 countries (from 2020) except reporting country

Foreign-born (first generation)

From 15 to 24 years

Males

Percentage

Euro area – 20 countries (from 2023)

2021

20.8

Annual

Less than primary, primary and lower secondary education (levels 0-2)

EU27 countries (from 2020) except reporting country

Foreign-born (first generation)

From 15 to 24 years

Males

Percentage

Spain

2021

38.2

Annual

Less than primary, primary and lower secondary education (levels 0-2)

EU27 countries (from 2020) except reporting country

Foreign-born (first generation)

From 15 to 24 years

Males

Percentage

European Union - 27 countries (from 2020)

2021

20.7

Annual

Less than primary, primary and lower secondary education (levels 0-2)

EU27 countries (from 2020) except reporting country

Foreign-born (first generation)

From 15 to 24 years

Males

Percentage

Italy

2021

47.2

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

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

Table List

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

@eurostat.lfsa_urganedm.tidy

freq

isced11

citizen

mgstatus

age

sex

unit

geo

time_period

value

Share link