Datadory notebook
Fdic Failed Bank List Csv Data: Dataset Structure and Field Coverage
Datadory delivers fdic failed bank list csv data covering comprehensive field definitions, entity mappings, and historical time series — structured for direct analytics and delivered on demand.
1,744 datasets. Pick your catch.
What fields does each row of the CSV carry?
Seven columns, all at the institution level: Bank Name, City, State, Cert, Acquiring Institution, Closing Date and Fund. Cert is the FDIC certificate number that also keys every other regulator file — the same FDIC certificate number joins BankFind Suite records, third-party branch pages and historical financial series stored per cert. Closing Date arrives in dd-Mon-yy form, and Fund is the insurance fund sequence number assigned to the resolution. The two newest rows in the reviewed snapshot show exactly what a record looks like: Small Business Bank of Lenexa, Kansas (cert 25744), acquired by The Farmers State Bank of Oakley, Kansas, closed 17-Jul-26 under fund 10553; and Kentland Federal Savings and Loan Association of Kentland, Indiana (cert 28722), acquired by Kentland Bank, closed 10-Jul-26 under fund 10552. An acquiring institution can be blank when no acquirer assumed the deposits.
Which datasets pair with the failed bank list?
In working order, three pairings earn their place:
The bank failure receivership list entry defines the resolution vocabulary these sources share, and the side-by-side scorecard comparing the failed bank list with the Fed H.8 breaks down where one-row-per-event data beats one-column-per-week aggregates.
| Column | Type | What it holds |
|---|---|---|
| Bank Name | string | Name of the failed institution |
| City | string | City where the failed bank was headquartered |
| State | string | Two-letter state abbreviation |
| Cert | integer | FDIC certificate number of the failed bank — the join key to other regulator data |
| Acquiring Institution | string | Institution that assumed the failed bank's deposits and assets; blank if none |
| Closing Date | date | Date the bank was closed and placed into receivership (dd-Mon-yy in the CSV) |
| Fund | integer | Insurance fund sequence number assigned to the resolution |
Pick up where this leaves off
Every one of these ships with sample rows before you commit to anything.
FDIC Failed Bank List — Every U.S. Bank Failure Since 2000
City · State · Cert …+1 more
FDIC BankFind Suite — Every Insured Institution, One Cert Key
NAME · CERT · LEI …+12 more
OCC — Office of the Comptroller of the Currency
Federal Reserve H.8 — Assets and Liabilities of Commercial Banks
Borrowings
Want rows instead of a pitch? Name the datasets.
API, files, or your warehouse. Daily, weekly, or hourly.
Get a sampleQuestions worth asking
Does the FDIC failed bank list cover failures before 2000?
No. The list begins at October 1, 2000 and holds about 577 rows as of July 2026, one per failed institution. Failures before that date live in other FDIC historical publications rather than this CSV, so pre-2000 research means consulting those archives and cannot be spliced onto this file naively.