Private sector debt, consolidated - % of GDP - tipspd20

Data - Eurostat

Structure

France, Germany, Italy, Spain, Netherlands

Percent

Code
tipspd20 |>
  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("Private sector credit flow, consolidated - % GDP") +
  scale_y_continuous(breaks = 0.01*seq(-300, 600, 20),
                     labels = scales::percent_format(accuracy = 1)) +
  geom_hline(yintercept = 1.33, linetype = "dashed")

Level (Bn, national currency)

Code
tipspd20 |>
  filter(geo %in% c("FR", "DE", "NL", "ES", "IT"),
         unit == "MIO_NAC") |>
  year_to_date() |>

  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(1960, 2100, 2), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Private sector debt, consolidated (Bn)")

Latest Year: Private Sector Debt by Country

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

tipspd20 |>
  filter(unit == "PC_GDP", time == latest_yr) |>
  select(geo, Geo, `Private sector debt (% GDP)` = values) |>
  arrange(desc(`Private sector debt (% GDP)`)) |>
  print_table_conditional()
geo Geo Private sector debt (% GDP)
LU Luxembourg 315.2
NL Netherlands 199.8
DK Denmark 197.9
SE Sweden 189.8
CY Cyprus 161.6
FR France 151.6
BE Belgium 147.3
FI Finland 140.2
EA20 Euro area – 20 countries (2023-2025) 122.2
EA21 Euro area – 21 countries (from 2026) 121.8
PT Portugal 119.6
EU27_2020 European Union - 27 countries (from 2020) 119.4
MT Malta 110.4
AT Austria 107.4
DE Germany 106.4
ES Spain 105.4
IE Ireland 104.5
EL Greece 96.6
EE Estonia 95.4
IT Italy 91.1
SK Slovakia 84.3
CZ Czechia 76.6
BG Bulgaria 73.5
HR Croatia 72.2
HU Hungary 70.6
LV Latvia 57.1
SI Slovenia 56.9
LT Lithuania 55.1
PL Poland 52.8
RO Romania 40.4