Failed Bank List

Comprehensive List of Banks That Have Failed by the FDIC S Since October 1, 2000

@kaggle.umairhayat_false_bank_list

Table List

1 table(30.9 KB)

Failed Bank List

@kaggle.umairhayat_false_bank_list.failed_bank_list

30.9 KB
569 rows
7 columns

bank_name Bank Name	city City	state State	cert Cert	acquiring_institution Acquiring Institution	closing_date Closing Date	fund Fund
Republic First Bank dba Republic Bank	Philadelphia	PA	27332	Fulton Bank, National Association	26-Apr-24	10546
Citizens Bank	Sac City	IA	8758	Iowa Trust & Savings Bank	3-Nov-23	10545
Heartland Tri-State Bank	Elkhart	KS	25851	Dream First Bank, N.A.	28-Jul-23	10544
First Republic Bank	San Francisco	CA	59017	JPMorgan Chase Bank, N.A.	1-May-23	10543
Signature Bank	New York	NY	57053	Flagstar Bank, N.A.	12-Mar-23	10540
Silicon Valley Bank	Santa Clara	CA	24735	FirstCitizens Bank & Trust Company	10-Mar-23	10539
Almena State Bank	Almena	KS	15426	Equity Bank	23-Oct-20	10538
First City Bank of Florida	Fort Walton Beach	FL	16748	United Fidelity Bank, fsb	16-Oct-20	10537
The First State Bank	Barboursville	WV	14361	MVB Bank, Inc.	3-Apr-20	10536
Ericson State Bank	Ericson	NE	18265	Farmers and Merchants Bank	14-Feb-20	10535


CREATE TABLE failed_bank_list (
  "bank_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "cert" BIGINT,
  "acquiring_institution" VARCHAR,
  "closing_date" VARCHAR,
  "fund" BIGINT
);