Business Rates

ratepayer Ratepayer	liable_from Liable From	mandatory_relief Mandatory Relief %	discretionary_relief Discretionary Relief %	small_business_rate_relief Small Business Rate Relief %	local_discount_2016_17 Local Discount 2016/17	property_status Property Status	exempt_empty Exempt Empty	empty_from Empty From	address Address	addr2 Addr2	addr3 Addr3	addr4 Addr4	postcode Postcode	rateable_value Rateable Value	description_code Description Code	property_description Property Description	billing_authority_reference Billing Authority Reference
(A Q) NETWORKS LTD	Mon Aug 11 2008 00:00:00 GMT+0000 (Coordinated Universal Time)			£0.00	£0.00	Occupied Property	N		11- 13 HUNSLET ROAD	LEEDS			LS10 1JQ	14750	CO	OFFICES AND PREMISES	2050827484287
06 MARKETING LTD	Tue Apr 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)			£0.00	£0.00	Occupied Property	N		UNIT 6B	MILLSHAW PARK CLOSE	LEEDS		LS11 0LW	18250	CW	WAREHOUSE AND PREMISES	2024426329249
1 TO CONSULT LIMITED	Mon Feb 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)			£100.00	£0.00	Occupied Property	N		SUITE 2 LONGWOOD HALL	60 BRADFORD ROAD	STANNINGLEY	LEEDS	LS28 6DX	3350	CO	OFFICES AND PREMISES	2321954649042
10TH AIREDALE SCOUT GROUP	Fri Apr 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	80	10	£0.00	£0.00	Occupied Property	N		SCOUT HALL	R/O ST PETER & PAUL RC CHURCH	NEW ROAD, YEADON	LEEDS	LS19 7DA	3650	LC3	HALL AND PREMISES	2222192100719
116 CARDIGAN ROAD LIMITED	Sat Aug 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)			£0.00	£0.00	Empty Property	N	Mon Dec 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	ROOM LG4 AT	116 CARDIGAN ROAD	LEEDS		LS6 3BJ	4500	CO	Store and Premises	2120273638772
116 CARDIGAN ROAD LIMITED	Sat Aug 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)			£0.00	£0.00	Empty Property	N	Mon Dec 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	ROOM GF2 AT	116 CARDIGAN ROAD	LEEDS		LS6 3BJ	3150	CO	Offices and Premises	2120273638794
116 CARDIGAN ROAD LIMITED	Sat Aug 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)			£0.00	£0.00	Empty Property	N	Mon Dec 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	ROOM M3 AT	116 CARDIGAN ROAD	LEEDS		LS6 3BJ	6100	CO	Offices and Premises	2120273638816
116 CARDIGAN ROAD LIMITED	Mon Jan 04 2016 00:00:00 GMT+0000 (Coordinated Universal Time)			£0.00	£0.00	Occupied Property	N		ROOMS GF3 & GF4 AT	116 CARDIGAN ROAD	LEEDS		LS6 3BJ	5700	CO	Offices and Premises	2120273640301
116 CARDIGAN ROAD LIMITED	Mon Jan 04 2016 00:00:00 GMT+0000 (Coordinated Universal Time)			£0.00	£0.00	Occupied Property	N		ROOM G5 AT	116 CARDIGAN ROAD	LEEDS		LS6 3BJ	550	CO	Offices and Premises	2120273640312
116 CARDIGAN ROAD LIMITED	Mon Jan 04 2016 00:00:00 GMT+0000 (Coordinated Universal Time)			£0.00	£0.00	Occupied Property	N		ROOM GF6 AT	116 CARDIGAN ROAD	LEEDS		LS6 3BJ	800	CO	Offices and Premises	2120273640323


CREATE TABLE n_15_07_2016 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatory_relief" BIGINT,
  "discretionary_relief" DOUBLE,
  "small_business_rate_relief" VARCHAR,
  "local_discount_2016_17" VARCHAR,
  "property_status" VARCHAR,
  "exempt_empty" VARCHAR,
  "empty_from" TIMESTAMP,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "rateable_value" BIGINT,
  "description_code" VARCHAR,
  "property_description" VARCHAR,
  "billing_authority_reference" BIGINT,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR
);