Compensation of employees - quarterly data, million units of national currency - tipslm14

Data - Eurostat

Info

Last observation: Quarterly: 2026Q2 (N = 3)

First observation: Quarterly: 1995Q1 (N = 66)

Last data update: 11 aoû 2026, 19:48. Last compile: 12 aoû 2026, 03:59

Structure

freq

na_item

s_adj

unit

geo

France, Germany, Portugal

tipslm14 |>
  filter(geo %in% c("FR", "DE", "PT")) |>
  quarter_to_date() |>
  
  mutate(values = values/100) |>
  left_join(colors, by = c("Geo" = "country")) |>
  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)

tipslm14 |>
  filter(geo %in% c("FR", "DE", "IT", "ES", "NL"),
         s_adj %in% c("SA", "SCA")) |>
  quarter_to_date() |>

  mutate(values = values/1000) |>
  left_join(colors, by = c("Geo" = "country")) |>
  mutate(color = ifelse(geo == "NL", color2, color)) |>
  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

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) |>
  left_join(colors, by = c("Geo" = "country")) |>
  mutate(color = ifelse(geo == "NL", color2, color)) |>
  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")