Missing Data in Bank Regulatory - Commercial Banks

Learn about the Missing Data in Bank Regulatory - Commercial Banks

Most balance sheet variables are missing from the recent years of Commercial Bank datasets.

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.

Data prior to 2013:

Data prior to 2013 was created from the Structure Files available from the Federal Reserve Bank of Chicago. At this time, most rows were populated.

Data from 2013 On:

The Federal Reserve Bank of Chicago started providing the "Structure Files" only. [1] The remainder of the finance reporting data comes from the FFIEC [2]. Our datasets are a combination of the FRB Structure Files and the FFIEC files.

At this time, the quarterly data started becoming sparsely populated.


[1] Source: https://www.chicagofed.org/banking/financial-institution-reports/commercial-bank-structure-data

[2] Source: https://cdr.ffiec.gov/public/PWS/DownloadBulkData.aspx