Business Rates

account_holder1 Account Holder1	liable_from Liable From	rateable_value Rateable Value	mandatory_relief Mandatory Relief (%)	discretionary_relief Discretionary Relief (%)	small_business_rate_relief Small Business Rate Relief (%)	retail_relief Retail Relief (£)	empty_property Empty Property?	exempt_empty Exempt Empty?	empty_from Empty From	address_1 Address 1	addr2 Addr2	addr3 Addr3	addr4 Addr4	postcode Postcode	voa_description_code VOA 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)	9200	80			£0.00	N	N		67 BAYSWATER GROVE	HAREHILLS	LEEDS		LS8 5LN	CO	OFFICES AND PREMISES	2010106340733
INCHMERY LTD	Mon Aug 06 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	7800				£0.00	Y	N	Tue Apr 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	111/113 BAYSWATER ROAD	HAREHILLS	LEEDS		LS8 5NT	CS	SHOP AND PREMISES	2010109322071
BAYSWATER GROUP LTD	Fri Apr 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	4450			100	£0.00	N	N		94 BAYSWATER ROAD	HAREHILLS	LEEDS		LS8 5NT	CS	SHOP AND PREMISES	2010109322758
LEEDS ANIMATION WORKSHOP	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	3350		50	100	£0.00	N	N		45 BAYSWATER ROW	LEEDS			LS8 5LF	CO	OFFICES AND PREMISES	2010110339162
CLEAR CHANNEL UK LIMITED	Wed Nov 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	800				£0.00	N	N		ADSHEL SITE REF 0704 0862 OPP	BECKETT WING	BECKETT STREET	LEEDS	LS9 7LS	CA	ADVERTISING RIGHT AND PREMISES	2010113456390
CLEAR CHANNEL UK LIMITED	Wed Nov 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	800				£0.00	N	N		ADVERTISING RIGHT 0704 0863	AT ST JAMES HOSPITAL	BECKETT STREET	LEEDS	LS9 7JZ	CA	ADVERTISING RIGHT AND PREMISES	2010113468446
CLEAR CHANNEL UK LIMITED	Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	800				£0.00	N	N		ADVERT RIGHT SITE REF 0704 0904	OPP BECKETT WING	BECKETT STREET	LEEDS	LS9 7TF	CA	ADVERTISING RIGHT AND PREMISES	2010113477477
THACKRAY MEDICAL MUSEUM CO LTD	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	160000	80			£0.00	N	N		THACKRAY MEDICAL MUSEUM	BECKETT STREET	BURMANTOFTS	LEEDS	LS9 7LP	EM1	MUSEUM AND PREMISES	2010114356678
LEEDS TEACHING HOSPITALSNHS TRUST	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	11750				£0.00	N	N		POST GRADUATE MEDICAL	EDUCATION CENTRE	BECKETT STREET	BURMANTOFTS LEEDS	LS9 7LP	CO	LECTURE ROOMS AND PREMISES	2010114356679
COMPASS CONTRACT SERVICES (UK)LTD	Wed Mar 04 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	5800				-£1,500.00	N	N		UNIT 1, CHANCELLOR WING,	ST JAMES UNIVERSITY HOSPITAL	BECKETT STREET	BURMANTOFTS LEEDS	LS9 7TF	CS	SHOP AND PREMISES	2010116352915


CREATE TABLE n_11_09_2015 (
  "account_holder1" VARCHAR,
  "liable_from" TIMESTAMP,
  "rateable_value" DOUBLE,
  "mandatory_relief" DOUBLE,
  "discretionary_relief" DOUBLE,
  "small_business_rate_relief" DOUBLE,
  "retail_relief" VARCHAR,
  "local_discount" VARCHAR,
  "empty_property" VARCHAR,
  "exempt_empty" VARCHAR,
  "empty_from" TIMESTAMP,
  "address_1" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "voa_description_code" VARCHAR,
  "description" VARCHAR,
  "b_a_reference" DOUBLE
);