Unemployment Rates By Sex, Age And Educational Attainment Level (%)

Eurostat code: lfsa_urgaed$dv_611

@eurostat.lfsa_urgaed_dv_611

Table List

2 tables(22.57 KB)

Unemployment Rates By Sex, Age And Educational Attainment Level (%) - Raw

Unemployment Rates By Sex, Age And Educational Attainment Level (%) - Unpivoted

Unemployment Rates By Sex, Age And Educational Attainment Level (%) - Unpivoted

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

7.41 KB
472 rows
8 columns

freq Freq	unit Unit	sex Sex	age Age	isced11 Isced11	geo Geo	time_period Time Period	value Value
Annual	Percentage	Total	From 15 to 74 years	All ISCED 2011 levels	Austria	2012	4.9
Annual	Percentage	Total	From 15 to 74 years	All ISCED 2011 levels	Belgium	2012	7.6
Annual	Percentage	Total	From 15 to 74 years	All ISCED 2011 levels	Bulgaria	2012	12.3
Annual	Percentage	Total	From 15 to 74 years	All ISCED 2011 levels	Switzerland	2012	4.5
Annual	Percentage	Total	From 15 to 74 years	All ISCED 2011 levels	Cyprus	2012	11.9
Annual	Percentage	Total	From 15 to 74 years	All ISCED 2011 levels	Czechia	2012	7
Annual	Percentage	Total	From 15 to 74 years	All ISCED 2011 levels	Germany	2012	5.4
Annual	Percentage	Total	From 15 to 74 years	All ISCED 2011 levels	Denmark	2012	7.8
Annual	Percentage	Total	From 15 to 74 years	All ISCED 2011 levels	Euro area – 20 countries (from 2023)	2012	11.4
Annual	Percentage	Total	From 15 to 74 years	All ISCED 2011 levels	Estonia	2012	10


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

Share link

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