Business Rates

ratepayer Ratepayer	billing_authority_reference Billing Authority Reference	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	address Address	address_2 Address 2	address_3 Address 3	address_4 Address 4	postcode Postcode	empty_property Empty Property	empty_from Empty From	property_description_code Property Description Code	property_description Property Description
GET AWAY GIRLS	2010106340733	Thu Nov 30 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	£9,200	80			£0.00	67 BAYSWATER GROVE	HAREHILLS	LEEDS		LS8 5LN			CO	OFFICES AND PREMISES
INCHMERY LTD	2010109322071	Mon Aug 06 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	£7,800				£0.00	111/113 BAYSWATER ROAD	HAREHILLS	LEEDS		LS8 5NT	Yes	Tue Apr 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	CS	SHOP AND PREMISES
BAYSWATER GROUP LTD	2010109322758	Fri Apr 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	£4,450			100	£0.00	94 BAYSWATER ROAD	HAREHILLS	LEEDS		LS8 5NT			CS	SHOP AND PREMISES
LEEDS ANIMATION WORKSHOP	2010110339162	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	£3,350		50	100	£0.00	45 BAYSWATER ROW	LEEDS			LS8 5LF			CO	OFFICES AND PREMISES
CLEAR CHANNEL UK LIMITED	2010113456390	Wed Nov 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	£800				£0.00	ADSHEL SITE REF 0704 0862 OPP	BECKETT WING	BECKETT STREET	LEEDS	LS9 7LS			CA	ADVERTISING RIGHT AND PREMISES
CLEAR CHANNEL UK LIMITED	2010113468446	Wed Nov 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	£800				£0.00	ADVERTISING RIGHT 0704 0863	AT ST JAMES HOSPITAL	BECKETT STREET	LEEDS	LS9 7JZ			CA	ADVERTISING RIGHT AND PREMISES
CLEAR CHANNEL UK LIMITED	2010113477477	Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	£800				£0.00	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	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	£160,000	80			£0.00	THACKRAY MEDICAL MUSEUM	BECKETT STREET	BURMANTOFTS	LEEDS	LS9 7LP			EM1	MUSEUM AND PREMISES
LEEDS TEACHING HOSPITALS NHS TRUST	2010114356679	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	£11,750				£0.00	POST GRADUATE MEDICAL	EDUCATION CENTRE	BECKETT STREET	BURMANTOFTS LEEDS	LS9 7LP			CO	LECTURE ROOMS AND PREMISES
COMPASS CONTRACT SERVICES (UK) LTD	2010116352915	Wed Mar 04 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	£5,800				-£1,500.00	UNIT 1, CHANCELLOR WING,	ST JAMES UNIVERSITY HOSPITAL	BECKETT STREET	BURMANTOFTS LEEDS	LS9 7TF			CS	SHOP AND PREMISES


CREATE TABLE n_02_03_2015 (
  "ratepayer" VARCHAR,
  "billing_authority_reference" BIGINT,
  "liable_from" TIMESTAMP,
  "rateable_value" VARCHAR,
  "mandatory_relief" BIGINT,
  "discretionary_relief" BIGINT,
  "small_business_rate_relief" DOUBLE,
  "retail_relief" VARCHAR,
  "address" VARCHAR,
  "address_2" VARCHAR,
  "address_3" VARCHAR,
  "address_4" VARCHAR,
  "postcode" VARCHAR,
  "empty_property" VARCHAR,
  "empty_from" TIMESTAMP,
  "empty_exemption_type" VARCHAR,
  "property_description_code" VARCHAR,
  "property_description" VARCHAR,
  "unnamed_18" VARCHAR
);