Community Banking Initiatives
Historical Community Banking Reference Data Notes to Users
Table of Contents
- Business Problem
The FDIC has developed a community bank definition for research purposes and this definition is being used for publically available papers. A simple, public-facing data set detailing which banks meet the FDIC’s community bank definition by quarter is needed so that external analysts can build upon the FDIC’s research.
Create a data set available to the public that contains the most recent community bank designations for all FDIC-insured institutions from Q1-1984 onward.
The following table outlines the basic Historical Community Banking Reference Data.csv structure.
Name Source Type Definition CERT RIS Num FDIC certificate number. ID RIS Num Unique institution identification number. Designation of community bank status is at the banking organization level. Institutions in a multibank holding company take the RSSD ID (unique identifying number assigned by the Federal Reserve for all financial institutions, main offices, and branches) of the parent holding company, identified as their regulatory high holder, as their banking organization’s unique identifier (ID). Institutions not in a bank holding company or in a one-bank holding company take the bank’s FDIC certificate number as their organization’s unique identifier. Data for each banking organization is aggregated over all the institutions in the organization. CB CALC Num The community bank flag where a "1" designates community bank status. A "0" designates non-community bank status. CALLYM RIS Num The quarter of community bank designation, expressed as yyyymm. RUN_DATE CALC Num The date when the current data set was created, expressed as yyyymmdd. This date is the same for every record. Sources: RIS = Research Information System (updated quarterly), CALC = calculated by the Division of Insurance and Research (updated quarterly)
Derivation of CB (Community Bank Flag)
The CB flag designates community bank status based on the FDIC’s research definition of a community bank. This definition can be found in “Chapter 1- Defining the Community Bank”, an FDIC Community Banking Study publication, at http://www.fdic.gov/regulations/resources/cbi/study.html.
Methodological Changes From Q1-2014
Metro Population Estimates
Beginning with the first quarter of 2014, the metro area population estimates used to calculate the number of large MSAs in which banks have a presence will lag one year. That is, the 2013 metro area population estimates will be in use through 2014, and the 2014 estimates will be in use through 2015, and so on. The numbers of large MSAs in which banks have a presence calculated for prior years reflect the population estimates for those years.
Summary of Deposits (SOD)
Data taken from the annual Summary of Deposits will continue to be merger-adjusted from June 30 through the most recent quarter. Although the SOD is “as-of” June 30, the data is not available in time for the second quarter’s Community Bank designation. Thus, the SOD from the previous year will be merger-adjusted through June 30. New SOD data will be incorporated beginning with the third quarter’s Community Bank designations. The new SOD data will be merger-adjusted through the third quarter, as it reflects office and deposit data as-of June 30.
Users combining this data with other FDIC maintained data such as RIS should be aware that other FDIC maintained data are refreshed according to different schedules. For instance, RIS data is updated quarterly, capturing newly filed Call Report data for the current quarter in addition to amendments and other corrections to prior quarter data. Information generated using RIS or other FDIC maintained data may not exactly correspond to analysis posted on FDIC.gov produced using prior versions of that data.
Historical Community Banking Reference Data 1 .csv will be updated quarterly for all periods by the FDIC’s Division of Insurance and Research and always be named “Historical Community Banking Reference Data 1.csv” and “Historical Community Banking Reference Data 2.csv.” The former file will contain records prior to Q1-2000 and the latter will contain records from Q1-2000 through the most recent quarter. Any changes made to the data set will be recorded in all subsequent notes to users.
June 5, 2014 – Notes revised to reflect changes associated with the quarterly designation of Community Banks, as well as the split into two separate files.
June 13, 2014 – Section 2c added.