Unemployment Rates By Sex, Age, Citizenship And Degree Of Urbanisation

Eurostat code: lfst_r_lfur2ganu · (1995 - 2024)

@eurostat.lfst_r_lfur2ganu

Table List

2 tables(598.06 KB)

Unemployment Rates By Sex, Age, Citizenship And Degree Of Urbanisation - Raw

Unemployment Rates By Sex, Age, Citizenship And Degree Of Urbanisation - Unpivoted

Unemployment Rates By Sex, Age, Citizenship And Degree Of Urbanisation - Unpivoted

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

285.39 KB
171934 rows
9 columns

freq Freq	unit Unit	deg_urb Deg Urb	citizen Citizen	sex Sex	age Age	geo Geo	time_period Time Period	value Value
Annual	Percentage	Cities	EU27 countries (from 2020) except reporting country	Females	From 15 to 64 years	Belgium	1995	26.1
Annual	Percentage	Cities	EU27 countries (from 2020) except reporting country	Females	From 15 to 64 years	Germany	1995	12.5
Annual	Percentage	Cities	EU27 countries (from 2020) except reporting country	Females	From 15 to 64 years	Spain	1995	26
Annual	Percentage	Cities	EU27 countries (from 2020) except reporting country	Females	From 15 to 64 years	France	1995	9.3
Annual	Percentage	Cities	EU27 countries (from 2020) except reporting country	Females	From 15 to 64 years	United Kingdom	1995	9
Annual	Percentage	Cities	EU27 countries (from 2020) except reporting country	Females	From 15 to 74 years	Belgium	1995	26.1
Annual	Percentage	Cities	EU27 countries (from 2020) except reporting country	Females	From 15 to 74 years	Germany	1995	12.5
Annual	Percentage	Cities	EU27 countries (from 2020) except reporting country	Females	From 15 to 74 years	Spain	1995	26
Annual	Percentage	Cities	EU27 countries (from 2020) except reporting country	Females	From 15 to 74 years	France	1995	9.3
Annual	Percentage	Cities	EU27 countries (from 2020) except reporting country	Females	From 15 to 74 years	United Kingdom	1995	9


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

Share link

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