About this Dataset

Business Completions 2002-2016

Business completions by district and use class in Cambridgeshire 2002-2016. Shows B1 (unknown), B1a (Office), B1b (Research and Development), B1c (Light Industry), B2 (General Industrial, Manufacturing) and B8 (Storage and Distribution). Amount of floorspace completed (built) in sqm in each financial year from 2002/03 to 2015/16 according to annual monitoring reports, data gathered and cleaned by CCC Research and Monitoring Team.
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:41:42Z

Tables

Business Floorspace Completions 2002-2016

@ukgov.business_completions_2002_20161.business_floorspace_completions_2002_2016

52.3 kB
30 rows
48 columns

CREATE TABLE business_floorspace_completions_2002_2016 (
  "code" VARCHAR,
  "district" VARCHAR,
  "use_class" VARCHAR,
  "floorspace_gains_sqm_completed_2015_2016" DOUBLE  -- Floorspace Gains (sqm) Completed 2015-2016,
  "floorspace_gains_sqm_completed_2014_2015" BIGINT  -- Floorspace Gains (sqm) Completed 2014-2015,
  "floorspace_gains_sqm_completed_2013_2014" BIGINT  -- Floorspace Gains (sqm) Completed 2013-2014,
  "floorspace_gains_sqm_completed_2012_2013" BIGINT  -- Floorspace Gains (sqm) Completed 2012-2013,
  "floorspace_gains_sqm_completed_2011_2012" BIGINT  -- Floorspace Gains (sqm) Completed 2011-2012,
  "floorspace_gains_sqm_completed_2010_2011" BIGINT  -- Floorspace Gains (sqm) Completed 2010-2011,
  "floorspace_gains_sqm_completed_2009_2010" BIGINT  -- Floorspace Gains (sqm) Completed 2009-2010,
  "floorspace_gains_sqm_completed_2008_2009" BIGINT  -- Floorspace Gains (sqm) Completed 2008-2009,
  "floorspace_gains_sqm_completed_2007_2008" BIGINT  -- Floorspace Gains (sqm) Completed 2007-2008,
  "floorspace_gains_sqm_completed_2006_2007" BIGINT  -- Floorspace Gains (sqm) Completed 2006-2007,
  "floorspace_gains_sqm_completed_2005_2006" BIGINT  -- Floorspace Gains (sqm) Completed 2005-2006,
  "floorspace_gains_sqm_completed_2004_2005" BIGINT  -- Floorspace Gains (sqm) Completed 2004-2005,
  "floorspace_gains_sqm_completed_2003_2004" BIGINT  -- Floorspace Gains (sqm) Completed 2003-2004,
  "floorspace_gains_sqm_completed_2002_2003" BIGINT  -- Floorspace Gains (sqm) Completed 2002-2003,
  "floorspace_gains_sqm_completed_2002_2016" DOUBLE  -- Floorspace Gains (sqm) Completed 2002-2016,
  "floorspace_losses_sqm_completed_2015_2016" DOUBLE  -- Floorspace Losses (sqm) Completed 2015-2016,
  "floorspace_losses_sqm_completed_2014_2015" DOUBLE  -- Floorspace Losses (sqm) Completed 2014-2015,
  "floorspace_losses_sqm_completed_2013_2014" DOUBLE  -- Floorspace Losses (sqm) Completed 2013-2014,
  "floorspace_losses_sqm_completed_2012_2013" BIGINT  -- Floorspace Losses (sqm) Completed 2012-2013,
  "floorspace_losses_sqm_completed_2011_2012" BIGINT  -- Floorspace Losses (sqm) Completed 2011-2012,
  "floorspace_losses_sqm_completed_2010_2011" BIGINT  -- Floorspace Losses (sqm) Completed 2010-2011,
  "floorspace_losses_sqm_completed_2009_2010" BIGINT  -- Floorspace Losses (sqm) Completed 2009-2010,
  "floorspace_losses_sqm_completed_2008_2009" BIGINT  -- Floorspace Losses (sqm) Completed 2008-2009,
  "floorspace_losses_sqm_completed_2007_2008" BIGINT  -- Floorspace Losses (sqm) Completed 2007-2008,
  "floorspace_losses_sqm_completed_2006_2007" BIGINT  -- Floorspace Losses (sqm) Completed 2006-2007,
  "floorspace_losses_sqm_completed_2005_2006" BIGINT  -- Floorspace Losses (sqm) Completed 2005-2006,
  "floorspace_losses_sqm_completed_2004_2005" BIGINT  -- Floorspace Losses (sqm) Completed 2004-2005,
  "floorspace_losses_sqm_completed_2003_2004" BIGINT  -- Floorspace Losses (sqm) Completed 2003-2004,
  "floorspace_losses_sqm_completed_2002_2003" BIGINT  -- Floorspace Losses (sqm) Completed 2002-2003,
  "floorspace_losses_sqm_completed_2002_2016" DOUBLE  -- Floorspace Losses (sqm) Completed 2002-2016,
  "floorspace_net_sqm_completed_2015_2016" DOUBLE  -- Floorspace Net (sqm) Completed 2015-2016,
  "floorspace_net_sqm_completed_2014_2015" DOUBLE  -- Floorspace Net (sqm) Completed 2014-2015,
  "floorspace_net_sqm_completed_2013_2014" DOUBLE  -- Floorspace Net (sqm) Completed 2013-2014,
  "floorspace_net_sqm_completed_2012_2013" BIGINT  -- Floorspace Net (sqm) Completed 2012-2013,
  "floorspace_net_sqm_completed_2011_2012" BIGINT  -- Floorspace Net (sqm) Completed 2011-2012,
  "floorspace_net_sqm_completed_2010_2011" BIGINT  -- Floorspace Net (sqm) Completed 2010-2011,
  "floorspace_net_sqm_completed_2009_2010" BIGINT  -- Floorspace Net (sqm) Completed 2009-2010,
  "floorspace_net_sqm_completed_2008_2009" BIGINT  -- Floorspace Net (sqm) Completed 2008-2009,
  "floorspace_net_sqm_completed_2007_2008" BIGINT  -- Floorspace Net (sqm) Completed 2007-2008,
  "floorspace_net_sqm_completed_2006_2007" BIGINT  -- Floorspace Net (sqm) Completed 2006-2007,
  "floorspace_net_sqm_completed_2005_2006" BIGINT  -- Floorspace Net (sqm) Completed 2005-2006,
  "floorspace_net_sqm_completed_2004_2005" BIGINT  -- Floorspace Net (sqm) Completed 2004-2005,
  "floorspace_net_sqm_completed_2003_2004" BIGINT  -- Floorspace Net (sqm) Completed 2003-2004,
  "floorspace_net_sqm_completed_2002_2003" BIGINT  -- Floorspace Net (sqm) Completed 2002-2003,
  "floorspace_net_sqm_completed_2002_2016" DOUBLE  -- Floorspace Net (sqm) Completed 2002-2016
);