A newer version of this project is available. See below for other available versions.

HUD FHA Single Family Portfolio Snapshot

Principal Investigator(s):  View help for Principal Investigator(s) United States Department of Housing and Urban Development

Version:  View help for Version V1

Name File Type Size Last Modified
  FHA Single Family Portfolio SnapShot 02/20/2025 03:05:PM

Project Citation: 

United States Department of Housing and Urban Development. HUD FHA Single Family Portfolio Snapshot. Ann Arbor, MI: Inter-university Consortium for Political and Social Research [distributor], 2025-02-20. https://doi.org/10.3886/E220223V1

Project Description

Project Title:  View help for Project Title HUD FHA Single Family Portfolio Snapshot
Summary:  View help for Summary The Single-Family Portfolio Snapshot consists of a monthly data table and a report generator (Excel pivot table) that can be used to quickly create new reports of interest to the user from the data records. The data records themselves are loan level records using all of the categorical variables highlighted on the report generator table. Users may download and save the Excel file that contains the data records and the pivot table.

The report generator sheet consists of an Excel pivot table that gives individual users some ability to analyze monthly trends on dimensions of interest to them. There are six choice dimensions: property state, property county, loan purpose, loan type, property product type, and downpayment source.

Each report generator selection variable has an associated drop-down menu that is accessed by clicking once on the associated arrows. Only single selections can be made from each menu. For example, users must choose one state or all states, one county or all counties. If a county is chosen that does not correspond with the selected state, the result will be null values.

The data records include each report generator choice variable plus the property zip code, originating mortgagee (lender) number, sponsor-lender name, sponsor number, nonprofit gift provider tax identification number, interest rate, and FHA insurance endorsement year and month. The report generator only provides output for the dollar amount of loans. Users who desire to analyze other data that are available on the data table, for example, interest rates or sponsor number, must first download the Excel file. See the data definitions (PDF in top folder) for details on each data element.

Files switch from .zip to excel in August 2017.
Original Distribution URL:  View help for Original Distribution URL https://www.hud.gov/program_offices/housing/rmra/oe/rpts/sfsnap/sfsnap

Scope of Project

Subject Terms:  View help for Subject Terms mortgages; loans; housing costs
Geographic Coverage:  View help for Geographic Coverage United States of America
Time Period(s):  View help for Time Period(s) 2/2010 – 11/2024
Data Type(s):  View help for Data Type(s) administrative records data


Related Publications

Download this project

Published Versions

V3 [2026-04-03]

V2 [2025-06-09]

V1 [2025-02-20]

Export Metadata

Dublin Core

DDI 2.5

Report a Problem

Found a serious problem with the data, such as disclosure risk or copyrighted content? Let us know.

This material is distributed exactly as received from the data depositor. ICPSR has not reviewed, checked, or processed this material. For additional information about the study, please contact the investigator(s) directly. If you have questions about the accessibility of materials distributed by ICPSR or require further assistance, please visit ICPSR's Accessibility Center.