About this Dataset

New Jobs Creation In Cambridgeshire (2013/14)

This dataset looks at new planning applications where employment will be increased and whether this is located within the growth areas of district local plans.
Publisher name: Cambridgeshire Insight
Last updated: 2025-04-03T04:00:04Z

Tables

Business Commitments 2013-2014

@ukgov.new_jobs_creation_in_cambridgeshire_2013_141.business_commitments_2013_2014

114.05 KB
304 rows
79 columns


CREATE TABLE business_commitments_2013_2014 (
  "case_no" VARCHAR,
  "alternative_ref" VARCHAR,
  "district_name" VARCHAR,
  "parish" VARCHAR,
  "sub_area" VARCHAR,
  "csr" VARCHAR,
  "location" VARCHAR,
  "proposal" VARCHAR,
  "applicant" VARCHAR,
  "agent" VARCHAR,
  "application_type" VARCHAR,
  "development_type" VARCHAR,
  "statutory_class" VARCHAR,
  "green_brown" VARCHAR,
  "decision_date" TIMESTAMP,
  "appeal_date" VARCHAR,
  "lapse_date" VARCHAR,
  "as_at_date" TIMESTAMP,
  "r" BIGINT,
  "s" BIGINT,
  "t" BIGINT,
  "u" BIGINT,
  "gains_of_b" BIGINT,
  "gains_of_o" BIGINT,
  "losses_of" BIGINT,
  "losses_of_1" BIGINT,
  "entry_no" BIGINT,
  "primary_use" VARCHAR,
  "sub_use" VARCHAR,
  "monitor_status" VARCHAR,
  "target_lost" BIGINT,
  "target_new" BIGINT,
  "target_net" BIGINT,
  "outline" BIGINT,
  "uc" BIGINT,
  "ui" BIGINT,
  "alloc" BIGINT,
  "total" BIGINT,
  "comp_2003" BIGINT,
  "comp_2004" BIGINT,
  "comp_2005" BIGINT,
  "comp_2006" BIGINT,
  "comp_2007" BIGINT,
  "comp_2008" BIGINT,
  "comp_2009" BIGINT,
  "comp_2010" BIGINT,
  "comp_2011" BIGINT,
  "comp_2012" BIGINT,
  "comp_2013" BIGINT,
  "comp_2014" BIGINT,
  "completed" BIGINT,
  "developable_site_area" DOUBLE,
  "outline_ha" DOUBLE,
  "uc_ha" DOUBLE,
  "ui_ha" DOUBLE,
  "allocation_ha" DOUBLE,
  "total_ha" DOUBLE,
  "comp_2003_ha" DOUBLE,
  "comp_2004_ha" DOUBLE,
  "comp_2005_ha" DOUBLE,
  "comp_2006_ha" DOUBLE,
  "comp_2007_ha" DOUBLE,
  "comp_2008_ha" DOUBLE,
  "comp_2009_ha" DOUBLE,
  "comp_2010_ha" DOUBLE,
  "comp_2011_ha" DOUBLE,
  "comp_2012_ha" DOUBLE,
  "comp_2013_ha" DOUBLE,
  "comp_2014_ha" DOUBLE,
  "completed_ha" DOUBLE,
  "occupier" VARCHAR,
  "comment" VARCHAR,
  "bn" BIGINT,
  "bo" BIGINT,
  "allocation" VARCHAR,
  "development_type_3" VARCHAR,
  "built_to_housing" VARCHAR,
  "town_centre" VARCHAR,
  "employment_area" VARCHAR
);

Business Completions 2013-2014

@ukgov.new_jobs_creation_in_cambridgeshire_2013_141.business_completions_2013_2014

143.71 KB
482 rows
79 columns


CREATE TABLE business_completions_2013_2014 (
  "case_no" VARCHAR,
  "alternative_ref" VARCHAR,
  "district_name" VARCHAR,
  "parish" VARCHAR,
  "sub_area" VARCHAR,
  "csr" VARCHAR,
  "location" VARCHAR,
  "proposal" VARCHAR,
  "applicant" VARCHAR,
  "agent" VARCHAR,
  "application_type" VARCHAR,
  "development_type" VARCHAR,
  "statutory_class" VARCHAR,
  "green_brown" VARCHAR,
  "decision_date" TIMESTAMP,
  "appeal_date" VARCHAR,
  "lapse_date" VARCHAR,
  "as_at_date" TIMESTAMP,
  "r" BIGINT,
  "s" BIGINT,
  "t" BIGINT,
  "u" BIGINT,
  "gains_of_b" BIGINT,
  "gains_of_o" BIGINT,
  "losses_of" BIGINT,
  "losses_of_1" BIGINT,
  "entry_no" BIGINT,
  "primary_use" VARCHAR,
  "sub_use" VARCHAR,
  "monitor_status" VARCHAR,
  "target_lost" BIGINT,
  "target_new" BIGINT,
  "target_net" BIGINT,
  "outline" BIGINT,
  "uc" BIGINT,
  "ui" BIGINT,
  "alloc" BIGINT,
  "total" BIGINT,
  "comp_2003" BIGINT,
  "comp_2004" BIGINT,
  "comp_2005" BIGINT,
  "comp_2006" BIGINT,
  "comp_2007" BIGINT,
  "comp_2008" BIGINT,
  "comp_2009" BIGINT,
  "comp_2010" BIGINT,
  "comp_2011" BIGINT,
  "comp_2012" BIGINT,
  "comp_2013" BIGINT,
  "comp_2014" BIGINT,
  "completed" BIGINT,
  "developable_site_area" DOUBLE,
  "outline_ha" DOUBLE,
  "uc_ha" DOUBLE,
  "ui_ha" DOUBLE,
  "allocation_ha" DOUBLE,
  "total_ha" DOUBLE,
  "comp_2003_ha" DOUBLE,
  "comp_2004_ha" DOUBLE,
  "comp_2005_ha" DOUBLE,
  "comp_2006_ha" DOUBLE,
  "comp_2007_ha" DOUBLE,
  "comp_2008_ha" DOUBLE,
  "comp_2009_ha" DOUBLE,
  "comp_2010_ha" DOUBLE,
  "comp_2011_ha" DOUBLE,
  "comp_2012_ha" DOUBLE,
  "comp_2013_ha" DOUBLE,
  "comp_2014_ha" DOUBLE,
  "completed_ha" DOUBLE,
  "occupier" VARCHAR,
  "comment" VARCHAR,
  "bn" BIGINT,
  "bo" BIGINT,
  "allocation" VARCHAR,
  "development_type_3" VARCHAR,
  "built_to_housing" VARCHAR,
  "town_centre" VARCHAR,
  "employment_area" VARCHAR
);