Dataset: Financial Institution Office Locations

About this Dataset

Financial Institution Office Locations

This dataset lists office locations of FDIC-insured financial institutions.
Organization: Federal Deposit Insurance Corporation
Last updated: 2020-11-12T12:17:37.389490
Tags: banking, banks, branches, financial-institution, locations, offices

Tables

Table 1

@usgov.fdic_gov_financial_institution_office_locations.table_1

4.78 MB
78769 rows
30 columns


CREATE TABLE table_1 (
  "address" VARCHAR,
  "bkclass" VARCHAR,
  "cbsa" VARCHAR,
  "cbsa_div" VARCHAR,
  "cbsa_div_flg" BIGINT,
  "cbsa_div_no" DOUBLE,
  "cbsa_metro" BIGINT,
  "cbsa_metro_flg" BIGINT,
  "cbsa_metro_name" VARCHAR,
  "cbsa_micro_flg" BIGINT,
  "cbsa_no" BIGINT,
  "cert" BIGINT,
  "city" VARCHAR,
  "county" VARCHAR,
  "csa" VARCHAR,
  "csa_flg" BIGINT,
  "csa_no" DOUBLE,
  "estymd" TIMESTAMP,
  "fi_uninum" BIGINT,
  "mainoff" BIGINT,
  "name" VARCHAR,
  "offname" VARCHAR,
  "offnum" BIGINT,
  "rundate" TIMESTAMP,
  "servtype" BIGINT,
  "stalp" VARCHAR,
  "stcnty" BIGINT,
  "stname" VARCHAR,
  "uninum" BIGINT,
  "zip" VARCHAR
);