Unemployment by duration - DUR_D

Data - OECD

Author

François Geerolf

Code 
load_data("oecd/DUR_D_var.RData")
DUR_D <- read_parquet("DUR_D.parquet")

Last observation: 2022 (N = 6193)

First observation: 1968 (N = 441)

Last data update: 02 août 2026, 08:57

Last compile: 02 sept. 2026, 23:15

Structure

Nobs - Javascript

Code 
DUR_D |>
  left_join(DUR_D_var |> pluck("DURATION"), by = c("DURATION" = "id")) |>
  rename(`DURATION Description` = label) |>
  group_by(DURATION, `DURATION Description`, SEX, AGE) |>
  summarise(Nobs = n()) |>
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

Data Structure

Code 
DUR_D_var |>
  pluck("VAR_DESC") %>%
  {if (is_html_output()) print_table(.) else .}
id description
COUNTRY Country
TIME Time
SEX Sex
AGE Age
DURATION Duration
FREQUENCY Frequency
OBS_VALUE Observation Value
TIME_FORMAT Time Format
OBS_STATUS Observation Status
UNIT Unit
POWERCODE Unit multiplier
REFERENCEPERIOD Reference period

All persons, All ages

France

Code 
DUR_D |>
  filter(AGE == "900000", 
         SEX == "MW",
         COUNTRY == "FRA") |>
  year_to_enddate() |>
  left_join(DUR_D_var |> pluck("DURATION"), by = c("DURATION" = "id")) |>
  rename(DURATION_desc = label) |>
  ggplot() + theme_minimal() +
  geom_line(aes(x = date, y = obsValue/1000, color = DURATION_desc, linetype = DURATION_desc)) + 
  scale_color_manual(values = viridis(9)[1:8]) +
  theme(legend.position = c(0.85, 0.9),
        legend.title = element_blank()) +
  xlab("") + ylab("Unemployed (Millions)") +
  scale_x_date(breaks = seq(1920, 2100, 5) |> paste0("-01-01") |> as.Date(),
               labels = date_format("%Y")) +
  theme(legend.position = c(0.47, 0.9),
        legend.title = element_blank(),
        legend.direction = "horizontal") +
  scale_y_continuous(breaks = seq(0, 1000, 0.5),
                     limits = c(0, 4))

Code 
DUR_D |>
  filter(AGE == "900000", 
         SEX == "MW",
         COUNTRY == "FRA",
         DURATION %in% c("UN1", "UN2", "UN3", "UN4", "UN5")) |>
  year_to_enddate() |>
  left_join(DUR_D_var |> pluck("DURATION"), by = c("DURATION" = "id")) |>
  rename(DURATION_desc = label) |>
  ggplot() + theme_minimal() +
  geom_line(aes(x = date, y = obsValue/1000, color = DURATION_desc)) + 
  scale_color_manual(values = viridis(6)[1:5]) +
  theme(legend.position = c(0.85, 0.9),
        legend.title = element_blank()) +
  xlab("") + ylab("Unemployed (Millions)") +
  scale_x_date(breaks = seq(1920, 2100, 5) |> paste0("-01-01") |> as.Date(),
               labels = date_format("%Y")) +
  theme(legend.position = c(0.2, 0.8),
        legend.title = element_blank(),
        legend.direction = "vertical") +
  scale_y_continuous(breaks = seq(0, 1000, 0.5),
                     limits = c(0, 2))

Germany

Code 
DUR_D |>
  filter(AGE == "900000", 
         SEX == "MW",
         COUNTRY == "DEU") |>
  year_to_enddate() |>
  left_join(DUR_D_var |> pluck("DURATION"), by = c("DURATION" = "id")) |>
  rename(DURATION_desc = label) |>
  ggplot() + theme_minimal() +
  geom_line(aes(x = date, y = obsValue/1000, color = DURATION_desc, linetype = DURATION_desc)) + 
  scale_color_manual(values = viridis(9)[1:8]) +
  theme(legend.position = c(0.85, 0.9),
        legend.title = element_blank()) +
  xlab("") + ylab("Unemployed (Millions)") +
  scale_x_date(breaks = seq(1920, 2100, 5) |> paste0("-01-01") |> as.Date(),
               labels = date_format("%Y")) +
  theme(legend.position = c(0.47, 0.9),
        legend.title = element_blank(),
        legend.direction = "horizontal") +
  scale_y_continuous(breaks = seq(0, 1000, 0.5),
                     limits = c(0, 6))

Code 
DUR_D |>
  filter(AGE == "900000", 
         SEX == "MW",
         COUNTRY == "DEU",
         DURATION %in% c("UN1", "UN2", "UN3", "UN4", "UN5")) |>
  year_to_enddate() |>
  left_join(DUR_D_var |> pluck("DURATION"), by = c("DURATION" = "id")) |>
  rename(DURATION_desc = label) |>
  ggplot() + theme_minimal() +
  geom_line(aes(x = date, y = obsValue/1000, color = DURATION_desc)) + 
  scale_color_manual(values = viridis(6)[1:5]) +
  theme(legend.position = c(0.85, 0.9),
        legend.title = element_blank()) +
  xlab("") + ylab("Unemployed (Millions)") +
  scale_x_date(breaks = seq(1920, 2100, 5) |> paste0("-01-01") |> as.Date(),
               labels = date_format("%Y")) +
  theme(legend.position = c(0.2, 0.8),
        legend.title = element_blank(),
        legend.direction = "vertical") +
  scale_y_continuous(breaks = seq(0, 1000, 0.5),
                     limits = c(0, 3))

Spain

Code 
DUR_D |>
  filter(AGE == "900000", 
         SEX == "MW",
         COUNTRY == "ESP") |>
  year_to_enddate() |>
  left_join(DUR_D_var |> pluck("DURATION"), by = c("DURATION" = "id")) |>
  rename(DURATION_desc = label) |>
  ggplot() + theme_minimal() +
  geom_line(aes(x = date, y = obsValue/1000, color = DURATION_desc, linetype = DURATION_desc)) + 
  scale_color_manual(values = viridis(9)[1:8]) +
  theme(legend.position = c(0.85, 0.9),
        legend.title = element_blank()) +
  xlab("") + ylab("Unemployed (Millions)") +
  scale_x_date(breaks = seq(1920, 2100, 5) |> paste0("-01-01") |> as.Date(),
               labels = date_format("%Y")) +
  theme(legend.position = c(0.47, 0.9),
        legend.title = element_blank(),
        legend.direction = "horizontal") +
  scale_y_continuous(breaks = seq(0, 1000, 0.5),
                     limits = c(0, 7))

Code 
DUR_D |>
  filter(AGE == "900000", 
         SEX == "MW",
         COUNTRY == "ESP",
         DURATION %in% c("UN1", "UN2", "UN3", "UN4", "UN5")) |>
  year_to_enddate() |>
  left_join(DUR_D_var |> pluck("DURATION"), by = c("DURATION" = "id")) |>
  rename(DURATION_desc = label) |>
  ggplot() + theme_minimal() +
  geom_line(aes(x = date, y = obsValue/1000, color = DURATION_desc)) + 
  scale_color_manual(values = viridis(6)[1:5]) +
  theme(legend.position = c(0.85, 0.9),
        legend.title = element_blank()) +
  xlab("") + ylab("Unemployed (Millions)") +
  scale_x_date(breaks = seq(1920, 2100, 5) |> paste0("-01-01") |> as.Date(),
               labels = date_format("%Y")) +
  theme(legend.position = c(0.2, 0.8),
        legend.title = element_blank(),
        legend.direction = "vertical") +
  scale_y_continuous(breaks = seq(0, 1000, 0.5),
                     limits = c(0, 3.5))

Portugal

Code 
DUR_D |>
  filter(AGE == "900000", 
         SEX == "MW",
         COUNTRY == "PRT") |>
  year_to_enddate() |>
  left_join(DUR_D_var |> pluck("DURATION"), by = c("DURATION" = "id")) |>
  rename(DURATION_desc = label) |>
  ggplot() + theme_minimal() +
  geom_line(aes(x = date, y = obsValue/1000, color = DURATION_desc, linetype = DURATION_desc)) + 
  scale_color_manual(values = viridis(9)[1:8]) +
  theme(legend.position = c(0.85, 0.9),
        legend.title = element_blank()) +
  xlab("") + ylab("Unemployed (Millions)") +
  scale_x_date(breaks = seq(1920, 2100, 5) |> paste0("-01-01") |> as.Date(),
               labels = date_format("%Y")) +
  theme(legend.position = c(0.47, 0.9),
        legend.title = element_blank(),
        legend.direction = "horizontal") +
  scale_y_continuous(breaks = seq(0, 1000, 0.1),
                     limits = c(0, 1))

Code 
DUR_D |>
  filter(AGE == "900000", 
         SEX == "MW",
         COUNTRY == "PRT",
         DURATION %in% c("UN1", "UN2", "UN3", "UN4", "UN5")) |>
  year_to_enddate() |>
  left_join(DUR_D_var |> pluck("DURATION"), by = c("DURATION" = "id")) |>
  rename(DURATION_desc = label) |>
  ggplot() + theme_minimal() +
  geom_line(aes(x = date, y = obsValue/1000, color = DURATION_desc)) + 
  scale_color_manual(values = viridis(6)[1:5]) +
  theme(legend.position = c(0.85, 0.9),
        legend.title = element_blank()) +
  xlab("") + ylab("Unemployed (Millions)") +
  scale_x_date(breaks = seq(1920, 2100, 5) |> paste0("-01-01") |> as.Date(),
               labels = date_format("%Y")) +
  theme(legend.position = c(0.2, 0.8),
        legend.title = element_blank(),
        legend.direction = "vertical") +
  scale_y_continuous(breaks = seq(0, 1000, 0.1),
                     limits = c(0, 0.6))

United States

Code 
DUR_D |>
  filter(AGE == "900000", 
         SEX == "MW",
         COUNTRY == "USA") |>
  year_to_enddate() |>
  left_join(DUR_D_var |> pluck("DURATION"), by = c("DURATION" = "id")) |>
  rename(DURATION_desc = label) |>
  ggplot() + theme_minimal() +
  geom_line(aes(x = date, y = obsValue/1000, color = DURATION_desc, linetype = DURATION_desc)) + 
  scale_color_manual(values = viridis(9)[1:8]) +
  theme(legend.position = c(0.85, 0.9),
        legend.title = element_blank()) +
  xlab("") + ylab("Unemployed (Millions)") +
  scale_x_date(breaks = seq(1920, 2100, 5) |> paste0("-01-01") |> as.Date(),
               labels = date_format("%Y")) +
  theme(legend.position = c(0.47, 0.9),
        legend.title = element_blank(),
        legend.direction = "horizontal") +
  scale_y_continuous(breaks = seq(0, 1000, 2),
                     limits = c(0, 16))

Code 
DUR_D |>
  filter(AGE == "900000", 
         SEX == "MW",
         COUNTRY == "USA",
         DURATION %in% c("UN1", "UN2", "UN3", "UN4", "UN5")) |>
  year_to_enddate() |>
  left_join(DUR_D_var |> pluck("DURATION"), by = c("DURATION" = "id")) |>
  rename(DURATION_desc = label) |>
  ggplot() + theme_minimal() +
  geom_line(aes(x = date, y = obsValue/1000, color = DURATION_desc)) + 
  scale_color_manual(values = viridis(6)[1:5]) +
  theme(legend.position = c(0.85, 0.9),
        legend.title = element_blank()) +
  xlab("") + ylab("Unemployed (Millions)") +
  scale_x_date(breaks = seq(1920, 2100, 5) |> paste0("-01-01") |> as.Date(),
               labels = date_format("%Y")) +
  theme(legend.position = c(0.2, 0.8),
        legend.title = element_blank(),
        legend.direction = "vertical") +
  scale_y_continuous(breaks = seq(0, 1000, 1),
                     limits = c(0, 6))