HMDA Data Products

Once the HMDA data are final, the FFIEC publishes various data products. Refer to the FFIEC HMDA Data Request Order Form for product descriptions, formats, and availability. Unless otherwise specified, HMDA data products are available for years 1990 - 2006.

 












Aggregate and Disclosure Reports on CD-ROM

The CD consists of aggregated mortgage and home improvement lending data within an MSA/MD and a summary of mortgage and home improvement lending data from data prepared yearly by individual lenders. Beginning with calendar year 2005, HMDA Aggregate and Disclosure Reports are available via the Internet only at http://www.ffiec.gov/hmda/online_rpts.htm. (CD-ROM production of this data product was discontinued). For more information regarding data distributed on cartridge tape (for years prior to 2004) or CD-ROM (for years 2000 - 2003), contact NTIS at http://www.ntis.gov/search/index.aspx.


Available Formats:
* CD-ROM ($10 per year for year 2004 only): Item #302


Back to HMDA Product List



 


Aggregate Reports

This report, which is sorted by MSA/MD, aggregates the mortgage and home improvement lending information within an MSA/MD. For more information regarding data distributed on cartridge tape or CD-ROM for years prior to 2004, contact NTIS at http://www.ntis.gov/search/index.aspx.


Available Formats:
* CD-ROM ($10 per year for year 2004 only): Item #302
* HMDA Internet for years 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006
* PMIC Internet for years 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006


Back to HMDA Product List



 


A Guide to HMDA Reporting: Getting It Right!

The Guide is a valuable resource for assisting all institutions in their HMDA reporting. It provides a summary of responsibilities and requirements, directions for assembling the necessary tools, and step-by-step instructions for reporting HMDA data. The 2004 version along with the 2006 information letter should be used for guidance on collecting and reporting calendar year (CY) 2006 HMDA (due March 1, 2007) data. If you must refile HMDA data for CYs 2004 and 2005, use the 2004 edition of the Guide. The 2003 edition of the Guide is used for refiling CY 2003 data. And, if you should need to refile CY 2002 HMDA data, use the 1998 edition along with the 2002 information letter.


Available Formats:
* HMDA Internet for years 1998, 2003, and 2004


Back to HMDA Product List



 


Disclosure Reports

This report summarizes mortgage and home improvement lending information from data that are prepared yearly by individual institutions. For more information regarding data distributed on CD-ROM for years 2000 - 2003, contact NTIS at http://www.ntis.gov/search/index.aspx.


Available Formats:
* CD-ROM ($10 per year for year 2004 only): Item #302
* HMDA Internet for years 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006
* PMIC Internet for years 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006


Back to HMDA Product List



 


Loan Application Register (LAR) & Transmittal Sheet (TS) Raw Data

The LAR & TS data are collected by a financial institution as a result of applications for, and originations and purchases of, home-purchase loans (including refinancings) and home-improvement loans for each calendar year. Also included on the CD-ROM are the file specifications and the Reporter Panel information. For more information regarding data distributed on cartridge tape or CD-ROM for years prior to 2003, contact NTIS at http://www.ntis.gov/search/index.aspx.


* 2006
Starting with CY2006, HMDA data is available via download from this website.  You may download CY2006 HMDA data in two ways, as zipped raw flat files or as the HMDA Raw LAR & TS Windows Application which includes the data and a query tool.  This is the same application that has been available on CD-ROM in previous years.

 

   Zipped 2006 HMDA Flat Files
Raw Data Windows Application
TS & MSA Info  
LAR
File Formats &
Documentation (PDFs)
 HMDA Windows Application (formerly available on CD) 
  • TS Records
  • All
  • Code Sheet
  • MSA Description
  • By Agency
  • Instit Record Format
  •  
  • MSA Office
  • By MSA
  • LAR Record Format
  •  
  • Reporter Panel
  •  
  • MSA Office
  •  
       
  • Reporter Panel
  • * Note: With a high-speed connection, this application may take as long as one hour to download. Therefore, a broadband connection is recommended.

     

       Zipped 2006 PMIC Flat Files
    Raw Data Windows Application
     TS & MSA Info    
    LAR
    File Formats &
    Documentation (PDFs)
     PMIC Windows Application
    (formerly available on CD)   
  • TS Records
  • All
  • Code Sheet
  • MSA Description
  • By MSA
  • Instit Record Format
  •  
  • MSA Office
  •  
  • LAR Record Format
  •  
  • Reporter Panel
  •  
  • MSA Office
  •  
       
  • Reporter Panel
  •  

     

     

    Available Formats:
    * 2006 LAR & TS Raw Data Windows Application

    * DVD-ROM ($50 per year beginning 2006)

    * CD-ROM ($50 per year beginning with 2004): Item #102b

    Back to HMDA Product List



     


    National Aggregates

    These reports are a nationwide summation of the individual MSA/MD Aggregate Reports. They indicate the number and dollar amounts of lending, cross-tabulated by loan, applicant, and geographic characteristics. For more information regarding data distributed on cartridge tape or CD-ROM for years prior to 2004, contact NTIS at http://www.ntis.gov/search/index.aspx


    Available Formats:
    * HMDA Internet for years 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006
    * PMIC Internet for years 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006



    Back to HMDA Product List



     


    Reporter Panel

    This is the universe of all institutions that reported under HMDA. The Reporter Panel information is taken from the database at the same time that the final aggregate and disclosure reports are prepared for the institutions and the public. The panel data is a fixed flat file (ReporterPanel.dat). From 1997 through 2005 the fixed flat file (ReporterPanel.dat) contains all panel data except the reporter's agency group code (other lender code) and parent information (where appropriate) and are included on the HMDA LAR and TS Raw Data CD-ROMs. If you download the 2006 LAR & TS Raw Data Windows Application, the reporter panel can be found in a subdirectory called ReporterPanel within the application directory. In addition, the reporter panel fixed flat file was also included on the 2003 and 2004 HMDA Aggregate and Disclosure Reports CD-ROMs. Beginning with calendar year 2005 data, the HMDA Aggregate and Disclosure Reports CD-ROM will not be available. Another source of the HMDA reporter panel information for years 1990 through 2003 is NTIS ( http://www.ntis.gov/search/index.aspx).



    Back to HMDA Product List