Business Rates

property_reference_number Property Reference Number	ba_reference_number BA Reference Number	ratepayer Ratepayer	address Address	postcode Postcode	latitude Latitude	longitude Longitude	liability_start_date Liability Start Date	empty_from Empty From	voa_code VOA Code	voa_description VOA Description	exemption Exemption	exemptions_start_date Exemptions Start Date
72126201	2010994512183	KMREGROUP MABGATE LTD	APSON HOUSE ,MABGATE LEEDS	LS9 7DY	53.80076	-1.53233	Thu Jun 15 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 15 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	CW	WAREHOUSE AND PREMISES	RV	2017-06-15
72141351	2011100331786	SAFESTORE LTD T/A ABBEY SELF STORAGE	BAKER HOUSE ,BRIDGE STREET LEEDS	LS2 7QZ	53.79954	-1.53667	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 24 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	CW	INCAPABLE OF BENEFICIAL OCCUPATION	RV	2018-05-24
72229233	2011749333980	STANDEVEN & MATHERS LTD	49A WESTFIELD ROAD ,BURLEY LEEDS	LS3 1DF	53.8048	-1.56758	Fri Apr 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	IF3	BAKERY AND PREMISES	RV	2016-04-22
72669550	2011795311668	QAR PROPERTY LIMITED	PART 1ST FLR NORTH ,KIMBERLEY HOUSE WOODHOUSE SQUARE LEEDS	LS3 1AD	53.80122	-1.55692	Thu Dec 07 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Dec 07 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	CO	UNDER RECONSTRUCTION	RV	2017-12-07
72236202	2011795357744	QAR PROPERTY LTD	PART 1ST FLOOR SOUTH ,KIMBERLEY HOUSE WOODHOUSE SQUARE LEEDS	LS3 1AD	53.80122	-1.55692	Mon Apr 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Apr 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	CO	UNDER RECONSTRUCTION	RV	2018-04-30
72567190	2011795357745	QAR PROPERTY LTD	SECOND FLOOR ,KIMBERLEY HOUSE WOODHOUSE SQUARE, WOODHOUSE LEEDS	LS3 1AD	53.80122	-1.55692	Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	CO	BUILDING UNDER-GOING RE-DEVELOPMENT.	RV	2018-04-01
72669551	2011795367766	QAR PROPERTY LTD	GND FLOOR NORTH ,KIMBERLEY HOUSE WOODHOUSE SQUARE, WOODHOUSE LEEDS	LS3 1AD	53.80122	-1.55692	Mon Apr 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Apr 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	CO	BUILING UNDER-GOING RE-DEVELOPMENT.	RV	2018-04-30
72669554	2011795368064	QAR PROPERTY LTD	4TH FLOOR ,KIMBERLEY HOUSE WOODHOUSE SQUARE, WOODHOUSE LEEDS	LS3 1AD	53.80122	-1.55692	Mon Apr 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Apr 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	CO	BUILDING UNDER-GOING RE-DEVELOPMENT.	RV	2018-04-30
72669552	2011795369633	QAR PROPERTY LTD	GND FLOOR SOUTH ,KIMBERLEY HOUSE WOODHOUSE SQUARE, WOODHOUSE LEEDS	LS3 1AD	53.80122	-1.55692	Thu Mar 29 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 29 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	CO	UNDER RECONSTRUCTION	RV	2018-03-29
72669553	2011795446688	QAR PROPERTY LTD	3RD FLOOR ,KIMBERLEY HOUSE WOODHOUSE SQUARE LEEDS	LS3 1AD	53.80122	-1.55692	Mon Apr 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Apr 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	CO	BUILDING UNDER-GOING RE-DEVELOPMENT.'	RV	2018-04-30


CREATE TABLE n_16_07_2019 (
  "property_reference_number" VARCHAR,
  "ba_reference_number" BIGINT,
  "ratepayer" VARCHAR,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "occupied" VARCHAR,
  "liability_start_date" TIMESTAMP,
  "empty_from" TIMESTAMP,
  "rateable_value" BIGINT,
  "voa_code" VARCHAR,
  "voa_description" VARCHAR,
  "exemption" VARCHAR,
  "exemptions_start_date" VARCHAR,
  "total_relief" DOUBLE,
  "relief_mandatory" DOUBLE,
  "relief_discretionary" BIGINT
);