Business Completions 2002-2016
Cambridgeshire Insight
@ukgov.business_completions_2002_20161
Table List
- 1 table(51.07 KB)
Business Floorspace Completions 2002-2016
@ukgov.business_completions_2002_20161.business_floorspace_completions_2002_2016
- 51.07 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_2014_2015" BIGINT,
"floorspace_gains_sqm_completed_2013_2014" BIGINT,
"floorspace_gains_sqm_completed_2012_2013" BIGINT,
"floorspace_gains_sqm_completed_2011_2012" BIGINT,
"floorspace_gains_sqm_completed_2010_2011" BIGINT,
"floorspace_gains_sqm_completed_2009_2010" BIGINT,
"floorspace_gains_sqm_completed_2008_2009" BIGINT,
"floorspace_gains_sqm_completed_2007_2008" BIGINT,
"floorspace_gains_sqm_completed_2006_2007" BIGINT,
"floorspace_gains_sqm_completed_2005_2006" BIGINT,
"floorspace_gains_sqm_completed_2004_2005" BIGINT,
"floorspace_gains_sqm_completed_2003_2004" BIGINT,
"floorspace_gains_sqm_completed_2002_2003" BIGINT,
"floorspace_gains_sqm_completed_2002_2016" DOUBLE,
"floorspace_losses_sqm_completed_2015_2016" DOUBLE,
"floorspace_losses_sqm_completed_2014_2015" DOUBLE,
"floorspace_losses_sqm_completed_2013_2014" DOUBLE,
"floorspace_losses_sqm_completed_2012_2013" BIGINT,
"floorspace_losses_sqm_completed_2011_2012" BIGINT,
"floorspace_losses_sqm_completed_2010_2011" BIGINT,
"floorspace_losses_sqm_completed_2009_2010" BIGINT,
"floorspace_losses_sqm_completed_2008_2009" BIGINT,
"floorspace_losses_sqm_completed_2007_2008" BIGINT,
"floorspace_losses_sqm_completed_2006_2007" BIGINT,
"floorspace_losses_sqm_completed_2005_2006" BIGINT,
"floorspace_losses_sqm_completed_2004_2005" BIGINT,
"floorspace_losses_sqm_completed_2003_2004" BIGINT,
"floorspace_losses_sqm_completed_2002_2003" BIGINT,
"floorspace_losses_sqm_completed_2002_2016" DOUBLE,
"floorspace_net_sqm_completed_2015_2016" DOUBLE,
"floorspace_net_sqm_completed_2014_2015" DOUBLE,
"floorspace_net_sqm_completed_2013_2014" DOUBLE,
"floorspace_net_sqm_completed_2012_2013" BIGINT,
"floorspace_net_sqm_completed_2011_2012" BIGINT,
"floorspace_net_sqm_completed_2010_2011" BIGINT,
"floorspace_net_sqm_completed_2009_2010" BIGINT,
"floorspace_net_sqm_completed_2008_2009" BIGINT,
"floorspace_net_sqm_completed_2007_2008" BIGINT,
"floorspace_net_sqm_completed_2006_2007" BIGINT,
"floorspace_net_sqm_completed_2005_2006" BIGINT,
"floorspace_net_sqm_completed_2004_2005" BIGINT,
"floorspace_net_sqm_completed_2003_2004" BIGINT,
"floorspace_net_sqm_completed_2002_2003" BIGINT,
"floorspace_net_sqm_completed_2002_2016" DOUBLE
);