Commercial Bank Failures, 1934-Present

Every bank failure in the United States since the Great Depression

@kaggle.fdic_bank_failures

Table List

1 table(186.48 KB)

Banks

@kaggle.fdic_bank_failures.banks

186.48 KB
3484 rows
12 columns

institution_name Institution Name	institution_type Institution Type	charter_type Charter Type	headquarters Headquarters	failure_date Failure Date	insurance_fund Insurance Fund	transaction_type Transaction Type	total_deposits Total Deposits	total_assets Total Assets
BANK OF AMERICA TRUST CO.	COMMERCIAL BANK	STATE	PITTSBURGH, PA	4/19/1934	FDIC	PAYOUT	1064	1435
FON DU LAC STATE BANK	COMMERCIAL BANK	STATE	EAST PEORIA, IL	5/28/1934	FDIC	PAYOUT	238	374
FIRST NATIONAL BANK OF LIMA	COMMERCIAL BANK	FEDERAL	LIMA, MT	7/18/1934	FDIC	PAYOUT	42	91
FLORENCE DEPOSIT BANK	COMMERCIAL BANK	STATE	FLORENCE, IN	7/18/1934	FDIC	PAYOUT	69	105
BANK OF LEWISPORT	COMMERCIAL BANK	STATE	LEWISPORT, KY	8/6/1934	FDIC	PAYOUT	68	81
FARMERS STATE BANK OF BONGARDS	COMMERCIAL BANK	STATE	BONGARDS, MN	9/13/1934	FDIC	PAYOUT	73	91
FARMERS & TRADERS BANK	COMMERCIAL BANK	STATE	PORTERFIELD, WI	10/11/1934	FDIC	PAYOUT	32	46
PICKENS COUNTY BANK	COMMERCIAL BANK	STATE	JASPER, GA	10/13/1934	FDIC	PAYOUT	210	243
THE STATE BANK	COMMERCIAL BANK	STATE	SAUK CITY, WI	11/16/1934	FDIC	PAYOUT	170	195
CLIFFSIDE PARK TITLE GUARANTEE & TRUST CO.	COMMERCIAL BANK	STATE	GRANTWOOD, NJ	1/3/1935	FDIC	PAYOUT	590	2305


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
);