Business Rates

ratepayer Ratepayer	liable_from Liable From	mandatory_relief Mandatory Relief %	discretionary_relief Discretionary Relief %	small_business_relief Small Business Relief %	transitional_relief Transitional Relief	transitional_premium Transitional Premium	property_status Property Status	empty_from Empty From	addr1 Addr1	addr2 Addr2	addr3 Addr3	addr4 Addr4	postcode Postcode	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	£0.00	Occupied Property		67 BAYSWATER GROVE	HAREHILLS	LEEDS		LS8 5LN	8500	CO	OFFICES AND PREMISES	2010106340733
INCHMERY LTD	Mon Aug 06 2001 00:00:00 GMT+0000 (Coordinated Universal Time)				-£966.26	£0.00	Empty Property	Tue Apr 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	111/113 BAYSWATER ROAD	HAREHILLS	LEEDS		LS8 5NT	10750	CS	SHOP AND PREMISES	2010109322071
BAYSWATER GROUP LTD	Fri Apr 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)			100	-£489.28	£0.00	Occupied Property		94 BAYSWATER ROAD	HAREHILLS	LEEDS		LS8 5NT	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	£0.00	Occupied Property		45 BAYSWATER ROW	LEEDS			LS8 5LF	3100	CO	OFFICES AND PREMISES	2010110339162
CLEAR CHANNEL UK LIMITED	Wed Nov 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)				£0.00	£0.00	Occupied Property		ADSHEL SITE REF 0704 0862 OPP	BECKETT WING	BECKETT STREET	LEEDS	LS9 7LS	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	£0.00	Occupied Property		ADVERTISING RIGHT 0704 0863	AT ST JAMES HOSPITAL	BECKETT STREET	LEEDS	LS9 7JZ	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	£0.00	Occupied Property		ADVERT RIGHT SITE REF 0704 0904	OPP BECKETT WING	BECKETT STREET	LEEDS	LS9 7TF	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			-£10,160.90	£0.00	Occupied Property		THACKRAY MEDICAL MUSEUM	BECKETT STREET	BURMANTOFTS	LEEDS	LS9 7LP	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	£0.00	Occupied Property		POST GRADUATE MEDICAL	EDUCATION CENTRE	BECKETT STREET	BURMANTOFTS LEEDS	LS9 7LP	11750	CO	LECTURE ROOMS AND PREMISES	2010114356679
BHE (ST JAMES) LIMITED	Sat Aug 29 2015 00:00:00 GMT+0000 (Coordinated Universal Time)				-£376.19	£0.00	Empty Property	Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIT 18	GLEDHOW WING ST JAMES HOSPITAL	BECKETT STREET	LEEDS	LS9 7TF	4200	CS	SHOP AND PREMISES	2010116101022


CREATE TABLE n_20_04_2017 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatory_relief" BIGINT,
  "discretionary_relief" BIGINT,
  "small_business_relief" DOUBLE,
  "transitional_relief" VARCHAR,
  "transitional_premium" VARCHAR,
  "property_status" VARCHAR,
  "empty_from" TIMESTAMP,
  "addr1" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "n_2017_rateable_value" BIGINT,
  "description_code" VARCHAR,
  "description" VARCHAR,
  "b_a_reference" BIGINT
);