Business Rates

ratepayer Ratepayer	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	empty_property Empty Property	exempt_empty_rates Exempt Empty Rates	address Address	addr2 Addr2	addr3 Addr3	addr4 Addr4	postcode Postcode	description_code Description Code	description Description	property_reference Property Reference
GUISELEY& DIST FACT WORKERS CLUB & INSTITUTE	Sun Oct 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	£6,300			95	£0.00	No	No	6 TOWN STREET	GUISELEY	LEEDS		LS20 9DT	CL2	CLUB AND PREMISES	2222145437151
YEADON AMATEUR OPERATIC & DRAMATIC SOCIETY	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	£3,250	80			£0.00	No	No	CEMETERY CHAPEL	CEMETERY ROAD	YEADON	LEEDS	LS19 6AH	CW3	STORE AND PREMISES	2222152355020
WORLEYPARSONS INFRATRUTURE & ENVIRONMENT LTD	Tue May 05 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	£39,000				£0.00	No	No	MOORFIELD COURT	11A ALMA ROAD	HEADINGLEY	LEEDS	LS6 2AH	CO	OFFICES AND PREMISES	2120016310273
REDWOOD ENGINEERING & FABRICATION LTD	Sat Jun 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	£16,500				£0.00	No	No	UNIT B2 SCOTCH PARK TRADING ESTATE	FORGE LANE	LEEDS		LS12 2PY	IF3	WORKSHOP AND PREMISES	2104069309338
REDWOOD ENGINEERING & FABRICATION LTD	Sat Jun 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	£23,250				£0.00	No	No	UNITS B3 & L	SCOTCH PARK TRADING ESTATE	FORGE LANE	LEEDS	LS12 2PY	IF3	WORKSHOP AND PREMISES	2104069655060
GREEN AYURVEDA WELLNESS CENTRE & HOLISTIC SPA LTD	Sat Dec 31 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	£15,500				£0.00	No	No	UNIT 452	BIRCH PARK	THORP ARCH ESTATE	WETHERBY	LS23 7FG	IF3	HEALTH SPA AND PREMISES	2253380361513
MANNING STAINTON RENTALS & PROPERTY MANAGEMENT LTD	Tue Oct 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	£23,500				£0.00	No	No	9 ALLERTON AVENUE	MOORTOWN	LEEDS		LS17 6RE	CS	SHOP AND PREMISES	2165138481943
MANNING STAINTON RENTALS & PROPERTY MANAGEMENT LTD	Fri Apr 26 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	£7,600				£0.00	No	No	40 QUEEN STREET	MORLEY	LEEDS		LS27 9BR	CS	SHOP AND PREMISES	2292705314811
CHAPEL ALLERTON LAWN TENNIS & SQUASH CLUB	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	£59,000	80	20		£0.00	No	No	CHAPEL ALLERTON LAWN TENNIS &	SQUASH CLUB	WENSLEY AVENUE	CHAPEL ALLERTON LEEDS	LS7 3QX	LS7	TENNIS CENTRE AND PREMISES	2041741353412
SACKVILLE UKPEC1 LEEDS (GP) LTD & THREADNEEDLE LTD	Mon Apr 16 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	£10,750				£0.00	No	No	CENTRE MANAGEMENT SUITE	THE CORE, THE HEADROW	LEEDS		LS1 6JD	CO	OFFICES AND PREMISES	2054445330465


CREATE TABLE n_09_12_2014 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "rateable_value" VARCHAR,
  "mandatory_relief" DOUBLE,
  "discretionary_relief" DOUBLE,
  "small_business_rate_relief" DOUBLE,
  "retail_relief" VARCHAR,
  "empty_property" VARCHAR,
  "exempt_empty_rates" VARCHAR,
  "exemption_type" VARCHAR,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "empty_from" TIMESTAMP,
  "description_code" VARCHAR,
  "description" VARCHAR,
  "property_reference" BIGINT
);