Baselight
Sign In

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

Eurostat code: lfso_14luner ยท (2014 - 2014)

@eurostat.lfso_14luner

Unemployment Rate By Sex, Age, Migration Status, Citizenship And Educational Attainment Level - Unpivoted
@eurostat.lfso_14luner.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.

  • 64.24 KB
  • 31137 rows
  • 10 columns
freq

Freq

unit

Unit

isced11

Isced11

citizen

Citizen

mgstatus

Mgstatus

age

Age

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Foreign-born (first generation)From 15 to 24 yearsFemalesSpain201457.1
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Foreign-born (first generation)From 15 to 24 yearsFemalesItaly201445.4
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Foreign-born (first generation)From 15 to 24 yearsMalesGreece201456.2
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Foreign-born (first generation)From 15 to 24 yearsMalesSpain201442.9
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Foreign-born (first generation)From 15 to 24 yearsMalesItaly201443.6
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Foreign-born (first generation)From 15 to 24 yearsTotalBelgium201454.9
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Foreign-born (first generation)From 15 to 24 yearsTotalGreece201454
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Foreign-born (first generation)From 15 to 24 yearsTotalSpain201449.3
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Foreign-born (first generation)From 15 to 24 yearsTotalItaly201444.3
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)Foreign-born (first generation)From 15 to 29 yearsFemalesSpain201448

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

Share link

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