Unemployment rate - total - Member States - definition EUROSTAT - ZUTN

Data - AMECO

Author

geo, Country

Code

ZUTN %>%
  left_join(COU, by = "COU") %>%
  group_by(COUNTRY) %>%
  summarise(Nobs = n()) %>%
  mutate(Flag = gsub(" ", "-", str_to_lower(COUNTRY)),
         Flag = paste0('<img src="../../icon/flag/vsmall/', Flag, '.png" alt="Flag">')) %>%
  select(Flag, everything()) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}

Unemployment vs. NAWRU

France, Germany, Italy

All

Code

ZNAWRU %>%
  mutate(variable = "Non Accelerating Wage Rate of Unemployment (NAWRU)") %>%
  bind_rows(ZUTN %>%
              mutate(variable = "Actual Unemployment Rate")) %>%
  filter(COU %in% c("FRA", "DEU", "ITA"),
         vintage == 2021) %>%
  left_join(COU, by = "COU") %>%
  na.omit %>%
  ggplot() + theme_minimal() + ylab("Non-accelerating wage rate of unemployment") + xlab("") +
  geom_line(aes(x = date, y = value/100, color = COUNTRY, linetype = variable)) +
  scale_color_manual(values = viridis(5)[1:4]) +
  scale_x_date(breaks = seq(1920, 2025, 5) %>% paste0("-01-01") %>% as.Date,
               labels = date_format("%y")) +
  scale_color_manual(values = c("#0055a4", "#000000", "#008c45")) +
  geom_image(data = . %>%
               filter(date == as.Date("2017-01-01"),
                      variable == "Non Accelerating Wage Rate of Unemployment (NAWRU)") %>%
               mutate(image = paste0("../../icon/flag/", str_to_lower(gsub(" ", "-", COUNTRY)), ".png")),
             aes(x = date, y = value/100, image = image), asp = 1.5) +
  theme(legend.position = "none") +
  scale_y_continuous(breaks = 0.01*seq(-60, 60, 1),
                     labels = scales::percent_format(accuracy = 1))

2000-

Code

ZNAWRU %>%
  mutate(variable = "Non Accelerating Wage Rate of Unemployment (NAWRU)") %>%
  bind_rows(ZUTN %>%
              mutate(variable = "Actual unemployment rate")) %>%
  filter(COU %in% c("FRA", "DEU", "ITA"),
         vintage == 2021,
         date >= as.Date("2000-01-01")) %>%
  left_join(COU, by = "COU") %>%
  na.omit %>%
  ggplot() + theme_minimal() + ylab("NAWRU, Actual unemployment rate") + xlab("") +
  geom_line(aes(x = date, y = value/100, color = COUNTRY, linetype = variable)) +
  scale_color_manual(values = viridis(5)[1:4]) +
  scale_x_date(breaks = seq(1920, 2025, 2) %>% paste0("-01-01") %>% as.Date,
               labels = date_format("%y")) +
  scale_color_manual(values = c("#0055a4", "#000000", "#008c45")) +
  scale_linetype_manual(values = c("longdash", "solid")) +
  geom_image(data = . %>%
               filter(date == as.Date("2020-01-01"),
                      variable == "Actual unemployment rate") %>%
               mutate(image = paste0("../../icon/flag/", str_to_lower(gsub(" ", "-", COUNTRY)), ".png")),
             aes(x = date, y = value/100, image = image), asp = 1.5) +
  theme(legend.position = c(0.35, 0.25),
        legend.title = element_blank()) +
  scale_y_continuous(breaks = 0.01*seq(-60, 60, 1),
                     labels = scales::percent_format(accuracy = 1))