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

69.94 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 2 Bed 2011/12,
  "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  -- 80% Of Median Private Rent 1 Bed 2011/12,
  "n_80_of_median_private_rent_2_bed_2011_12" DOUBLE  -- 80% Of Median Private Rent 2 Bed 2011/12,
  "n_80_of_median_private_rent_3_bed_2011_12" DOUBLE  -- 80% Of Median Private Rent 3 Bed 2011/12,
  "n_80_of_median_private_rent_1_bed_2009_10" DOUBLE  -- 80% Of Median Private Rent 1 Bed 2009/10,
  "n_80_of_median_private_rent_2_bed_2009_10" DOUBLE  -- 80% Of Median Private Rent 2 Bed 2009/10,
  "n_80_of_median_private_rent_3_bed_2009_10" DOUBLE  -- 80% Of Median Private Rent 3 Bed 2009/10,
  "n_80_of_median_private_rent_1_bed_2008_9" VARCHAR  -- 80% Of Median Private Rent 1 Bed 2008/9,
  "n_80_of_median_private_rent_2_bed_2008_9" VARCHAR  -- 80% Of Median Private Rent 2 Bed 2008/9,
  "n_80_of_median_private_rent_3_bed_2008_9" VARCHAR  -- 80% Of Median Private Rent 3 Bed 2008/9,
  "n_80_of_median_private_rent_1_bed_2007_8" VARCHAR  -- 80% Of Median Private Rent 1 Bed 2007/8,
  "n_80_of_median_private_rent_2_bed_2007_8" VARCHAR  -- 80% Of Median Private Rent 2 Bed 2007/8,
  "n_80_of_median_private_rent_3_bed_2007_8" VARCHAR  -- 80% Of Median Private Rent 3 Bed 2007/8,
  "shared_ownership_at_50_1_bed_2011_12" VARCHAR  -- Shared Ownership At 50% 1 Bed 2011/12,
  "shared_ownership_at_50_2_bed_2011_12" DOUBLE  -- Shared Ownership At 50% 2 Bed 2011/12,
  "shared_ownership_at_50_3_bed_2011_12" DOUBLE  -- Shared Ownership At 50% 3 Bed 2011/12,
  "shared_ownership_at_50_1_bed_2009_10" VARCHAR  -- Shared Ownership At 50% 1 Bed 2009/10,
  "shared_ownership_at_50_2_bed_2009_10" DOUBLE  -- Shared Ownership At 50% 2 Bed 2009/10,
  "shared_ownership_at_50_3_bed_2009_10" VARCHAR  -- Shared Ownership At 50% 3 Bed 2009/10,
  "shared_ownership_at_50_1_bed_2008_9" DOUBLE  -- Shared Ownership At 50% 1 Bed 2008/9,
  "shared_ownership_at_50_2_bed_2008_9" DOUBLE  -- Shared Ownership At 50% 2 Bed 2008/9,
  "shared_ownership_at_50_3_bed_2008_9" DOUBLE  -- Shared Ownership At 50% 3 Bed 2008/9,
  "shared_ownership_at_50_1_bed_2007_8" DOUBLE  -- Shared Ownership At 50% 1 Bed 2007/8,
  "shared_ownership_at_50_2_bed_2007_8" DOUBLE  -- Shared Ownership At 50% 2 Bed 2007/8,
  "shared_ownership_at_50_3_bed_2007_8" DOUBLE  -- Shared Ownership At 50% 3 Bed 2007/8,
  "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
);