Gross fixed capital formation with AN_F6 asset breakdowns - namq_10_an6

Data - Eurostat

Info

Last observation: Quarterly: 2026Q2 (N = 1,574)

First observation: Quarterly: 1978Q1 (N = 392)

Last data update: 11 aoû 2026, 22:33. Last compile: 12 aoû 2026, 02:10

Structure

freq

unit

asset10

s_adj

geo

Total Fixed Assets Investment (% of GDP)

France, Germany, Italy, Spain

namq_10_an6 |>
  filter(geo %in% c("FR", "DE", "IT", "ES"),
         asset10 == "N11G",
         unit == "PC_GDP",
         s_adj == "SCA") |>
  quarter_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(1980, 2100, 5), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Total fixed assets investment (% of GDP)") +
  scale_y_continuous(labels = scales::percent_format(accuracy = 1))

Asset Composition, France

namq_10_an6 |>
  filter(geo == "FR",
         asset10 %in% c("N111G", "N117G", "N11KG"),
         unit == "PC_GDP",
         s_adj == "SCA") |>
  quarter_to_date() |>
  mutate(values = values/100) |>
  ggplot() + geom_line(aes(x = date, y = values, color = Asset10)) +
  theme_minimal() +
  theme(legend.position = c(0.3, 0.85),
        legend.title = element_blank()) +
  scale_x_date(breaks = as.Date(paste0(seq(1980, 2100, 5), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Share of GDP") +
  scale_y_continuous(labels = scales::percent_format(accuracy = 1))

Latest Quarter Snapshot: Total Fixed Assets Investment

latest_q <- namq_10_an6 |>
  filter(asset10 == "N11G", unit == "PC_GDP", s_adj == "SCA",
         geo %in% c("FR", "DE", "IT", "ES", "NL", "BE", "PT"),
         !is.na(values)) |>
  summarise(m = max(time)) |>
  pull(m)

namq_10_an6 |>
  filter(asset10 == "N11G",
         unit == "PC_GDP",
         s_adj == "SCA",
         geo %in% c("FR", "DE", "IT", "ES", "NL", "BE", "PT"),
         time == latest_q) |>
  select(Geo, values) |>
  arrange(desc(values)) |>
  print_table_conditional()

Geo	values
France	22.1
Spain	20.7
Netherlands	20.2