Cambridgeshire Housing Completions 2002-2017
Cambridgeshire Insight
@ukgov.cambridgeshire_housing_completions_2002_2017
Cambridgeshire Insight
@ukgov.cambridgeshire_housing_completions_2002_2017
CREATE TABLE net_dwellings_completed_by_settlement_in_cambridgeshire_2002_17 (
"settlement" VARCHAR,
"n_2002_2003" BIGINT,
"n_2003_2004" BIGINT,
"n_2004_2005" BIGINT,
"n_2005_2006" BIGINT,
"n_2006_2007" BIGINT,
"n_2007_2008" BIGINT,
"n_2008_2009" BIGINT,
"n_2009_2010" BIGINT,
"n_2010_2011" BIGINT,
"n_2011_2012" BIGINT,
"n_2012_2013" BIGINT,
"n_2013_2014" BIGINT,
"n_2014_2015" BIGINT,
"n_2015_2016" BIGINT,
"n_2016_2017" BIGINT,
"n_2002_2017" BIGINT
);
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 gross_affordable_dwellings_completed_in_cambridgeshire_2002_17 (
"district_name" VARCHAR,
"affordable" VARCHAR,
"n_2002_2003" VARCHAR,
"n_2003_2004" VARCHAR,
"n_2004_2005" VARCHAR,
"n_2005_2006" VARCHAR,
"n_2006_2007" VARCHAR,
"n_2007_2008" VARCHAR,
"n_2008_2009" VARCHAR,
"n_2009_2010" VARCHAR,
"n_2010_2011" VARCHAR,
"n_2011_2012" VARCHAR,
"n_2012_2013" VARCHAR,
"n_2013_2014" VARCHAR,
"n_2014_2015" VARCHAR,
"n_2015_2016" VARCHAR,
"n_2016_2017" VARCHAR,
"n_2002_2017" VARCHAR
);
CREATE TABLE net_dwellings_completed_by_district_in_cambridgeshire_2002_17 (
"district" VARCHAR,
"n_2002_2003" BIGINT,
"n_2003_2004" BIGINT,
"n_2004_2005" BIGINT,
"n_2005_2006" BIGINT,
"n_2006_2007" BIGINT,
"n_2007_2008" BIGINT,
"n_2008_2009" BIGINT,
"n_2009_2010" BIGINT,
"n_2010_2011" BIGINT,
"n_2011_2012" BIGINT,
"n_2012_2013" BIGINT,
"n_2013_2014" BIGINT,
"n_2014_2015" BIGINT,
"n_2015_2016" BIGINT,
"n_2016_2017" BIGINT,
"n_2002_2017" BIGINT
);
CREATE TABLE gross_dwellings_completed_on_previously_developed_land_53181f27 (
"district_name" VARCHAR,
"green_brown" VARCHAR,
"n_2002_2003" VARCHAR,
"n_2003_2004" VARCHAR,
"n_2004_2005" VARCHAR,
"n_2005_2006" VARCHAR,
"n_2006_2007" VARCHAR,
"n_2007_2008" VARCHAR,
"n_2008_2009" VARCHAR,
"n_2009_2010" VARCHAR,
"n_2010_2011" VARCHAR,
"n_2011_2012" VARCHAR,
"n_2012_2013" VARCHAR,
"n_2013_2014" VARCHAR,
"n_2014_2015" VARCHAR,
"n_2015_2016" VARCHAR,
"n_2016_2017" VARCHAR,
"n_2002_2017" VARCHAR
);
CREATE TABLE net_dwellings_completed_by_ward_parish_in_cambridgeshi_39dc12d3 (
"ward_parish" VARCHAR,
"n_2002_2003" BIGINT,
"n_2003_2004" BIGINT,
"n_2004_2005" BIGINT,
"n_2005_2006" BIGINT,
"n_2006_2007" BIGINT,
"n_2007_2008" BIGINT,
"n_2008_2009" BIGINT,
"n_2009_2010" BIGINT,
"n_2010_2011" BIGINT,
"n_2011_2012" BIGINT,
"n_2012_2013" BIGINT,
"n_2013_2014" BIGINT,
"n_2014_2015" BIGINT,
"n_2015_2016" BIGINT,
"n_2016_2017" BIGINT,
"n_2002_2017" BIGINT
);
CREATE TABLE dwelling_completions_in_cambridgeshire_2002_17 (
"district" VARCHAR,
"settlement" VARCHAR,
"n_2002_2003" BIGINT,
"n_2003_2004" BIGINT,
"n_2004_2005" BIGINT,
"n_2005_2006" BIGINT,
"n_2006_2007" BIGINT,
"n_2007_2008" BIGINT,
"n_2008_2009" BIGINT,
"n_2009_2010" BIGINT,
"n_2010_2011" BIGINT,
"n_2011_2012" BIGINT,
"n_2012_2013" BIGINT,
"n_2013_2014" BIGINT,
"n_2014_2015" BIGINT,
"n_2015_2016" BIGINT,
"n_2016_2017" BIGINT,
"n_2002_2017" BIGINT
);
CREATE TABLE density_range_of_completed_dwellings_on_sites_greater__89b27ce5 (
"district" VARCHAR,
"year" VARCHAR,
"n__30_dph" VARCHAR,
"n_30_50_dph" VARCHAR,
"n__50_dph" VARCHAR,
"total_completed" BIGINT
);
CREATE TABLE gross_dwellings_completed_by_number_of_bedrooms_in_cam_a0115399 (
"district" VARCHAR,
"number_of_bedrooms" VARCHAR,
"n_2002_2003" BIGINT,
"n_2003_2004" BIGINT,
"n_2004_2005" BIGINT,
"n_2005_2006" BIGINT,
"n_2006_2007" BIGINT,
"n_2007_2008" BIGINT,
"n_2008_2009" BIGINT,
"n_2009_2010" BIGINT,
"n_2010_2011" BIGINT,
"n_2011_2012" BIGINT,
"n_2012_2013" BIGINT,
"n_2013_2014" BIGINT,
"n_2014_2015" BIGINT,
"n_2015_2016" BIGINT,
"n_2016_2017" BIGINT,
"n_2002_2017" BIGINT,
"n__total" VARCHAR
);
CREATE TABLE net_additional_pitches_for_gypsies_and_travellers_and__ede753ed (
"district" VARCHAR,
"n_2002_2003" BIGINT,
"n_2003_2004" BIGINT,
"n_2004_2005" BIGINT,
"n_2005_2006" BIGINT,
"n_2006_2007" BIGINT,
"n_2007_2008" BIGINT,
"n_2008_2009" BIGINT,
"n_2009_2010" BIGINT,
"n_2010_2011" BIGINT,
"n_2011_2012" BIGINT,
"n_2012_2013" BIGINT,
"n_2013_2014" BIGINT,
"n_2014_2015" BIGINT,
"n_2015_2016" BIGINT,
"n_2016_2017" BIGINT,
"n_2002_2017" BIGINT
);
Anyone who has the link will be able to view this.