Gross debt-to-income ratio of households - tec00104

Data - Eurostat

Structure

France, Germany, Portugal

Code
tec00104 |>
  filter(geo %in% c("FR", "DE", "PT")) |>
  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.3, 0.85),
        legend.title = element_blank()) +
  xlab("") + ylab("Gross debt-to-income ratio of households") +
  scale_y_continuous(breaks = 0.01*seq(0, 200, 5),
                     labels = scales::percent_format(accuracy = 1))

Netherlands, Denmark, Sweden

Code
tec00104 |>
  filter(geo %in% c("NL", "DK", "SE")) |>
  year_to_enddate() |>

  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, 1), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Gross debt-to-income ratio of households") +
  scale_y_continuous(breaks = 0.01*seq(0, 400, 20),
                     labels = scales::percent_format(accuracy = 1))

Latest Year: All Countries

Code
latest_y <- tec00104 |>
  filter(!is.na(values)) |>
  summarise(m = max(time)) |>
  pull(m)

tec00104 |>
  filter(time == latest_y) |>
  mutate(values = round(values, 1)) |>
  select(Geo, values) |>
  arrange(-values) |>
  rename(!!paste0("Gross debt-to-income ratio, % (", latest_y, ")") := values) |>
  print_table_conditional()
Geo Gross debt-to-income ratio, % (2025)
Netherlands 180.1
Denmark 163.1
Luxembourg 155.8
Sweden 150.4
Iceland 128.6
Finland 106.8
Belgium 95.0
France 91.0
Malta 89.5
Cyprus 85.9
Euro area – 21 countries (from 2026) 80.9
European Union - 27 countries (from 2020) 79.8
Ireland 79.4
Portugal 78.3
Germany 72.5
Slovakia 69.8
Estonia 68.8
Spain 68.4
Austria 66.3
Greece 57.0
Italy 55.9
Czechia 53.8
Croatia 48.6
Slovenia 41.2
Lithuania 38.9
Poland 34.9
Latvia 32.3
Hungary 28.3
Romania 20.8