Business Rates

ratepayer Ratepayer	liable_from Liable From	mandatory_relief Mandatory Relief %	small_business_rate_relief Small Business Rate Relief %	local_discount_2016_17 Local Discount 2016/17	property_status Property Status	exempt_empty Exempt Empty	empty_from Empty From	address Address	addr2 Addr2	addr3 Addr3	addr4 Addr4	postcode Postcode	rateable_value Rateable Value	description_code Description Code	property_description Property Description	billing_authority_reference Billing Authority Reference
NAIL & BEAUTY SHOP LTD	Wed Mar 13 2002 00:00:00 GMT+0000 (Coordinated Universal Time)		100	£0.00	Occupied Property	N		12 ROBIN LANE	PUDSEY	LEEDS		LS28 7BR	6000	CS	Shop and Premises	2312002314303
LANDMARK TRUST	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	80		£0.00	Occupied Property	N		NORTH HOUSE	18 WOODHALL ROAD	CALVERLEY	PUDSEY	LS28 5NL	2225	CH1	SELF CATERING HOLIDAY UNIT AND PREMISES	2321909337450
HOME FARM TRUST	Mon Apr 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	80		£0.00	Occupied Property	N		GROUND FLOOR	1B BRAMLEY GARDENS	LEEDS		LS14 1AE	1350	CO	OFFICES AND PREMISES	2183300369073
LEEDS BUILDING SOCIETY	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)			£0.00	Occupied Property	N		13 HAREHILLS ROAD	HAREHILLS	LEEDS		LS8 5HR	10250	CS	SHOP AND PREMISES	2090719319515
UNITED CO-OPERATIVES LTD	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)			£0.00	Empty Property	N	Sun Jul 14 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	12 LOWTOWN	PUDSEY	LEEDS		LS28 7AA	12000	CS	SHOP AND PREMISES	2312061330137
TOWN END CHEMICAL WORKS LTD	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)			£0.00	Occupied Property	N		UNITS 17/18	SILVER COURT	INTERCITY WAY	LEEDS	LS13 4LY	83000	CW	WAREHOUSE AND PREMISES	2323549348891
CLYDESDALE BANK PLC	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)			£0.00	Occupied Property	N		50 WATERLOO LANE	BRAMLEY	LEEDS		LS13 2JB	82000	CW	WAREHOUSE AND PREMISES	2191722303516
CLYDESDALE BANK PLC	Tue Apr 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)			£0.00	Occupied Property	N		ATM AT	66 STREET LANE	ROUNDHAY	LEEDS	LS8 2DQ	5950	CX	SITE OF AUTOMATIC TELLER MACHINE AND PREMISES	2201543369898
HAROLD NEWSOME LTD	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)			£0.00	Occupied Property	N		PARAGON WORKS	ELDER ROAD	BRAMLEY	LEEDS	LS13 4DL	64500	IF	FACTORY AND PREMISES	2100521303523
GREGGS PLC	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)			£0.00	Occupied Property	N		20 BOAR LANE	LEEDS			LS1 5EL	35250	CS	SHOP AND PREMISES	2050177356847


CREATE TABLE n_07_03_2016 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatory_relief" DOUBLE,
  "discretionary_relief" DOUBLE,
  "small_business_rate_relief" DOUBLE,
  "local_discount_2016_17" VARCHAR,
  "discount_type" VARCHAR,
  "property_status" VARCHAR,
  "exempt_empty" VARCHAR,
  "empty_from" TIMESTAMP,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "rateable_value" VARCHAR,
  "description_code" VARCHAR,
  "property_description" VARCHAR,
  "billing_authority_reference" DOUBLE,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR
);