Description
Compare every FDIC-insured US bank quarter by quarter, and see which ones later failed. Call-report financials since 1984 are joined to each bank's location, regulator and holding company, and to the FDIC failed-bank list. Use the table to screen banks on capital, uninsured deposits or commercial real estate exposure, or to train and test a bank-failure model.
Dollar amounts are converted from the thousands FDIC reports into whole US dollars. Income figures are year to date, so the December row holds the full year.
Coverage
- Window: quarter ends from 1984-03-31 to the latest quarter FDIC has published.
- Grain: one row per bank (FDIC certificate number) per quarter.
- Cadence: FDIC publishes each quarter about two months after it ends. About 4,300 banks report in a recent quarter and about 18,000 reported in 1984.
Columns
cert,report_date: the bank's FDIC certificate number and the quarter-end date.bank_name,city,state,charter_class,holding_company_name,rssd_id,holding_company_rssd_id: identity as reported that quarter.state_name,county,zip_code,metro_area,latitude,longitude,primary_regulator,website,established_on,closed_on,is_active_today: the bank's current FDIC profile, repeated on every quarter.charter_class_name,specialization,size_tier: labels derived by rule from FDIC codes and total assets.total_assets_usd,total_deposits_usd,insured_deposits_usd,uninsured_deposits_usd,brokered_deposits_usd,total_equity_usdand the other_usdbalance columns: balance sheet amounts in US dollars.real_estate_loans_usd,commercial_real_estate_loans_usd,credit_card_loans_usdand related columns: the loan book by type.- Columns ending
_ytd_usd: income statement amounts for the year to date. return_on_assets_pct,return_on_equity_pct,net_interest_margin_pct,efficiency_ratio_pct,noncurrent_loans_pct,net_charge_off_rate_pct,cet1_ratio_pct,tier1_leverage_ratio_pct,total_capital_ratio_pct: FDIC's own ratios, in percent.uninsured_deposit_share_pct,brokered_deposit_share_pct,commercial_real_estate_to_equity_pct: shares derived here, in percent.failed_on,days_until_failure,failure_cost_usd: the failure date, the days from the report date to that failure, and FDIC's estimated resolution cost.
Other tables
bank_branch_deposits: every branch with its deposits each 30 June since 1994, and the bank's share of its county.bank_enforcement_actions: 4,210 enforcement actions by the OCC and the Federal Reserve, matched to the bank's certificate number.causecomes from the OCC's own subject list, or from a model reading the order itself for OCC actions since 2000, or the press release for Federal Reserve actions. Most Federal Reserve causes read "other or unclear". OCC orders before 2000 have no cause. FDIC's own orders are not included.
All tables join on cert.
Missing values
A figure the bank did not report, or that FDIC did not collect in that era, is null. Uninsured deposit estimates and some capital ratios are null in the early years. Banks that never failed have null failure columns, and open-bank assistance cases are not counted as failures.
Suitable for
- Screening banks by capital, funding mix, credit quality or loan concentration.
- Training and backtesting bank-failure and distress models, with
days_until_failureas the label. - Joining to other data by state, metro area, coordinates or Federal Reserve RSSD identifier.
Source and rights
Federal Deposit Insurance Corporation (FDIC) BankFind Suite: financials, institutions, failures and Summary of Deposits. Enforcement actions come from the OCC enforcement search and the Federal Reserve's enforcement list. The figures come from the quarterly Reports of Condition and Income (call reports) that banks file through the FFIEC. All are works of the US federal government.
Tables4
- Table healthStatus unavailablebank_branch_depositsTable overviewPublished rows2,898,836Columns25 rows30 Jun 1994 to 30 Jun 2026 · latest event 136 d before refresh · 33 anomaliesStatus unavailable
- Table healthStatus unavailablebank_enforcement_actionsTable overviewPublished rows4,210Columns19 rows11 Feb 1987 to 13 Oct 2026 · latest event 32 d before refresh · 6 anomaliesStatus unavailable
- Table healthStatus unavailablebank_quarter_financialsTable overviewPublished rows1,682,616Columns77 rows31 Mar 1984 to 30 Jun 2026 · latest event 136 d before refresh · 1 anomalyStatus unavailable
- Table healthStatus unavailablesource_enforcement_actionsTable overviewPublished rows4,210Columns18 rows11 Feb 1987 to 13 Oct 2026 · latest event 31 d before refresh · 6 anomaliesStatus unavailable
Sources
FDIC: Federal Deposit Insurance Corporation | FDIC.govThe FDIC is an independent agency created by Congress to maintain stability and public confidence in the nation's financial system.3 endpoints
The FDIC is an independent agency created by Congress to maintain stability and public confidence in the nation's financial system.
- Website
- api.fdic.gov ↗
- Usage rights
- Public domain asserted.
- Collection
- 13 requests across 3 endpoints
Collected endpoints
Details
- Contents
- 4 tables · 4,589,872 rows · 139 columns
- Category
- Finance
- Updated
- Published
- Version
- v1
- License
- Not stated
- Visibility
- Public
- Publisher
- Mostly Right
- Topics
- banks · fdic · call reports +4



