FDIC Branch Locations Index

Snowflake table name : CYBERSYN.FDIC_BRANCH_LOCATIONS_INDEX

View data source documentation here.

Name	Description	Type	Example
FDIC_INSTITUTION_ID	Unique FDIC ID of the institution that owns the branch. It is a unique number, sequentially added to the FDIC database for both banks and branches. This ID is updated with every merger or purchase of branches to reflect the most current owner.	VARCHAR	1124
FDIC_BRANCH_ID	Unique FDIC ID for each bank branch. The branch ID for the Headquarters branch is the same as the branch ID for the entire bank or savings institution.	VARCHAR	665308
FDIC_INSTITUTION_CERTIFICATE_NUMBER	Unique number assigned by the FDIC used to identify institutions and for for the issuance of insurance certificates.	VARCHAR	3066
RSSDHCR	Unique number assigned by the Federal Reserve Board (FRB) to the regulatory bank holding company of the institution.	VARCHAR	1102312
RSSDID	Unique number assigned by the Federal Reserve Board (FRB) to the institution.	VARCHAR	470050
OTS_ID	Unique identification number assigned to institutions chartered by the Office of the Thrift Supervision (OTS) or that become members of the Federal Home Loan System.	VARCHAR	1265
HOLDING_COMPANY_NAME	Name of the holding company for the institution (e.g., JPMorgan Chase & Co.).	VARCHAR	First Financial Bankshares, Inc.
HOLDING_COMPANY_TYPE	Identifies the type of holding company associated with the branch.	VARCHAR	Multi-bank holding company
INSTITUTION_NAME	Legal name of the FDIC Insured Institution (e.g., JPMorgan Chase Bank, National Association).	VARCHAR	First Financial Bank
BRANCH_NAME	Name of the branch (e.g., Magnolia Branch).	VARCHAR	United Branch
BRANCH_NUMBER	The branch's corresponding office number.	VARCHAR	47
BRANCH_TYPE	Description of the branch's main function (e.g., Full Service Brick and Mortar Office).	VARCHAR	Full Service - Brick And Mortar
ESTABLISHED_DATE	Date on which the branch began operations.	DATE	1999-06-17
ACQUIRED_DATE	Date that a branch was last acquired by another institution.	DATE	2024-12-04
MAIN_OFFICE_FLAG	Flag identifying the main office for the institution.	NUMBER	0
INSTITUTION_PRIMARY_REGULATORY_AGENCY	Primary regulatory agency of the institution.	VARCHAR	FDIC
FDIC_REGIONAL_OFFICE	Name of the FDIC Regional Office that services the institution.	VARCHAR	Dallas
FEDERAL_RESERVE_DISTRICT	Name of the Federal Reserve District where the institution is located.	VARCHAR	Dallas
COMPTROLLER_DISTRICT	Name of the Comptroller of the Currency district in which the institution is located.	VARCHAR	Southern
INSTITUTION_PRIMARY_INSURER	Primary insurer, insurance agent, or insurance status of an institution.	VARCHAR	Deposit Insurance Fund
FDIC_CLASSIFICATION_CODE	A classification code assigned by the FDIC based on the institution's charter type (commercial bank or savings institution), charter agent (state or federal), Federal Reserve membership status (Fed member, Fed nonmember) and its primary federal regulator (state chartered institutions are subject to both federal and state supervision).	VARCHAR	Commercial bank, state charter and Fed member, supervised by the...
CHARTER_TYPE	Identifies whether an institution is federally or state chartered.	VARCHAR	State
INSTITUTION_CHARTER_AGENCY	The chartering agency of the institution that granted the license or charter for the institution to operate and regulates and supervises the financial and operational activities of that institution.	VARCHAR	Comptroller of the Currency
INSTITUTION_CATEGORY	Type of financial institution defined by its charter type, ownership structure, regulatory oversight, and other characteristics.	VARCHAR	National Member Bank
INSTITUTION_PRIMARY_ASSET_SPECIALIZATION	Description of a mutually exclusive industry classification grouping which indicates the institution's primary asset specialization.	VARCHAR	Commercial Lending
INSTITUTION_MINORITY_DEPOSITORY_STATUS	Description of the regulatory status of the financial institution associated with the location.	VARCHAR	Asian Or Pacific Islander Americans
LATITUDE	Latitude of the branch's physical location.	FLOAT	40.78482565506587
LONGITUDE	Longitude of the branch's physical location.	FLOAT	-84.27307601285776
ADDRESS	Street address at which the branch is physically located.	VARCHAR	920 N Willis St
CITY	City at which the branch is physically located.	VARCHAR	Orlando
GEO_ID_STATE	Geographic ID representing the state where the branch is physically located. Can be joined to the GEOGRAPHY_INDEX table.	VARCHAR	geoId/39
GEO_ID_ZIP	Geographic ID representing the zip code where the branch is physically located. Can be joined to the GEOGRAPHY_INDEX table.	VARCHAR	zip/76903
GEO_ID_COUNTY	Geographic ID representing the county where the branch is physically located. Can be joined to the GEOGRAPHY_INDEX table.	VARCHAR	geoId/21151
GEO_ID_CBSA	Geographic ID representing the core-based statistical area where the branch is physically located. Can be joined to the GEOGRAPHY_INDEX table.	VARCHAR	geoId/C10180
GEO_ID_METRO_DIV	Geographic ID representing the metropolitan division where the branch is physically located. Can be joined to the GEOGRAPHY_INDEX table.	VARCHAR	geoId/M41884