Business Rates

ratepayer Ratepayer	b_a_reference B A Reference	rateable_value Rateable Value	empty Empty ?	mandatory_relief_percent Mandatory Relief Percent	discretionary_relief_percentage Discretionary Relief Percentage	small_business_rate_percentage Small Business Rate Percentage	charged_from Charged From	address Address	addr2 Addr2	addr3 Addr3	addr4 Addr4	postcode Postcode	empty_from Empty From	exemption_type Exemption Type	vo_property_description_code Vo Property Description Code	description Description
GET AWAY GIRLS	2010106340733	9200	N	80			Thu Nov 30 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	67 BAYSWATER GROVE	HAREHILLS	LEEDS		LS8 5LN			CO	OFFICES AND PREMISES
INCHMERY LTD	2010109322071	7800	Y				Mon Aug 06 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	111/113 BAYSWATER ROAD	HAREHILLS	LEEDS		LS8 5NT	Tue Apr 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)		CS	SHOP AND PREMISES
BAYSWATER GROUP LTD	2010109322758	4450	N			100	Fri Apr 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	94 BAYSWATER ROAD	HAREHILLS	LEEDS		LS8 5NT			CS	SHOP AND PREMISES
LEEDS ANIMATION WORKSHOP	2010110339162	3350	N		50	100	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	45 BAYSWATER ROW	LEEDS			LS8 5LF			CO	OFFICES AND PREMISES
CLEAR CHANNEL UK LIMITED	2010113456390	800	N				Wed Nov 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	ADSHEL SITE REF 0704 0862 OPP	BECKETT WING	BECKETT STREET	LEEDS	LS9 7LS			CA	ADVERTISING RIGHT AND PREMISES
CLEAR CHANNEL UK LIMITED	2010113468446	800	N				Wed Nov 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	ADVERTISING RIGHT 0704 0863	AT ST JAMES HOSPITAL	BECKETT STREET	LEEDS	LS9 7JZ			CA	ADVERTISING RIGHT AND PREMISES
CLEAR CHANNEL UK LIMITED	2010113477477	800	N				Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	ADVERT RIGHT SITE REF 0704 0904	OPP BECKETT WING	BECKETT STREET	LEEDS	LS9 7TF			CA	ADVERTISING RIGHT AND PREMISES
THACKRAY MEDICAL MUSEUM CO LTD	2010114356678	160000	N	80			Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	THACKRAY MEDICAL MUSEUM	BECKETT STREET	BURMANTOFTS	LEEDS	LS9 7LP		Listed BuiLanding	EM1	MUSEUM AND PREMISES
LEEDS TEACHING HOSPITALS NHS TRUST	2010114356679	11750	N				Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	POST GRADUATE MEDICAL	EDUCATION CENTRE	BECKETT STREET	BURMANTOFTS LEEDS	LS9 7LP			CO	LECTURE ROOMS AND PREMISES
COMPASS CONTRACT SERVICES (UK) LTD	2010116352915	5800	N				Wed Mar 04 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIT 1, CHANCELLOR WING,	ST JAMES UNIVERSITY HOSPITAL	BECKETT STREET	BURMANTOFTS LEEDS	LS9 7TF		Listed BuiLanding	CS	SHOP AND PREMISES


CREATE TABLE n_08_10_2014 (
  "ratepayer" VARCHAR,
  "b_a_reference" DOUBLE,
  "rateable_value" DOUBLE,
  "empty" VARCHAR,
  "mandatory_relief_percent" DOUBLE,
  "discretionary_relief_percentage" DOUBLE,
  "small_business_rate_percentage" DOUBLE,
  "charged_from" TIMESTAMP,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "empty_from" TIMESTAMP,
  "exemption_type" VARCHAR,
  "vo_property_description_code" VARCHAR,
  "description" VARCHAR
);