Loading dataset

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_usd and the other _usd balance columns: balance sheet amounts in US dollars.
  • real_estate_loans_usd, commercial_real_estate_loans_usd, credit_card_loans_usd and 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. cause comes 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_failure as 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 unavailable
    bank_branch_deposits
    Table overviewPublished rows2,898,836Columns25 rows30 Jun 1994 to 30 Jun 2026 · latest event 136 d before refresh · 33 anomalies
    Status unavailable
  • Table healthStatus unavailable
    bank_enforcement_actions
    Table overviewPublished rows4,210Columns19 rows11 Feb 1987 to 13 Oct 2026 · latest event 32 d before refresh · 6 anomalies
    Status unavailable
  • Table healthStatus unavailable
    bank_quarter_financials
    Table overviewPublished rows1,682,616Columns77 rows31 Mar 1984 to 30 Jun 2026 · latest event 136 d before refresh · 1 anomaly
    Status unavailable
  • Table healthStatus unavailable
    source_enforcement_actions
    Table overviewPublished rows4,210Columns18 rows11 Feb 1987 to 13 Oct 2026 · latest event 31 d before refresh · 6 anomalies
    Status 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.

Usage rights
Public domain asserted.
Collection
13 requests across 3 endpoints

Collected endpoints

Quarterly balance sheet, income and ratio figures each FDIC-insured bank filed in its call report./banks/financials11 requests
FDIC's current profile of every insured bank, active or closed: location, regulator and dates./banks/institutions1 request
FDIC's list of failed banks with the failure date and estimated resolution cost./banks/failures1 request

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

Activity

Views213+213 in the last 30 days
Likes0+0 in the last 30 days
Uses3+3 in the last 30 days

Support

Talk to Mostly Right

Loading chat…