FDIC Branch Locations Index

Snowflake table name : CYBERSYN.FDIC_BRANCH_LOCATIONS_INDEX

View data sources, attributes, and sample queries 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	463605
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	202988
FDIC_INSTITUTION_CERTIFICATE_NUMBER	Unique number assigned by the FDIC used to identify institutions and for for the issuance of insurance certificates.	VARCHAR	14028
RSSDHCR	Unique number assigned by the Federal Reserve Board (FRB) to the regulatory bank holding company of the institution.	VARCHAR	1132104
RSSDID	Unique number assigned by the Federal Reserve Board (FRB) to the institution.	VARCHAR	436159
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	11468
HOLDING_COMPANY_NAME	Name of the holding company for the institution (e.g., JPMorgan Chase & Co.).	VARCHAR	Fb Financial Corporation
HOLDING_COMPANY_TYPE	Identifies the type of holding company associated with the branch.	VARCHAR	One bank holding company
INSTITUTION_NAME	Legal name of the FDIC Insured Institution (e.g., JPMorgan Chase Bank, National Association).	VARCHAR	Bom Bank
BRANCH_NAME	Name of the branch (e.g., Magnolia Branch).	VARCHAR	Pearland Branch
BRANCH_NUMBER	The branch's corresponding office number.	VARCHAR	12
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	2014-09-03
ACQUIRED_DATE	Date that a branch was last acquired by another institution.	DATE	2006-01-10
MAIN_OFFICE_FLAG	Flag identifying the main office for the institution.	NUMBER	0
INSTITUTION_PRIMARY_REGULATORY_AGENCY	Primary regulatory agency of the institution.	VARCHAR	FED
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	N/A
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	State Agency
INSTITUTION_CATEGORY	Type of financial institution defined by its charter type, ownership structure, regulatory oversight, and other characteristics.	VARCHAR	State Member Industrial 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	29.57450997995889
LONGITUDE	Longitude of the branch's physical location.	FLOAT	-93.714684012213
ADDRESS	Street address at which the branch is physically located.	VARCHAR	700 County Road 42w
CITY	City at which the branch is physically located.	VARCHAR	Pearland
GEO_ID_STATE	Geographic ID representing the state where the branch is physically located. Can be joined to the GEOGRAPHY_INDEX table.	VARCHAR	geoId/47
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/37343
GEO_ID_COUNTY	Geographic ID representing the county where the branch is physically located. Can be joined to the GEOGRAPHY_INDEX table.	VARCHAR	geoId/47065
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/C16860
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/M47894