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	exempt_empty Exempt Empty	addr1 Addr1	addr2 Addr2	addr3 Addr3	addr4 Addr4	postcode Postcode	n_2017_rateable_value 2017 Rateable Value	description_code Description Code	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		No	67 BAYSWATER GROVE	HAREHILLS	LEEDS		LS8 5LN	8500	CO	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)	No	111/113 BAYSWATER ROAD	HAREHILLS	LEEDS		LS8 5NT	10750	CS	2010109322071
BAYSWATER GROUP LTD	Fri Apr 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)			100	-£489.28	£0.00	Occupied Property		No	94 BAYSWATER ROAD	HAREHILLS	LEEDS		LS8 5NT	6000	CS	2010109322758
LEEDS ANIMATION WORKSHOP	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)		50	100	£0.00	£0.00	Occupied Property		No	45 BAYSWATER ROW	LEEDS			LS8 5LF	3100	CO	2010110339162
CLEAR CHANNEL UK LIMITED	Wed Nov 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)				£0.00	£0.00	Occupied Property		No	ADSHEL SITE REF 0704 0862 OPP	BECKETT WING	BECKETT STREET	LEEDS	LS9 7LS	850	CA	2010113456390
CLEAR CHANNEL UK LIMITED	Wed Nov 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)				£0.00	£0.00	Occupied Property		No	ADVERTISING RIGHT 0704 0863	AT ST JAMES HOSPITAL	BECKETT STREET	LEEDS	LS9 7JZ	850	CA	2010113468446
CLEAR CHANNEL UK LIMITED	Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)				£0.00	£0.00	Occupied Property		No	ADVERT RIGHT SITE REF 0704 0904	OPP BECKETT WING	BECKETT STREET	LEEDS	LS9 7TF	850	CA	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		No	THACKRAY MEDICAL MUSEUM	BECKETT STREET	BURMANTOFTS	LEEDS	LS9 7LP	262500	EM1	2010114356678
LEEDS TEACHING HOSPITALS NHS TRUST	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)				£0.00	£0.00	Occupied Property		No	POST GRADUATE MEDICAL	EDUCATION CENTRE	BECKETT STREET	BURMANTOFTS LEEDS	LS9 7LP	11750	CO	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)	No	UNIT 18	GLEDHOW WING ST JAMES HOSPITAL	BECKETT STREET	LEEDS	LS9 7TF	4200	CS	2010116101022


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