A broad snow-streaked Alpine panorama.
All projects

07Quantitative · Individual · October 2026

Hot Potato

Interactive data story“Who Holds America’s Household Debt”

Most analyses of household debt split it by loan type. This one splits it by who holds it, because whoever holds a loan takes the loss if it goes bad: the federal government, the GSEs and agency pools, banks, private securitization and others. In 1952 the public sector held 3.2% of American household mortgages and consumer credit; by 2026 it held 56.4%. The project started from the thesis that each crisis ratchets that share up, and the data rejects it as a general pattern: the shift after a crisis looks like any other period’s, and the long climb is a slow structural build-out of the GSEs. One crisis is the exception. From 2007 to 2011 private-label securitization lost almost two-thirds of its book, the public share jumped 13 points, and it never went back. The story is told as an animated dot flow in which each dot is $50 billion of debt in 2026 dollars, moving between holders as the reader scrolls.

Open full screen ↗
Question
Have economic crises since the 1950s moved the credit risk on American household debt onto public balance sheets?
My role
Individual. The question, the data pipeline and warehouse, the analysis and the dot-flow site.
Method
Python · PostgreSQL · Next.js · Canvas animation
Tools
Python (pandas, psycopg) · Supabase Postgres · Next.js and HTML Canvas on Vercel · Vitest
Evidence
Federal Reserve Z.1 Financial Accounts, 1952 to 2026Q2: holders of 1–4 family mortgages and of consumer credit by type; FRED price and labour series; the New York Fed Household Debt and Credit report from 2003.
Result
56.4%Held by the public sector, 2026
3.2%
Public share, 1952
+13.1 pp
Public share, 2007Q4 to 2011Q4
$50B
Of debt per dot, 2026 dollars
Findings
  • The public share of household mortgages and consumer credit rose from 3.2% in 1952 to 56.4% in 2026
  • Crises do not reliably ratchet it up: across eleven recessions the shift after a crisis looks like any other period’s, and the 1980s alone added about 19 points with no crisis at all
  • One crisis did: from 2007Q4 to 2011Q4 the share rose from 36.1% to 49.2%, larger than 98% of all four-year windows, and it never reversed
Output
Live interactive dot-flow story on Vercel.

BoundaryDescriptive: the share is measured by holder from the Fed’s Financial Accounts, and the crisis test compares crisis windows with ordinary ones rather than identifying what caused any shift. Holder is a proxy for who bears the credit risk: federally insured loans held by banks count as private, and risk the GSEs pass on to private investors still counts as public.