Info
Last observation: Annual: 2025 (N = 44)
First observation: Annual: 2000 (N = 128)
Last data update: 11 aoû 2026, 20:13. Last compile: 12 aoû 2026, 03:18
Total Investment Share of GDP
France, Germany, Italy, Spain
Code
sdg_08_11 |>
filter(geo %in% c("FR", "DE", "IT", "ES"),
indic == "INV_TOT") |>
year_to_date() |>
mutate(values = values/100) |>
left_join(colors, by = c("Geo" = "country")) |>
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(2000, 2100, 2), "-01-01")),
labels = date_format("%Y")) +
xlab("") + ylab("Total investment (% of GDP)") +
scale_y_continuous(labels = scales::percent_format(accuracy = 1))
France: by Institutional Sector
Code
sdg_08_11 |>
filter(geo == "FR",
indic %in% c("INV_BSN", "INV_GOV", "INV_HH")) |>
year_to_date() |>
mutate(values = values/100) |>
ggplot() + geom_line(aes(x = date, y = values, color = Indic)) +
theme_minimal() +
scale_x_date(breaks = as.Date(paste0(seq(2000, 2100, 2), "-01-01")),
labels = date_format("%Y")) +
theme(legend.position = c(0.25, 0.85),
legend.title = element_blank()) +
xlab("") + ylab("Investment (% of GDP)") +
scale_y_continuous(labels = scales::percent_format(accuracy = 1))
Average 2010-2019
Javascript
Code
sdg_08_11 |>
mutate(time = as.numeric(time)) |>
filter(time >= 2010) |>
group_by(geo, Geo, indic, Indic) |>
summarise(values = mean(values, na.rm = T)) |>
ungroup() |>
mutate(Indic = gsub(" investment", "", Indic)) |>
select(Indic, `Investment 2010-19 (% of GDP)` = Geo, values) |>
spread(Indic, values) |>
arrange(-Government) %>%
mutate_at(vars(-1), funs(percent(./100, accuracy = 0.1))) |>
select(1, 5, 2, 3, 4) %>%
{if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}
png
Code
include_graphics3("bib/eurostat/sdg_08_11_ex1.png")