Harmonised unemployment rates (%) - monthly data - ei_lmhr_m

Data - Eurostat

Author

s_adj

Code

ei_lmhr_m %>%
  left_join(s_adj, by = "s_adj") %>%
  group_by(s_adj, S_adj) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}

s_adj	S_adj	Nobs
SA	Seasonally adjusted data, not calendar adjusted data	120771
NSA	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	117862

indic

Code

ei_lmhr_m %>%
  left_join(indic, by = "indic") %>%
  group_by(indic, Indic) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}

indic	Indic	Nobs
LM-UN-T-TOT	Unemployment according to ILO definition - Total	26983
LM-UN-T-LE25	Unemployment according to ILO definition - Under 25 years - Total	26955
LM-UN-F-TOT	Unemployment according to ILO definition - Females	26767
LM-UN-M-TOT	Unemployment according to ILO definition - Males	26767
LM-UN-T-GT25	Unemployment according to ILO definition - Over 25 years - Total	26461
LM-UN-F-GT25	Unemployment according to ILO definition - Over 25 years - Females	26245
LM-UN-M-GT25	Unemployment according to ILO definition - Over 25 years - Males	26245
LM-UN-F-LE25	Unemployment according to ILO definition - Under 25 years - Females	26105
LM-UN-M-LE25	Unemployment according to ILO definition - Under 25 years - Males	26105

geo

Code

ei_lmhr_m %>%
  left_join(geo, by = "geo") %>%
  group_by(geo, Geo) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

unit

Code

ei_lmhr_m %>%
  left_join(unit, by = "unit") %>%
  group_by(unit, Unit) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}

unit	Unit	Nobs
PC_ACT	Percentage of population in the labour force	238633

France, Germany, Portugal

Code

ei_lmhr_m %>%
  filter(geo %in% c("FR", "DE", "PT"),
         unit == "PC_ACT",
         s_adj == "SA",
         indic == "LM-UN-T-TOT") %>%
  month_to_date %>%
  left_join(geo, by = "geo") %>%
  ggplot + geom_line() + theme_minimal()  +
  aes(x = date, y = values/100, color = Geo, linetype = Geo) +
  scale_color_manual(values = viridis(4)[1:3]) +
  scale_x_date(breaks = as.Date(paste0(seq(1960, 2020, 2), "-01-01")),
               labels = date_format("%y")) +
  theme(legend.position = c(0.3, 0.85),
        legend.title = element_blank()) +
  xlab("") + ylab("Unemployment, Percentage of active population") +
  scale_y_continuous(breaks = 0.01*seq(0, 200, 1),
                     labels = scales::percent_format(accuracy = 1))

Euro Area

Code

ei_lmhr_m %>%
  filter(geo %in% c("EA19", "EU15", "DE"),
         unit == "PC_ACT",
         s_adj == "SA",
         indic == "LM-UN-T-TOT") %>%
  month_to_date %>%
  left_join(geo, by = "geo") %>%
  ggplot + geom_line() + theme_minimal()  +
  aes(x = date, y = values/100, color = Geo, linetype = Geo) +
  scale_color_manual(values = viridis(4)[1:3]) +
  scale_x_date(breaks = as.Date(paste0(seq(1960, 2020, 2), "-01-01")),
               labels = date_format("%y")) +
  theme(legend.position = c(0.3, 0.25),
        legend.title = element_blank()) +
  xlab("") + ylab("Percentage of active population") +
  scale_y_continuous(breaks = 0.01*seq(0, 200, 1),
                     labels = scales::percent_format(accuracy = 1))