Failed US Banks FDIC Data

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

@kaggle.neutrino404_failed_banks_fdic_data

Table List

1 table(42.07 KB)

Failed Bank Dataset 2

@kaggle.neutrino404_failed_banks_fdic_data.failed_bank_dataset_2

42.07 KB
566 rows
9 columns

bank_name Bank Name	city City	state State	cert Cert	acquiring_institution Acquiring Institution	closing_date Closing Date	estimated_loss Estimated Loss	total_assets Total Assets	total_deposits Total Deposits
First Republic Bank	San Francisco	CA	59017	JPMorgan Chase Bank, N.A.	Mon May 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)		212638872000	176436706000
Signature Bank	New York	NY	57053	Flagstar Bank, N.A.	Sun Mar 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2400000000	110363650000	88612911000
Silicon Valley Bank	Santa Clara	CA	24735	First–Citizens Bank & Trust Company	Fri Mar 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	16100000000	209026000000	175378000000
Almena State Bank	Almena	KS	15426	Equity Bank	Fri Oct 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	16330000	65733000	64941000
First City Bank of Florida	Fort Walton Beach	FL	16748	United Fidelity Bank, fsb	Fri Oct 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	7247000	136566000	133936000
The First State Bank	Barboursville	WV	14361	MVB Bank, Inc.	Fri Apr 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	45328000	151808000	143102000
Ericson State Bank	Ericson	NE	18265	Farmers and Merchants Bank	Fri Feb 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	24465000	100879000	95159000
City National Bank of New Jersey	Newark	NJ	21111	Industrial Bank	Fri Nov 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	2136000	120574000	111234000
Louisa Community Bank	Louisa	KY	58112	Kentucky Farmers Bank Corporation	Fri Oct 25 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	4264000	28163000	25174000
Resolute Bank	Maumee	OH	58317	Buckeye State Bank	Fri Oct 25 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1571000	23292000	22885000


CREATE TABLE failed_bank_dataset_2 (
  "bank_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "cert" BIGINT,
  "acquiring_institution" VARCHAR,
  "closing_date" TIMESTAMP,
  "estimated_loss" DOUBLE,
  "total_assets" BIGINT,
  "total_deposits" BIGINT
);