Long-term unemployment rate, % of active population aged 15-74 - tipslm70

Data - Eurostat

Author

François Geerolf

Info

Last observation: Annual: 2025 (N = 60)

First observation: Annual: 2003 (N = 1)

Last data update: 11 aoû 2026, 22:42. Last compile: 12 aoû 2026, 04:00

Structure

unit

Code 
tipslm70 %>%
  select_if(~n_distinct(.) > 1) |>
  
  group_by(unit, Unit) |>
  summarise(Nobs = n()) |>
  arrange(-Nobs) |>
  print_table_conditional()
unit Unit Nobs
PC_ACT Percentage of population in the labour force 520
PPCH_3Y Percentage point change (t-(t-3)) 430

France, Germany, Italy, Spain, Netherlands

Levels

Code 
tipslm70 |>
  filter(geo %in% c("FR", "DE", "NL", "ES", "IT"),
         unit == "PC_ACT") |>
  year_to_date() |>
  
  left_join(colors, by = c("Geo" = "country")) |>
  mutate(values = values/100) |>
  mutate(color = ifelse(geo == "NL", color2, color)) |>
  ggplot() + geom_line(aes(x = date, y = values, color = color)) + theme_minimal() +
  scale_color_identity() + add_flags +
  scale_x_date(breaks = as.Date(paste0(seq(1960, 2100, 2), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Long-term unemployment rate, % of active population aged 15-74") +
  scale_y_continuous(breaks = 0.01*seq(-300, 2200, 2),
                     labels = scales::percent_format(accuracy = 1))

Changes

Code 
tipslm70 |>
  filter(geo %in% c("FR", "DE", "NL", "ES", "IT"),
         unit == "PPCH_3Y") |>
  year_to_date() |>
  
  left_join(colors, by = c("Geo" = "country")) |>
  mutate(values = values/100) |>
  mutate(color = ifelse(geo == "NL", color2, color)) |>
  ggplot() + geom_line(aes(x = date, y = values, color = color)) + theme_minimal() +
  scale_color_identity() + add_flags +
  scale_x_date(breaks = as.Date(paste0(seq(1960, 2100, 2), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Long-term unemployment rate, % of active population aged 15-74") +
  scale_y_continuous(breaks = 0.01*seq(-300, 2200, 1),
                     labels = scales::percent_format(accuracy = 1)) +
  geom_hline(yintercept = 0.005, linetype = "dashed")

Greece, Spain, Italy

Code 
tipslm70 |>
  filter(geo %in% c("EL", "ES", "IT"),
         unit == "PC_ACT") |>
  year_to_date() |>

  left_join(colors, by = c("Geo" = "country")) |>
  mutate(values = values/100) |>
  ggplot() + geom_line(aes(x = date, y = values, color = color)) + theme_minimal() +
  scale_color_identity() + add_flags +
  scale_x_date(breaks = as.Date(paste0(seq(1960, 2100, 2), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Long-term unemployment rate, % of active population aged 15-74") +
  scale_y_continuous(labels = scales::percent_format(accuracy = 1))

Latest Year: Ranking by Country

Code 
latest_y <- tipslm70 |>
  filter(geo == "FR",
         unit == "PC_ACT",
         !is.na(values)) |>
  summarise(m = max(time)) |>
  pull(m)

tipslm70 |>
  filter(unit == "PC_ACT",
         time == latest_y,
         !is.na(values)) |>
  mutate(values = values/100) |>
  select(Geo, values) |>
  arrange(-values) |>
  print_table_conditional()
Geo values
Greece 0.050
Spain 0.034
Slovakia 0.034
Italy 0.031
Lithuania 0.025
Finland 0.024
Latvia 0.023
Portugal 0.022
Euro area – 20 countries (2023-2025) 0.021
Euro area – 21 countries (from 2026) 0.021
Romania 0.021
Belgium 0.020
Luxembourg 0.020
European Union - 27 countries (from 2020) 0.019
Estonia 0.018
France 0.018
Croatia 0.018
Sweden 0.018
Bulgaria 0.015
Hungary 0.015
Austria 0.013
Germany 0.011
Ireland 0.011
Slovenia 0.011
Cyprus 0.009
Denmark 0.009
Czechia 0.008
Poland 0.008
Malta 0.006
Netherlands 0.005