⚠ Treasury Fiscal Data API currently returning 404 from this host — no data ingested yet.
Run python -m finance.rates.collect_treasury_debt --verify-fields to confirm API recovery,
then --lane daily and --lane mspd_t3 to populate. All UI sections below show placeholders.
Data Sources & Methodology
Treasury Fiscal Data API — Debt to the Penny
Daily publication. Fields: record_date, tot_pub_debt_out_amt, debt_held_public_amt, intragov_holdings_amt. ⚠ Field names must be verified with --verify-fields before production ingest (API returning 404 as of 2026-08-20).
Treasury Fiscal Data API — MSPD Table 3 (Marketable)
Monthly, published ~11th-17th of following month. Full history ~180,000 rows (CUSIP-level). Requires pagination (max 10,000 rows/request). Taxonomy: MSPD class labels → normalized type via MSPD_TO_SOMA_TYPE in collect_treasury_debt.py.
Reconciliation — mspd_vs_penny
MSPD T3 SUM vs Debt to the Penny. Measured tolerance: up to $967,921 (known rounding + timing floor). Tolerance band sized from measured p99 of residuals, not assumption. Two-table design: reconciliation_status (overwritten) + reconciliation_events (append-only, status-change only).
Note on Debt Components
Total = Debt Held by Public + Intragovernmental Holdings. Debt Held by Public includes Fed holdings (SOMA) + private sector + foreign official. The Fed share is tracked on the Fed Holdings page. TIPS outstanding_amt excludes inflation accrual; inflation_adj_amt tracks the accreted value separately.
Source: Treasury Fiscal Data API · DB: rates.db · Tables: treasury_debt_daily, treasury_debt_securities, treasury_debt_composition, reconciliation_status
· Plan:
fed-holdings-treasury-debt-cards.md