Business Rates

ratepayer Ratepayer	billing_authority_reference Billing Authority Reference	liable_from Liable From	rateable_value Rateable Value	small_business_rate_relief Small Business Rate Relief (%)	local_discount Local Discount	address Address	address_2 Address 2	address_3 Address 3	address_4 Address 4	postcode Postcode	empty_property Empty Property	exempt_empty_rates Exempt Empty Rates	property_description_code Property Description Code	property_description Property Description
FRANKLIN WINDOWS LIMITED	2233714494385	Tue Oct 07 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	20250		Ł0.00	FRANKLIN WINDOWS	CARLTON BUSINESS PARK	CEMETERY ROAD, LEEDS	LEEDS	LS19 7BD	N	N	IF3	Workshop and Premises
LLOYDS PHARMACY LTD	2191666316262	Thu Dec 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	10000		Ł0.00	283/285 UPPER TOWN STREET	BRAMLEY	LEEDS		LS13 3JT	N	N	CS	SHOP AND PREMISES
LLOYDS PHARMACY LTD	2191872360199	Thu Dec 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	24750		Ł0.00	MANOR PARK PHARMACY	BELLMOUNT CLOSE	BRAMLEY	LEEDS	LS13 2UW	N	N	CS	SHOP AND PREMISES
LLOYDS PHARMACY LTD	2090719428296	Thu Dec 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	7100		Ł0.00	125 HAREHILLS ROAD	HAREHILLS	LEEDS		LS8 5BW	N	N	CS	SHOP AND PREMISES
LLOYDS PHARMACY LTD	2014199520873	Tue May 27 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	9500		Ł0.00	UNIT B OATLANDS RETAIL CENTRE	OATLAND DRIVE	LITTLE LONDON	LEEDS	LS7 1SH	N	N	CS	SHOP AND PREMISES
LLOYDS PHARMACY LTD	2011791317664	Thu Dec 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	11000		Ł0.00	166 WOODHOUSE LANE	LEEDS			LS2 9HB	N	N	CS	SHOP AND PREMISES
LLOYDS PHARMACY LTD	2030714351883	Thu Dec 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	5800		Ł0.00	399 HAREHILLS LANE	HAREHILLS	LEEDS		LS9 6AP	N	N	CS	SHOP AND PREMISES
LLOYDS PHARMACY LTD	2200461427988	Thu Dec 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	10000		Ł0.00	PHARMACY AT 12 DEVONSHIRE AVENUE	ROUNDHAY	LEEDS		LS8 1AY	N	N	CS	SHOP AND PREMISES
LLOYDS PHARMACY LTD	2160746354064	Thu Dec 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	29000		Ł0.00	396 HARROGATE ROAD	MOORTOWN	LEEDS		LS17 6PY	N	N	CS	SHOP AND PREMISES
GUISELEY& DIST FACT WORKERS CLUB & INSTITUTE	2222145437151	Sun Oct 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	6300	95	Ł0.00	6 TOWN STREET	GUISELEY	LEEDS		LS20 9DT	N	N	CL2	CLUB AND PREMISES


CREATE TABLE n_18_05_2015 (
  "ratepayer" VARCHAR,
  "billing_authority_reference" DOUBLE,
  "liable_from" TIMESTAMP,
  "rateable_value" DOUBLE,
  "mandatory_relief" DOUBLE,
  "discretionary_relief" DOUBLE,
  "small_business_rate_relief" DOUBLE,
  "local_discount" VARCHAR,
  "address" VARCHAR,
  "address_2" VARCHAR,
  "address_3" VARCHAR,
  "address_4" VARCHAR,
  "postcode" VARCHAR,
  "empty_property" VARCHAR,
  "empty_from" TIMESTAMP,
  "exempt_empty_rates" VARCHAR,
  "property_description_code" VARCHAR,
  "property_description" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR
);