A dataset comprising various variables around housing and demographics for the top 50 American cities by population.

Variables:

Zip Code: Zip code within which the listing is present.

Price: Listed price for the property.

Beds: Number of beds mentioned in the listing.

Baths: Number of baths mentioned in the listing.

Living Space: The total size of the living space, in square feet, mentioned in the listing.

Address: Street address of the listing.

City: City name where the listing is located.

State: State name where the listing is located.

Zip Code Population: The estimated number of individuals within the zip code. Data from Simplemaps.com.

Zip Code Density: The estimated number of individuals per square mile within the zip code. Data from Simplemaps.com.

County: County where the listing is located.

Median Household income: Estimated median household income. Data from the U.S. Census Bureau.

Latitude: Latitude of the zip code. ** Data from Simplemaps.com.**

Longitude: Longitude of the zip code. Data from Simplemaps.com.

Affordability ratios calculated by dividing house prices by gross annual residence-based earnings. Based on the median and lower quartiles of both house prices and earnings in England and Wales.

https://raw.githubusercontent.com/Masterx-AI/Project_Housing_Price_Prediction_/main/hs.jpg" alt="">

Description:

A simple yet challenging project, to predict the housing price based on certain factors like house area, bedrooms, furnished, nearness to mainroad, etc. The dataset is small yet, it's complexity arises due to the fact that it has strong multicollinearity. Can you overcome these obstacles & build a decent predictive model?

Acknowledgement:

Harrison, D. and Rubinfeld, D.L. (1978) Hedonic prices and the demand for clean air. J. Environ. Economics and Management 5, 81–102. Belsley D.A., Kuh, E. and Welsch, R.E. (1980) Regression Diagnostics. Identifying Influential Data and Sources of Collinearity. New York: Wiley.

Objective:

• Understand the Dataset & cleanup (if required).
• Build Regression models to predict the sales w.r.t a single & multiple feature.
• Also evaluate the models & compare thier respective scores like R2, RMSE, etc.

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.

The standardised house price-to-income ratio is defined as the ratio of the current price to income ratio relative to the long-term average price-to-income ratio, calculated over the period 2000 to the most recent data available. If the ratio equals 100, it means the current price-to-income ratio is equal to its long term average. House prices are provided by Eurostat, and income is calculated as adjusted household gross disposable income (B7G) per head of population based on Eurostat data.

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

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.

This dataset provides insights into the global housing market, covering various economic factors from 2015 to 2024. It includes details about property prices, rental yields, interest rates, and household income across multiple countries. This dataset is ideal for real estate analysis, financial forecasting, and market trend visualization.

📑 Column Descriptions

A commonly accepted threshold for affordable housing costs at the household level is 30% of a household's income. Accordingly, a household is considered cost burdened if it pays more than 30% of its income on housing. Households paying more than 50% are considered severely cost burdened. These thresholds apply to both homeowners and renters.

The Housing Affordability indicator only measures cost burden among the region's households, and not the supply of affordable housing. The directionality of cost burden trends can be impacted by changes in both income and housing supply. If lower income households are priced out of a county or the region, it would create a downward trend in cost burden, but would not reflect a positive trend for an inclusive housing market.

This dataset contains the ratio of lower quartile/median house price to lower quartile/median earnings in England

Graph and download economic data for Median Sales Price of Houses Sold for the United States (MSPUS) from Q1 1963 to Q2 2025 about sales, median, housing, and USA.

Affordability ratios calculated by dividing house prices by gross annual workplace-based earnings. Based on the median and lower quartiles of both house prices and earnings in England and Wales.

The 2006 Second Edition TIGER/Line files are an extract of selected geographic and cartographic information from the Census TIGER database. The geographic coverage for a single TIGER/Line file is a county or statistical equivalent entity, with the coverage area based on the latest available governmental unit boundaries. The Census TIGER database represents a seamless national file with no overlaps or gaps between parts. However, each county-based TIGER/Line file is designed to stand alone as an independent data set or the files can be combined to cover the whole Nation. The 2006 Second Edition TIGER/Line files consist of line segments representing physical features and governmental and statistical boundaries. This shapefile represents the current State House Districts for New Mexico as posted on the Census Bureau website for 2006.

Rental Affordability Analysis Based on Median Income

Trends in Tier-Based Affordability Across the U.S

By Zillow Data [source]

About this dataset

This dataset contains rental affordability data for different regions in the US, giving valuable insights into regional rental markets. Renters can use this information to identify where their budget will go the farthest. The cities are organized by rent tier in order to analyze affordability trends within and between different housing stock types. Within each region, the data includes median household income, Zillow Rent Index (ZRI), and percent of income spent on rent.

The Zillow Home Value Forecast (ZHVF) is used to calculate future combined mortgage pay/rent payments in each region using current median home prices, actual outstanding debt amounts and 30-year fixed mortgage interest rates reported through partnership with TransUnion credit bureau. Zillow also provides a breakdown of cash vs financing purchases for buyers looking for an investment or cash option solution.

This dataset provides an effective tool for consumers who want to better understand how their budget fits into diverse rental markets across the US; from condominiums and co-ops, multifamily residences with five or more units, duplexes and triplexes - every renter can determine how their housing budget should be adjusted as they consider multiple living possibilities throughout the country based on real-time price data!

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

Introduction

Getting Started

• First, you'll need to download the TieredAffordability_Rental.csv dataset from this Kaggle page onto your computer or device.

• After downloading the data set onto your device, open it with any CSV viewing software of your choice (ex: Excel). It will include columns for RegionName**RegionName** , homes type/housing stock (All Homes or Condo/Co-op) SizeRank , Rent tier tier , Date date , median household income income , Zillow Rent Index zri and PercentIncomeSpentOnRent percentage (what portion of monthly median house-hold goes toward monthly mortgage payment) .

• To begin analyzing rental prices across different regions using this dataset, look first at column four: SizeRank; which ranks each region based on size - smallest regions listed first and largest at last - so that you can compare a similar range of Regions when looking at affordability by home sizes larger than one unit multiplex dwellings.*Duples/Triplex*. Once there is an understanding of how all homes compare overall now it is time to consider home types Multifamily 5+ units according to rent tiers tier .

• Next, choose one or more region(s) for comparison based on their rank in SizeRank column –so that all information gathered about them reflects what portionof households fall into certain categories ; eg; All Homes / Small Home /Large Home / MultiPlex Dwelling and what tier does each size rank falls into eg.: Affordable/Slightly Expensive/ Moderately Expensive etc.. This will enable further abstraction from other elements like date vs inflation rate per month or periodical intervals set herein by Rate segmentation i e dates givenin ‘Date’Columns – making the task easier and more direct while analyzing renatalAffordibility Analysis Based On Median Income zri 00 zwi & PCISOR 00 PCIRO

Research Ideas

• Use the PercentIncomeSpentOnRent column to compare rental affordability between regions within a particular tier and determine optimal rent tiers for relocating families.
• Analyze how market conditions are affecting rental affordability over time by using the income, zri, and PercentageIncomeSpentOnRent columns.
• Identify trends in housing prices for different tiers over the years by comparing SizeRank data with Zillow Home Value Forecast (ZHVF) numbers across different regions in order to identify locations that may be headed up or down in terms of home values (and therefore rent levels)

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: TieredAffordability_Rental.csv | Column name | Description | |:-----------------------------|:-------------------------------------------------------------| | RegionName | The name of the region. (String) ...

This dataset contains the ratio of median house price to median earnings by district from 1997 to 2012.

This data set uses the median house price data from Land Registry on residential house price transactions at full market value, this means it excludes all: commercial transactions, transfer, conveyances, assignments or lease at a premium with nominal rent which are: Right to Buy sales at a discount, subject to a lease, subject to an existing mortgage, by way of a gift or exchange or under a court order or Compulsory Purchase Order. This is compared to the median income data of full time workers from the Annual Survey of Hours and Earnings (ASHE) produced by the ONS.

This data was derived from Table 577, available for download as an Excel spreadsheet.

This table shows the average House Price/Earnings ratio, which is an important indicator of housing affordability. Ratios are calculated by dividing house price by the median earnings of a borough. The Annual Survey of Hours and Earnings (ASHE) is based on a 1 per cent sample of employee jobs. Information on earnings and hours is obtained in confidence from employers. It does not cover the self-employed nor does it cover employees not paid during the reference period. Information is as at April each year. The statistics used are workplace based full-time individual earnings. Pre-2013 Land Registry housing data are for the first half of the year only, so that they are comparable to the ASHE data which are as at April. This is no longer the case from 2013 onwards as this data uses house price data from the ONS House Price Statistics for Small Areas statistical release. Prior to 2006 data are not available for Inner and Outer London. The lowest 25 per cent of prices are below the lower quartile; the highest 75 per cent are above the lower quartile. The "lower quartile" property price/income is determined by ranking all property prices/incomes in ascending order. The 'median' property price/income is determined by ranking all property prices/incomes in ascending order. The point at which one half of the values are above and one half are below is the median. Regional data has not been published by DCLG since 2012. Data for regions has been calculated by the GLA. Data since 2014 has been calculated by the GLA using Land Registry house prices and ONS Earnings data. Link to DCLG Live Tables An interactive map showing the affordability ratios by local authority for 2013, 2014 and 2015 is also available.

Australia Standardised Price-Income Ratio: sa data was reported at 149.268 Ratio in Dec 2024. This records a decrease from the previous number of 152.371 Ratio for Sep 2024. Australia Standardised Price-Income Ratio: sa data is updated quarterly, averaging 82.643 Ratio from Mar 1970 (Median) to Dec 2024, with 220 observations. The data reached an all-time high of 153.422 Ratio in Jun 2024 and a record low of 62.554 Ratio in Sep 1983. Australia Standardised Price-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 Australia – Table AU.OECD.AHPI: House Price Index: Seasonally Adjusted: OECD Member: Quarterly. 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. The long-term average is calculated over the whole period available when the indicator begins after 1980 or after 1980 if the indicator is longer. This value is used as a reference value. The ratio is calculated by dividing the indicator source on this long-term average, and indexed to a reference value equal to 100.

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

URA28 - Gross Median Household Income Compared to Median Property Prices - Dataset - data.gov.ie

Context

This dataset is created via OECD datasource which is consisted of 2000 between 2020. https://data.oecd.org/price/housing-prices.htm

Content

The housing prices indicator shows indices of residential property prices over time. Included are rent prices, real and nominal house prices, and ratios of price to rent and price to income; the main elements of housing costs. In most cases, the nominal house price covers the sale of newly-built and existing dwellings, following the recommendations from RPPI (Residential Property Prices Indices) manual. The real house price is given by the ratio of nominal price to the consumers’ expenditure deflator in each country, both seasonally adjusted, from the OECD national accounts database. The price to income ratio is the nominal house price divided by the nominal disposable income per head and can be considered as a measure of affordability. The price to rent ratio is the nominal house price divided by the rent price and can be considered as a measure of the profitability of house ownership. This indicator is an index with base year 2015.