Baselight

Long-term Unemployment By Sex - Annual Data

Eurostat code: une_ltu_a$dv_1821

@eurostat.une_ltu_a_dv_1821

Long-term Unemployment By Sex - Annual Data - Unpivoted
@eurostat.une_ltu_a_dv_1821.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.

  • 20.81 KB
  • 6282 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 forceAustria20151.6
AnnualLong-term unemploymentFrom 15 to 74 yearsFemalesPercentage of population in the labour forceBelgium20153.9
AnnualLong-term unemploymentFrom 15 to 74 yearsFemalesPercentage of population in the labour forceBulgaria20155.6
AnnualLong-term unemploymentFrom 15 to 74 yearsFemalesPercentage of population in the labour forceSwitzerland20151.9
AnnualLong-term unemploymentFrom 15 to 74 yearsFemalesPercentage of population in the labour forceCyprus20156.2
AnnualLong-term unemploymentFrom 15 to 74 yearsFemalesPercentage of population in the labour forceCzechia20152.9
AnnualLong-term unemploymentFrom 15 to 74 yearsFemalesPercentage of population in the labour forceGermany20151.7
AnnualLong-term unemploymentFrom 15 to 74 yearsFemalesPercentage of population in the labour forceDenmark20151.6
AnnualLong-term unemploymentFrom 15 to 74 yearsFemalesPercentage of population in the labour forceEuro area – 20 countries (from 2023)20155.4
AnnualLong-term unemploymentFrom 15 to 74 yearsFemalesPercentage of population in the labour forceEstonia20152.2

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.