Baselight

Failed US Banks FDIC Data

Failed US banks from 2000-2023 including: Estimated loss,Closing date, etc...

@kaggle.neutrino404_failed_banks_fdic_data

About this Dataset

Failed US Banks FDIC Data

    Data was obtained from FDIC bank records API and the FDIC Bank List, combined and cleaned with Big Query SQL.  The data covers a range from October 1 2020  to  July 25 2023. 

Column Value Definitions

Bank_Name string This is the legal name of the institution. When available, the Institution's name links to useful information for the customers and vendors of these institutions. This information includes press releases, information about the acquiring institution, (if applicable), how your accounts and loans are affected, and how vendors can file claims against the receivership.

CERT string
The certificate number assigned by the FDIC used to identify institutions and for the issuance of insurance certificates.

CITY and STATE string

The city and state (or territory) of the headquarters of the institution.

Closing_Date (effective date) string

The date that the failed institution ceased to exist as a privately held going concern. For institutions that entered into government ownership, such as FDIC Bridge Banks and RTC conservatorships, this is the date that they entered into such ownership.

Total_Deposits number

Total including demand deposits, money market deposits, other savings deposits, time deposits and deposits in foreign offices as of the last Call Report or Thrift Financial Report filed by the institution prior to the effective date. Note this does not necessarily reflect total deposits on the last report filed because in some cases reports were filed after the effective date.

Total_Assets number

The total assets owned by the institution including cash, loans, securities, bank premises and other assets as of the last Call Report or Thrift Financial Report filed by the institution prior to the effective date. Note this does not necessarily reflect total assets on the last report filed because in some cases reports were filed after the effective date. This total does not include off-balance-sheet accounts.

Acquiring_Institution string

When a bank fails and is closed by regulators, the FDIC is responsible for managing the resolution process. In many cases, the FDIC will find another healthy financial institution to take over the failed bank's operations. This acquiring institution, often referred to as the "acquirer," assumes the assets and liabilities of the failed bank and continues to serve the bank's customers.

Estimated_Loss number

The estimated loss is the difference between the amount disbursed from the Deposit Insurance Fund (DIF) to cover obligations to insured depositors and the amount estimated to be ultimately recovered from the liquidation of the receivership estate. Estimated losses reflect unpaid principal amounts deemed unrecoverable and do not reflect interest that may be due on the DIF's administrative or subrogated claims should its principal be repaid in full. Notes: Comprehensive data on estimated losses are not available for FDIC-insured failures prior to 1986, or for FSLIC-insured failures from 1934-88. Estimated loss is presented as "N/A" in years for which comprehensive information is not available. Estimated Loss data was previously referred to as 'Estimated Cost' in past releases of the Historical Statistic on Banking. For RTC receiverships, the 'Estimated Cost' included an allocation of FDIC corporate revenue and expense items such as interest expense on Federal Financing Bank debt, interest expense on escrowed funds and interest revenue on advances to receiverships. Other FDIC receiverships did not include such an allocation. To maintain consistency with FDIC receiverships, the RTC allocation is no longer reflected in the estimated loss amounts for failed / assisted institutions that were resolved through RTC receiverships. Beginning with the release of 2007 information, the 'Estimated Loss' in the Historical Statistics on Banking is presented and defined consistently with the aggregate Estimated Receivership Loss for FRF-RTC institutions and Estimated Losses for FDIC receiverships that are reported in the FDIC's Annual Report. The estimated loss is obtained from the FDIC's Failed Bank Cost Analysis (FBCA) report and the RTC Loss report. The FBCA provides data for receiverships back to 1986. The RTC Loss Report provides similar data back to 1989. Questions regarding Estimated Loss should be sent to DOFBusinessCenter@fdic.gov. Also, for more detail regarding resolution transactions and the FDIC's receivership activities, see Managing the Crisis: The FDIC and RTC Experience, a historical study prepared by the FDIC's Division of Resolutions and Receiverships. Copies are available from the FDIC's Public Information Center.

*information obtained from FDIC data documentation

Share link

Anyone who has the link will be able to view this.