Name: FDIC-insured Financial Institutions
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

FDIC-insured Financial Institutions

This dataset provides a listing of FDIC-insured financial institutions. The FDIC-insured financial institutions dataset is a comprehensive listing of all financial institutions in the United States that are insured by the Federal Deposit Insurance Corporation (FDIC). The dataset includes information on more than 5,000 banks, savings associations, and other financial institutions that offer deposit accounts to consumers and businesses.

Tables

Institutions

@kaggle.utkarshx27_fdic_insured_financial_institutions.institutions

5.28 MB
27,819 rows
142 columns

CREATE TABLE institutions (
  "stname" VARCHAR,
  "cert" BIGINT,
  "docket" BIGINT,
  "active" BIGINT,
  "address" VARCHAR,
  "asset" DOUBLE,
  "bkclass" VARCHAR,
  "changec1" DOUBLE,
  "changec2" DOUBLE,
  "changec3" DOUBLE,
  "changec4" DOUBLE,
  "changec5" DOUBLE,
  "changec6" DOUBLE,
  "changec7" DOUBLE,
  "changec8" DOUBLE,
  "changec9" DOUBLE,
  "changec10" DOUBLE,
  "changec11" DOUBLE,
  "changec12" DOUBLE,
  "changec13" DOUBLE,
  "changec14" DOUBLE,
  "changec15" DOUBLE,
  "charter" BIGINT,
  "chrtagnt" VARCHAR,
  "conserve" VARCHAR,
  "city" VARCHAR,
  "clcode" BIGINT,
  "cmsa_no" BIGINT,
  "cmsa" VARCHAR,
  "county" VARCHAR,
  "dateupdt" TIMESTAMP,
  "denovo" DOUBLE,
  "dep" DOUBLE,
  "effdate" TIMESTAMP,
  "endefymd" VARCHAR,
  "eq" DOUBLE,
  "estymd" TIMESTAMP,
  "fdicdbs" BIGINT,
  "fdicregn" VARCHAR,
  "fdicsupv" VARCHAR,
  "fed" BIGINT,
  "fed_rssd" BIGINT,
  "fedchrtr" BIGINT,
  "fldoff" VARCHAR,
  "iba" BIGINT,
  "inactive" BIGINT,
  "insagnt1" VARCHAR,
  "insagnt2" VARCHAR,
  "insdate" VARCHAR,
  "instcrcd" DOUBLE,
  "insbif" BIGINT,
  "inscoml" BIGINT,
  "insdif" BIGINT,
  "insfdic" BIGINT,
  "inssaif" BIGINT,
  "inssave" BIGINT,
  "msa_no" BIGINT,
  "msa" VARCHAR,
  "name" VARCHAR,
  "newcert" BIGINT,
  "oakar" BIGINT,
  "otsdist" DOUBLE,
  "otsregnm" VARCHAR,
  "procdate" TIMESTAMP,
  "qbprcoml" BIGINT,
  "regagnt" VARCHAR,
  "repdte" TIMESTAMP,
  "risdate" TIMESTAMP,
  "stchrtr" BIGINT,
  "roa" DOUBLE,
  "roaq" DOUBLE,
  "roe" DOUBLE,
  "roeq" DOUBLE,
  "rundate" TIMESTAMP,
  "sasser" BIGINT,
  "law_sasser_flg" VARCHAR,
  "stalp" VARCHAR,
  "stcnty" BIGINT,
  "stnum" BIGINT,
  "zip" BIGINT,
  "suprv_fd" BIGINT,
  "occdist" BIGINT,
  "uninum" BIGINT,
  "ultcert" BIGINT,
  "cfpbeffdte" VARCHAR,
  "cfpbenddte" VARCHAR,
  "cfpbflag" BIGINT,
  "regagent2" VARCHAR,
  "te01n528" VARCHAR,
  "te02n528" VARCHAR,
  "te03n528" VARCHAR,
  "te04n528" VARCHAR,
  "te05n528" VARCHAR,
  "te06n528" VARCHAR,
  "te07n528" VARCHAR,
  "te08n528" VARCHAR,
  "te09n528" VARCHAR,
  "te10n528" VARCHAR,
  "te01n529" VARCHAR,
  "te02n529" VARCHAR
);