Cambridgeshire Housing Completions 2002-2017
Cambridgeshire Insight
@ukgov.cambridgeshire_housing_completions_2002_2017
Cambridgeshire Insight
@ukgov.cambridgeshire_housing_completions_2002_2017
Number of dwellings completed (built) in each financial year from 2002/03 to 2016/17, data gathered and cleaned by CCC Business Intelligence (Research) team. Worksheet includes data by district, parish, settlement, by bedrooms, on previously development land, affordable and density. This data supercedes data published in previous years.
Publisher name: Cambridgeshire Insight
Last updated: 2025-04-03T04:00:15Z
CREATE TABLE average_density_of_completed_dwellings_on_sites_greate_cf9e19ad (
"financial_year_ending" VARCHAR,
"cambridge_city" DOUBLE,
"east_cambridgeshire" DOUBLE,
"fenland" DOUBLE,
"huntingdonshire" DOUBLE,
"south_cambridgeshire" DOUBLE,
"cambridgeshire_total" DOUBLE
);CREATE TABLE density_range_of_completed_dwellings_on_sites_greater__89b27ce5 (
"district" VARCHAR,
"year" VARCHAR,
"n__30_dph" VARCHAR -- <30 DPH,
"n_30_50_dph" VARCHAR -- 30-50 DPH,
"n__50_dph" VARCHAR -- >50 DPH,
"total_completed" BIGINT
);CREATE TABLE dwelling_completions_in_cambridgeshire_2002_17 (
"district" VARCHAR,
"settlement" VARCHAR,
"n_2002_2003" BIGINT -- 2002-2003,
"n_2003_2004" BIGINT -- 2003-2004,
"n_2004_2005" BIGINT -- 2004-2005,
"n_2005_2006" BIGINT -- 2005-2006,
"n_2006_2007" BIGINT -- 2006-2007,
"n_2007_2008" BIGINT -- 2007-2008,
"n_2008_2009" BIGINT -- 2008-2009,
"n_2009_2010" BIGINT -- 2009-2010,
"n_2010_2011" BIGINT -- 2010-2011,
"n_2011_2012" BIGINT -- 2011-2012,
"n_2012_2013" BIGINT -- 2012-2013,
"n_2013_2014" BIGINT -- 2013-2014,
"n_2014_2015" BIGINT -- 2014-2015,
"n_2015_2016" BIGINT -- 2015-2016,
"n_2016_2017" BIGINT -- 2016-2017,
"n_2002_2017" BIGINT -- 2002-2017
);CREATE TABLE gross_affordable_dwellings_completed_in_cambridgeshire_2002_17 (
"district_name" VARCHAR,
"affordable" VARCHAR,
"n_2002_2003" VARCHAR -- 2002-2003,
"n_2003_2004" VARCHAR -- 2003-2004,
"n_2004_2005" VARCHAR -- 2004-2005,
"n_2005_2006" VARCHAR -- 2005-2006,
"n_2006_2007" VARCHAR -- 2006-2007,
"n_2007_2008" VARCHAR -- 2007-2008,
"n_2008_2009" VARCHAR -- 2008-2009,
"n_2009_2010" VARCHAR -- 2009-2010,
"n_2010_2011" VARCHAR -- 2010-2011,
"n_2011_2012" VARCHAR -- 2011-2012,
"n_2012_2013" VARCHAR -- 2012-2013,
"n_2013_2014" VARCHAR -- 2013-2014,
"n_2014_2015" VARCHAR -- 2014-2015,
"n_2015_2016" VARCHAR -- 2015-2016,
"n_2016_2017" VARCHAR -- 2016-2017,
"n_2002_2017" VARCHAR -- 2002-2017
);CREATE TABLE gross_dwellings_completed_by_number_of_bedrooms_in_cam_a0115399 (
"district" VARCHAR,
"number_of_bedrooms" VARCHAR,
"n_2002_2003" BIGINT -- 2002-2003,
"n_2003_2004" BIGINT -- 2003-2004,
"n_2004_2005" BIGINT -- 2004-2005,
"n_2005_2006" BIGINT -- 2005-2006,
"n_2006_2007" BIGINT -- 2006-2007,
"n_2007_2008" BIGINT -- 2007-2008,
"n_2008_2009" BIGINT -- 2008-2009,
"n_2009_2010" BIGINT -- 2009-2010,
"n_2010_2011" BIGINT -- 2010-2011,
"n_2011_2012" BIGINT -- 2011-2012,
"n_2012_2013" BIGINT -- 2012-2013,
"n_2013_2014" BIGINT -- 2013-2014,
"n_2014_2015" BIGINT -- 2014-2015,
"n_2015_2016" BIGINT -- 2015-2016,
"n_2016_2017" BIGINT -- 2016-2017,
"n_2002_2017" BIGINT -- 2002-2017,
"n__total" VARCHAR -- % Total
);CREATE TABLE gross_dwellings_completed_on_previously_developed_land_53181f27 (
"district_name" VARCHAR,
"green_brown" VARCHAR,
"n_2002_2003" VARCHAR -- 2002-2003,
"n_2003_2004" VARCHAR -- 2003-2004,
"n_2004_2005" VARCHAR -- 2004-2005,
"n_2005_2006" VARCHAR -- 2005-2006,
"n_2006_2007" VARCHAR -- 2006-2007,
"n_2007_2008" VARCHAR -- 2007-2008,
"n_2008_2009" VARCHAR -- 2008-2009,
"n_2009_2010" VARCHAR -- 2009-2010,
"n_2010_2011" VARCHAR -- 2010-2011,
"n_2011_2012" VARCHAR -- 2011-2012,
"n_2012_2013" VARCHAR -- 2012-2013,
"n_2013_2014" VARCHAR -- 2013-2014,
"n_2014_2015" VARCHAR -- 2014-2015,
"n_2015_2016" VARCHAR -- 2015-2016,
"n_2016_2017" VARCHAR -- 2016-2017,
"n_2002_2017" VARCHAR -- 2002-2017
);CREATE TABLE net_additional_pitches_for_gypsies_and_travellers_and__ede753ed (
"district" VARCHAR,
"n_2002_2003" BIGINT -- 2002-2003,
"n_2003_2004" BIGINT -- 2003-2004,
"n_2004_2005" BIGINT -- 2004-2005,
"n_2005_2006" BIGINT -- 2005-2006,
"n_2006_2007" BIGINT -- 2006-2007,
"n_2007_2008" BIGINT -- 2007-2008,
"n_2008_2009" BIGINT -- 2008-2009,
"n_2009_2010" BIGINT -- 2009-2010,
"n_2010_2011" BIGINT -- 2010-2011,
"n_2011_2012" BIGINT -- 2011-2012,
"n_2012_2013" BIGINT -- 2012-2013,
"n_2013_2014" BIGINT -- 2013-2014,
"n_2014_2015" BIGINT -- 2014-2015,
"n_2015_2016" BIGINT -- 2015-2016,
"n_2016_2017" BIGINT -- 2016-2017,
"n_2002_2017" BIGINT -- 2002-2017
);CREATE TABLE net_dwellings_completed_by_district_in_cambridgeshire_2002_17 (
"district" VARCHAR,
"n_2002_2003" BIGINT -- 2002-2003,
"n_2003_2004" BIGINT -- 2003-2004,
"n_2004_2005" BIGINT -- 2004-2005,
"n_2005_2006" BIGINT -- 2005-2006,
"n_2006_2007" BIGINT -- 2006-2007,
"n_2007_2008" BIGINT -- 2007-2008,
"n_2008_2009" BIGINT -- 2008-2009,
"n_2009_2010" BIGINT -- 2009-2010,
"n_2010_2011" BIGINT -- 2010-2011,
"n_2011_2012" BIGINT -- 2011-2012,
"n_2012_2013" BIGINT -- 2012-2013,
"n_2013_2014" BIGINT -- 2013-2014,
"n_2014_2015" BIGINT -- 2014-2015,
"n_2015_2016" BIGINT -- 2015-2016,
"n_2016_2017" BIGINT -- 2016-2017,
"n_2002_2017" BIGINT -- 2002-2017
);CREATE TABLE net_dwellings_completed_by_settlement_in_cambridgeshire_2002_17 (
"settlement" VARCHAR,
"n_2002_2003" BIGINT -- 2002-2003,
"n_2003_2004" BIGINT -- 2003-2004,
"n_2004_2005" BIGINT -- 2004-2005,
"n_2005_2006" BIGINT -- 2005-2006,
"n_2006_2007" BIGINT -- 2006-2007,
"n_2007_2008" BIGINT -- 2007-2008,
"n_2008_2009" BIGINT -- 2008-2009,
"n_2009_2010" BIGINT -- 2009-2010,
"n_2010_2011" BIGINT -- 2010-2011,
"n_2011_2012" BIGINT -- 2011-2012,
"n_2012_2013" BIGINT -- 2012-2013,
"n_2013_2014" BIGINT -- 2013-2014,
"n_2014_2015" BIGINT -- 2014-2015,
"n_2015_2016" BIGINT -- 2015-2016,
"n_2016_2017" BIGINT -- 2016-2017,
"n_2002_2017" BIGINT -- 2002-2017
);CREATE TABLE net_dwellings_completed_by_ward_parish_in_cambridgeshi_39dc12d3 (
"ward_parish" VARCHAR,
"n_2002_2003" BIGINT -- 2002-2003,
"n_2003_2004" BIGINT -- 2003-2004,
"n_2004_2005" BIGINT -- 2004-2005,
"n_2005_2006" BIGINT -- 2005-2006,
"n_2006_2007" BIGINT -- 2006-2007,
"n_2007_2008" BIGINT -- 2007-2008,
"n_2008_2009" BIGINT -- 2008-2009,
"n_2009_2010" BIGINT -- 2009-2010,
"n_2010_2011" BIGINT -- 2010-2011,
"n_2011_2012" BIGINT -- 2011-2012,
"n_2012_2013" BIGINT -- 2012-2013,
"n_2013_2014" BIGINT -- 2013-2014,
"n_2014_2015" BIGINT -- 2014-2015,
"n_2015_2016" BIGINT -- 2015-2016,
"n_2016_2017" BIGINT -- 2016-2017,
"n_2002_2017" BIGINT -- 2002-2017
);Anyone who has the link will be able to view this.