View weekly updates and historical trends for 30 Year Mortgage Rate. from United States. Source: Freddie Mac. Track economic data with YCharts analytics.

Graph and download economic data for 15-Year Fixed Rate Mortgage Average in the United States (MORTGAGE15US) from 1991-08-30 to 2025-11-26 about 15-year, mortgage, fixed, interest rate, interest, rate, and USA.

Fannie Mae and Freddie Mac Loan-Level Dataset

Borrower Demographics, Loan-to-Value Ratios, and Census Tract Location

By Natarajan Krishnaswami [source]

About this dataset

The FHFA Public Use Databases provide an unprecedented look into the flow of mortgage credit and capital in America's communities. With detailed information about the income, race, gender and census tract location of borrowers, this database can help lenders, planners, researchers and housing advocates better understand how mortgages are acquired by Fannie Mae and Freddie Mac.

This data set includes 2009-2016 single-family property loan information from the Enterprises in combination with corresponding census tract information from the 2010 decennial census. It allows for greater granularity in examining mortgage acquisition patterns within each MSA or county by combining borrower/property characteristics, such as borrower's race/ethnicity; co-borrower demographics; occupancy type; Federal guarantee program (conventional/other versus FHA-insured); age of borrowers; loan purpose (purchase, refinance or home improvement); lien status; rate spread between annual percentage rate (APR) and average prime offer rate (APOR); HOEPA status; area median family income and more.

In addition to demographic data on borrowers and properties, this dataset also provides insight into affordability metrics such as median family incomes at both the MSA/county level as well as functional owner occupied bankrupt tracts using 2010 Census based geography while taking into account American Community Survey estimates available at January 1st 2016. This allows us to calculate metrics that are important for assessing inequality such as tract income ratios which measure what portion of an area’s median family income is made up by a single borrows earnings or the ratio between borrows annual income compared to an area’s average median family iincome for those year’s reporting period. Finally each record contains Enterprise Flags associated with whether loans were purchased my Fannie Mae or Freddie Mac indicating further insights regarding who is financing policies affecting undocumented immigrant labor access as well affordable housing legislation targeted towards first time home buyers

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

This guide will provide you with all the information needed to use the Fannie Mae and Freddie Mac Loan-Level Dataset for 2016. The dataset contains loan-level data for both Fannie Mae and Freddie Mac, including loans acquired in 2016. It includes details such as homeowner demographics, loan-to-value ratio, census tract location, and affordability of mortgage.

The first step to using this dataset is understanding how it is organized. There are 38 fields that make up the loan level data set, making it easy to understand what is being looked at. For each field there is a description of what the field represents and potential values it can take on (i.e., if it’s an integer or float). Having an understanding of the different fields will help when querying certain data points or comparing/contrasting.

Once you understand what type of information is available in this dataset you can start to create queries or visualizations that compare trends across Fannie Mae & Freddie Mac loans made in 2016. Depending on your interest areas such as homeownership rates or income disparities certain statistics may be pulled from the dataset such as borrower’s Annual Income Ratio per area median family income by state code or a comparison between Race & Ethnicity breakdown between borrowers and co-borrowers from various states respective MSAs, among other possibilities based on your inquiries . Visualizations should then be created so that clear comparisons and contrasts could be seen more easily by other users who may look into this same dataset for additional insights as well .

After creating queries/visualization , you can dive deeper into research about corresponding trends & any biases seen within these datasets related within particular racial groupings compared against US Postal & MSA codes used within the 2010 Census Tract locations throughout the US respectively by further utilizing publicly available research material that looks at these subjects with regards housing policies implemented through out years one could further draw conclusions depending on their current inquiries

Research Ideas

• Use the dataset to analyze borrowing patterns based on race, nationality and gender, to better understand the links between minority groups and access to credit...

Graph and download economic data for Delinquency Rate on Single-Family Residential Mortgages, Booked in Domestic Offices, All Commercial Banks (DRSFRMACBS) from Q1 1991 to Q3 2025 about domestic offices, delinquencies, 1-unit structures, mortgage, family, residential, commercial, domestic, banks, depository institutions, rate, and USA.

The minimum equity required for rate and term conventional refinance

The maximum loan-to-value ratio allowed for cash-out refinance

this graph was created in PowerBI,Loocker Studio and Tableau :

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F16731800%2F2c47517ee758ba17954f5d3b9afb1885%2Ffoto1.jpg?generation=1738439043783559&alt=media" alt=""> https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F16731800%2F8871e7e74de3cdfb320232eb25178f65%2Ffoto2.jpg?generation=1738439050149204&alt=media" alt=""> https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F16731800%2Fe1aa095491e1b95676f348317695043c%2Ffoto3.png?generation=1738439055944651&alt=media" alt="">

Components may not sum to totals because of rounding. 1. Includes securities lent to dealers under the overnight securities lending facility; refer to table 1A. 2. Face value of the securities. 3. Compensation that adjusts for the effect of inflation on the original face value of inflation-indexed securities. 4. Guaranteed by Fannie Mae, Freddie Mac, and Ginnie Mae. The current face value shown is the remaining principal balance of the securities. 5. Reflects the premium or discount, which is the difference between the purchase price and the face value of the securities that has not been amortized. For U.S. Treasury securities, Federal agency debt securities, and mortgage-backed securities, amortization is on an effective-interest basis. 6. Cash value of agreements. 7. Includes outstanding loans to depository institutions that were subsequently placed into Federal Deposit Insurance Corporation (FDIC) receivership, including depository institutions established by the FDIC. The Federal Reserve Banks' loans to these depository institutions are secured by pledged collateral and the FDIC provides repayment guarantees. 8. Includes assets purchased pursuant to terms of the credit facility and amounts related to Treasury contributions to the facility. Refer to note on consolidation below. 9. Dollar value of foreign currency held under these agreements valued at the exchange rate to be used when the foreign currency is returned to the foreign central bank. This exchange rate equals the market exchange rate used when the foreign currency was acquired from the foreign central bank. 10. Includes bank premises, accrued interest, and other accounts receivable. 11. Revalued daily at current foreign currency exchange rates. 12. Estimated. 13. Cash value of agreements, which are collateralized by U.S. Treasury securities, federal agency debt securities, and mortgage-backed securities 14. Includes deposits held at the Reserve Banks by international and multilateral organizations, government-sponsored enterprises, designated financial market utilities, and deposits held by depository institutions in joint accounts in connection with their participation in certain private-sector payment arrangements. Also includes certain deposit accounts other than the U.S. Treasury, General Account, for services provided by the Reserve Banks as fiscal agents of the United States. 15. Book value. Amount of equity investments in MS Facilities 2020 LLC. 16. Includes the liability for earnings remittances due to the U.S. Treasury. Sources: Federal Reserve Banks and the U.S. Department of the Treasury