Data‐Dictionary - Silesians/Economic_Related_Database GitHub Wiki
Data-Dictionary
Holder Data
| Field Name |
Description |
Data Type |
Example Values |
| Institution Name |
Name of the bank |
TXT |
Bank1, Bank2 |
| Data Access Effective |
Date of Access Begin |
TXT |
MM/DD/YYYY |
| Federal Deposit Insurance |
Deposit Insured by FDIC or NCUA |
TXT |
FDIC, NCUA |
| City |
Geographical location of the bank |
TXT |
New York, Los Angeles |
| State |
Geographical location of the bank |
TXT |
NJ, OH |
| Reserve Bank District |
District that institution access |
TXT |
Chicago, New York |
Holder Data Dictionary Table:
(https://github.com/Silesians/Holder-Requestor-Data/blob/main/holder-data-dictionary.csv)
Official Data Definitions:
(https://www.federalreserve.gov/paymentsystems/master-accounts-data-definitions.htm)
Requestor Data
| Field Name |
Description |
Data Type |
Example Values |
| Institution Name |
Name of the bank |
TXT |
Bank1, Bank2 |
| Date Submitted |
Date when institution request access |
TXT |
MM/DD/YYYY |
| Federal Deposit Insurance |
Deposit Insured by FDIC or NCUA |
TXT |
FDIC, NCUA |
| Action |
Status of access request |
TXT |
Approved, Pending |
| Action Date |
Date for specific action taken regarding the access request |
TXT |
MM/DD/YYYY |
| Access Request Tier(Initial) |
Classification of requestor under Account Access Guidlines |
TXT |
Tier 1, Tier 2, Tier 3 |
| City |
Geographical location of the bank |
TXT |
New York, Los Angeles |
| State |
Geographical location of the bank |
TXT |
NJ, OH |
| Reserve Bank District |
District that institution access |
TXT |
Chicago, New York |
Requestor Data Dictionary Table:
(https://github.com/Silesians/Holder-Requestor-Data/blob/main/requestor-data-dictionary.csv)
Official Data Definitions:
(https://www.federalreserve.gov/paymentsystems/master-accounts-data-definitions.htm)
FDIC Deposit Data
| Full Name |
Dataset Variable Name |
Description |
Data Type |
| Report Year (Institution) |
YEAR |
The year the report was generated. |
Integer |
| FDIC Certificate # |
CERT |
Unique identifier for the institution. |
Integer |
| Institution Name at Time of Reporting |
NAMEFULL |
Name of the institution at reporting time. |
String |
| Total Assets |
ASSET |
Total assets held by the institution. |
Float |
| Institution Class |
BKCLASS |
Classification of the institution. |
String |
| Deposits held in domestic offices |
DEPDOM |
Deposits in domestic offices. |
Float |
| Total Deposits (Institution) |
DEPSUM |
Total deposits held by the institution. |
Float |
| Primary Federal Regulator (Institution) |
REGAGNT |
Primary federal regulator of the institution. |
String |
| State Code |
STALP |
State code of the institution. |
String |
| Zip Code |
ZIP |
Zip code of the institution's location. |
String |
| Full Name |
Dataset Variable Name |
Description |
Data Type |
| Address (Branch) |
ADDRESBR |
Address of the branch. |
String |
| Branch Office Number (Branch) |
BRNUM |
Number identifying the branch office. |
Integer |
| Unique Identification Number for a Branch Office (Branch) |
UNINUMBR |
Unique ID for the branch office. |
Integer |
| State Code (Branch) |
STALPBR |
State code where the branch is located. |
String |
| Main Office Designation Flag (Branch) |
BKMO |
Indicates if the branch is the main office. |
Boolean |
| Branch Service Type (Branch) |
BRSERTYP |
Type of services offered by the branch. |
String |
| City (Reported)(Branch) |
CITYBR |
City where the branch is located. |
String |
| County Name (Branch) |
CNTYNAMB |
County where the branch is located. |
String |
| Deposits (Branch)(in thousands of dollars) |
DEPSUMBR |
Total deposits held by the branch. |
Float |
| Metropolitan Statistical Area Name (Branch) |
MSANAMB |
Name of the metropolitan statistical area. |
String |
| Branch Name (Branch) |
NAMEBR |
Name of the branch. |
String |
| Established Date (Branch Office) |
SIMS_ESTABLISHED_DATE |
Date when the branch was established. |
Date |
| Physical Latitude Coordinates (Branch Office) |
SIMS_LATITUDE |
Latitude coordinates of the branch location. |
Float |
| Physical Longitude Coordinates (Branch Office) |
SIMS_LONGITUDE |
Longitude coordinates of the branch location. |
Float |
Deposit Data Dictionary Table:
(https://github.com/Silesians/Holder-Requestor-Data/blob/main/FDIC%20Deposit%20Dataset/FDIC_Deposit_Data_Dictionary.csv)
Official Data Definition:
(https://banks.data.fdic.gov/bankfind-suite/SOD/customDownload?displayResults=&instType=&institutionType=banks&institutionTypeTimeSeries=&lastYear=2019&locations=&pageNumber=1&reportType=&resultLimit=25&sortField=STNAME&sortOrder=ASC&totalsType=)