US bankruptcy-court filing distress intelligence (quarterly)

Name: US bankruptcy-court filing distress intelligence (quarterly)
Creator: Administrative Office of the U.S. Courts
License: https://www.uscourts.gov/
Keywords: us, bankruptcy, insolvency, credit, risk, quarterly, signals, rankings, finance, macroeconomics

Commercial use OKFresh

Query in workbench

The full snapshot isn't published yet — check back after the next refresh.Download sample CSV Download sample JSONSample rows only (up to 20) — not the complete dataset.

Quarterly district-level bankruptcy filing distress intelligence from the Administrative Office of the U.S. Courts' Table F-2 (business and nonbusiness cases commenced, by chapter of the Bankruptcy Code, circuit and district): 93 federal judicial districts x 6 quarters (2025-Q1..2026-Q2 at launch, extending quarterly), with raw filing counts (total/business/nonbusiness x chapter 7/11/13/other), business and chapter-11 shares, quarter-over-quarter and year-over-year momentum, a trailing 4-quarter z-score, a documented 0-100 distress score with per-quarter ranks and quartile tiers, and filing-surge / chapter-11-spike flags. Join keys: quarter_start (ISO date) and state_code/state_name. Useful as a credit-risk, small-business churn, and household-distress prediction feature.

Source: Administrative Office of the U.S. Courts
Rows: 558
Columns: 35
Source cadence: Quarterly
Last refreshed: Sep 29, 2026
Theme: economy

Column	Type	Description
quarter	string	Reference quarter as YYYY-QN (e.g. 2026-Q2), matching the Table F-2 '3-month period ending <quarter-end>'. Primary time join key with quarter_start. (unit: quarter)
quarter_start	string	First day of the reference quarter, ISO date. Joinable with any ISO-date series. (unit: ISO date)
country_code	string	ISO alpha-3 country code (USA for every row). (unit: ISO 3166-1 alpha-3)
district_code	string	Federal judicial district code as printed in Table F-2 (e.g. NY,N = Northern District of New York; AR = the combined Eastern+Western Districts of Arkansas; NMI = Northern Mariana Islands). Primary geography join key with quarter. (unit: district code)
district_name	string	Deterministic official-style district name derived from the district code (e.g. 'New York, Northern District').
state_code	string	USPS state/territory abbreviation of the district (prefix of district_code; NMI stays NMI). Join key for state-level rollups. (unit: USPS)
state_name	string	Official state/territory name for state_code.
filings_total	integer	Total bankruptcy cases commenced in the district during the quarter (business + nonbusiness), as published. (unit: count)
filings_business	integer	Business bankruptcy cases commenced in the quarter, as published. (unit: count)
filings_nonbusiness	integer	Nonbusiness (household/consumer) cases commenced in the quarter, as published. (unit: count)
ch7_total	integer	Chapter 7 filings in the quarter. (unit: count)
ch11_total	integer	Chapter 11 filings in the quarter. (unit: count)
ch13_total	integer	Chapter 13 filings in the quarter. (unit: count)
other_total	integer	Filings under chapters other than 7/11/13 (chapters 9, 12, 15), as published. (unit: count)
biz_ch7	integer	Business chapter 7 filings. (unit: count)
biz_ch11	integer	Business chapter 11 filings. (unit: count)
biz_ch13	integer	Business chapter 13 filings. (unit: count)
nb_ch7	integer	Nonbusiness chapter 7 filings. (unit: count)
nb_ch11	integer	Nonbusiness chapter 11 filings. (unit: count)
nb_ch13	integer	Nonbusiness chapter 13 filings. (unit: count)
business_share	float	Share of the quarter's filings that are business cases (filings_business / filings_total). Null when the district had zero filings. (unit: share 0-1)
ch11_share_total	float	Share of the quarter's filings under chapter 11. Null when the district had zero filings. (unit: share 0-1)
biz_ch11_share	float	Share of business filings under chapter 11 (reorganization). Null when the district had zero business filings. (unit: share 0-1)
filings_qoq_pct	float	Quarter-over-quarter percent change of filings_total. Null in the first quarter; null when the base quarter had zero filings (undefined). (unit: percent)
filings_yoy_pct	float	Year-over-year percent change of filings_total: the primary momentum lens. Null in the first four quarters; null when the base quarter had zero filings. (unit: percent)
business_qoq_pct	float	Quarter-over-quarter percent change of filings_business. Null in the first quarter / off a zero base. (unit: percent)
business_yoy_pct	float	Year-over-year percent change of filings_business. Null in the first four quarters / off a zero base. (unit: percent)
filings_z_4q	float	Z-score of filings_total versus the district's own trailing-4-quarter mean/std (inclusive, minimum 4 observations). Positive = unusually hot versus its own recent year; null on zero-variance windows. (unit: z-score)
distress_score	float	Documented 0-100 composite: 100 * (0.35 * min-max(business_share) + 0.35 * min-max(biz_ch11_share) + 0.30 * min-max(winsorized filings_yoy_pct, -50..100)), min-maxed within each quarter across the 93 districts. Higher = more bankruptcy distress versus peers this quarter. Null components contribute 0.5. (unit: 0-100 score)
distress_rank	integer	Per-quarter rank of distress_score across the 93 districts (1 = most distressed). (unit: rank)
distress_tier	string	Quartile bucket of distress_score within the quarter: d1 (least distressed) .. d4 (most distressed). (unit: tier)
filing_surge_flag	integer	1 when filings_yoy_pct >= 25% (sharp yearly filing surge). (unit: binary)
ch11_spike_flag	integer	1 when biz_ch11_share >= 0.20 AND biz_ch11 >= 3 (material chapter-11 reorganization wave). (unit: binary)
source_url	string	Exact Table F-2 PDF URL the row was parsed from. (unit: URL)
row_hash	string	Deterministic 16-hex row hash of district_code + quarter (idempotency).

First 10 sample rows — a preview, not the complete dataset.

quarter	quarter_start	country_code	district_code	district_name	state_code	state_name	filings_total	filings_business	filings_nonbusiness	ch7_total	ch11_total	ch13_total	other_total	biz_ch7	biz_ch11	biz_ch13	nb_ch7	nb_ch11	nb_ch13	business_share	ch11_share_total	biz_ch11_share	filings_qoq_pct	filings_yoy_pct	business_qoq_pct	business_yoy_pct	filings_z_4q	distress_score	distress_rank	distress_tier	ch11_spike_flag	source_url	row_hash
2025-Q1	2025-01-01	USA	AK	Alaska	AK	Alaska	47	3	44	29	2	16	0	1	2	0	28	0	16	0.064	0.043	0.667	—	—	—	—	—	40.567	5	d4	0	https://www.uscourts.gov/sites/default/files/document/bf_f2.3_0331.2025.pdf	4e4d3f687661da1e
2025-Q1	2025-01-01	USA	AL,M	Alabama, Middle District	AL	Alabama	1,523	11	1,512	278	5	1,240	0	5	4	2	273	1	1,238	0.007	0.003	0.364	—	—	—	—	—	27.98	33	d3	1	https://www.uscourts.gov/sites/default/files/document/bf_f2.3_0331.2025.pdf	17f6a1ea5ac355e9
2025-Q1	2025-01-01	USA	AL,N	Alabama, Northern District	AL	Alabama	2,515	33	2,482	1,022	9	1,483	1	19	9	4	1,003	0	1,479	0.013	0.004	0.273	—	—	—	—	—	25.005	49	d2	1	https://www.uscourts.gov/sites/default/files/document/bf_f2.3_0331.2025.pdf	b8c0bf6717a9e112
2025-Q1	2025-01-01	USA	AL,S	Alabama, Southern District	AL	Alabama	958	16	942	207	7	744	0	9	7	0	198	0	744	0.017	0.007	0.438	—	—	—	—	—	30.897	19	d4	1	https://www.uscourts.gov/sites/default/files/document/bf_f2.3_0331.2025.pdf	b03bea95f9ef245f
2025-Q1	2025-01-01	USA	AR	Arkansas	AR	Arkansas	1,695	57	1,638	712	15	965	3	39	12	3	673	3	962	0.034	0.009	0.211	—	—	—	—	—	23.545	55	d2	1	https://www.uscourts.gov/sites/default/files/document/bf_f2.3_0331.2025.pdf	9819946e7df954b7
2025-Q1	2025-01-01	USA	AZ	Arizona	AZ	Arizona	2,877	110	2,767	2,330	41	505	1	67	39	3	2,263	2	502	0.038	0.014	0.355	—	—	—	—	—	28.747	30	d3	1	https://www.uscourts.gov/sites/default/files/document/bf_f2.3_0331.2025.pdf	c70fd5cf0dbdba26
2025-Q1	2025-01-01	USA	CA,C	California, Central District	CA	California	6,632	454	6,178	5,531	124	977	0	330	109	15	5,201	15	962	0.068	0.019	0.24	—	—	—	—	—	25.799	43	d3	1	https://www.uscourts.gov/sites/default/files/document/bf_f2.3_0331.2025.pdf	23c7e721085c34de
2025-Q1	2025-01-01	USA	CA,E	California, Eastern District	CA	California	2,908	116	2,792	2,318	19	565	6	79	19	12	2,239	0	553	0.04	0.007	0.164	—	—	—	—	—	22.129	64	d2	0	https://www.uscourts.gov/sites/default/files/document/bf_f2.3_0331.2025.pdf	8c39cf1cc6e2d0b6
2025-Q1	2025-01-01	USA	CA,N	California, Northern District	CA	California	1,498	117	1,381	979	44	475	0	75	33	9	904	11	466	0.078	0.029	0.282	—	—	—	—	—	27.605	36	d3	1	https://www.uscourts.gov/sites/default/files/document/bf_f2.3_0331.2025.pdf	629d5b458c8cffcd
2025-Q1	2025-01-01	USA	CA,S	California, Southern District	CA	California	1,356	67	1,289	1,198	7	151	0	57	5	5	1,141	2	146	0.049	0.005	0.075	—	—	—	—	—	19.341	81	d1	0	https://www.uscourts.gov/sites/default/files/document/bf_f2.3_0331.2025.pdf	932ab5e81a1362e6

Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).

cURL

curl "https://datazimuts.com/v1/datasets/us_bankruptcy_filing_distress_intel/us_bankruptcy_filing_distress_quarterly" | jq '{title, rows, columns_count, license}'

Python

import requests

ds = requests.get("https://datazimuts.com/v1/datasets/us_bankruptcy_filing_distress_intel/us_bankruptcy_filing_distress_quarterly").json()
print(ds["title"], ds["rows"], "rows")

# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
    print(row)

API endpoint: https://datazimuts.com/v1/datasets/us_bankruptcy_filing_distress_intel/us_bankruptcy_filing_distress_quarterly

Tip: fetch /llms.txt for the full machine-readable catalog.

Cite this snapshot

Pinned to snapshot 20260929T154346Z-62bf652026ec and its content hash, so readers get exactly the data you used.

APA

Administrative Office of the U.S. Courts. (2026). US bankruptcy-court filing distress intelligence (quarterly) [Data set, snapshot 20260929T154346Z-62bf652026ec, sha256 62bf652026ec]. Datazimuts. Retrieved 2026-09-30, from https://datazimuts.com/en/datasets/us_bankruptcy_filing_distress_intel/us_bankruptcy_filing_distress_quarterly?snapshot=20260929T154346Z-62bf652026ec

BibTeX

@misc{dz_us_bankruptcy_filing_distress_intel_us_b_62bf6520,
  title        = {{US bankruptcy-court filing distress intelligence (quarterly)}},
  author       = {{Administrative Office of the U.S. Courts}},
  year         = {2026},
  publisher    = {Datazimuts},
  howpublished = {\url{https://datazimuts.com/en/datasets/us_bankruptcy_filing_distress_intel/us_bankruptcy_filing_distress_quarterly?snapshot=20260929T154346Z-62bf652026ec}},
  note         = {Snapshot 20260929T154346Z-62bf652026ec, sha256 62bf652026eca32400d7ff50d677adc3bd20a63a3aba85c6090326a561d38505; accessed 2026-09-30}
}

Embed a table or a chart

Paste this into any page. The embed is pinned to the same snapshot, follows the reader's light or dark setting, and always shows the source, license and a link back.

Type

X axis

Value

Aggregate

Theme

HTML

<iframe src="https://datazimuts.com/embed/chart?dataset=us_bankruptcy_filing_distress_intel%2Fus_bankruptcy_filing_distress_quarterly&lang=en&theme=auto&snapshot=20260929T154346Z-62bf652026ec&x=quarter&y=filings_total&agg=avg" title="US bankruptcy-court filing distress intelligence (quarterly)" width="100%" height="380" style="border:0" loading="lazy"></iframe>

US bankruptcy-court filing distress intelligence (quarterly)

Follow this dataset

Cite this snapshot

Embed a table or a chart

Use your own AI key