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.

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 workplace-based earnings. Based on the median and lower quartiles of both house prices and earnings in England and Wales.

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.

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

Housing affordability (median house prices to earnings ratio)

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.

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

Context

Demand for houses has exploded in the UK in the last two years due to the pandemic. As a result, it feels like it is becoming more difficult for young people to afford to buy a house in the near future. I wanted to collect data to see if this sentiment is backed up by numbers.

Content

In this folder you will find the average house price in the UK between between 1975 and 2020, the median wage in the UK between 1999 and 2020. Both of these metrics have been adjusted by inflation up to 2020.

This folder also contains a table containing data on the wage gap in 2021, in the UK and by age group.

Sources

Statista: https://www.statista.com/statistics/802183/annual-pay-employees-in-the-uk/ and https://www.statista.com/statistics/1002964/average-full-time-annual-earnings-in-the-uk/.

allAgents: https://www.allagents.co.uk/house-prices-adjusted/.

Bank of England: https://www.bankofengland.co.uk/monetary-policy/inflation/inflation-calculator.

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.

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.

Housing affordability (lower quartile house prices to earnings ratio) *This indicator has been discontinued

Housing affordability (house prices to earnings ratio) *This indicator has been discontinued

About Dataset

All the following text is copied directly from the original dataset used: https://www.kaggle.com/datasets/fedesoriano/the-boston-houseprice-data
The only difference is that features 12 and 13 have been removed for simplicity. See original link for a version with those features in place.

Similar Datasets

Gender Pay Gap Dataset: https://www.kaggle.com/fedesoriano/gender-pay-gap-dataset
California Housing Prices Data (5 new features!): https://www.kaggle.com/fedesoriano/california-housing-prices-data-extra-features
Company Bankruptcy Prediction: https://www.kaggle.com/fedesoriano/company-bankruptcy-prediction
Spanish Wine Quality Dataset: https://www.kaggle.com/datasets/fedesoriano/spanish-wine-quality-dataset

Context

The Boston house-price data of Harrison, D. and Rubinfeld, D.L. 'Hedonic prices and the demand for clean air', J. Environ. Economics & Management, vol.5, 81-102, 1978.

Attribute Information

Input features in order: 1) CRIM: per capita crime rate by town
2) ZN: proportion of residential land zoned for lots over 25,000 sq.ft.
3) INDUS: proportion of non-retail business acres per town
4) CHAS: Charles River dummy variable (1 if tract bounds river; 0 otherwise)
5) NOX: nitric oxides concentration (parts per 10 million) [parts/10M]
6) RM: average number of rooms per dwelling
7) AGE: proportion of owner-occupied units built prior to 1940
8) DIS: weighted distances to five Boston employment centres
9) RAD: index of accessibility to radial highways
10) TAX: full-value property-tax rate per $10,000 [$/10k]
11) PTRATIO: pupil-teacher ratio by town
[Original features 12 and 13 have been deliberately removed from this version of the dataset]

Output variable:
1) MEDV: Median value of owner-occupied homes in $1000's [k$]

Source

StatLib - Carnegie Mellon University

Relevant Papers

Harrison, David & Rubinfeld, Daniel. (1978). Hedonic housing prices and the demand for clean air. Journal of Environmental Economics and Management. 5. 81-102. 10.1016/0095-0696(78)90006-2. https://www.researchgate.net/profile/Daniel-Rubinfeld/publication/4974606_Hedonic_housing_prices_and_the_demand_for_clean_air/links/5c38ce85458515a4c71e3a64/Hedonic-housing-prices-and-the-demand-for-clean-air.pdf

Belsley, David A. & Kuh, Edwin. & Welsch, Roy E. (1980). Regression diagnostics: identifying influential data and sources of collinearity. New York: Wiley https://www.wiley.com/en-us/Regression+Diagnostics%3A+Identifying+Influential+Data+and+Sources+of+Collinearity-p-9780471691174

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.

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 is the unadjusted lower quartile house priced for residential property sales (transactions) in the area for a 12 month period with April in the middle (year-ending September). These figures have been produced by the ONS (Office for National Statistics) using the Land Registry (LR) Price Paid data on residential dwelling transactions.

The LR Price Paid data are comprehensive in that they capture changes of ownership for individual residential properties which have sold for full market value and covers both cash sales and those involving a mortgage.

The lower quartile is the value determined by putting all the house sales for a given year, area and type in order of price and then selecting the price of the house sale which falls three quarters of the way down the list, such that 75Percentage of transactions lie above and 25Percentage lie below that value. These are particularly useful for assessing housing affordability when viewed alongside average and lower quartile income for given areas.

Note that a transaction occurs when a change of freeholder or leaseholder takes place regardless of the amount of money involved and a property can transact more than once in the time period.

The LR records the actual price for which the property changed hands. This will usually be an accurate reflection of the market value for the individual property, but it is not always the case. In order to generate statistics that more accurately reflect market values, the LR has excluded records of houses that were not sold at market value from the dataset. The remaining data are considered a good reflection of market values at the time of the transaction. For full details of exclusions and more information on the methodology used to produce these statistics please see http://www.ons.gov.uk/peoplepopulationandcommunity/housing/qmis/housepricestatisticsforsmallareasqmi

The LR Price Paid data are not adjusted to reflect the mix of houses in a given area. Fluctuations in the types of house that are sold in that area can cause differences between the lower quartile transactional value of houses and the overall market value of houses.

If, for a given year, for house type and area there were fewer than 5 sales records in the LR Price Paid data, the house price statistics are not reported." Data is Powered by LG Inform Plus and automatically checked for new data on the 3rd of each month.

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.

The Global Housing Watch tracks developments in housing markets across the world on a quarterly basis. It provides current data on house prices as well as metrics used to assess valuation in housing markets, such as house price‑to‑rent and house-price‑to‑income ratios. This collection includes only a subset of indicators from the source dataset.