Baselight

Long-term Unemployment Rate By Sex

Eurostat code: sdg_08_40 · (2009 - 2024)

@eurostat.sdg_08_40

Long-term Unemployment Rate By Sex - Unpivoted
@eurostat.sdg_08_40.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.

  • 9.2 KB
  • 1680 rows
  • 8 columns
freq

Freq

indic_em

Indic Em

age

Age

unit

Unit

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualLong-term unemploymentFrom 15 to 74 yearsPercentage of population in the labour forceFemalesAustria20091.3
AnnualLong-term unemploymentFrom 15 to 74 yearsPercentage of population in the labour forceFemalesBelgium20093.5
AnnualLong-term unemploymentFrom 15 to 74 yearsPercentage of population in the labour forceFemalesBulgaria20093.6
AnnualLong-term unemploymentFrom 15 to 74 yearsPercentage of population in the labour forceFemalesCyprus20090.6
AnnualLong-term unemploymentFrom 15 to 74 yearsPercentage of population in the labour forceFemalesCzechia20092.5
AnnualLong-term unemploymentFrom 15 to 74 yearsPercentage of population in the labour forceFemalesGermany20093.4
AnnualLong-term unemploymentFrom 15 to 74 yearsPercentage of population in the labour forceFemalesDenmark20090.5
AnnualLong-term unemploymentFrom 15 to 74 yearsPercentage of population in the labour forceFemalesEuro area – 20 countries (from 2023)20093.5
AnnualLong-term unemploymentFrom 15 to 74 yearsPercentage of population in the labour forceFemalesEstonia20092.9
AnnualLong-term unemploymentFrom 15 to 74 yearsPercentage of population in the labour forceFemalesGreece20095.6

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

Share link

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