NIHPI Verified Sales

CREATE TABLE verified_sales_by_lgd (
  "quarter_year" VARCHAR,
  "antrim_and_newtownabbey" BIGINT,
  "ards_and_north_down" BIGINT,
  "armagh_city_banbridge_and_craigavon" BIGINT,
  "belfast" BIGINT,
  "causeway_coast_and_glens" BIGINT,
  "derry_city_and_strabane" BIGINT,
  "fermanagh_and_omagh" BIGINT,
  "lisburn_and_castlereagh" BIGINT,
  "mid_and_east_antrim" BIGINT,
  "mid_ulster" BIGINT,
  "newry_mourne_and_down" BIGINT,
  "total_verified_sales" BIGINT
);

CREATE TABLE verified_sales_by_nuts3 (
  "quarter_year" VARCHAR,
  "belfast" BIGINT,
  "outer_belfast" BIGINT,
  "east_of_northern_ireland" BIGINT,
  "north_of_northern_ireland" BIGINT,
  "west_south_of_northern_ireland" BIGINT,
  "total_verified_sales" BIGINT
);

CREATE TABLE verified_sales_by_property_type (
  "quarter_year" VARCHAR,
  "detached" BIGINT,
  "semidetached" BIGINT,
  "terrace" BIGINT,
  "apartment" BIGINT,
  "total_verified_sales" BIGINT
);

CREATE TABLE verified_sales_by_urban_rural_classification (
  "quarter_year" VARCHAR,
  "urban" BIGINT,
  "rural" BIGINT,
  "total_verified_sales" BIGINT
);