Baselight

Long-term Unemployment Rate By Sex

Eurostat code: tesem130 ยท (2005 - 2024)

@eurostat.tesem130

Long-term Unemployment Rate By Sex - Unpivoted
@eurostat.tesem130.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.28 KB
  • 1704 rows
  • 8 columns
freq

Freq

indic_em

Indic Em

age

Age

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualLong-term unemploymentFrom 15 to 74 yearsFemalesPercentage of population in the labour forceFrance20052.6
AnnualLong-term unemploymentFrom 15 to 74 yearsFemalesPercentage of population in the labour forceSweden20051
AnnualLong-term unemploymentFrom 15 to 74 yearsMalesPercentage of population in the labour forceFrance20052.2
AnnualLong-term unemploymentFrom 15 to 74 yearsMalesPercentage of population in the labour forceSweden20051.2
AnnualLong-term unemploymentFrom 15 to 74 yearsTotalPercentage of population in the labour forceFrance20052.4
AnnualLong-term unemploymentFrom 15 to 74 yearsTotalPercentage of population in the labour forceSweden20051.1
AnnualLong-term unemploymentFrom 15 to 74 yearsFemalesPercentage of population in the labour forceFrance20062.6
AnnualLong-term unemploymentFrom 15 to 74 yearsFemalesPercentage of population in the labour forceSweden20060.9
AnnualLong-term unemploymentFrom 15 to 74 yearsMalesPercentage of population in the labour forceFrance20062.4
AnnualLong-term unemploymentFrom 15 to 74 yearsMalesPercentage of population in the labour forceSweden20061

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

Share link

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