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 157.7
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 114.8
AT Austria 107.4
DE Germany 106.4
ES Spain 104.9
IE Ireland 104.5
EL Greece 98.0
EE Estonia 95.4
IT Italy 92.1
SK Slovakia 84.3
CZ Czechia 76.6
BG Bulgaria 73.5
HR Croatia 71.4
HU Hungary 70.6
LV Latvia 57.1
SI Slovenia 56.9
LT Lithuania 55.1
PL Poland 52.9
RO Romania 40.1