Cambridgeshire Housing Commitments 2017

CREATE TABLE dwelling_commitments_by_district_in_cambridgeshire_2017 (
  "district" VARCHAR,
  "settlement" VARCHAR,
  "outline_planning_permission" BIGINT,
  "full_reserved_matters_permission_under_construction" BIGINT,
  "full_reserved_matters_permission_not_started" BIGINT,
  "total_permissions" BIGINT,
  "adopted_allocation_with_no_planning_permissions" BIGINT,
  "proposed_allocation_included_in_local_plans_submitted__028033c5" BIGINT,
  "total_commitments" BIGINT
);

CREATE TABLE dwelling_commitments_by_ward_parish_in_cambridgeshire_2017 (
  "ward_parish" VARCHAR,
  "sum_of_outline_planning_permission" BIGINT,
  "sum_of_under_construction" BIGINT,
  "sum_of_not_started_planning_permission" BIGINT,
  "sum_of_total_planning_permission" BIGINT,
  "sum_of_allocations_with_no_planning_permission" BIGINT,
  "n_2014_local_plan_allocation" BIGINT,
  "sum_of_total_outstanding_commitments" BIGINT
);