Dataset: Housing Affordability

About this Dataset

Housing Affordability

This data sets out the percentage of residents of the Cambridge housing sub-region who are unable to afford housing, based on contemporary income data and housing costs, broken down into percentage for 1, 2 and 3 bedroom homes.

The data comes from the housing sub-region's Strategic Housing Market Assessment, or SHMA, which is updated regularly. The data provided in this open data set comes from:
*SHMA 2013, based on 2011/12 data
*SHMA 2012, based on 2009/10 data
*SHMA 2010, based on 2008/9 data
*SHMA 2009, based on mostly 2007/8 data

The data is all published in chapters of our strategic housing market assessment which are used as part of our calculations around the need for affordable housing, particularly where we need to work out the proportion of people unlikely to be able to afford housing via the private market (owned or rented) and thus potentially in need of "sub market" or affordable housing.
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:32:22Z

Tables

Housing Affordability

@ukgov.housing_affordability1.housing_affordability

68.3 KB
12 rows
74 columns


CREATE TABLE housing_affordability (
  "code" VARCHAR,
  "names" VARCHAR,
  "housing_association_1_bed_2011_12" DOUBLE,
  "n__housing_association_2_bed_2011_12" DOUBLE,
  "housing_association_3_bed_2011_12" DOUBLE,
  "housing_association_1_bed_2009_10" DOUBLE,
  "housing_association_2_bed_2009_10" DOUBLE,
  "housing_association_3_bed_2009_10" DOUBLE,
  "housing_association_1_bed_2008_9" DOUBLE,
  "housing_association_2_bed_2008_9" DOUBLE,
  "housing_association_3_bed_2008_9" DOUBLE,
  "housing_association_1_bed_2007_8" DOUBLE,
  "housing_association_2_bed_2007_8" DOUBLE,
  "housing_association_3_bed_2007_8" DOUBLE,
  "n_80_of_median_private_rent_1_bed_2011_12" DOUBLE,
  "n_80_of_median_private_rent_2_bed_2011_12" DOUBLE,
  "n_80_of_median_private_rent_3_bed_2011_12" DOUBLE,
  "n_80_of_median_private_rent_1_bed_2009_10" DOUBLE,
  "n_80_of_median_private_rent_2_bed_2009_10" DOUBLE,
  "n_80_of_median_private_rent_3_bed_2009_10" DOUBLE,
  "n_80_of_median_private_rent_1_bed_2008_9" VARCHAR,
  "n_80_of_median_private_rent_2_bed_2008_9" VARCHAR,
  "n_80_of_median_private_rent_3_bed_2008_9" VARCHAR,
  "n_80_of_median_private_rent_1_bed_2007_8" VARCHAR,
  "n_80_of_median_private_rent_2_bed_2007_8" VARCHAR,
  "n_80_of_median_private_rent_3_bed_2007_8" VARCHAR,
  "shared_ownership_at_50_1_bed_2011_12" VARCHAR,
  "shared_ownership_at_50_2_bed_2011_12" DOUBLE,
  "shared_ownership_at_50_3_bed_2011_12" DOUBLE,
  "shared_ownership_at_50_1_bed_2009_10" VARCHAR,
  "shared_ownership_at_50_2_bed_2009_10" DOUBLE,
  "shared_ownership_at_50_3_bed_2009_10" VARCHAR,
  "shared_ownership_at_50_1_bed_2008_9" DOUBLE,
  "shared_ownership_at_50_2_bed_2008_9" DOUBLE,
  "shared_ownership_at_50_3_bed_2008_9" DOUBLE,
  "shared_ownership_at_50_1_bed_2007_8" DOUBLE,
  "shared_ownership_at_50_2_bed_2007_8" DOUBLE,
  "shared_ownership_at_50_3_bed_2007_8" DOUBLE,
  "lower_quartile_private_rent_1_bed_2011_12" DOUBLE,
  "lower_quartile_private_rent_2_bed_2011_12" DOUBLE,
  "lower_quartile_private_rent_3_bed_2011_12" DOUBLE,
  "lower_quartile_private_rent_1_bed_2009_10" DOUBLE,
  "lower_quartile_private_rent_2_bed_2009_10" DOUBLE,
  "lower_quartile_private_rent_3_bed_2009_10" DOUBLE,
  "lower_quartile_private_rent_1_bed_2008_9" DOUBLE,
  "lower_quartile_private_rent_2_bed_2008_9" DOUBLE,
  "lower_quartile_private_rent_3_bed_2008_9" DOUBLE,
  "lower_quartile_private_rent_1_bed_2007_8" DOUBLE,
  "lower_quartile_private_rent_2_bed_2007_8" DOUBLE,
  "lower_quartile_private_rent_3_bed_2007_8" DOUBLE,
  "average_private_rent_1_bed_2011_12" DOUBLE,
  "average_private_rent_2_bed_2011_12" DOUBLE,
  "average_private_rent_3_bed_2011_12" DOUBLE,
  "average_private_rent_1_bed_2009_10" DOUBLE,
  "average_private_rent_2_bed_2009_10" DOUBLE,
  "average_private_rent_3_bed_2009_10" DOUBLE,
  "average_private_rent_1_bed_2008_9" DOUBLE,
  "average_private_rent_2_bed_2008_9" DOUBLE,
  "average_private_rent_3_bed_2008_9" DOUBLE,
  "average_private_rent_1_bed_2007_8" DOUBLE,
  "average_private_rent_2_bed_2007_8" DOUBLE,
  "average_private_rent_3_bed_2007_8" DOUBLE,
  "lower_quartile_market_purchase_1_bed_2011_12" DOUBLE,
  "lower_quartile_market_purchase_2_bed_2011_12" DOUBLE,
  "lower_quartile_market_purchase_3_bed_2011_12" DOUBLE,
  "lower_quartile_market_purchase_1_bed_2009_10" DOUBLE,
  "lower_quartile_market_purchase_2_bed_2009_10" DOUBLE,
  "lower_quartile_market_purchase_3_bed_2009_10" DOUBLE,
  "lower_quartile_market_purchase_1_bed_2008_9" DOUBLE,
  "lower_quartile_market_purchase_2_bed_2008_9" DOUBLE,
  "lower_quartile_market_purchase_3_bed_2008_9" DOUBLE,
  "lower_quartile_market_purchase_1_bed_2007_8" DOUBLE,
  "lower_quartile_market_purchase_2_bed_2007_8" DOUBLE,
  "lower_quartile_market_purchase_3_bed_2007_8" DOUBLE
);