Business Rates

ratepayer Ratepayer	liable_from Liable From	local_discount Local Discount	local_discount_type Local Discount Type	property_status Property Status	exempt_empty_rates Exempt Empty Rates	addr1 Addr1	addr2 Addr2	addr3 Addr3	addr4 Addr4	postcode Postcode	rateable_value Rateable Value	description_code Description Code	description Description
WATERSHED PACKAGING LTD	Mon Apr 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	-Ł55,000.00	Enterprise Zone	Occupied Property	N	WATERSHED PACKAGING LTD	THORNES FARM WAY	PONTEFRACT LANE	LEEDS	LS9 0AN	129000	CW	WAREHOUSE AND PREMISES
FEDEX LTD	Sat Aug 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	-Ł55,000.00	Enterprise Zone	Occupied Property	N	UNIT 1 CONNEX 45	THORNES FARM WAY	CROSS GREEN	LEEDS	LS9 0PS	184000	CW	Warehouse and Premises
PERSPEX DISTRIBUTION LIMITED	Tue Feb 09 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	-Ł55,000.00	Enterprise Zone	Occupied Property	N	UNIT 2 CONNEX 45	THORNES FARM WAY	CROSS GREEN	LEEDS	LS9 0PS	121000	CW	WAREHOUSE AND PREMISES
SAMUEL GRANT (LEEDS) LTD	Wed Aug 12 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	-Ł55,000.00	Enterprise Zone	Occupied Property	N	UNIT 1 ORION WAY	FAR LANE	LEEDS		LS9 0DN	207000	CW	WAREHOUSE AND PREMISES
IMPETUS ENCLOSURE SYSTEMS LTD	Sun Nov 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	-Ł55,000.00	Enterprise Zone	Occupied Property	N	UNIT 3 ORION WAY	FAR LANE	LEEDS		LS9 0DN	115000	IF3	Workshop and Premises
SYMINGTONS LTD	Wed Jul 02 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	-Ł50,360.00	Enterprise Zone	Occupied Property	N	SYMINGTONS	PONTEFRACT LANE	RICHMOND HILL	LEEDS	LS9 0DN	835000	CW	WAREHOUSE AND PREMISES
M MERCADO LTD	Thu Apr 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	-Ł50,360.00	Enterprise Zone	Occupied Property	N	M MERCADO LTD	THORNES FARM WAY	PONTEFRACT LANE, RICHMOND HILL	LEEDS	LS9 0AN	875000	CW	WAREHOUSE AND PREMISES
ROBERTS MART & CO LTD	Sun Aug 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	-Ł50,360.00	Enterprise Zone	Occupied Property	N	AIRE VALLEY HOUSE	THORNES FARM WAY	PONTEFRACT LANE	LEEDS	LS9 0AN	390000	IFO	FACTORY, OFFICE AND PREMISES
OPEN DATA INSTITUTE	Mon Mar 10 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	-Ł14,537.25	Local Scheme	Occupied Property	N	STUDIO 4 THIRD FLOOR	MUNRO HOUSE	DUKE STREET	LEEDS	LS9 8AG	29250	CO	Offices and Premises
METPRINT LTD	Sat Mar 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	-Ł8,747.20	Local Scheme	Occupied Property	N	FELIX ESTATES	GRANGEFIELD INDUSTRIAL ESTATE	RICHARDSHAW ROAD	PUDSEY	LS28 6QW	88000	IF	Factory and Premises


CREATE TABLE n_10_05_2016 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatory_relief" DOUBLE,
  "discretionary_relief" DOUBLE,
  "small_business_rare_relief" DOUBLE,
  "local_discount" VARCHAR,
  "local_discount_type" VARCHAR,
  "property_status" VARCHAR,
  "exempt_empty_rates" VARCHAR,
  "addr1" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "empty_from" TIMESTAMP,
  "rateable_value" BIGINT,
  "description_code" VARCHAR,
  "description" VARCHAR
);