Dataset: Retail And Town Centre 2014

About this Dataset

Retail And Town Centre 2014

Planning completion and commitments for retail and town centre uses 01/04/2013-31/03/2014
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:42:50Z

Tables

Retail And Town Centre 2014

@ukgov.retail_and_town_centre_20141.retail_and_town_centre_2014

460.15 KB
3612 rows
64 columns


CREATE TABLE retail_and_town_centre_2014 (
  "case_no" VARCHAR,
  "district_name" VARCHAR,
  "parish" VARCHAR,
  "sub_area" 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,
  "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,
  "development_type_3" VARCHAR,
  "built_to_housing" VARCHAR,
  "town_centre" VARCHAR,
  "employment_area" VARCHAR
);