Business Rates

ratepayer Ratepayer	liable_from Liable From	rateable_value Rateable Value	mandatory_relief Mandatory 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	empty_from Empty From	description_code Description Code	description Description	property_reference Property Reference
YORKSHIRE AMBULANCE SERVICE NHS TRUST	Thu Oct 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	530		£0.00	N	N	YORKSHIRE AMBULANCE SERVICE CABIN	ADJ ELECTRICITY SUB STATION	RING ROAD	HORSFORTH LEEDS	LS18 4ER		CO	AMBULANCE RESTROOM AND PARKING AREA	2335159491734
MOBILE BROADBAND NETWORK LTD	Mon Sep 28 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	6200		£0.00	N	N	TELECOM MAST REF 99946	SEWAGE WORKS	OFF TOWN STREET, RODLEY	LEEDS	LS13 1EQ		MT1	COMMUNICATION STATION AND PREMISES	2335053436964
JEPHSON HOUSING ASSOCIATION	Fri Apr 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	2325		£0.00	N	N	FLAT 16, WARWICK COURT	BURLEY LANE	HORSFORTH	LEEDS	LS18 4TB		CO	OFFICES AND PREMISES	2335033423191
BURROW & CROWE LTD	Mon Apr 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	34000		£0.00	N	N	8 & 9 FEAST FIELD	TOWN STREET	HORSFORTH	LEEDS	LS18 4TJ		CO	Offices and Premises	2334971331166
PERMANENT FUTURES LTD	Fri Mar 20 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	17000		£0.00	N	N	4 FEAST FIELD	TOWN STREET	HORSFORTH	LEEDS	LS18 4TJ		CO	OFFICES AND PREMISES	2334971324739
STONEBRIDGE PROJECTS LTD	Thu Oct 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	79000		£0.00	Y	N	ROMERO HOUSE	1 FEATHERBANK COURT	HORSFORTH	LEEDS	LS18 4WA	Thu Oct 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	CO	OFFICES AND PREMISES	2334946622880
WOODHOUSE GROVE SCHOOL	Thu Apr 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	427500	80	£0.00	N	N	WOODHOUSE GROVE SCHOOL	APPERLEY BRIDGE	BRADFORD		BD10 0NR		EP	SCHOOL AND PREMISES	2334451501953
WOODHOUSE GROVE SCHOOL	Tue Oct 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	17500	80	£0.00	N	N	INTERNATIONAL HARVESTERS	APPERLEY BRIDGE	BRADFORD		BD10 0NU		LS	SPORTS GROUND AND PREMISES	2334451331923
DEPHO ESTATES LTD	Wed May 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	3700		£0.00	Y	N	THE ANNEXE	3 STONEY RISE	LEEDS		LS18 4SF	Wed May 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	CO	OFFICES AND PREMISES	2334151365361
DEPHO ESTATES LTD	Mon Apr 29 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	7800		£0.00	Y	N	CALDER CONFERENCES THE MEWS	3 STONEY RISE	LEEDS		LS18 4SF	Mon Apr 29 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	CO	OFFICES AND PREMISES	2334151307206


CREATE TABLE n_18_06_2014 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "rateable_value" BIGINT,
  "mandatory_relief" BIGINT,
  "discretionary_relief" BIGINT,
  "small_business_rate_relief" BIGINT,
  "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
);