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.

In 2022, the annual salary needed to buy a median priced home in the United States was ****** U.S. dollars. However, in some of the largest metropolitan areas in the United States where housing prices are up to *** or ***** times higher, homebuyers would have to earn more than 100,000 U.S. dollars to afford a home. In San Jose, which was the most expensive metro in 2022, the annual salary needed for a median home was approximately ******* U.S. dollars.

The house price to income ratio in the United States has reached concerning levels, with the index hitting ***** in the fourth quarter of 2024. This indicates that house prices have outpaced income growth by over ** percent since 2015, highlighting a growing affordability crisis in the housing market. The widening gap between home prices and wages is putting homeownership out of reach for many Americans, particularly as real wages have remained stagnant. Rising home prices and stagnant wages While average annual real wages in the United States have increased slightly since 2014, home prices have soared. The median sales price of existing single-family homes reached a record-high in 2024, representing a substantial increase over the past five years. This disparity between wage growth and home price appreciation has led to a significant decrease in housing affordability across the country. Affordability challenges in the U.S. housing market The U.S. Housing Affordability Index, which measures whether a family earning the median income can afford a median-priced home, plummeted in 2024, marking the second-worst year for homebuyers since records began. This decline in affordability is reflected in homebuyer sentiment, with homebuyer sentiment plummeting.

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

Hungary increased 9% of House Price to Income Ratio in 2019, from a year earlier.

Japan JP: Standardised Price-Income Ratio: sa data was reported at 87.536 Ratio in 2024. This records a decrease from the previous number of 89.289 Ratio for 2023. Japan JP: Standardised Price-Income Ratio: sa data is updated yearly, averaging 113.262 Ratio from Dec 1960 (Median) to 2024, with 65 observations. The data reached an all-time high of 163.202 Ratio in 1973 and a record low of 73.471 Ratio in 2009. Japan JP: 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 Japan – Table JP.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. 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.

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.

Land Registry housing data are for the first half of the year only, so that they comparable to the ASHE data which are as at April.
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 for 2014 has been calculated by the GLA.

Link to DCLG Live Tables

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.

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.

Israel IL: Price to Income Ratio: sa data was reported at 104.421 2015=100 in 2016. This records an increase from the previous number of 100.000 2015=100 for 2015. Israel IL: Price to Income Ratio: sa data is updated yearly, averaging 91.925 2015=100 from Dec 1995 (Median) to 2016, with 22 observations. The data reached an all-time high of 109.755 2015=100 in 1997 and a record low of 70.115 2015=100 in 2007. Israel IL: 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 Israel – Table IL.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.

The house price to income index in Europe declined in almost all European countries in 2023, indicating that income grew faster than house prices. Portugal, Luxembourg, and the Netherlands led the house price to income index ranking in 2023, with values exceeding *** index points. Romania, Bulgaria, and Finland were on the other side of the spectrum, with less than 100 index points. The house price to income ratio is an indicator for the development of housing affordability across OECD countries and is calculated as the nominal house prices divided by nominal disposable income per head, with 2015 chosen as a base year. A ratio higher than 100 means that the nominal house price growth since 2015 has outpaced the nominal disposable income growth, and housing is therefore comparatively less affordable. In 2023, the OECD average stood at ***** index points.

Graph and download economic data for Other Financial Information: Estimated Market Value of Owned Home by Quintiles of Income Before Taxes: Fourth 20 Percent (61st to 80th Percentile) (CXU800721LB0105M) from 1984 to 2023 about owned, market value, information, percentile, tax, financial, income, housing, estimate, and USA.

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.

EnhancedHousingMarketData.csv is an auxiliary dataset for the "Housing Prices" competition, containing key economic and demographic indicators vital for real estate market analysis. It includes data on non-farm employment, housing price index, per capita income, total quarterly wages, quantitative indexes of real GDP, total GDP, real GDP, stable population, employed individuals, and the average weekly wage in the private sector, along with the unemployment rate. This dataset aids in better understanding the factors influencing housing prices and allows for a more in-depth analysis of the real estate market.

"**TotalNonfarmEmployees**" - reflects the total number of employees working outside the agricultural sector. This figure includes workers in industries such as manufacturing, construction, trade, transportation, education, healthcare, and other non-agricultural sectors, making it a key indicator of economic activity and employment in the region.

"**HousingPriceIndex**" - represents a housing price index, reflecting changes in real estate prices in a specific region for a given month. This index can be used to analyze trends in the real estate market and assess the overall economic conditions.

"**AnnualPerCapitaIncome**" - represents the annual per capita income, measured yearly. This indicator reflects the average income per resident in a specific region over a year, serving as an important measure of the population's economic well-being.

"**QuarterlyTotalWages**" - represents the total quarterly wages, measured in dollars and adjusted for seasonal variations. This metric reflects the sum of wages paid by employers insured for unemployment insurance over a calendar quarter. It includes components such as vacation pay, bonuses, and tips.

"**TotalRealGDPChainIndex**" - represents the total annual quantitative index of real GDP, encompassing data from all private sectors and the government. It is based on the Fisher chain-weighted method, tracking changes in production volume or expenditures while eliminating the effects of price changes. This index is useful for comparing the volumes of production or expenditures across different time periods.

"**TotalGDP**" - describes the total Gross Domestic Product (GDP), measured in millions of dollars and calculated annually without seasonal adjustments. This metric encompasses all private sectors and the government, reflecting the market value of all final goods and services produced within an agglomeration. The agglomeration GDP represents the gross output minus intermediate costs, serving as a key indicator of economic activity and production volume.

"**TotalRealGDP**" - represents the total real Gross Domestic Product, measured in millions of chained 2012 dollars and calculated annually without seasonal adjustments. This metric includes data from all private sectors and the government. The real GDP for agglomerations is a measure of the gross product of each agglomeration, adjusted for inflation, and based on national prices for goods and services produced in the agglomeration.

"**StablePopulation**" - reflects the stable population, measured in thousands of people and calculated annually without seasonal adjustments. This metric represents population estimates as of July 1st each year, providing reliable data for analyzing demographic trends and planning purposes.

"**EmployedIndividuals**" - represents the number of employed individuals, measured in persons without seasonal adjustment and updated monthly. The data are derived from the Current Population Survey (CPS). Employed individuals include those who did any paid work, owned a business or farm, worked 15 hours or more as unpaid workers in a family business, or were temporarily absent from their job for various reasons. This metric is important for analyzing employment levels and the economic activity of the population.

"**AverageWeeklyWagePrivate**" - denotes the average weekly wage of private enterprise employees, measured in dollars per week and calculated quarterly without seasonal adjustment. It includes payments made by employers insured against unemployment over the quarter, encompassing vacation pay, bonuses, stock options, tips, and other components. This metric is important for assessing the level of wages in the private sector.

"**UnemploymentRate**" - represents the unemployment rate, measured in percentages and calculated monthly without seasonal adjustments. This metric indicates the proportion of the unemployed within the total labor force, providing key information about the labor market's condition and the population's economic activity.

Taiwan Housing Price to Income Ratio data was reported at 9.160 Times in Dec 2017. This records a decrease from the previous number of 9.220 Times for Sep 2017. Taiwan Housing Price to Income Ratio data is updated quarterly, averaging 6.735 Times from Mar 2002 (Median) to Dec 2017, with 64 observations. The data reached an all-time high of 9.460 Times in Jun 2017 and a record low of 4.150 Times in Sep 2002. Taiwan Housing Price to Income Ratio data remains active status in CEIC and is reported by Construction and Planning Agency, Ministry of the Interior. The data is categorized under Global Database’s Taiwan – Table TW.EB017: Housing Price and Housing Loan Payment to Income Ratio.

Housing Index in Spain increased to 2033 EUR/SQ. METRE in the first quarter of 2025 from 1972.10 EUR/SQ. METRE in the fourth quarter of 2024. This dataset provides the latest reported value for - Spain House Prices - plus previous releases, historical high and low, short-term forecast and long-term prediction, economic calendar, survey consensus and news.

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.

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.

This layer shows housing costs as a percentage of household income by age. 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 predominant housing type for householders where the householder is age 65+ and spending at least 30% of their income on housing. 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): B25072, B25093 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.

Update 29-04-2020: The data is now split into two files based on the variable collection frequency (monthly and yearly). Additional variables added: area size in hectares, number of jobs in the area, number of people living in the area.

Context

I have been inspired by Xavier and his work on Barcelona to explore the city of London! 🇬🇧 💂

Content

The datasets is primarily centered around the housing market of London. However, it contains a lot of additional relevant data: - Monthly average house prices - Yearly number of houses - Yearly number of houses sold - Yearly percentage of households that recycle - Yearly life satisfaction - Yearly median salary of the residents of the area - Yearly mean salary of the residents of the area - Monthly number of crimes committed - Yearly number of jobs - Yearly number of people living in the area - Area size in hectares

The data is split by areas of London called boroughs (a flag exists to identify these), but some of the variables have other geographical UK regions for reference (like England, North East, etc.). There have been no changes made to the data except for melting it into a long format from the original tables.

Acknowledgements

The data has been extracted from London Datastore. It is released under UK Open Government License v2 and v3. The underlining datasets can be found here: https://data.london.gov.uk/dataset/uk-house-price-index https://data.london.gov.uk/dataset/number-and-density-of-dwellings-by-borough https://data.london.gov.uk/dataset/subjective-personal-well-being-borough https://data.london.gov.uk/dataset/household-waste-recycling-rates-borough https://data.london.gov.uk/dataset/earnings-place-residence-borough https://data.london.gov.uk/dataset/recorded_crime_summary https://data.london.gov.uk/dataset/jobs-and-job-density-borough https://data.london.gov.uk/dataset/ons-mid-year-population-estimates-custom-age-tables

Cover photo by Frans Ruiter from Unsplash

Inspiration

The dataset lends itself for extensive exploratory data analysis. It could also be a great supervised learning regression problem to predict house price changes of different boroughs over time.