Main GDP aggregates per capita - namq_10_pc

Data - Eurostat

Structure

GDP per Capita, Current Prices

France, Germany, Italy, Spain, Netherlands

Code
namq_10_pc |>
  filter(geo %in% c("FR", "DE", "IT", "ES", "NL"),
         na_item == "B1GQ",
         unit == "CP_EUR_HAB") |>
  quarter_to_date() |>

  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(1980, 2100, 5), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("GDP per capita, current prices (€)")

GDP per Capita Growth (Year-on-Year)

France, Germany, Italy, Spain, Netherlands

Code
namq_10_pc |>
  filter(geo %in% c("FR", "DE", "IT", "ES", "NL"),
         na_item == "B1GQ",
         unit == "CLV_PCH_SM_HAB") |>
  quarter_to_date() |>

  add_flag_color("Geo") |>
  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(1980, 2100, 5), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("GDP per capita, real growth (y-o-y)") +
  scale_y_continuous(labels = scales::percent_format(accuracy = 1)) +
  geom_hline(yintercept = 0, linetype = "dashed", color = "black")

Latest Quarter, GDP per Capita

Code
latest_q_pc <- namq_10_pc |>
  filter(na_item == "B1GQ",
         unit == "CP_EUR_HAB",
         geo %in% c("FR", "DE", "IT", "ES", "NL"),
         !is.na(values)) |>
  summarise(m = max(time)) |>
  pull(m)

namq_10_pc |>
  filter(na_item == "B1GQ",
         unit %in% c("CP_EUR_HAB", "CLV_PCH_SM_HAB"),
         geo %in% c("FR", "DE", "IT", "ES", "NL"),
         time == latest_q_pc) |>
  select(unit, Unit, Geo, values) |>
  spread(Geo, values) |>
  print_table_conditional()
unit Unit France Germany Italy Netherlands Spain
CLV_PCH_SM_HAB Chain linked volumes, percentage change compared to same period in previous year, per capita 0.5 1.2 1.2 0.9 1.8
CP_EUR_HAB Current prices, euro per capita 10970.0 13810.0 9670.0 17200.0 9010.0