Council Housing Stock

CREATE TABLE november_2017 (
  "n__id" BIGINT,
  "addr1" VARCHAR,
  "addr2" VARCHAR,
  "postcode" VARCHAR,
  "warddescription" VARCHAR,
  "propertytype" VARCHAR,
  "yearbuilt" BIGINT,
  "solddate" VARCHAR,
  "demolisheddate" VARCHAR
);

CREATE TABLE september_2019 (
  "n__id" BIGINT,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "postcode" VARCHAR,
  "ward" VARCHAR,
  "property_type" VARCHAR,
  "year_built" BIGINT,
  "sold_date" TIMESTAMP,
  "demolished_date" TIMESTAMP
);