Accessibility Of Services To Affordable And Student Housing Provision

CREATE TABLE affordable_housing_commitments_2013_2014 (
  "case_no" VARCHAR,
  "alternative_ref" VARCHAR,
  "orn" DOUBLE,
  "district_name" VARCHAR,
  "parish" VARCHAR,
  "sub_area" VARCHAR,
  "csr" VARCHAR,
  "location_address" VARCHAR,
  "proposal" 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" BIGINT,
  "dwelling_type" VARCHAR,
  "affordable" VARCHAR,
  "target_dwellings" BIGINT,
  "status" VARCHAR,
  "total_completions_01_04_2002_31_03_2003" BIGINT,
  "n_1_bed" BIGINT  -- 1 BED,
  "n_2_beds" BIGINT  -- 2 BEDS,
  "n_3_beds" BIGINT  -- 3 BEDS,
  "n_4_beds" BIGINT  -- 4+ BEDS,
  "u_k_beds" BIGINT,
  "total_cumulative_completions" TIMESTAMP,
  "n_1_bed_1" VARCHAR  -- 1 BED.1,
  "n_2_beds_1" VARCHAR  -- 2 BEDS.1,
  "n_3_beds_1" VARCHAR  -- 3 BEDS.1,
  "n_4_beds_1" BIGINT  -- 4+ BEDS.1,
  "u_k_beds_1" BIGINT,
  "gains_01_04_2002_31_03_2003" BIGINT,
  "losses_01_04_2002_31_03_2003" BIGINT,
  "hori_site" BIGINT,
  "comment" BIGINT,
  "as_at_date" BIGINT,
  "site_on_allocated_land" BIGINT,
  "unnamed_41" BIGINT  -- Unnamed: 41,
  "unnamed_42" BIGINT  -- Unnamed: 42
);