Last observation: Q2 2026 (N = 61)
First observation: Q1 1995 (N = 66)
Last data update: 20 sept. 2026, 22:26
Last compile: 20 sept. 2026, 23:51
Structure
France, Germany, Portugal
Code
tipslm14 |>
filter(geo %in% c("FR", "DE", "PT")) |>
quarter_to_date() |>
mutate(values = values/100) |>
add_flag_color("Geo") |>
ggplot() + geom_line() + theme_minimal() +
aes(x = date, y = values, color = color) +
scale_color_identity() + add_flags +
scale_x_date(breaks = as.Date(paste0(seq(1960, 2100, 1), "-01-01")),
labels = date_format("%Y")) +
theme(legend.position = c(0.3, 0.85),
legend.title = element_blank()) +
xlab("") + ylab("Compensation of employees")
France, Germany, Italy, Spain, Netherlands
Level (seasonally adjusted)
Code
tipslm14 |>
filter(geo %in% c("FR", "DE", "IT", "ES", "NL"),
s_adj %in% c("SA", "SCA")) |>
quarter_to_date() |>
mutate(values = values/1000) |>
add_flag_color("Geo") |>
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(1960, 2100, 2), "-01-01")),
labels = date_format("%Y")) +
xlab("") + ylab("Compensation of employees (Bn, national currency)")
Year-on-Year Growth
Code
tipslm14 |>
filter(geo %in% c("FR", "DE", "IT", "ES", "NL"),
s_adj %in% c("SA", "SCA")) |>
quarter_to_date() |>
arrange(geo, date) |>
group_by(geo) |>
mutate(yoy = values/lag(values, 4) - 1) |>
ungroup() |>
filter(!is.na(yoy)) |>
mutate(values = yoy) |>
add_flag_color("Geo") |>
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(1960, 2100, 2), "-01-01")),
labels = date_format("%Y")) +
xlab("") + ylab("Compensation of employees, y-o-y growth") +
scale_y_continuous(labels = scales::percent_format(accuracy = 1)) +
geom_hline(yintercept = 0, linetype = "dashed", color = "black")