United States US: Price to Income Ratio: sa data was reported at 130.892 2015=100 in 2024. This records an increase from the previous number of 129.315 2015=100 for 2023. United States US: Price to Income Ratio: sa data is updated yearly, averaging 113.539 2015=100 from Dec 1970 (Median) to 2024, with 55 observations. The data reached an all-time high of 132.929 2015=100 in 1979 and a record low of 90.287 2015=100 in 2012. United States US: Price to Income Ratio: sa data remains active status in CEIC and is reported by Organisation for Economic Co-operation and Development. The data is categorized under Global Database’s United States – Table US.OECD.AHPI: House Price Index: Seasonally Adjusted: OECD Member: Annual. Nominal house prices divided by nominal disposable income per head. Net household disposable income is used. The population data come from the OECD national accounts database.

Portugal, Canada, and the United States were the countries with the highest house price to income ratio in 2024. In all three countries, the index exceeded 130 index points, while the average for all OECD countries stood at 116.2 index points. The index measures the development of housing affordability and is calculated by dividing nominal house price by nominal disposable income per head, with 2015 set as a base year when the index amounted to 100. An index value of 120, for example, would mean that house price growth has outpaced income growth by 20 percent since 2015. How have house prices worldwide changed since the COVID-19 pandemic? House prices started to rise gradually after the global financial crisis (2007–2008), but this trend accelerated with the pandemic. The countries with advanced economies, which usually have mature housing markets, experienced stronger growth than countries with emerging economies. Real house price growth (accounting for inflation) peaked in 2022 and has since lost some of the gain. Although, many countries experienced a decline in house prices, the global house price index shows that property prices in 2023 were still substantially higher than before COVID-19. Renting vs. buying In the past, house prices have grown faster than rents. However, the home affordability has been declining notably, with a direct impact on rental prices. As people struggle to buy a property of their own, they often turn to rental accommodation. This has resulted in a growing demand for rental apartments and soaring rental prices.

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

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.

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

Price to Rent Ratio in the United States increased to 134.20 in the fourth quarter of 2024 from 133.60 in the third quarter of 2024. This dataset includes a chart with historical data for the United States Price to Rent Ratio.

The Housing Affordability Data System (HADS) is a set of housing unit level datasets that measures the affordability of housing units and the housing cost burdens of households, relative to area median incomes, poverty level incomes, and Fair Market Rents. The purpose of these datasets is to provide housing analysts with consistent measures of affordability and burdens over a long period. The datasets are based on the American Housing Survey (AHS) national files from 1985 through 2005 and the metropolitan files for 2002 and 2004. Users can link records in HADS files to AHS records, allowing access to all of the AHS variables. Housing-level variables include information on the number of rooms in the housing unit, the year the unit was built, whether it was occupied or vacant, whether the unit was rented or owned, whether it was a single family or multiunit structure, the number of units in the building, the current market value of the unit, and measures of relative housing costs. The dataset also includes variables describing the number of people living in the household, household income, and the type of residential area (e.g., urban or suburban).

The average sales price of new homes in the United States experienced a slight decrease in 2024, dropping to 512,2000 U.S. dollars from the peak of 521,500 U.S. dollars in 2022. This decline came after years of substantial price increases, with the average price surpassing 400,000 U.S. dollars for the first time in 2021. The recent cooling in the housing market reflects broader economic trends and changing consumer sentiment towards homeownership. Factors influencing home prices and affordability The rapid rise in home prices over the past few years has been driven by several factors, including historically low mortgage rates and increased demand during the COVID-19 pandemic. However, the market has since slowed down, with the number of home sales declining by over two million between 2021 and 2023. This decline can be attributed to rising mortgage rates and decreased affordability. The Housing Affordability Index hit a record low of 98.1 in 2023, indicating that the median-income family could no longer afford a median-priced home. Future outlook for the housing market Despite the recent cooling, experts forecast a potential recovery in the coming years. The Freddie Mac House Price Index showed a growth of 6.5 percent in 2023, which is still above the long-term average of 4.4 percent since 1990. However, homebuyer sentiment remains low across all age groups, with people aged 45 to 64 expressing the most pessimistic outlook. The median sales price of existing homes is expected to increase slightly until 2025, suggesting that affordability challenges may persist in the near future.

The house price for Ontario is forecast to decrease by eight percent in 2023, followed by a minor increase of one percent in 2024. From roughly 932,000 Canadian dollars, the average house price in Canada's second most expensive province for housing is expected to fall to 861,000 Canadian dollars in 2024. After British Columbia, Ontario is Canada's most expensive province for housing. Ontario Ontario is the most populated province in Canada, located on the eastern-central side of the country. It is an English speaking province. To the south, it borders American states Minnesota, Michigan, Ohio, Pennsylvania, and New York. Its provincial capital and largest city is Toronto. It is also home to Canada’s national capital, Ottawa. Furthermore, a large part of Ontario’s economy comes from manufacturing, as it is the leading manufacturing province in Canada. The population of Ontario has been steadily increasing since 2000. The population in 2018 was an estimated 14.3 million people. The median total family income in 2016 came to 83,160 Canadian dollars. Ontario housing market The number of housing units sold in Ontario is projected to rise until 2024. Additionally, the average home prices in Ontario have significantly increased since 2007.

This layer shows housing costs as a percentage of household income. This is shown by tract, county, and state boundaries. This service is updated annually to contain the most currently released American Community Survey (ACS) 5-year data, and contains estimates and margins of error. There are also additional calculated attributes related to this topic, which can be mapped or used within analysis. Income is based on earnings in past 12 months of survey. This layer is symbolized to show the percent of renter households that spend 30.0% or more of their household income on gross rent (contract rent plus tenant-paid utilities). To see the full list of attributes available in this service, go to the "Data" tab, and choose "Fields" at the top right. Current Vintage: 2019-2023ACS Table(s): B25070, B25091 Data downloaded from: Census Bureau's API for American Community Survey Date of API call: December 12, 2024National Figures: data.census.govThe United States Census Bureau's American Community Survey (ACS):About the SurveyGeography & ACSTechnical DocumentationNews & UpdatesThis ready-to-use layer can be used within ArcGIS Pro, ArcGIS Online, its configurable apps, dashboards, Story Maps, custom apps, and mobile apps. Data can also be exported for offline workflows. For more information about ACS layers, visit the FAQ. Please cite the Census and ACS when using this data.Data Note from the Census:Data are based on a sample and are subject to sampling variability. The degree of uncertainty for an estimate arising from sampling variability is represented through the use of a margin of error. The value shown here is the 90 percent margin of error. The margin of error can be interpreted as providing a 90 percent probability that the interval defined by the estimate minus the margin of error and the estimate plus the margin of error (the lower and upper confidence bounds) contains the true value. In addition to sampling variability, the ACS estimates are subject to nonsampling error (for a discussion of nonsampling variability, see Accuracy of the Data). The effect of nonsampling error is not represented in these tables.Data Processing Notes:This layer is updated automatically when the most current vintage of ACS data is released each year, usually in December. The layer always contains the latest available ACS 5-year estimates. It is updated annually within days of the Census Bureau's release schedule. Click here to learn more about ACS data releases.Boundaries come from the US Census TIGER geodatabases, specifically, the National Sub-State Geography Database (named tlgdb_(year)_a_us_substategeo.gdb). Boundaries are updated at the same time as the data updates (annually), and the boundary vintage appropriately matches the data vintage as specified by the Census. These are Census boundaries with water and/or coastlines erased for cartographic and mapping purposes. For census tracts, the water cutouts are derived from a subset of the 2020 Areal Hydrography boundaries offered by TIGER. Water bodies and rivers which are 50 million square meters or larger (mid to large sized water bodies) are erased from the tract level boundaries, as well as additional important features. For state and county boundaries, the water and coastlines are derived from the coastlines of the 2023 500k TIGER Cartographic Boundary Shapefiles. These are erased to more accurately portray the coastlines and Great Lakes. The original AWATER and ALAND fields are still available as attributes within the data table (units are square meters).The States layer contains 52 records - all US states, Washington D.C., and Puerto RicoCensus tracts with no population that occur in areas of water, such as oceans, are removed from this data service (Census Tracts beginning with 99).Percentages and derived counts, and associated margins of error, are calculated values (that can be identified by the "_calc_" stub in the field name), and abide by the specifications defined by the American Community Survey.Field alias names were created based on the Table Shells file available from the American Community Survey Summary File Documentation page.Negative values (e.g., -4444...) have been set to null, with the exception of -5555... which has been set to zero. These negative values exist in the raw API data to indicate the following situations:The margin of error column indicates that either no sample observations or too few sample observations were available to compute a standard error and thus the margin of error. A statistical test is not appropriate.Either no sample observations or too few sample observations were available to compute an estimate, or a ratio of medians cannot be calculated because one or both of the median estimates falls in the lowest interval or upper interval of an open-ended distribution.The median falls in the lowest interval of an open-ended distribution, or in the upper interval of an open-ended distribution. A statistical test is not appropriate.The estimate is controlled. A statistical test for sampling variability is not appropriate.The data for this geographic area cannot be displayed because the number of sample cases is too small.

Analysis of ‘ Zillow Housing Aspirations Report’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/yamqwe/zillow-housing-aspirations-reporte on 13 February 2022.

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

About this dataset

Additional Data Products

Product: Zillow Housing Aspirations Report

Date: April 2017

Definitions

Home Types and Housing Stock

• All Homes: Zillow defines all homes as single-family, condominium and co-operative homes with a county record. Unless specified, all series cover this segment of the housing stock.
• Condo/Co-op: Condominium and co-operative homes.
• Multifamily 5+ units: Units in buildings with 5 or more housing units, that are not a condominiums or co-ops.
• Duplex/Triplex: Housing units in buildings with 2 or 3 housing units.

Additional Data Products

• Zillow Home Value Forecast (ZHVF): The ZHVF is the one-year forecast of the ZHVI. Our forecast methodology is methodology post.
• Zillow creates our negative equity data using our own data in conjunction with data received through our partnership with TransUnion, a leading credit bureau. We match estimated home values against actual outstanding home-related debt amounts provided by TransUnion. To read more about how we calculate our negative equity metrics, please see our here.
• Cash Buyers: The share of homes in a given area purchased without financing/in cash. To read about how we calculate our cash buyer data, please see our research brief.
• Mortgage Affordability, Rental Affordability, Price-to-Income Ratio, Historical ZHVI, Historical ZHVI and Houshold Income are calculated as a part of Zillow’s quarterly Affordability Indices. To calculate mortgage affordability, we first calculate the mortgage payment for the median-valued home in a metropolitan area by using the metro-level Zillow Home Value Index for a given quarter and the 30-year fixed mortgage interest rate during that time period, provided by the Freddie Mac Primary Mortgage Market Survey (based on a 20 percent down payment). Then, we consider what portion of the monthly median household income (U.S. Census) goes toward this monthly mortgage payment. Median household income is available with a lag. For quarters where median income is not available from the U.S. Census Bureau, we calculate future quarters of median household income by estimating it using the Bureau of Labor Statistics’ Employment Cost Index. The affordability forecast is calculated similarly to the current affordability index but uses the one year Zillow Home Value Forecast instead of the current Zillow Home Value Index and a specified interest rate in lieu of PMMS. It also assumes a 20 percent down payment. We calculate rent affordability similarly to mortgage affordability; however we use the Zillow Rent Index, which tracks the monthly median rent in particular geographical regions, to capture rental prices. Rents are chained back in time by using U.S. Census Bureau American Community Survey data from 2006 to the start of the Zillow Rent Index, and Decennial Census for all other years.
• The mortgage rate series is the average mortgage rate quoted on Zillow Mortgages for a 30-year, fixed-rate mortgage in 15-minute increments during business hours, 6:00 AM to 5:00 PM Pacific. It does not include quotes for jumbo loans, FHA loans, VA loans, loans with mortgage insurance or quotes to consumers with credit scores below 720. Federal holidays are excluded. The jumbo mortgage rate series is the average jumbo mortgage rate quoted on Zillow Mortgages for a 30-year, fixed-rate, jumbo mortgage in one-hour increments during business hours, 6:00 AM to 5:00 PM Pacific Time. It does not include quotes to consumers with credit scores below 720. Traditional federal holidays and hours with insufficient sample sizes are excluded.

About Zillow Data (and Terms of Use Information)

• Zillow is in the process of transitioning some data sources with the goal of producing published data that is more comprehensive, reliable, accurate and timely. As this new data is incorporated, the publication of select metrics may be delayed or temporarily suspended. We look forward to resuming our usual publication schedule for all of our established datasets as soon as possible, and we apologize for any inconvenience. Thank you for your patience and understanding.
• All data accessed and downloaded from this page is free for public use by consumers, media, analysts, academics etc., consistent with our published Terms of Use. Proper and clear attribution of all data to Zillow is required.
• For other data requests or inquiries for Zillow Real Estate Research, contact us here.
• All files are time series unless noted otherwise.
• To download all Zillow metrics for specific levels of geography, click here.
• To download a crosswalk between Zillow regions and federally defined regions for counties and metro areas, click here.
• Unless otherwise noted, all series cover single-family residences, condominiums and co-op homes only.

Source: https://www.zillow.com/research/data/

This dataset was created by Zillow Data and contains around 200 samples along with Unnamed: 1, Unnamed: 0, technical information and other features such as: - Unnamed: 1 - Unnamed: 0 - and more.

How to use this dataset

• Analyze Unnamed: 1 in relation to Unnamed: 0
• Study the influence of Unnamed: 1 on Unnamed: 0
• More datasets

Acknowledgements

If you use this dataset in your research, please credit Zillow Data

Start A New Notebook!

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

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.

Context

According to the Zillow Research website, Zillow Home Value Index (ZHVI) is a smoothed, seasonally adjusted measure of the typical home value and market changes across a given region and housing type. In this case we are looking at historic ZHVI for 916 metropolitan regions across the US. The Data also includes the ZHVI for the total United States.

Content

Affordability_ChainedZHVI_2017Q2.csv - includes historic ZHVI data sampled quarterly for 916 metropolitan regions across the US as well as for total US for a period spanning from 03-1979 to 06-2017.

Affordability_Income_2017Q2.csv - includes historic median Income data sampled quarterly for 916 metropolitan regions across the US as well as for total US for a period spanning from 03-1979 to 06-2017.

Acknowledgements

ZHVI and Income data was downloaded from the Zillow Research website.

Inspiration

To understand what factors account for changes in ZHVI values both regionally and nationally.

As part of the Regional Housing Initiative (RHI), the team conducted a submarket analysis. This analysis identifies 2020 census tracts with similar housing characteristics (density, price, market conditions) and groups them accordingly. This submarket analysis uses a Latent Profile Analysis (LPA) via the mclust package in R to group the region's 1,407 eligible census tracts (tracts with no households or population were removed) into one of eight submarkets. The team reviewed the existing conditions of these submarkets to identify their housing challenges and appropriate policies and strategies for each submarket. Census tables used to gather data from the 2016-2020 American Community Survey 5-Year Estimates. Data Dictionary Field Name Source submarket Housing submarket DVRPC hhinc_med Median household income U.S. Census Bureau, ACS 5-Year Estimates, 2016-2020 rent_med Median gross rent U.S. Census Bureau, ACS 5-Year Estimates, 2016-2020 ten_rent Percent of households that are renter-occupied U.S. Census Bureau, ACS 5-Year Estimates, 2016-2020 ten_own Percent of households that are owner-occupied U.S. Census Bureau, ACS 5-Year Estimates, 2016-2020 vcy Residential vacancy rate U.S. Census Bureau, ACS 5-Year Estimates, 2016-2020 hhi_150p Percent of households with incomes of $150,000 or higher U.S. Census Bureau, ACS 5-Year Estimates, 2016-2020 yb_59e Percent of housing units built in 1959 or earlier U.S. Census Bureau, ACS 5-Year Estimates, 2016-2020 yb_6099 Percent of housing units built between 1960 and 1999 U.S. Census Bureau, ACS 5-Year Estimates, 2016-2020 yb_00p Percent of housing units built since 2000 U.S. Census Bureau, ACS 5-Year Estimates, 2016-2020 unit_1 Percent of housing units that are 1 unit in structure U.S. Census Bureau, ACS 5-Year Estimates, 2016-2020 unit_2to4 Percent of housing units that are 2 to 4 units in structure U.S. Census Bureau, ACS 5-Year Estimates, 2016-2020 unit_5p Percent of housing units that are 5 or more units in structure U.S. Census Bureau, ACS 5-Year Estimates, 2016-2020 pct_subsidized Percent of housing units that are federally subsidized (Public housing, Section 8, LIHTC) U.S. Census Bureau, ACS 5-Year Estimates, 2016-2020, National Housing Preservation Database (NHPD) med21 Median single family home sale price, 2021 The Warren Group, 2021 pct_diff Median percent change in median single family home sale price, 2016-2021 The Warren Group, 2016 & 2021 hhs_1 Percent of households that are 1-person households U.S. Census Bureau, ACS 5-Year Estimates, 2016-2020 hhs_2to4 Percent of households that are 2- to 4-person households U.S. Census Bureau, ACS 5-Year Estimates, 2016-2020 hhs_5p Percent of households that are 5 or more person households U.S. Census Bureau, ACS 5-Year Estimates, 2016-2020 hu_acre Housing units per acre U.S. Census Bureau, ACS 5-Year Estimates, 2016-2020 Please contact Brian Carney, bcarney@dvrpc.org, for more information.