Unemployment by sex, age and metropolitan regions - met_lfe3emprt

Data - Eurostat

Info

Last observation: Annual: 2023 (N = 1,788)

First observation: Annual: 1999 (N = 771)

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

Structure

Employment Rate, France, Germany, Italy, Spain

Code
met_lfe3emprt |>
  filter(metroreg %in% c("FR", "DE", "IT", "ES"),
         age == "Y20-64",
         sex == "T") |>
  mutate(Geo = Metroreg) |>
  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(1995, 2100, 5), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Employment rate, ages 20-64") +
  scale_y_continuous(labels = scales::percent_format(accuracy = 1))

France: Capital Metro Region vs. Non-Metropolitan Regions

Code
met_lfe3emprt |>
  filter(metroreg %in% c("FR001MC", "FR_NM", "FR"),
         age == "Y20-64",
         sex == "T") |>
  year_to_date() |>
  mutate(values = values/100) |>
  ggplot() + geom_line(aes(x = date, y = values, color = Metroreg)) +
  theme_minimal() +
  theme(legend.position = c(0.25, 0.82),
        legend.title = element_blank()) +
  scale_x_date(breaks = as.Date(paste0(seq(1995, 2100, 5), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Employment rate, ages 20-64") +
  scale_y_continuous(labels = scales::percent_format(accuracy = 1))

Latest Snapshot: Employment Rate in Capital Metro Regions

Code
latest_y <- met_lfe3emprt |>
  filter(grepl("MC$", metroreg), age == "Y20-64", sex == "T", !is.na(values)) |>
  summarise(m = max(time)) |>
  pull(m)

met_lfe3emprt |>
  filter(grepl("MC$", metroreg),
         age == "Y20-64",
         sex == "T",
         time == latest_y) |>
  select(Metroreg, values) |>
  arrange(desc(values)) |>
  print_table_conditional()
Metroreg values
Warszawa 86.5
Bratislava 85.8
Stockholm 85.2
Tallinn 84.9
Budapest 83.8
Amsterdam 83.8
Praha 83.7
Vilnius 83.2
København 82.1
Valletta 81.8
Sofia 81.2
Bucuresti 80.7
Dublin 80.3
Ljubljana 80.3
Helsinki 79.7
Riga 79.7
Lisboa 79.7
Lefkosia 78.9
Berlin 78.9
Paris 76.6
Zagreb 76.5
Madrid 75.5
LU001MC Luxembourg 74.8
Wien 73.0
Bruxelles / Brussel 70.8
Roma 70.4
Athina 69.6