Baselight
Sign In

Unemployment Rates By Sex, Age And Country Of Birth (%)

Eurostat code: lfsa_urgacob$dv_1762

@eurostat.lfsa_urgacob_dv_1762

Unemployment Rates By Sex, Age And Country Of Birth (%) - Unpivoted
@eurostat.lfsa_urgacob_dv_1762.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.

  • 28.7 KB
  • 14385 rows
  • 8 columns
freq

Freq

unit

Unit

sex

Sex

age

Age

c_birth

C Birth

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageFemalesFrom 15 to 24 yearsEU27 countries (from 2020) except reporting countryBelgium201527.6
AnnualPercentageFemalesFrom 15 to 24 yearsEU27 countries (from 2020) except reporting countrySwitzerland201518.3
AnnualPercentageFemalesFrom 15 to 24 yearsEU27 countries (from 2020) except reporting countryEuro area – 20 countries (from 2023)201530.8
AnnualPercentageFemalesFrom 15 to 24 yearsEU27 countries (from 2020) except reporting countrySpain201540
AnnualPercentageFemalesFrom 15 to 24 yearsEU27 countries (from 2020) except reporting countryEuropean Union - 27 countries (from 2020)201529.7
AnnualPercentageFemalesFrom 15 to 24 yearsEU27 countries (from 2020) except reporting countryFrance201532.2
AnnualPercentageFemalesFrom 15 to 24 yearsEU27 countries (from 2020) except reporting countryItaly201541.1
AnnualPercentageFemalesFrom 15 to 24 yearsEU27 countries (from 2020) except reporting countryLuxembourg201519.3
AnnualPercentageFemalesFrom 15 to 24 yearsEU27 countries (from 2020) except reporting countryNetherlands201519
AnnualPercentageFemalesFrom 15 to 24 yearsEU27 countries (from 2020) except reporting countrySweden201527.9

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

Share link

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