Business Rates

property_reference_number Property Reference Number	ba_reference_number BA Reference Number	ratepayer Ratepayer	address Address	postcode Postcode	latitude Latitude	longitude Longitude	occupied Occupied	liability_start_date Liability Start Date	empty_from Empty From	rateable_value Rateable Value	voa_code VOA Code	voa_description VOA Description	exempt_from Exempt From	relief_types Relief Types	relief_total Relief Total	relief_mandatory Relief Mandatory
72560596	2010110000000	GET AWAY GIRLS	67 BAYSWATER GROVE HAREHILLS LEEDS	LS8 5LN	53.8108	-1.51922	Y	Thu Nov 30 2000 00:00:00 GMT+0000 (Coordinated Universal Time)		8500	CO	OFFICES AND PREMISES		Not for Profit	-3427.2	-3427.2
72015840	2010110000000	INCHMERY LTD	111/113 BAYSWATER ROAD HAREHILLS LEEDS	LS8 5NT	53.80956	-1.5182		Mon Aug 06 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	10750	CS	SHOP AND PREMISES	Tue Apr 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)
72015919	2010110000000	LEEDS ANIMATION WORKSHOP LTD	45 BAYSWATER ROW LEEDS	LS8 5LF	53.81119	-1.5192	Y	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)		3100	CO	OFFICES AND PREMISES		Small Business Rate Relief	-1522.1	-1522.1
72673717	2010110000000	CLEAR CHANNEL UK LIMITED	ADSHEL SITE REF 0704 0862 OPP BECKETT WING BECKETT STREET LEEDS	LS9 7LS	53.80276	-1.52446	Y	Wed Nov 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)		850	CA	ADVERTISING RIGHT AND PREMISES
72673735	2010110000000	CLEAR CHANNEL UK LIMITED	ADVERTISING RIGHT 0704 0863 AT ST JAMES HOSPITAL BECKETT STREET LEEDS	LS9 7JZ	53.80528	-1.52297	Y	Wed Nov 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)		850	CA	ADVERTISING RIGHT AND PREMISES
72670087	2010110000000	CLEAR CHANNEL UK LIMITED	ADVERT RIGHT SITE REF 0704 0904 OPP BECKETT WING BECKETT STREET LEEDS	LS9 7TF	53.80686	-1.52035	Y	Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)		850	CA	ADVERTISING RIGHT AND PREMISES
72563680	2010110000000	THACKRAY MEDICAL MUSEUM CO LTD	THACKRAY MEDICAL MUSEUM BECKETT STREET BURMANTOFTS LEEDS	LS9 7LN	53.80818	-1.51867	Y	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)		262500	EM1	MUSEUM AND PREMISES		Not for Profit	-105840	-105840
72673719	2010110000000	LEEDS TEACHING HOSPITALS NHS TRUST	POST GRADUATE MEDICAL EDUCATION CENTRE BECKETT STREET BURMANTOFTS LEEDS	LS9 7LP	53.8038	-1.52349	Y	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)		11750	CO	LECTURE ROOMS AND PREMISES
72748995	2010120000000	BHE (ST JAMES) LIMITED	UNIT 18 GLEDHOW WING ST JAMES HOSPITAL BECKETT STREET LEEDS	LS9 7TF	53.80686	-1.52035		Sat Aug 29 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	4200	CS	SHOP AND PREMISES	Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
72673696	2010120000000	COMPASS CONTRACT SERVICES (UK) LTD	UNIT 1, CHANCELLOR WING, ST JAMES UNIVERSITY HOSPITAL BECKETT STREET BURMANTOFTS LEEDS	LS9 7TF	53.80686	-1.52035	Y	Wed Mar 04 2009 00:00:00 GMT+0000 (Coordinated Universal Time)		7800	CS	SHOP AND PREMISES


CREATE TABLE n_07_01_2020 (
  "property_reference_number" DOUBLE,
  "ba_reference_number" DOUBLE,
  "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,
  "exempt_from" TIMESTAMP,
  "relief_types" VARCHAR,
  "relief_total" DOUBLE,
  "relief_mandatory" DOUBLE,
  "relief_discretionary" DOUBLE
);