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	description_code Description Code	description Description	n_2017_rateable_value 2017 Rateable Value	b_a_reference B A Reference
GET AWAY GIRLS	Thu Nov 30 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	£80.00	£0.00	£0.00	£0.00	£0.00	Occupied Property		N	67 BAYSWATER GROVE	HAREHILLS	LEEDS		LS8 5LN	CO	OFFICES AND PREMISES	8500	2010106340733
INCHMERY LTD	Mon Aug 06 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	£0.00	-£966.26	£0.00	Empty Property	Tue Apr 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	N	111/113 BAYSWATER ROAD	HAREHILLS	LEEDS		LS8 5NT	CS	SHOP AND PREMISES	10750	2010109322071
BAYSWATER GROUP LTD	Fri Apr 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	£100.00	-£489.28	£0.00	Occupied Property		N	94 BAYSWATER ROAD	HAREHILLS	LEEDS		LS8 5NT	CS	SHOP AND PREMISES	6000	2010109322758
LEEDS ANIMATION WORKSHOP	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£50.00	£100.00	£0.00	£0.00	Occupied Property		N	45 BAYSWATER ROW	LEEDS			LS8 5LF	CO	OFFICES AND PREMISES	3100	2010110339162
CLEAR CHANNEL UK LIMITED	Wed Nov 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	£0.00	£0.00	£0.00	Occupied Property		N	ADSHEL SITE REF 0704 0862 OPP	BECKETT WING	BECKETT STREET	LEEDS	LS9 7LS	CA	ADVERTISING RIGHT AND PREMISES	850	2010113456390
CLEAR CHANNEL UK LIMITED	Wed Nov 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	£0.00	£0.00	£0.00	Occupied Property		N	ADVERTISING RIGHT 0704 0863	AT ST JAMES HOSPITAL	BECKETT STREET	LEEDS	LS9 7JZ	CA	ADVERTISING RIGHT AND PREMISES	850	2010113468446
CLEAR CHANNEL UK LIMITED	Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	£0.00	£0.00	£0.00	Occupied Property		N	ADVERT RIGHT SITE REF 0704 0904	OPP BECKETT WING	BECKETT STREET	LEEDS	LS9 7TF	CA	ADVERTISING RIGHT AND PREMISES	850	2010113477477
THACKRAY MEDICAL MUSEUM CO LTD	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	£80.00	£0.00	£0.00	-£10,160.90	£0.00	Occupied Property		N	THACKRAY MEDICAL MUSEUM	BECKETT STREET	BURMANTOFTS	LEEDS	LS9 7LP	EM1	MUSEUM AND PREMISES	262500	2010114356678
LEEDS TEACHING HOSPITALS NHS TRUST	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	£0.00	£0.00	£0.00	Occupied Property		N	POST GRADUATE MEDICAL	EDUCATION CENTRE	BECKETT STREET	BURMANTOFTS LEEDS	LS9 7LP	CO	LECTURE ROOMS AND PREMISES	11750	2010114356679
BHE (ST JAMES) LIMITED	Sat Aug 29 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	£0.00	-£376.19	£0.00	Empty Property	Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	N	UNIT 18	GLEDHOW WING ST JAMES HOSPITAL	BECKETT STREET	LEEDS	LS9 7TF	CS	SHOP AND PREMISES	4200	2010116101022


CREATE TABLE n_17_08_2017 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatory_relief" VARCHAR,
  "discretionary_relief" VARCHAR,
  "small_business_relief" VARCHAR,
  "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,
  "description_code" VARCHAR,
  "description" VARCHAR,
  "n_2017_rateable_value" BIGINT,
  "b_a_reference" BIGINT
);