The Housing Affordability Data System (HADS) is a set of files derived from the 1985 and later national American Housing Survey (AHS) and the 2002 and later Metro AHS. This system categorizes housing units by affordability and households by income, with respect to the Adjusted Median Income, Fair Market Rent (FMR), and poverty income. It also includes housing cost burden for owner and renter households. These files have been the basis for the worst case needs tables since 2001. The data files are available for public use, since they were derived from AHS public use files and the published income limits and FMRs. These dataset give the community of housing analysts the opportunity to use a consistent set of affordability measures. The most recent year HADS is available as a Public Use File (PUF) is 2013. For 2015 and beyond, HADS is only available as an IUF and can no longer be released on a PUF. Those seeking access to more recent data should reach to the listed point of contact.

The housing affordability measure illustrates the relationship between income and housing costs. A household that spends 30% or more of its collective monthly income to cover housing costs is considered to be “housing cost-burden[ed].”[1] Those spending between 30% and 49.9% of their monthly income are categorized as “moderately housing cost-burden[ed],” while those spending more than 50% are categorized as “severely housing cost-burden[ed].”[2]

How much a household spends on housing costs affects the household’s overall financial situation. More money spent on housing leaves less in the household budget for other needs, such as food, clothing, transportation, and medical care, as well as for incidental purchases and saving for the future.

The estimated housing costs as a percentage of household income are categorized by tenure: all households, those that own their housing unit, and those that rent their housing unit.

Throughout the period of analysis, the percentage of housing cost-burdened renter households in Champaign County was higher than the percentage of housing cost-burdened homeowner households in Champaign County. All three categories saw year-to-year fluctuations between 2005 and 2023, and none of the three show a consistent trend. However, all three categories were estimated to have a lower percentage of housing cost-burdened households in 2023 than in 2005.

Data on estimated housing costs as a percentage of monthly income was sourced from the U.S. Census Bureau’s American Community Survey (ACS) 1-Year Estimates, which are released annually.

As with any datasets that are estimates rather than exact counts, it is important to take into account the margins of error (listed in the column beside each figure) when drawing conclusions from the data.

Due to the impact of the COVID-19 pandemic, instead of providing the standard 1-year data products, the Census Bureau released experimental estimates from the 1-year data in 2020. This includes a limited number of data tables for the nation, states, and the District of Columbia. The Census Bureau states that the 2020 ACS 1-year experimental tables use an experimental estimation methodology and should not be compared with other ACS data. For these reasons, and because data is not available for Champaign County, no data for 2020 is included in this Indicator.

For interested data users, the 2020 ACS 1-Year Experimental data release includes a dataset on Housing Tenure.

[1] Schwarz, M. and E. Watson. (2008). Who can afford to live in a home?: A look at data from the 2006 American Community Survey. U.S. Census Bureau.

[2] Ibid.

Sources: U.S. Census Bureau; American Community Survey, 2023 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using data.census.gov; (17 October 2024).; U.S. Census Bureau; American Community Survey, 2022 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using data.census.gov; (22 September 2023).; U.S. Census Bureau; American Community Survey, 2021 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using data.census.gov; (30 September 2022).; U.S. Census Bureau; American Community Survey, 2019 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using data.census.gov; (10 June 2021).; U.S. Census Bureau; American Community Survey, 2018 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using data.census.gov; (10 June 2021).;U.S. Census Bureau; American Community Survey, 2017 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using American FactFinder; (13 September 2018).; U.S. Census Bureau; American Community Survey, 2016 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using American FactFinder; (14 September 2017).; U.S. Census Bureau; American Community Survey, 2015 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using American FactFinder; (19 September 2016).; U.S. Census Bureau; American Community Survey, 2014 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using American FactFinder; (16 March 2016).; U.S. Census Bureau; American Community Survey, 2013 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using American FactFinder; (16 March 2016).; U.S. Census Bureau; American Community Survey, 2012 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using American FactFinder; (16 March 2016).; U.S. Census Bureau; American Community Survey, 2011 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using American FactFinder; (16 March 2016).; U.S. Census Bureau; American Community Survey, 2010 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using American FactFinder; (16 March 2016).; U.S. Census Bureau; American Community Survey, 2009 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using American FactFinder; (16 March 2016).; U.S. Census Bureau; American Community Survey, 2008 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using American FactFinder; 16 March 2016).; U.S. Census Bureau; American Community Survey, 2007 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using American FactFinder; (16 March 2016).; U.S. Census Bureau; American Community Survey, 2006 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using American FactFinder; (16 March 2016).; U.S. Census Bureau; American Community Survey, 2005 American Community Survey 1-Year Estimates, Table B25106; generated by CCRPC staff; using American FactFinder; (16 March 2016).

The Affordable Housing Appeals Procedure List is published annually on or about February 1. The data for the Affordable Housing Appeals Procedure List comes from different sources including federal, state and local programs. This makes it difficult to ensure complete accuracy, so DOH asks municipalities to provide a local administrative review of and input on the street addresses of units and projects as well as information on deed-restricted units. The responses received by DOH vary widely from each municipality. In developing the Affordable Housing Appeals Procedure List, DOH counts: -Assisted housing units or housing receiving financial assistance under any governmental program for the construction or substantial rehabilitation of low and moderate income housing that was occupied or under construction by the end date of the report period for compilation of a given year’s list; -Rental housing occupied by persons receiving rental assistance under C.G.S. Chapter 138a (State Rental Assistance/RAP) or Section 142f of Title 42 of the U.S. Code (Section 8); -Ownership housing or housing currently financed by the Connecticut Housing Finance Authority and/or the U.S. Department of Agriculture; and -Deed-restricted properties or properties with deeds containing covenants or restrictions that require such dwelling unit(s) be sold or rented at or below prices that will preserve the unit(s) as affordable housing as defined in C.G.S. Section 8-39a for persons or families whose incomes are less than or equal to 80% of the area median income.

The U.S. Department of Housing and Urban Development (HUD) periodically receives "custom tabulations" of Census data from the U.S. Census Bureau that are largely not available through standard Census products. These datasets, known as "CHAS" (Comprehensive Housing Affordability Strategy) data, demonstrate the extent of housing problems and housing needs, particularly for low income households. The primary purpose of CHAS data is to demonstrate the number of households in need of housing assistance. This is estimated by the number of households that have certain housing problems and have income low enough to qualify for HUD’s programs (primarily 30, 50, and 80 percent of median income). CHAS data provides counts of the numbers of households that fit these HUD-specified characteristics in a variety of geographic areas. In addition to estimating low-income housing needs, CHAS data contributes to a more comprehensive market analysis by documenting issues like lead paint risks, "affordability mismatch," and the interaction of affordability with variables like age of homes, number of bedrooms, and type of building.This dataset is a special tabulation of the 2016-2020 American Community Survey (ACS) and reflects conditions over that time period. The dataset uses custom HUD Area Median Family Income (HAMFI) figures calculated by HUD PDR staff based on 2016-2020 ACS income data. CHAS datasets are used by Federal, State, and Local governments to plan how to spend, and distribute HUD program funds. To learn more about the Comprehensive Housing Affordability Strategy (CHAS), visit: https://www.huduser.gov/portal/datasets/cp.html, for questions about the spatial attribution of this dataset, please reach out to us at GISHelpdesk@hud.gov. To learn more about the American Community Survey (ACS), and associated datasets visit: https://www.census.gov/programs-surveys/acs Data Dictionary: DD_ACS 5-Year CHAS Estimate Data by County Date of Coverage: 2016-2020

The Department of Housing Preservation and Development (HPD) reports on projects, buildings, and units that began after January 1, 2014, and are counted towards either the Housing New York plan (1/1/2014 – 12/31/2021) or the Housing Our Neighbors: A Blueprint for Housing & Homelessness plan (1/1/2022 – present).

First launched by the U.S. Department of Housing and Urban Development (HUD) and Department of Transportation (DOT) in November 2013, the Location Affordability Index (LAI) provides ubiquitous, standardized household housing and transportation cost estimates at the Census block-group level for the majority of the populated area of the United States. Because what is affordable is different for everyone, users can choose among eight household profiles—which vary by household income, size, and number of commuters—and see the impact of the built environment on affordability in a given neighborhood location while holding household demographics constant.

In Version 1, these estimates were originally generated with data from several federal sources and vehicle miles traveled (VMT) data from Illinois EPA using separate OLS regression models for household housing costs, VMT, car ownership, and transit usage. Version 2, in addition to updating all the constituent data sources, represents a significant a methodological and technical advance from Version 1, modelling auto ownership, housing costs, and transit usage for both homeowners and renters are concurrently using simultaneous equation modeling (SEM) to capture the interrelationship of these factors. The inputs to the SEM include these six endogenous variables and 18 exogenous variables, with VMT still modeled separately due to data limitations.

To learn more about the Location Affordability Index (v.2.0) visit: https://www.hudexchange.info/programs/location-affordability-index/, for questions about the spatial attribution of this dataset, please reach out to us at GISHelpdesk@hud.gov. Data Dictionary: DD_Location Affordability Indev v.2.0 Date of Coverage: 2008-2012

Low Income Housing Tax Credit PropertiesThis National Geospatial Data Asset (NGDA) dataset, shared as a Department of Housing and Urban Development (HUD) feature layer, displays low income housing tax credit properties in the United States. Per HUD, "the Low-Income Housing Tax Credit (LIHTC) is the primary Federal program for creating affordable housing in the United States. The LIHTC program gives State and local LIHTC-allocating agencies the authority to issue tax credits for the acquisition, rehabilitation, or new construction of rental housing targeted to lower-income households. The location of the property is derived from the address of the building with the most units".Lawndale Restoration, Chicago, ILData currency: current federal service (Low Income Housing Tax Credit Properties)NGDAID: 132 (Assisted Housing - Low Income Housing Tax Credit Properties - National Geospatial Data Asset (NGDA))OGC API Features Link: Not AvailableFor more information, please visit: Low-Income Housing Tax Credit (LIHTC)Support documentation: Data Dictionary - Low Income Tax Credit ProgramFor feedback please contact: Esri_US_Federal_Data@esri.comNGDA Data SetThis data set is part of the NGDA Real Property Theme Community. Per the Federal Geospatial Data Committee (FGDC), Real Property is defined as "the spatial representation (location) of real property entities, typically consisting of one or more of the following: unimproved land, a building, a structure, site improvements and the underlying land. Complex real property entities (that is "facilities") are used for a broad spectrum of functions or missions. This theme focuses on spatial representation of real property assets only and does not seek to describe special purpose functions of real property such as those found in the Cultural Resources, Transportation, or Utilities themes."For other NGDA Content: Esri Federal Datasets

The Inclusionary Housing Program is designed to preserve and promote affordable housing within neighborhoods where zoning has been modified to encourage new development. The Voluntary Inclusionary Housing program, enacted in 1987, enables a development to receive a density bonus in return for the new construction, substantial rehabilitation, or preservation of permanently affordable housing. The Inclusionary Housing Floor Area Generated table provides information on the IH floor area generated by generating sites in the program. The Voluntary Inclusionary Housing (VIH) open data is published in four tables. Please see the documentation for more information on how these four tables relate. For a complete list of Inclusionary Housing datasets, please follow this link.

This table contains data on the percent of households paying more than 30% (or 50%) of monthly household income towards housing costs for California, its regions, counties, cities/towns, and census tracts. Data is from the U.S. Department of Housing and Urban Development (HUD), Consolidated Planning Comprehensive Housing Affordability Strategy (CHAS) and the U.S. Census Bureau, American Community Survey (ACS). The table is part of a series of indicators in the [Healthy Communities Data and Indicators Project of the Office of Health Equity] Affordable, quality housing is central to health, conferring protection from the environment and supporting family life. Housing costs—typically the largest, single expense in a family's budget—also impact decisions that affect health. As housing consumes larger proportions of household income, families have less income for nutrition, health care, transportation, education, etc. Severe cost burdens may induce poverty—which is associated with developmental and behavioral problems in children and accelerated cognitive and physical decline in adults. Low-income families and minority communities are disproportionately affected by the lack of affordable, quality housing. More information about the data table and a data dictionary can be found in the Attachments.

First launched by the U.S. Department of Housing and Urban Development (HUD) and Department of Transportation (DOT) in November 2013, the Location Affordability Index (LAI) provides ubiquitous, standardized household housing and transportation cost estimates for all 50 states and the District of Columbia. Because what is affordable is different for everyone, users can choose among eight household profiles—which vary by household income, size, and number of commuters—and see the impact of the built environment on affordability in a given location while holding household demographics constant.

Version 3 updates the constituent data sets with 2012-2016 American Community Survey data and makes several methodological tweaks, most notably moving to modeling at the Census tract level rather at the block group. As with Version 2, the inputs to the simultaneous equation model (SEM) include six endogenous variables—housing costs, car ownership, and transit usage for both owners and renters—and 18 exogenous variables, with vehicle miles traveled still modeled separately due to data limitations.To learn more about the Location Affordability Index (v.3) visit: https://www.hudexchange.info/programs/location-affordability-index/, for questions about the spatial attribution of this dataset, please reach out to us at GISHelpdesk@hud.gov. Date of Coverage: 2012-2016 Data Dictionary: DD_Location Affordability Indev v.3.0LAI Version 3 Data and MethodologyLAI Version 3 Technical Documentation

This data, maintained by the Mayor’s Office of Housing (MOH), is an inventory of all income-restricted units in the city. This data includes public housing owned by the Boston Housing Authority (BHA), privately- owned housing built with funding from DND and/or on land that was formerly City-owned, and privately-owned housing built without any City subsidy, e.g., created using Low-Income Housing Tax Credits (LIHTC) or as part of the Inclusionary Development Policy (IDP). Information is gathered from a variety of sources, including the City's IDP list, permitting and completion data from the Inspectional Services Department (ISD), newspaper advertisements for affordable units, Community Economic Development Assistance Corporation’s (CEDAC) Expiring Use list, and project lists from the BHA, the Massachusetts Department of Housing and Community Development (DHCD), MassHousing, and the U.S. Department of Housing and Urban Development (HUD), among others. The data is meant to be as exhaustive and up-to-date as possible, but since many units are not required to report data to the City of Boston, MOH is constantly working to verify and update it. See the data dictionary for more information on the structure of the data and important notes. The database only includes units that have a deed-restriction. It does not include tenant-based (also known as mobile) vouchers, which subsidize rent, but move with the tenant and are not attached to a particular unit. There are over 22,000 tenant-based vouchers in the city of Boston which provide additional affordability to low- and moderate-income households not accounted for here. The Income-Restricted Housing report can be directly accessed here:
https://www.boston.gov/sites/default/files/file/2023/04/Income%20Restricted%20Housing%202022_0.pdf

Learn more about income-restricted housing (as well as other types of affordable housing) here: https://www.boston.gov/affordable-housing-boston#income-restricted

This dataset was developed by the Research & Analytics Group at the Atlanta Regional Commission using data from the U.S. Census Bureau across all standard and custom geographies at statewide summary level where applicable.

For a deep dive into the data model including every specific metric, see the ACS 2016-2020 Data Manifest. The manifest details ARC-defined naming conventions, field names/descriptions and topics, summary levels; source tables; notes and so forth for all metrics.

Prefixes:

None

Count

p

Percent

r

Rate

m

Median

a

Mean (average)

t

Aggregate (total)

ch

Change in absolute terms (value in t2 - value in t1)

pch

Percent change ((value in t2 - value in t1) / value in t1)

chp

Change in percent (percent in t2 - percent in t1)

s

Significance flag for change: 1 = statistically significant with a 90% CI, 0 = not statistically significant, blank = cannot be computed

Suffixes:

_e20

Estimate from 2016-20 ACS

_m20

Margin of Error from 2016-20 ACS

_e10

2006-10 ACS, re-estimated to 2020 geography

_m10

Margin of Error from 2006-10 ACS, re-estimated to 2020 geography

_e10_20

Change, 2010-20 (holding constant at 2020 geography)

Geographies

AAA = Area Agency on Aging (12 geographic units formed from counties providing statewide coverage)

ARWDB7 = Atlanta Regional Workforce Development Board (7 counties merged to a single geographic unit)

Census Tracts (statewide)

CFGA23 = Community Foundation for Greater Atlanta (23 counties merged to a single geographic unit)

City (statewide)

City of Atlanta Council Districts (City of Atlanta)

City of Atlanta Neighborhood Planning Unit (City of Atlanta)

City of Atlanta Neighborhood Planning Unit STV (subarea of City of Atlanta)

City of Atlanta Neighborhood Statistical Areas (City of Atlanta)

County (statewide)

Georgia House (statewide)

Georgia Senate (statewide)

MetroWater15 = Atlanta Metropolitan Water District (15 counties merged to a single geographic unit)

Regional Commissions (statewide)

State of Georgia (statewide)

Superdistrict (ARC region)

US Congress (statewide)

UWGA13 = United Way of Greater Atlanta (13 counties merged to a single geographic unit)

WFF = Westside Future Fund (subarea of City of Atlanta)

ZIP Code Tabulation Areas (statewide)

The user should note that American Community Survey data represent estimates derived from a surveyed sample of the population, which creates some level of uncertainty, as opposed to an exact measure of the entire population (the full census count is only conducted once every 10 years and does not cover as many detailed characteristics of the population). Therefore, any measure reported by ACS should not be taken as an exact number – this is why a corresponding margin of error (MOE) is also given for ACS measures. The size of the MOE relative to its corresponding estimate value provides an indication of confidence in the accuracy of each estimate. Each MOE is expressed in the same units as its corresponding measure; for example, if the estimate value is expressed as a number, then its MOE will also be a number; if the estimate value is expressed as a percent, then its MOE will also be a percent.

The user should also note that for relatively small geographic areas, such as census tracts shown here, ACS only releases combined 5-year estimates, meaning these estimates represent rolling averages of survey results that were collected over a 5-year span (in this case 2016-2020). Therefore, these data do not represent any one specific point in time or even one specific year. For geographic areas with larger populations, 3-year and 1-year estimates are also available.

For further explanation of ACS estimates and margin of error, visit Census ACS website.

Source: U.S. Census Bureau, Atlanta Regional Commission Date: 2016-2020 Data License: Creative Commons Attribution 4.0 International (CC by 4.0)

Link to the manifest: https://opendata.atlantaregional.com/documents/GARC::acs-2020-data-manifest/about

Analysis of ‘Affordable Housing by Town 2011-2020’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/12fb0759-dd5d-4701-a95d-3a7365723c24 on 27 January 2022.

--- Dataset description provided by original source is as follows ---

The Affordable Housing Appeals Procedure List is published annually on or about February 1. The data for the Affordable Housing Appeals Procedure List comes from different sources including federal, state and local programs. This makes it difficult to ensure complete accuracy, so DOH asks municipalities to provide a local administrative review of and input on the street addresses of units and projects as well as information on deed-restricted units. The responses received by DOH vary widely from each municipality.

In developing the Affordable Housing Appeals Procedure List, DOH counts:

-Assisted housing units or housing receiving financial assistance under any governmental program for the construction or substantial rehabilitation of low and moderate income housing that was occupied or under construction by the end date of the report period for compilation of a given year’s list; -Rental housing occupied by persons receiving rental assistance under C.G.S. Chapter 138a (State Rental Assistance/RAP) or Section 142f of Title 42 of the U.S. Code (Section 8); -Ownership housing or housing currently financed by the Connecticut Housing Finance Authority and/or the U.S. Department of Agriculture; and -Deed-restricted properties or properties with deeds containing covenants or restrictions that require such dwelling unit(s) be sold or rented at or below prices that will preserve the unit(s) as affordable housing as defined in C.G.S. Section 8-39a for persons or families whose incomes are less than or equal to 80% of the area median income.

--- Original source retains full ownership of the source dataset ---

The Affordable Housing Inventory is a statewide resource for anyone seeking affordable housing information in Oregon. The Oregon Health Authority (OHA) is not the originator of this information. The inventory has been assembled from a variety of various industry databases that are intended to provide information on affordable and subsidized housing in Oregon. OHA makes no warranties or guarantees about the accuracy or effectiveness of the information in the housing inventory. OHA will continue to assess data quantity and quality, making corrections as needed or warranted. Information regarding changes to the information in this inventory may be submitted to affordablehousing.inventory@dhsoha.state.or.us.

Negative Equity in U.S. Housing Market

Measuring Home Values, Debt, and Credit Risk

By Zillow Data [source]

About this dataset

This dataset, Negative Equity in the US Housing Market, provides an in-depth look into the negative equity occurring across the United States during this single quarter. Included are metrics such as total amount of negative equity in millions of dollars, total number of homes in negative equity, percentage of homes with mortgages that are in negative equity and more. These data points provide helpful insights into both regional and national trends regarding the prevalence and rate of home mortgage delinquency stemming from a diminishment of value from peak levels.

Home types available for analysis include 'all homes', condos/co-ops, multifamily units containing five or more housing units as well as duplexes/triplexes. Additionally, Cash buyers rates for particular areas can also be determined by referencing this collection. Further metrics such as mortgage affordability rates and impacts on overall indebtedness are readily calculated using information related to Zillow's Home Value Index (ZHVI) forecast methodology and TransUnion data respectively.

Other variables featured within this dataset include characteristics like region type (i.e city, county ..etc), size rank based on population values , percentage change in ZHVI since peak levels as well as loan-to-value ratio greater than 200 across all regions constituted herein (NE). Moreover Zillow's own Secondary Mortgage Market Survey data is utilized to acquire average mortgage quote rates while correlative Census Bureau NCHS median household income figures represent typical assessable proportions between wages and debt obligations . So whether you're looking to assess effects along metro lines or detailed buffering through zip codes , this database should prove sufficient for insightful explorations! Nonetheless users must strictly adhere to all conditions encompassed within Terms Of Use commitments put forth by our lead provider before accessing any resources included herewith

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

Research Ideas

• Analyzing regional and state trends in negative equity: Analyze geographic differences in the percentage of mortgages “underwater”, total amount of negative equity, number of homes at least 90 days late, and other key indicators to provide insight into the factors influencing negative equity across regions, states and cities.
• Tracking the recovery rate over time: Track short-term changes in numbers related to negative equity (e.g., region or area ZHVI Change from Peak) to monitor recovery rates over time as well as how different policy interventions are affecting homeownership levels in affected areas.
• Exploring best practices for promoting housing affordability: Compare affordability metrics (e.g., mortgage payments, price-to-income ratios) across different geographic locations over time to identify best practices for empowering homeowners and promoting stability within the housing market while reducing local inequality impacts related to availability of affordable housing options and access to credit markets like mortgages/loans etc

Acknowledgements

If you use this dataset in your research, please credit the original authors. Data Source

License

See the dataset description for more information.

Columns

File: NESummary_2017Q1_Public.csv | Column name | Description | |:------------------------------------------------|:-----------------------------------------------------------------------------------------------------------------------------------| | RegionType | The type of region (e.g., city, county, metro etc.) (String) | | City | Name of the city (String) | | County | Name of the county (String) | | State | Name of the state (String) | | Metro ...

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...

Analysis of ‘Inclusionary Housing Properties’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/44dbd898-1a11-45c1-87ea-0fa73d6d5bd3 on 26 January 2022.

--- Dataset description provided by original source is as follows ---

The Inclusionary Housing Program is designed to preserve and promote affordable housing within neighborhoods where zoning has been modified to encourage new development. The Voluntary Inclusionary Housing program, enacted in 1987, enables a development to receive a density bonus in return for the new construction, substantial rehabilitation, or preservation of permanently affordable housing. The Inclusionary Housing Properties table includes both generating sites and compensated developments. Please note that some properties are both generating sites and compensated developments. The Voluntary Inclusionary Housing (VIH) open data is published in four tables. Please see the documentation for more information on how these four tables relate.

For a complete list of Inclusionary Housing datasets, please follow this link.

--- Original source retains full ownership of the source dataset ---

Public Housing was established to provide decent and safe rental housing for eligible low-income families, the elderly, and persons with disabilities. Public housing comes in all sizes and types, from scattered single family houses to high-rise apartments for elderly families. There are approximately 1.2 million households living in public housing units, managed by over 3,300 housing agencies (HAs). HUD administers Federal aid to local housing agencies (HAs) that manage the housing for low-income residents at rents they can afford. HUD furnishes technical and professional assistance in planning, developing and managing these developments. Location data for HUD-related properties and facilities are derived from HUD's enterprise geocoding service. While not all addresses are able to be geocoded and mapped to 100% accuracy, we are continuously working to improve address data quality and enhance coverage. Please consider this issue when using any datasets provided by HUD. When using this data, take note of the field titled “LVL2KX” which indicates the overall accuracy of the geocoded address using the following return codes: ‘R’ - Interpolated rooftop (high degree of accuracy, symbolized as green) ‘4’ - ZIP+4 centroid (high degree of accuracy, symbolized as green) ‘B’ - Block group centroid (medium degree of accuracy, symbolized as yellow) ‘T’ - Census tract centroid (low degree of accuracy, symbolized as red) ‘2’ - ZIP+2 centroid (low degree of accuracy, symbolized as red) ‘Z’ - ZIP5 centroid (low degree of accuracy, symbolized as red) ‘5’ - ZIP5 centroid (same as above, low degree of accuracy, symbolized as red) Null - Could not be geocoded (does not appear on the map) For the purposes of displaying the location of an address on a map only use addresses and their associated lat/long coordinates where the LVL2KX field is coded ‘R’ or ‘4’. These codes ensure that the address is displayed on the correct street segment and in the correct census block. The remaining LVL2KX codes provide a cascading indication of the most granular level geography for which an address can be confirmed. For example, if an address cannot be accurately interpolated to a rooftop (‘R’), or ZIP+4 centroid (‘4’), then the address will be mapped to the centroid of the next nearest confirmed geography: block group, tract, and so on. When performing any point-in polygon analysis it is important to note that points mapped to the centroids of larger geographies will be less likely to map accurately to the smaller geographies of the same area. For instance, a point coded as ‘5’ in the correct ZIP Code will be less likely to map to the correct block group or census tract for that address. To learn more about Public Housing visit: https://www.hud.gov/program_offices/public_indian_housing/programs/ph/, for questions about the spatial attribution of this dataset, please reach out to us at GISHelpdesk@hud.gov. Data Dictionary: DD_Public Housing Authorities Date Updated: Q4 2024

HUD administers Federal aid to local Housing Agencies (HAs) that manage housing for low-income residents at rents they can afford. Likewise, HUD furnishes technical and professional assistance in planning, developing, and managing the buildings that comprise low-income housing developments. This dataset provides the location and resident characteristics of public housing development buildings. Location data for HUD-related properties and facilities are derived from HUD's enterprise geocoding service. While not all addresses are able to be geocoded and mapped to 100% accuracy, we are continuously working to improve address data quality and enhance coverage. Please consider this issue when using any datasets provided by HUD. When using this data, take note of the field titled “LVL2KX” which indicates the overall accuracy of the geocoded address using the following return codes: ‘R’ - Interpolated rooftop (high degree of accuracy, symbolized as green) ‘4’ - ZIP+4 centroid (high degree of accuracy, symbolized as green) ‘B’ - Block group centroid (medium degree of accuracy, symbolized as yellow) ‘T’ - Census tract centroid (low degree of accuracy, symbolized as red) ‘2’ - ZIP+2 centroid (low degree of accuracy, symbolized as red) ‘Z’ - ZIP5 centroid (low degree of accuracy, symbolized as red) ‘5’ - ZIP5 centroid (same as above, low degree of accuracy, symbolized as red) Null - Could not be geocoded (does not appear on the map) For the purposes of displaying the location of an address on a map only use addresses and their associated lat/long coordinates where the LVL2KX field is coded ‘R’ or ‘4’. These codes ensure that the address is displayed on the correct street segment and in the correct census block. The remaining LVL2KX codes provide a cascading indication of the most granular level geography for which an address can be confirmed. For example, if an address cannot be accurately interpolated to a rooftop (‘R’), or ZIP+4 centroid (‘4’), then the address will be mapped to the centroid of the next nearest confirmed geography: block group, tract, and so on. When performing any point-in polygon analysis it is important to note that points mapped to the centroids of larger geographies will be less likely to map accurately to the smaller geographies of the same area. For instance, a point coded as ‘5’ in the correct ZIP Code will be less likely to map to the correct block group or census tract for that address. In an effort to protect Personally Identifiable Information (PII), the characteristics for each building are suppressed with a -4 value when the “Number_Reported” is equal to, or less than 10. To learn more about Public Housing visit: https://www.hud.gov/program_offices/public_indian_housing/programs/ph/ Development FAQs - IMS/PIC | HUD.gov / U.S. Department of Housing and Urban Development (HUD), for questions about the spatial attribution of this dataset, please reach out to us at GISHelpdesk@hud.gov. Data Dictionary: DD_Public Housing Buildings Date Updated: Q1 2025

The Local Employment Dynamics (LED) Partnership is a voluntary federal-state enterprise created for the purpose of merging employee, and employer data to provide a set of enhanced labor market statistics known collectively as Quarterly Workforce Indicators (QWI). The QWI are a set of economic indicators including employment, job creation, earnings, and other measures of employment flows. For the purposes of this dataset, LED data for 2018 is aggregated to Census Summary Level 070 (State + County + County Subdivision + Place/Remainder), and joined with the Home Investment Partnership (HOME) Program grantee areas spatial dataset for FY2018. Authorized under Title II of the Cranston-Gonzalez National Affordable Housing Act, the HOME Investment Partnership Program (HOME) is designed exclusively to create affordable housing for low-income households. Each year the HOME Program allocates approximately $2 billion to fund the development, purchase, or rehabilitation of affordable housing, and to provide direct rental assistance.

Please note that this version of the data does not include Community Planning and Development (CPD) entitlement grantees. LED data for CPD entitlement areas can be obtained from the LED for CDBG Grantee Areas feature service.

To learn more about the Local Employment Dynamics (LED) Partnership visit: https://lehd.ces.census.gov/, for questions about the spatial attribution of this dataset, please reach out to us at GISHelpdesk@hud.gov. Data Dictionary: DD_LED for HOME Grantee Areas

Date of Coverage: HOME-2021/LED-2018