Dataset: Housing Commitments 2015

About this Dataset

Housing Commitments 2015

Data on housing commitments in the 5 Cambridgeshire Districts, gather and cleaned by CCC Research and Monitoring team.
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:36:37Z

Tables

Housing Commitments 2015

@ukgov.housing_commitments_20151.housing_commitments_2015

236 KB
1969 rows
45 columns


CREATE TABLE housing_commitments_2015 (
  "case_no" VARCHAR,
  "alternative_ref" VARCHAR,
  "orn" DOUBLE,
  "district_name" VARCHAR,
  "parish" VARCHAR,
  "sub_area" VARCHAR,
  "csr" VARCHAR,
  "location_address" VARCHAR,
  "propsal" VARCHAR,
  "applicant" VARCHAR,
  "agent" VARCHAR,
  "application_type" VARCHAR,
  "development_type" VARCHAR,
  "development_class" VARCHAR,
  "greenbrown" VARCHAR,
  "decision_date" TIMESTAMP,
  "appeal_decision_date" TIMESTAMP,
  "lapse_date" TIMESTAMP,
  "entry_no" DOUBLE,
  "dwelling_type" VARCHAR,
  "affordable" VARCHAR,
  "target_dwellings" BIGINT,
  "status" VARCHAR,
  "outline_planning_permission" DOUBLE,
  "under_construction" DOUBLE,
  "not_started_planning_permission" DOUBLE,
  "total_planning_permission" DOUBLE,
  "allocations_with_no_planning_permission" DOUBLE,
  "n_2014_allocation" DOUBLE,
  "total_outstanding_commitments" BIGINT,
  "as_at_date" TIMESTAMP,
  "hori_site" VARCHAR,
  "site_on_allocated_land" VARCHAR,
  "uc_1_bed" DOUBLE,
  "uc_2_beds" DOUBLE,
  "uc_3_beds" DOUBLE,
  "uc_4_beds" DOUBLE,
  "uc_nk_beds" DOUBLE,
  "ui_1_bed" DOUBLE,
  "ui_2_beds" DOUBLE,
  "ui_3_beds" DOUBLE,
  "ui_4_beds" DOUBLE,
  "ui_nk_beds" DOUBLE,
  "n_2014_alloc_ref" VARCHAR,
  "unnamed_44" VARCHAR
);