Name: Commercial Bank Failures, 1934-Present
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Commercial Bank Failures, 1934-Present

Content

This report lists each failure of a commercial bank, savings association, and savings bank since the establishment of the FDIC in 1933. Each record includes the institution name and FIN number, institution and charter types, location of headquarters (city and state), effective date, insurance fund and certificate number, failure transaction type, total deposits and total assets last reported prior to failure (in thousands of dollars), and the estimated cost of resolution. Data on estimated losses are not available for FDIC insured failures prior to 1986 or for FSLIC insured failures from 1934-88.

Acknowledgements

The bank failure report was downloaded from the FDIC website.

Inspiration

What type of banking institution is the most likely to fail? How have bank failure rates changed over time? What commercial bank failure cost the federal government the most to resolve?

Tables

Banks

@kaggle.fdic_bank_failures.banks

190.96 kB
3,484 rows
12 columns

CREATE TABLE banks (
  "financial_institution_number" DOUBLE,
  "institution_name" VARCHAR,
  "institution_type" VARCHAR,
  "charter_type" VARCHAR,
  "headquarters" VARCHAR,
  "failure_date" VARCHAR,
  "insurance_fund" VARCHAR,
  "certificate_number" DOUBLE,
  "transaction_type" VARCHAR,
  "total_deposits" BIGINT,
  "total_assets" DOUBLE,
  "estimated_loss_2015" DOUBLE  -- Estimated Loss (2015)
);