About this Dataset

ONS Median House Price To Income Ratios 1997 To 2023

ONS median house price to income ratios 1997 to 2023

Original data is available form ONS.

The data is uploaded here in order to experiment with building an API to represent the goverment's formula for new homes needed in each district.
Publisher name: Cambridgeshire Insight
Last updated: 2025-04-03T04:00:14Z

Tables

ONS Median House Price To Income Ratios 1997 To 2023

@ukgov.ons_median_house_price_to_income_ratios_1997_to_2023.ons_median_house_price_to_income_ratios_1997_to_2023

64.23 kB
318 rows
29 columns

CREATE TABLE ons_median_house_price_to_income_ratios_1997_to_2023 (
  "local_authority_code" VARCHAR,
  "local_authority_name" VARCHAR,
  "n_1997" DOUBLE  -- 1997,
  "n_1998" DOUBLE  -- 1998,
  "n_1999" DOUBLE  -- 1999,
  "n_2000" DOUBLE  -- 2000,
  "n_2001" DOUBLE  -- 2001,
  "n_2002" DOUBLE  -- 2002,
  "n_2003" DOUBLE  -- 2003,
  "n_2004" DOUBLE  -- 2004,
  "n_2005" DOUBLE  -- 2005,
  "n_2006" DOUBLE  -- 2006,
  "n_2007" DOUBLE  -- 2007,
  "n_2008" DOUBLE  -- 2008,
  "n_2009" DOUBLE  -- 2009,
  "n_2010" DOUBLE  -- 2010,
  "n_2011" DOUBLE  -- 2011,
  "n_2012" DOUBLE  -- 2012,
  "n_2013" DOUBLE  -- 2013,
  "n_2014" DOUBLE  -- 2014,
  "n_2015" DOUBLE  -- 2015,
  "n_2016" DOUBLE  -- 2016,
  "n_2017" DOUBLE  -- 2017,
  "n_2018" DOUBLE  -- 2018,
  "n_2019" DOUBLE  -- 2019,
  "n_2020" DOUBLE  -- 2020,
  "n_2021" DOUBLE  -- 2021,
  "n_2022" DOUBLE  -- 2022,
  "n_2023" DOUBLE  -- 2023
);