Danish residential house prices (1992-2024)

About the dataset (cleaned data)

The dataset (parquet file) contains approximately 1,5 million residential household sales from Denmark during the periode from 1992 to 2024. All cleaned data is merged into one parquet file here on Kaggle. Note some cleaning might still be nessesary, see notebook under code.

Also, added a random sample (100k) of the dataset as a csv file.

Done in Python version: 2.6.3.

Raw data

Raw data and more info is avaible on Github repositary: https://github.com/MartinSamFred/Danish-residential-housingPrices-1992-2024.git

The dataset has been scraped and cleaned (to some extent). Cleaned files are located in: \Housing_data_cleaned \ named DKHousingprices_1 and 2. Saved in parquet format (and saved as two files due to size).

Cleaning from raw files to above cleaned files is outlined in BoligsalgConcatCleanigGit.ipynb. (done in Python version: 2.6.3)

Webscraping script: Webscrape_script.ipynb (done in Python version: 2.6.3)

Provided you want to clean raw files from scratch yourself:

Uncleaned scraped files (81 in total) are located in \Housing_data_raw \ Housing_data_batch1 and 2. Saved in .csv format and compressed as 7-zip files.

Additional files added/appended to the Cleaned files are located in \Addtional_data and named DK_inflation_rates, DK_interest_rates, DK_morgage_rates and DK_regions_zip_codes. Saved in .xlsx format.

Content

Each row in the dataset contains a residential household sale during the period 1992 - 2024.

“Cleaned files” columns:

0 'date': is the transaction date

1 'quarter': is the quarter based on a standard calendar year

2 'house_id': unique house id (could be dropped)

3 'house_type': can be 'Villa', 'Farm', 'Summerhouse', 'Apartment', 'Townhouse'

4 'sales_type': can be 'regular_sale', 'family_sale', 'other_sale', 'auction', '-' (“-“ could be dropped)

5 'year_build': range 1000 to 2024 (could be narrowed more)

6 'purchase_price': is purchase price in DKK

7 '%_change_between_offer_and_purchase': could differ negatively, be zero or positive

8 'no_rooms': number of rooms

9 'sqm': number of square meters

10 'sqm_price': 'purchase_price' divided by 'sqm_price'

11 'address': is the address

12 'zip_code': is the zip code

13 'city': is the city

14 'area': 'East & mid jutland', 'North jutland', 'Other islands', 'Capital, Copenhagen', 'South jutland', 'North Zealand', 'Fyn & islands', 'Bornholm'

15 'region': 'Jutland', 'Zealand', 'Fyn & islands', 'Bornholm'

16 'nom_interest_rate%': Danish nominal interest rate show pr. quarter however actual rate is not converted from annualized to quarterly

17 'dk_ann_infl_rate%': Danish annual inflation rate show pr. quarter however actual rate is not converted from annualized to quarterly

18 'yield_on_mortgage_credit_bonds%': 30 year mortgage bond rate (without spread)

Uses

Various (statistical) analysis, visualisation and I assume machine learning as well.

Practice exercises etc.

Uncleaned scraped files are great to practice cleaning, especially string cleaning. I’m not an expect as seen in the coding ;-).

Disclaimer

The data and information in the data set provided here are intended to be used primarily for educational purposes only. I do not own any data, and all rights are reserved to the respective owners as outlined in “Acknowledgements/sources”. The accuracy of the dataset is not guaranteed accordingly any analysis and/or conclusions is solely at the user's own responsibly and accountability.

Acknowledgements/sources

All data is publicly available on:

Boliga: https://www.boliga.dk/

Finans Danmark: https://finansdanmark.dk/

Danmarks Statistik: https://www.dst.dk/da

Statistikbanken: https://statistikbanken.dk/statbank5a/default.asp?w=2560

Macrotrends: https://www.macrotrends.net/

PostNord: https://www.postnord.dk/

World Data: https://www.worlddata.info/

Dataset picture / cover photo: Nick Karvounis (https://unsplash.com/)

Have fun… :-)

In the United States, Hawaii was the state with the most expensive housing, with the typical value of single-family homes in the 35th to 65th percentile range exceeding ******* U.S. dollars. Unsurprisingly, Hawaii also ranked top as the state with the highest cost of living. Meanwhile, a property was the least expensive in West Virginia, where it cost under ******* U.S. dollars to buy the typical single-family home. Single-family home prices increased across most states in the United States between December 2023 and December 2024, except in Louisiana, Florida, and the District of Colombia. According to the Federal Housing Association, house appreciation in 13 states exceeded **** percent in 2023.

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

Forecast: Housing Cost Overburden in Chile 2024 - 2028 Discover more data with ReportLinker!

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

Forecast: Housing Cost Overburden in Sweden 2024 - 2028 Discover more data with ReportLinker!

Forecast: Housing Cost Overburden in Turkey 2024 - 2028 Discover more data with ReportLinker!

Forecast: Housing Cost Overburden in Switzerland 2024 - 2028 Discover more data with ReportLinker!

Forecast: Housing Cost Overburden in Denmark 2024 - 2028 Discover more data with ReportLinker!

Forecast: Housing Cost Overburden in Japan 2024 - 2028 Discover more data with ReportLinker!

Forecast: Housing Cost Overburden in France 2024 - 2028 Discover more data with ReportLinker!

The 'Nationwide Housing Prices MoM' in the UK measures the monthly change in the average price of homes, as reported by the Nationwide Building Society.-2024-12-01

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

In 2023, there were approximately **** million housing cost burdened households among renters in the United States. A household is considered to be moderately burdened when the housing costs exceed 30 percent of the family income. Severely burdened households, on the other hand, spend more than 50 percent of their income on rent.

Forecast: Housing Cost Overburden in South Korea 2024 - 2028 Discover more data with ReportLinker!

The year-end value of the S&P Case Shiller National Home Price Index amounted to 321.45 in 2024. The index value was equal to 100 as of January 2000, so if the index value is equal to 130 in a given year, for example, it means that the house prices increased by 30 percent since 2000. S&P/Case Shiller U.S. home indices – additional informationThe S&P Case Shiller National Home Price Index is calculated on a monthly basis and is based on the prices of single-family homes in nine U.S. Census divisions: New England, Middle Atlantic, East North Central, West North Central, South Atlantic, East South Central, West South Central, Mountain and Pacific. The index is the leading indicator of the American housing market and one of the indicators of the state of the broader economy. The index illustrates the trend of home prices and can be helpful during house purchase decisions. When house prices are rising, a house buyer might want to speed up the house purchase decision as the transaction costs can be much higher in the future. The S&P Case Shiller National Home Price Index has been on the rise since 2011.The S&P Case Shiller National Home Price Index is one of the indices included in the S&P/Case-Shiller Home Price Index Series. Other indices are the S&P/Case Shiller 20-City Composite Home Price Index, the S&P/Case Shiller 10-City Composite Home Price Index and twenty city composite indices.

Spain - Housing cost overburden rate: Two adults was 5.80% in December of 2024, according to the EUROSTAT. Trading Economics provides the current actual value, an historical data chart and related indicators for Spain - Housing cost overburden rate: Two adults - last updated from the EUROSTAT on November of 2025. Historically, Spain - Housing cost overburden rate: Two adults reached a record high of 8.60% in December of 2013 and a record low of 5.80% in December of 2024.

Percentage of the population living in a household where total housing costs (net of housing allowances) represent more than 40% of the total disposable household income (net of housing allowances).