FDIC Failed Bank Dataset

This data set contains the fdic public data on fdic institutions.

@kaggle.ronmallory_fdic_failed_bank_dataset

Table List

2 tables(386.91 KB)

Bank Failures

@kaggle.ronmallory_fdic_failed_bank_dataset.bank_failures

373.87 KB
4110 rows
33 columns

resdate RESDATE	qbfdep QBFDEP	bidcity BIDCITY	bidstate BIDSTATE	closcd CLOSCD	pstalp PSTALP	bstatus BSTATUS	comments COMMENTS	cityst CITYST	restype RESTYPE	costmostrecentasof COSTMOSTRECENTASOF	url URL	ptrdate PTRDATE	cost COST	qbfasset QBFASSET	termi TERMI	failyr FAILYR	chclass CHCLASS	fund FUND	bidname BIDNAME	fin FIN	faildate FAILDATE	savr SAVR	restype1 RESTYPE1	name NAME	chclass1 CHCLASS1	fsl_prog FSL PROG	city CITY	cert CERT	brdate BRDATE	id ID
Fri Apr 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	4373927	LANCASTER	PA	TASNN	PA	A	nan	PHILADELPHIA, PA	FAILURE	30JUN2024	nan	nan	667138	5866190	nan	2024	NM	1	FULTON BANK, NATIONAL ASSOCIATION	10546	Fri Apr 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	BIF	PA	REPUBLIC BANK	NM	nan	PHILADELPHIA	27332	nan	4110
Fri Nov 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	52311	EMMETSBURG	IA	PASAN	IA	A	nan	SAC CITY, IA	FAILURE	30JUN2024	nan	nan	14517	60448	nan	2023	NM	5	IOWA TRUST & SAVINGS BANK	10545	Fri Nov 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	DIF	PA	CITIZENS BANK	NM	nan	SAC CITY	8758	nan	4109
Fri Jul 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	130110	SYRACUSE	KS	TABAN	KS	A	nan	ELKHART, KS	FAILURE	30JUN2024	nan	nan	54136	139446	nan	2023	SM	5	DREAM FIRST BANK,NATIONAL ASSOCIATION	10544	Fri Jul 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	DIF	PA	HEARTLAND TRI-STATE BANK	SM	nan	ELKHART	25851	nan	4108
Mon May 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	176436706	COLUMBUS	OH	TASNN	CA	A	nan	SAN FRANCISCO, CA	FAILURE	30JUN2024	nan	nan	16339120	212638872	nan	2023	NM	5	JPMORGAN CHASE BANK, N.A.	10543	Mon May 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	DIF	PA	FIRST REPUBLIC BANK	NM	nan	SAN FRANCISCO	59017	nan	4107
Mon Mar 20 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	88612911	HICKSVILLE	NY	PASNN	NY	A	LCT not performed. DRR will provide data when available. Signature Bridge Bank, N.A. (59332) created with FIN 10541.	NEW YORK, NY	FAILURE	30JUN2024	nan	nan	2815579	110363650	nan	2023	NM	5	FLAGSTAR BANK, N.A.	10540	Sun Mar 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	DIF	PA	SIGNATURE BANK	NM	nan	NEW YORK	57053	nan	4106
Sun Mar 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	175378000	RALEIGH	NC	DTBNA	CA	A	LCT not performed. DRR will provide data when available. Silicon Valley Bank to Silicon Valley Bridge Bank (59334)created with FIN 10542.	SANTA CLARA, CA	FAILURE	30JUN2024	nan	nan	19630266	209026000	nan	2023	SM	5	FIRST-CITIZENS BANK & TRUST COMPANY	10539	Tue Mar 07 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	DIF	PA	SILICON VALLEY BANK	SM	nan	SANTA CLARA	24735	nan	4105
Fri Oct 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	64941	ANDOVER	KS	TASAN	KS	I	nan	ALMENA, KS	FAILURE	30JUN2024	https://www.fdic.gov/news/press-releases/2020/pr20119.html	nan	15861	65733	T	2020	NM	5	EQUITY BANK	10538	Fri Oct 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DIF	PA	ALMENA STATE BANK	NM	nan	ALMENA	15426	nan	4104
Fri Oct 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	133936	EVANSVILLE	IN	TASNN	FL	I	nan	FORT WALTON BEACH, FL	FAILURE	30JUN2024	https://www.fdic.gov/news/press-releases/2020/pr20112.html	nan	7247	136566	T	2020	NM	5	UNITED FIDELITY BANK, FSB	10537	Fri Oct 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DIF	PA	FIRST CITY BANK OF FLORIDA	NM	nan	FORT WALTON BEACH	16748	nan	4103
Fri Apr 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	143102	FAIRMONT	WV	TASNN	WV	A	nan	BARBOURSVILLE, WV	FAILURE	30JUN2024	https://www.fdic.gov/news/news/press/2020/pr20046.html	nan	43793	151808	nan	2020	NM	5	MVB BANK, INC	10536	Fri Apr 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DIF	PA	THE FIRST STATE BANK	NM	nan	BARBOURSVILLE	14361	nan	4102
Fri Feb 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	95159	MILFORD	NE	PASAN	NE	I	nan	ERICSON, NE	FAILURE	30JUN2024	https://www.fdic.gov/news/news/press/2020/pr20011.html	nan	23279	100879	T	2020	NM	5	FARMERS AND MERCHANTS BANK	10535	Fri Feb 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DIF	PA	ERICSON STATE BANK	NM	nan	ERICSON	18265	nan	4101


CREATE TABLE bank_failures (
  "resdate" TIMESTAMP,
  "qbfdep" DOUBLE,
  "bidcity" VARCHAR,
  "bidstate" VARCHAR,
  "closcd" VARCHAR,
  "pstalp" VARCHAR,
  "bstatus" VARCHAR,
  "comments" VARCHAR,
  "cityst" VARCHAR,
  "restype" VARCHAR,
  "costmostrecentasof" VARCHAR,
  "url" VARCHAR,
  "ptrdate" VARCHAR,
  "cost" DOUBLE,
  "qbfasset" DOUBLE,
  "uninsdep" DOUBLE,
  "termi" VARCHAR,
  "failyr" BIGINT,
  "chclass" VARCHAR,
  "fund" BIGINT,
  "bankno" DOUBLE,
  "bidname" VARCHAR,
  "fin" BIGINT,
  "faildate" TIMESTAMP,
  "savr" VARCHAR,
  "restype1" VARCHAR,
  "name" VARCHAR,
  "chclass1" VARCHAR,
  "fsl_prog" VARCHAR,
  "city" VARCHAR,
  "cert" DOUBLE,
  "brdate" VARCHAR,
  "id" BIGINT
);