Failed Banks Data With Balance Sheet

Banks Data with Balance Sheet which have failed since 2000-2023

@kaggle.utkarshx27_failed_banks_database

Table List

1 table(51.29 KB)

Balancesheetsummaries Xls

@kaggle.utkarshx27_failed_banks_database.balancesheetsummaries_xls

51.29 KB
117 rows
40 columns

fund_code Fund Code	receivership Receivership	year Year	quarter Quarter	failure_date Failure Date	cash_and_investments Cash And Investments	total_assets Total Assets	administrative_liabilities Administrative Liabilities	fdic_subrogated_deposit_claim FDIC Subrogated Deposit Claim	uninsured_deposit_claims Uninsured Deposit Claims	other_claimant_liabilities Other Claimant Liabilities	net_worth_deficit Net Worth (Deficit)	total_liabilities_and_net_worth Total Liabilities And Net Worth	fdic_subrogated_claim FDIC Subrogated Claim	fdic_subrogated_claim_34ce90 FDIC Subrogated Claim %	uninsured_depositors Uninsured Depositors	uninsured_depositors_f3e5aa Uninsured Depositors %	subtotal_proven_deposit_claims Subtotal - Proven Deposit Claims	subtotal_proven_deposit_claims_55cac0 Subtotal - Proven Deposit Claims %	dividends_paid_to_date Dividends Paid To Date	dividends_paid_to_date_3907e8 Dividends Paid To Date %	total_unpaid_deposit_claims Total Unpaid Deposit Claims	total_unpaid_deposit_claims_9ba507 Total Unpaid Deposit Claims %	general_creditor General Creditor	general_creditor_99f4f9 General Creditor %	subordinated_debt_holders Subordinated Debt Holders	subordinated_debt_holders_9eb27f Subordinated Debt Holders %	subtotal_other_claimants Subtotal- Other Claimants	subtotal_other_claimants_c83ae1 Subtotal- Other Claimants %	total_unpaid_other_claimants Total Unpaid Other Claimants	total_unpaid_other_claimants_2a6240 Total Unpaid Other Claimants %
10538	ALMENA STATE BANK	2023	Q1	10/23/2020	2785	2785		18804		338	-16357	2785	62525	100			62525	100	43721	70	18804	30	338	100			338	100	338	100
10218	AMCORE BANK, NA	2023	Q1	4/23/2010	13944	13944	5350	28364		57986	-77756	13944	2774841	100			2774841	100	2746477	99	28364	1	7842	14	50144	86	57986	100	57986	100
10057	AMERICA WEST BANK	2023	Q1	05-01-2009	1006	1006	1	115386		1097	-115478	1006	300153	100			300153	100	184767	62	115386	38	1097	100			1097	100	1097	100
10053	AMERICAN SOUTHERN BANK	2023	Q1	4/24/2009	2456	2456		35341		232	-33117	2456	108754	100			108754	100	73412	68	35342	32	232	100			232	100	232	100
10155	AMTRUST BANK	2023	Q1	12-04-2009	14112	14112	5352	1710251		25727	-1727218	14112	8140511	100			8140511	100	6430260	79	1710251	21	25727	100			25727	100	25727	100
10369	ATLANTIC BANK & TRUST	2023	Q1	06-03-2011	1018	1018		32263		33	-31278	1018	183489	100			183489	100	151226	82	32263	18	33	100			33	100	33	100
10380	BANK OF CHOICE	2023	Q1	7/22/2011	1144	1144	1	136766		860	-136483	1144	810294	100			810294	100	673528	83	136766	17	860	100			860	100	860	100
10029	BANK OF CLARK COUNTY	2023	Q1	1/16/2009	2520	2520	72	153157	10097	779	-161585	2520	316017	94	20834	6	336851	100	173597	52	163254	48	779	100			779	100	779	100
10064	BANK OF LINCOLNWOOD	2023	Q1	06-05-2009	3013	3013		74049		513	-71549	3013	203223	100			203223	100	129174	64	74049	36	513	100			513	100	513	100
10396	BANK OF THE COMMONWEALTH	2023	Q1	9/23/2011	5166	5166	9	244078		1673	-240594	5166	861854	100			861854	100	617776	72	244078	28	1673	100			1673	100	1673	100


CREATE TABLE balancesheetsummaries_xls (
  "fund_code" VARCHAR,
  "receivership" VARCHAR,
  "year" DOUBLE,
  "quarter" VARCHAR,
  "failure_date" VARCHAR,
  "cash_and_investments" DOUBLE,
  "due_from_fdic_corp_and_receivables" DOUBLE,
  "assets_in_liquidation" DOUBLE,
  "estimated_loss_on_assets_in_liquidation_1" DOUBLE,
  "total_assets" DOUBLE,
  "administrative_liabilities" DOUBLE,
  "fdic_subrogated_deposit_claim" DOUBLE,
  "uninsured_deposit_claims" DOUBLE,
  "other_claimant_liabilities" DOUBLE,
  "unproven_claims" DOUBLE,
  "total_liabilities_2" VARCHAR,
  "net_worth_deficit" DOUBLE,
  "total_liabilities_and_net_worth" DOUBLE,
  "fdic_subrogated_claim" DOUBLE,
  "fdic_subrogated_claim_34ce90" DOUBLE,
  "uninsured_depositors" DOUBLE,
  "uninsured_depositors_f3e5aa" DOUBLE,
  "subtotal_proven_deposit_claims" DOUBLE,
  "subtotal_proven_deposit_claims_55cac0" DOUBLE,
  "dividends_paid_to_date" DOUBLE,
  "dividends_paid_to_date_3907e8" DOUBLE,
  "total_unpaid_deposit_claims" DOUBLE,
  "total_unpaid_deposit_claims_9ba507" DOUBLE,
  "general_creditor" DOUBLE,
  "general_creditor_99f4f9" DOUBLE,
  "senior_debt_holders" DOUBLE,
  "senior_debt_holders_556944" DOUBLE,
  "subordinated_debt_holders" DOUBLE,
  "subordinated_debt_holders_9eb27f" DOUBLE,
  "subtotal_other_claimants" DOUBLE,
  "subtotal_other_claimants_c83ae1" DOUBLE,
  "dividends_paid_to_date_other_claimants" DOUBLE,
  "dividends_paid_to_date_other_claimants_9fbf1e" DOUBLE,
  "total_unpaid_other_claimants" DOUBLE,
  "total_unpaid_other_claimants_2a6240" DOUBLE
);