• Print
  • Email

Commercial Bank Data

 

Beginning with the September 30, 2017 data file, select variables were removed due to variable logic being no longer supported going forward. The removed variables are listed below.

Field Name MDRM
FGN_OWN_TYPE RSSD9325
FGN_OWN_US_ENT_CNT RSSD9127
FGN_OWN_HH_25_SC RSSD9083
FGN_OWN_HH_ID_25 RSSD9128
FGN_OWN_HH_PCT_25 RSSD9129
LG_ENT_BHC_IND RSSD9397
REG_DH_2_SC RSSD9114
REG_DH_2_ID RSSD9382
REG_DH_2_PCT RSSD9383
REG_DH_3_SC RSSD9118
REG_DH_3_ID RSSD9386
REG_DH_3_PCT RSSD9387
REG_DH_4_SC RSSD9119
REG_DH_4_ID RSSD9389
REG_DH_4_PCT RSSD9391
REG_HH_2_SC RSSD9121
REG_HH_2_ID RSSD9351
REG_HH_2_PCT RSSD9352
REG_HH_3_SC RSSD9134
REG_HH_3_ID RSSD9355
REG_HH_3_PCT RSSD9356
REG_HH_4_SC RSSD9137
REG_HH_4_ID RSSD9358
REG_HH_4_PCT RSSD9359
FGN_OWN_PCT_SC RSSD9084
FGN_OWN_PCT RSSD9329

Report of Condition and Income data are available for all banks regulated by the Federal Reserve System, Federal Deposit Insurance Corporation, and the Comptroller of the Currency. All financial data are on an individual bank basis. Data on this site are available from 1976 to 2010 in zipped SAS XPORT format datasets. You can download the free System Viewer from the SAS site to view these files if you are not a SAS user.

Availability of Commercial Bank Data

Beginning with the March 31, 2011, Report of Condition, future releases of quarterly commercial bank data will only be available from the FFIEC Central Data Repository's Public Data Distribution site (PDD). Data on the PDD site are available in two formats for downloading, tab delimited and eXtensible Business Reporting Language (XBRL); and includes historical data through March 31, 2001. This will help ensure timely access to data as it is submitted or revised. An example SAS program to read the tab delimited bulk files into a SAS dataset is provided in the Data Files section below to help ease the transition to the PDD.

The historical datasets will remain available on chicagofed.org, and historical datasets that are within the two year window of the most recent as-of date will continue to be refreshed. The PDD releases data for commercial banks that file the FFIEC 031 and FFIEC 041 only, and does not include additional structural information. Due to this restriction, other report of condition and income data included in the chicagofed.org datasets, specifically the FR 2886b and FFIEC 002 data, will be provided going forward, along with structure information for filers of all four reports. However, due to the lack of continuity with future datasets, the Data Extraction System for Call Report data tool will be decommissioned.

Data Files

The complete files below contain all the financial variables reported on the Report of Condition and Income and selected structure data. These files are large (15MB zipped) and are best suited for a network (file server) environment.

Complete Files, 2001 - 2010

Complete Files, 1976 - 2000 

The structure and non-CDR datasets below contain structure and geographical variables for all call report filers, and financial data for FR 2886b and FFIEC 002 filers.

Structure Files, 2011 - Present 

The example SAS program below provides one possible way of importing the tab delimited bulk files available on the CDR's PDD site into a SAS dataset. The PDD tab delimited bulk files are structured so that each schedule of the call report is available as a separate text file containing all respondents. The data are also available in XRBL format with individual files for each respondent.

Example SAS Program (Updated 06/21/2012)

Banking Research Datasets

CRSP-FRB Link is intended to distribute data that is useful for conducting and replicating academic research involving commercial banks.

Documentation

Data Dictionary 
Contains a brief definition of the variables on the files and their reporting frequency.

Forming Consistent Time Series
Notes on forming consistent time series.

Sample Call Report Forms 

Only the complete files contain all variables.

FFIEC 031 
Consolidated Reports of Condition and Income for a Bank with Domestic and Foreign Offices

FFIEC 041 
Consolidated Reports of Condition and Income for a Bank with Domestic Offices Only (replaces FFIEC 032, FFIEC 033, FFIEC 034)

FR 2886b 
Consolidated Report of Condition and Income for Edge and Agreement Corporations

FFIEC 002 
Report of Assets and Liabilities of U.S. Branches and Agencies of Foreign Banks

Regulatory Capital

Notes on changes in reporting Regulatory Capital data from 1990 to 1994 and 1994 to current.

Structure and Geographical Variables 
List of structure and geographical variables on both files (Complete and Subset). Detailed description for decoding can be found in the Dictionary file.

Having trouble accessing something on this page? Please send us an email and we will get back to you as quickly as we can.

Federal Reserve Bank of Chicago, 230 South LaSalle Street, Chicago, Illinois 60604-1413, USA. Tel. (312) 322-5322

Copyright © 2020. All rights reserved.

Please review our Privacy Policy | Legal Notices