Business Rates

ratepayer Ratepayer	liable_from Liable From	mandatory_relief Mandatory Relief %	discretionary_relief Discretionary Relief %	small_business_relief Small Business Relief %	local_discount Local Discount (È)	property_status Property Status	exempt_epr Exempt Epr	empty_from Empty From	addr1 Addr1	addr2 Addr2	addr3 Addr3	addr4 Addr4	postcode Postcode	n_2010_rateable_value 2010 Rateable Value	n_2017_rateable_value 2017 Rateable Value	description_code Description Code	description Description	b_a_reference B A Reference
GET AWAY GIRLS	Thu Nov 30 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	80			È0.00	Occupied Property	N		67 BAYSWATER GROVE	HAREHILLS	LEEDS		LS8 5LN	9200	8500	CO	OFFICES AND PREMISES	2010106340733
INCHMERY LTD	Mon Aug 06 2001 00:00:00 GMT+0000 (Coordinated Universal Time)				È0.00	Empty Property	N	Tue Apr 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	111/113 BAYSWATER ROAD	HAREHILLS	LEEDS		LS8 5NT	7800	10750	CS	SHOP AND PREMISES	2010109322071
BAYSWATER GROUP LTD	Fri Apr 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)			100	È0.00	Occupied Property	N		94 BAYSWATER ROAD	HAREHILLS	LEEDS		LS8 5NT	4450	6000	CS	SHOP AND PREMISES	2010109322758
LEEDS ANIMATION WORKSHOP	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)		50	100	È0.00	Occupied Property	N		45 BAYSWATER ROW	LEEDS			LS8 5LF	3350	3100	CO	OFFICES AND PREMISES	2010110339162
CLEAR CHANNEL UK LIMITED	Wed Nov 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)				È0.00	Occupied Property	N		ADSHEL SITE REF 0704 0862 OPP	BECKETT WING	BECKETT STREET	LEEDS	LS9 7LS	800	850	CA	ADVERTISING RIGHT AND PREMISES	2010113456390
CLEAR CHANNEL UK LIMITED	Wed Nov 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)				È0.00	Occupied Property	N		ADVERTISING RIGHT 0704 0863	AT ST JAMES HOSPITAL	BECKETT STREET	LEEDS	LS9 7JZ	800	850	CA	ADVERTISING RIGHT AND PREMISES	2010113468446
CLEAR CHANNEL UK LIMITED	Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)				È0.00	Occupied Property	N		ADVERT RIGHT SITE REF 0704 0904	OPP BECKETT WING	BECKETT STREET	LEEDS	LS9 7TF	800	850	CA	ADVERTISING RIGHT AND PREMISES	2010113477477
THACKRAY MEDICAL MUSEUM CO LTD	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	80			È0.00	Occupied Property	N		THACKRAY MEDICAL MUSEUM	BECKETT STREET	BURMANTOFTS	LEEDS	LS9 7LP	160000	262500	EM1	MUSEUM AND PREMISES	2010114356678
LEEDS TEACHING HOSPITALS NHS TRUST	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)				È0.00	Occupied Property	N		POST GRADUATE MEDICAL	EDUCATION CENTRE	BECKETT STREET	BURMANTOFTS LEEDS	LS9 7LP	11750	11750	CO	LECTURE ROOMS AND PREMISES	2010114356679
BHE (ST JAMES) LIMITED	Sat Aug 29 2015 00:00:00 GMT+0000 (Coordinated Universal Time)				È0.00	Empty Property	N	Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIT 18	GLEDHOW WING ST JAMES HOSPITAL	BECKETT STREET	LEEDS	LS9 7TF	3050	4200	CS	Shop and Premises	2010116101022


CREATE TABLE n_06_01_2017 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatory_relief" DOUBLE,
  "discretionary_relief" DOUBLE,
  "small_business_relief" DOUBLE,
  "local_discount" VARCHAR,
  "property_status" VARCHAR,
  "exempt_epr" VARCHAR,
  "empty_from" TIMESTAMP,
  "addr1" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "n_2010_rateable_value" BIGINT,
  "n_2017_rateable_value" BIGINT,
  "description_code" VARCHAR,
  "description" VARCHAR,
  "b_a_reference" BIGINT
);