Dataset: Financial Institutions

About this Dataset

Financial Institutions

This dataset provides a listing of FDIC-insured financial institutions.
Organization: Federal Deposit Insurance Corporation
Last updated: 2020-11-12T12:17:37.004351
Tags: banking, banks, financial-institution

Tables

Table 1

@usgov.fdic_gov_financial_institutions.table_1

4.86 MB
27826 rows
142 columns


CREATE TABLE table_1 (
  "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" VARCHAR,
  "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" DOUBLE,
  "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" VARCHAR,
  "msa" VARCHAR,
  "name" VARCHAR,
  "newcert" BIGINT,
  "oakar" BIGINT,
  "otsdist" VARCHAR,
  "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" DOUBLE,
  "stnum" BIGINT,
  "zip" BIGINT,
  "suprv_fd" DOUBLE,
  "occdist" DOUBLE,
  "uninum" BIGINT,
  "ultcert" DOUBLE,
  "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
);