Business Rates

ratepayer Ratepayer	liable_from Liable From	mandaory_relief Mandaory Relief	discretionay_relief Discretionay Relief	small_business_relief Small Business Relief	transitional_relief Transitional Relief	transitional_premium Transitional Premium	net_local_discount Net Local Discount	propery_status Propery Status	empty_from Empty From	address Address	addr2 Addr2	addr3 Addr3	addr4 Addr4	postcode Postcode	voa_description_code VOA Description Code	description Description	rateable_value Rateable Value	ba_referencenumber BA ReferenceNumber
GET AWAY GIRLS	Thu Nov 30 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	-£3,352.40	£0.00	£0.00	£0.00	£0.00	£0.00	Occupied Property		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	-£683.12	£0.00	£0.00	Empty Property	Tue Apr 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	111/113 BAYSWATER ROAD	HAREHILLS	LEEDS		LS8 5NT	CS	SHOP AND PREMISES	10750	2010109322071
LEEDS ANIMATION WORKSHOP	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	-£1,488.00	£0.00	£0.00	£0.00	Occupied Property		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	£0.00	Occupied Property		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	£0.00	Occupied Property		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	£0.00	Occupied Property		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)	-£103,530.00	£0.00	£0.00	£0.00	£0.00	£0.00	Occupied Property		THACKRAY MEDICAL MUSEUM	BECKETT STREET	BURMANTOFTS	LEEDS	LS9 7LN	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	£0.00	Occupied Property		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	-£265.43	£0.00	£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	CS	SHOP AND PREMISES	4200	2010116101022
COMPASS CONTRACT SERVICES (UK) LTD	Wed Mar 04 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	£0.00	-£415.04	£0.00	£0.00	Occupied Property		UNIT 1, CHANCELLOR WING,	ST JAMES UNIVERSITY HOSPITAL	BECKETT STREET	BURMANTOFTS LEEDS	LS9 7TF	CS	SHOP AND PREMISES	7800	2010116352915


CREATE TABLE n_14_01_2019 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandaory_relief" VARCHAR,
  "discretionay_relief" VARCHAR,
  "small_business_relief" VARCHAR,
  "transitional_relief" VARCHAR,
  "transitional_premium" VARCHAR,
  "net_local_discount" VARCHAR,
  "propery_status" VARCHAR,
  "empty_from" TIMESTAMP,
  "empty_exemption_reason" VARCHAR,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "voa_description_code" VARCHAR,
  "description" VARCHAR,
  "rateable_value" BIGINT,
  "ba_referencenumber" BIGINT
);