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	relief_types Relief Types	relief_total Relief Total	relief_mandatory Relief Mandatory	relief_discretionary Relief Discretionary
72560596	2010106340733	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		-3427.2	-3427.2
72015840	2010109322071	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
72015919	2010110339162	LEEDS ANIMATION WORKSHOP	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	2010113456390	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	2010113468446	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	2010113477477	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	2010114356678	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		-105840	-105840
72673719	2010114356679	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	2010116101022	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
72673696	2010116352915	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_17_10_2019 (
  "property_reference_number" DOUBLE,
  "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,
  "exemptions" VARCHAR,
  "exemptions_start_date" TIMESTAMP,
  "relief_types" VARCHAR,
  "relief_total" DOUBLE,
  "relief_mandatory" DOUBLE,
  "relief_discretionary" DOUBLE
);