Business Rates

ratepayer Ratepayer	rateable_value Rateable Value	liable_from Liable From	property_description_code Property Description Code	property_description Property Description	address_1 Address 1	address_2 Address 2	address_3 Address 3	address_4 Address 4	postcode Postcode	billing_authority_reference Billing Authority Reference	emptyes_prop EmptYes Prop	empty_from Empty From	exempt_empty Exempt Empty	exemption_type Exemption Type	mandatory_relief Mandatory Relief %	small_business_rate_relief_percentage Small Business Rate Relief Percentage
BRITISH AUTO RACING CLUB YORKSHIRE CENTRE	6500	01-Apr-00	LX	ROAD USED FOR RACING AND PREMISES	STOCKTON FARM	HAREWOOD AVENUE	HAREWOOD	LEEDS	LS17 9LA	2243125327473						91.67
BRADFORD PROPERTY TRUST LTD YORKSHIRE BRANCH	750	01-Apr-00	CW3	STORE AND PREMISES	BETWEEN	57/59 SANDRINGHAM DRIVE	MOORTOWN	LEEDS	LS17 8DB	2241371307852	Yes	01-Apr-05	Yes	RV
THE FIRE BRIGADE UNION YORKS & HUMBERSIDE	11000	05-Mar-01	CO	OFFICES & PREMISES	9A MARSH STREET	ROTHWELL	LEEDS		LS26 0AG	2282895309907
KCOM GROUP PUBLIC LIMITED COMPAN Y	2160000	01-Apr-05	MTX	TELECOMMUNICATIONS FIBRE OPTIC NETWORK AND PREMISES	AFFINITI FIBRE OPTIC TELECOMS	NETWORK IN ENGLAND & WALES	INCLUDING LS11 5JJ		LS2 7JL	2054908487400
NHS SHARED BUSINESS SERVICES LTD XANSA	197000	01-Apr-05	CO	Offices and Premises	GROUND FLOOR	2 STERLING WAY	TINGLEY	WAKEFIELD	WF3 1WE	2294945367573
NHS SHARED BUSINESS SERVICES LTD XANSA	190000	01-Apr-05	CO	Offices and Premises	1ST FLOOR	2 STERLING WAY	TINGLEY	WAKEFIELD	WF3 1WE	2294945368228
NHS SHARED BUSINESS SERVICES LTD XANSA	190000	01-Apr-05	CO	Offices and Premises	2ND FLOOR	2 STERLING WAY	TINGLEY	WAKEFIELD	WF3 1WE	2294945368229
WEST YORKSHIRE FEDERATION OF WOMENS INSTITUTES	15000	01-Jun-12	CO	Offices and Premises	164/166 TOWN STREET	RODLEY	LEEDS		LS13 1HP	2321677606179					80
BARMASTER (INDEPENDANT WHOLESALERS) LTD - FAO DAVID HIL	8800	30-Jun-14	CW	Warehouse and Premises	UNIT 3A HIGHCLIFFE MILLS	HIGHCLIFFE INDUSTRIAL ESTATE	BRUNTCLIFFE LANE	MORLEY LEEDS	LS27 9LR	2302688650340	Yes	30-Jun-14		IP
BARMASTER (INDEPENDANT WHOLESALERS) LTD	5100	29-Sep-06	CL2	CLUB AND PREMISES	2ND FLOOR	HIGH POINT HOUSE	QUEEN STREET, MORLEY	LEEDS	LS27 9EB	2292705428120


CREATE TABLE n_15_08_2014 (
  "ratepayer" VARCHAR,
  "rateable_value" DOUBLE,
  "liable_from" VARCHAR,
  "property_description_code" VARCHAR,
  "property_description" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "address_3" VARCHAR,
  "address_4" VARCHAR,
  "postcode" VARCHAR,
  "billing_authority_reference" DOUBLE,
  "emptyes_prop" VARCHAR,
  "empty_from" VARCHAR,
  "exempt_empty" VARCHAR,
  "exemption_type" VARCHAR,
  "mandatory_relief" DOUBLE,
  "discretionary_relief_percent" DOUBLE,
  "small_business_rate_relief_percentage" DOUBLE,
  "retail_relief" DOUBLE
);