General government gross debt (EDP concept), consolidated - annual data - tipsgo10

Data - Eurostat

Structure

France, Germany, Italy, Spain, Netherlands

Percent

Code
tipsgo10 |>
  filter(geo %in% c("FR", "DE", "NL", "ES", "IT"),
         unit == "PC_GDP") |>
  year_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(1960, 2100, 2), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("General government gross debt (EDP concept), consolidated") +
  scale_y_continuous(breaks = 0.01*seq(-300, 600, 20),
                     labels = scales::percent_format(accuracy = 1)) +
  geom_hline(yintercept = 0.6, linetype = "dashed")

Greece, Portugal, Belgium, Ireland

Percent

Code
tipsgo10 |>
  filter(geo %in% c("EL", "PT", "BE", "IE"),
         unit == "PC_GDP") |>
  year_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(1960, 2100, 2), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("General government gross debt (EDP concept), consolidated") +
  scale_y_continuous(breaks = 0.01*seq(-300, 600, 20),
                     labels = scales::percent_format(accuracy = 1)) +
  geom_hline(yintercept = 0.6, linetype = "dashed")

Latest Year: All Countries

Code
latest_y <- tipsgo10 |>
  filter(unit == "PC_GDP", !is.na(values)) |>
  summarise(m = max(time)) |>
  pull(m)

tipsgo10 |>
  filter(time == latest_y,
         unit == "PC_GDP") |>
  mutate(values = round(values, 1)) |>
  select(Geo, values) |>
  arrange(-values) |>
  rename(!!paste0("Gross debt, % of GDP (", latest_y, ")") := values) |>
  print_table_conditional()
Geo Gross debt, % of GDP (2025)
Greece 145.4
Italy 136.7
France 115.7
Belgium 108.1
Spain 100.5
Portugal 89.2
Finland 88.4
Euro area – 20 countries (2023-2025) 87.7
Euro area – 21 countries (from 2026) 87.3
European Union - 27 countries (from 2020) 81.5
Austria 80.7
Hungary 74.4
Slovenia 65.1
Germany 62.8
Slovakia 60.5
Poland 59.6
Romania 58.9
Croatia 55.7
Cyprus 52.3
Malta 46.3
Latvia 46.2
Netherlands 44.7
Czechia 44.2
Lithuania 39.3
Sweden 35.1
Ireland 34.8
Bulgaria 29.9
Denmark 27.2
Luxembourg 26.0
Estonia 24.0