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 |