Baselight
Sign In

Unemployment Rates By Sex, Age, Country Of Birth And Degree Of Urbanisation

Eurostat code: lfst_r_lfur2gacu ยท (1995 - 2024)

@eurostat.lfst_r_lfur2gacu

Unemployment Rates By Sex, Age, Country Of Birth And Degree Of Urbanisation - Unpivoted
@eurostat.lfst_r_lfur2gacu.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.

  • 282.77 KB
  • 185107 rows
  • 9 columns
freq

Freq

unit

Unit

deg_urb

Deg Urb

c_birth

C Birth

sex

Sex

age

Age

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageCitiesEU27 countries (from 2020) except reporting countryFemalesFrom 15 to 64 yearsBelgium199519.3
AnnualPercentageCitiesEU27 countries (from 2020) except reporting countryFemalesFrom 15 to 64 yearsGreece199516.9
AnnualPercentageCitiesEU27 countries (from 2020) except reporting countryFemalesFrom 15 to 64 yearsSpain199530.8
AnnualPercentageCitiesEU27 countries (from 2020) except reporting countryFemalesFrom 15 to 64 yearsFrance19959.1
AnnualPercentageCitiesEU27 countries (from 2020) except reporting countryFemalesFrom 15 to 64 yearsUnited Kingdom19958.3
AnnualPercentageCitiesEU27 countries (from 2020) except reporting countryFemalesFrom 15 to 74 yearsBelgium199519.6
AnnualPercentageCitiesEU27 countries (from 2020) except reporting countryFemalesFrom 15 to 74 yearsGreece199516.8
AnnualPercentageCitiesEU27 countries (from 2020) except reporting countryFemalesFrom 15 to 74 yearsSpain199530.8
AnnualPercentageCitiesEU27 countries (from 2020) except reporting countryFemalesFrom 15 to 74 yearsFrance19959.1
AnnualPercentageCitiesEU27 countries (from 2020) except reporting countryFemalesFrom 15 to 74 yearsUnited Kingdom19958.2

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "deg_urb" VARCHAR,
  "c_birth" 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.