FDIC Failed Bank Dataset
This data set contains the fdic public data on fdic institutions.
@kaggle.ronmallory_fdic_failed_bank_dataset
Failure Properties
@kaggle.ronmallory_fdic_failed_bank_dataset.failure_properties
- 13.04 KB
- 15 rows
- 4 columns
nameName | titleTitle | descriptionDescription | typeType |
|---|---|---|---|
| NAME | Institution Name | This is the legal name of the institution. When available, the Institution's name links to useful information for the customers and vendors of these institutions. This information includes press releases, information about the acquiring institution, (if applicable), how your accounts and loans are a… | string |
| CERT | Cert | The certificate number assigned by the FDIC used to identify institutions and for the issuance of insurance certificates. By clicking on this number, you will link to the Institution Directory (ID) system which will provide the last demographic and financial data filed by the selected institution. | string |
| FIN | FIN | Financial Institution Number (FIN) is a unique number assigned to the institution as an Assistance Agreement, Conservatorship, Bridge Bank or Receivership. | string |
| CITYST | Location | The city and state (or territory) of the headquarters of the institution. | string |
| FAILDATE | Effective Date | The date that the failed / assisted institution ceased to exist as a privately held going concern. For institutions that entered into government ownership, such as FDIC Bridge Banks and RTC conservatorships, this is the date that they entered into such ownership. | string |
| FAILYR | Year | The 4-digit year that the failed / assisted institution ceased to exist as a privately held going concern. For institutions that entered into government ownership, such as FDIC Bridge Banks and RTC conservatorships, this is the date that they entered into such ownership. | string |
| SAVR | Insurance Fund | Before 1989, there were two federal deposit insurance funds, one administered by the FDIC, which insured deposits in commercial banks and state-chartered savings banks, and another administered by the Federal Savings and Loan Insurance Corporation (FSLIC), which insured deposits in state- and federa… | string |
| RESTYPE1 | Transaction Type | Institutions have been resolved through several different types of transactions. The transaction types outlined below can be grouped into three general categories, based upon the method employed to protect insured depositors and how each transaction affects a failed / assisted institution's charter.… | string |
| CHCLASS1 | Charter Class | The FDIC assigns classification codes indicating an institution's charter type (commercial bank, savings bank, or savings association), its chartering agent (state or federal government), its Federal Reserve membership status (member or nonmember), and its primary federal regulator (state-chartered … | string |
| RESDATE | Date of Resolution | Date of Resolution. Usually the same as the fail date, except with banks with Open Bank Assistance. | string |
CREATE TABLE failure_properties (
"name" VARCHAR,
"title" VARCHAR,
"description" VARCHAR,
"type" VARCHAR
);