Who We Are
What We Do
Impact We Make
News & Events
How To Apply
Return to CDFI Fund mainpageU.S. Department of the Treasury websiteCommunity Development Institutions Fund
Community Development Financial Institutions Fund
CDFI Fund Releases Most Comprehensive CIIS Data to Date, FYs 2004-2010

December 5, 2011

Washington, DC - The CDFI Fund released today seven years of data provided by Community Development Financial Institutions (CDFIs) through its data collection system, known as the Community Investment Impact System (CIIS), for fiscal years 2004 through 2010.

“I am pleased to announce the largest, most detailed public data release in the history of the CDFI Fund,” said CDFI Fund Director Donna J. Gambrell. “This comprehensive data release will be a valuable tool for researchers, academics, and the CDFI industry, and I believe it presents evidence of the tangible and lasting impact of CDFI investments in low-income communities. The CDFIs that submitted CIIS data for this report originated $10.9 billion in loans and investments from 2004 to 2010.”

The release contains Institution Level Report (ILR) data on 534 CDFIs that have reported to CIIS. In general, these CDFIs have provided information on their overall assets, loans, investments, sources and cost of capital, financing of day-to-day activities, staffing, and impact in their communities. A previous data release in 2007 consisted of ILR data on 223 CDFIs in fiscal year 2003, 236 in fiscal year 2004, and 173 in fiscal year 2005.

Additionally, this release marks the first time that Transaction Level Report (TLR) data has been released to the public, which will enable researchers to look at the location, structure, and performance of over 400,000 individual loans and investments made by 239 CDFIs. The data release also includes a new report—the Portfolio Summary File—containing a snapshot of CDFIs’ lending and investing activities by sector.

The ILR and TLR data released today confirm that CDFIs across the nation are fulfilling their mission to deliver financial services and financial products in underserved communities.

Researchers interested in working with the CDFI Program public data should first review the following attachment, which provides helpful tips and guidelines for working with these data files: Guidelines for CDFI Program Public Data.

Background:

As part of compliance requirements, award recipients under the CDFI Program are required to submit information through CIIS after the close of their fiscal year. This includes the Institution Level Report (ILR) and the Transaction Level Report (TLR). Providing a window into the CDFI’s financial activity on the whole, the ILR examines the ownership characteristics, staffing levels and composition, technical assistance, training services, and loan sales of each CDFI. The TLR is divided into two sections (financial data and address data), and looks at CDFI activities on the micro-level, detailing each loan or investment a CDFI makes, including borrower and project addresses, borrower socioeconomic characteristics, loan or investment terms, repayment status, and community development outcomes. All TLR data released to the public are masked to protect the identity of individual borrowers.

Guidance and Codebooks

» Download Compressed Zip File 

The following guidance and codebooks contain variable explanations, valid codes, and frequencies that help explain the data structure of the various data files provided in the sections below.

  • Guidelines for CDFI Program Public Data.pdf
  • Portfolio Summary File Codebook.pdf
  • Institution Level Report Codebook.pdf
  • Financial Transaction Level Report Codebook.pdf
  • Address Transaction Level Report Codebook.pdf

CSV_TEXT Data Files (ASCII)

» Download Compressed Zip File 

Includes:

  • Portfolio Summary File, 2004-2010 (psf.csv
  • Institution Level Report, 2004-2010 (ilr.csv)
  • Financial Transaction Level Report, 2004-2005 (ftlr0405.csv)
  • Financial Transaction Level Report, 2006-2007 Part I (ftlr0607part1.csv)
  • Financial Transaction Level Report, 2006-2007 Part II (ftlr0607part2.csv)
  • Financial Transaction Level Report, 2006-2007 Part III (ftlr0607part3.csv)
  • Financial Transaction Level Report, 2008 Part I (ftlr08a.csv)
  • Financial Transaction Level Report, 2008 Part II (ftlr08b.csv)
  • Financial Transaction Level Report, 2009 Part I (ftlr09a.csv)
  • Financial Transaction Level Report, 2009 Part II (ftlr09b.csv)
  • Financial Transaction Level Report, 2010 (ftlr10.csv)
  • Address Transaction Level Report, 2004-2005 (atlr0405.csv)
  • Address Transaction Level Report, 2006-2007 Part I (atlr0607part1.csv)
  • Address Transaction Level Report, 2006-2007 Part II (atlr0607part2.csv)
  • Address Transaction Level Report, 2006-2007 Part III (atlr0607part3.csv)
  • Address Transaction Level Report, 2008 Part I (atlr08a.csv)
  • Address Transaction Level Report, 2008 Part II (atlr08b.csv)
  • Address Transaction Level Report, 2009 Part I (atlr09a.csv)
  • Address Transaction Level Report, 2009 Part II (atlr09b.csv)
  • Address Transaction Level Report, 2010 (atlr10.csv)

SAS Data Files

» Download Compressed Zip File 

Includes:

  • Portfolio Summary File, 2004-2010 (psf.sas7bdat)
  • Institution Level Report, 2004-2010 (ilr.sas7bdat)
  • Financial Transaction Level Report, 2004-2005 (ftlr0405.sas7bdat)
  • Financial Transaction Level Report, 2006-2007 Part I (ftlr0607part1.sas7bdat)
  • Financial Transaction Level Report, 2006-2007 Part II (ftlr0607part2.sas7bdat)
  • Financial Transaction Level Report, 2006-2007 Part III (ftlr0607part3.sas7bdat)
  • Financial Transaction Level Report, 2008 Part I (ftlr08a.sas7bdat)
  • Financial Transaction Level Report, 2008 Part II (ftlr08b.sas7bdat)
  • Financial Transaction Level Report, 2009 Part I (ftlr09a.sas7bdat)
  • Financial Transaction Level Report, 2009 Part II (ftlr09b.sas7bdat)
  • Financial Transaction Level Report, 2010 (ftlr10.sas7bdat)
  • Address Transaction Level Report, 2004-2005 (atlr0405.sas7bdat)
  • Address Transaction Level Report, 2006-2007 Part I (atlr0607part1.sas7bdat)
  • Address Transaction Level Report, 2006-2007 Part II (atlr0607part2.sas7bdat)
  • Address Transaction Level Report, 2006-2007 Part III (atlr0607part3.sas7bdat)
  • Address Transaction Level Report, 2008 Part I (atlr08a.sas7bdat)
  • Address Transaction Level Report, 2008 Part II (atlr08b.sas7bdat)
  • Address Transaction Level Report, 2009 Part I (atlr09a.sas7bdat)
  • Address Transaction Level Report, 2009 Part II (atlr09b.sas7bdat)
  • Address Transaction Level Report, 2010 (atlr10.sas7bdat)

Contact Us  |  Site Index  |  Search  |  Return to Main Page
  Copyright Status USA.gov | Grants.gov | Regulations.gov | OIG |
Small and Disadvantaged Businesses | Privacy & Security | No Fear Act
FOIA | Website Policies & Major Links | Download Adobe Acrobat PDF Reader | Download Microsoft Excel Viewer | Download Microsoft Word Viewer |
Download Microsoft Powerpoint Viewer