Last observation: 2025 (N = 84)
First observation: 2014 (N = 86)
Last data update: 24 oct. 2026, 00:34
Last compile: 31 oct. 2026, 00:37
Structure
France, Germany, Italy, Spain: Levels
Code
tec00010 |>
filter(geo %in% c("FR", "DE", "IT", "ES"),
unit == "CP_MEUR") |>
year_to_enddate() |>
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(2014, 2100, 1), "-01-01")),
labels = date_format("%Y")) +
xlab("") + ylab("Final consumption expenditure of general gvnt (Bn€)")
Latest Year: Ranking by % of GDP
Code
latest_y <- tec00010 |>
filter(unit == "PC_GDP", !is.na(values)) |>
summarise(m = max(time)) |>
pull(m)
tec00010 |>
filter(unit == "PC_GDP",
time == latest_y,
!(geo %in% c("EA19", "EA20", "EA21", "EU27_2020"))) |>
select(Geo, values) |>
arrange(-values) |>
slice(1:15) |>
print_table_conditional()| Geo | values |
|---|---|
| Sweden | 26.1 |
| Iceland | 26.0 |
| Netherlands | 26.0 |
| Finland | 25.8 |
| Belgium | 24.1 |
| France | 24.1 |
| Croatia | 24.0 |
| Denmark | 23.0 |
| Norway | 22.8 |
| Germany | 22.4 |
| Austria | 21.6 |
| Slovenia | 21.5 |
| Latvia | 21.4 |
| Estonia | 21.3 |
| Poland | 21.3 |
France, Germany, Portugal
Code
tec00010 |>
filter(geo %in% c("FR", "DE", "PT"),
unit == "PC_GDP") |>
year_to_enddate() |>
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.7, 0.55),
legend.title = element_blank()) +
xlab("") + ylab("Final consumption expenditure of general gvnt") +
scale_y_continuous(breaks = 0.01*seq(0, 200, 1),
labels = scales::percent_format(accuracy = 1))
Greece, Italy, Spain
Code
tec00010 |>
filter(geo %in% c("IT", "ES", "EL"),
unit == "PC_GDP") |>
year_to_enddate() |>
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.7, 0.55),
legend.title = element_blank()) +
xlab("") + ylab("Final consumption expenditure of general gvnt") +
scale_y_continuous(breaks = 0.01*seq(0, 200, 0.2),
labels = scales::percent_format(accuracy = 0.1))