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.
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
Published Versions
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 it arrived from the data depositor. ICPSR has not checked or processed this material. Users should consult the investigator(s) if further information is desired.