Business Rates

ratepayer Ratepayer	liable_from Liable From	mandatoty_relief Mandatoty Relief (%)	discretionary_relief Discretionary Relief (%)	small_business_rate_relief Small Business Rate Relief (%)	transitional_relief Transitional Relief (£)	transitional_premium Transitional Premium (£)	local_discount Local Discount (£)	occupation_status Occupation Status	exempty_empty_rates Exempty Empty Rates	empty_from Empty From	address Address	addr2 Addr2	addr3 Addr3	addr4 Addr4	postcode Postcode	description_code Description Code	description Description	rateable_value Rateable Value (£)	b_a_reference B A Reference
&CO CULTURAL MARKETING CIC	Mon May 15 2017 00:00:00 GMT+0000 (Coordinated Universal Time)			100	£0.00	£0.00	£0.00	Occupied Property	N		UNIT 7	COMMUNITY WORKSHOPS	30/34 AIRE STREET	LEEDS	LS1 4HT	CO	OFFICES AND PREMISES	1050	2054282640384
(A Q) NETWORKS LTD	Mon Aug 11 2008 00:00:00 GMT+0000 (Coordinated Universal Time)				£0.00	£116.92	£0.00	Empty Property	N	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	11- 13 HUNSLET ROAD	LEEDS			LS10 1JQ	CO	OFFICES AND PREMISES	12250	2050827484287
(AQ) NETWORKS LTD	Wed Apr 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)				£0.00	£0.00	£0.00	Occupied Property	N		AQL KIOSK	BISHOPGATE STREET	LEEDS		LS1 5DY	MT2	WIFI KIOSK AND PREMISES	100	2050162101942
1 TO CONSULT LIMITED	Mon Feb 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)			100	£0.00	£0.00	£0.00	Occupied Property	N		SUITE 2 LONGWOOD HALL	60 BRADFORD ROAD	STANNINGLEY	LEEDS	LS28 6DX	CO	OFFICES AND PREMISES	2850	2321954649042
101 IT LIMITED	Fri Jul 07 2017 00:00:00 GMT+0000 (Coordinated Universal Time)			100	£0.00	£14.32	£0.00	Occupied Property	N		OFFICE 83 1ST FLR PURE OFFICE	4100 PARK APPROACH	THORPE PARK SELBY ROAD	LEEDS	LS15 8GB	CO	OFFICES AND PREMISES	4450	2115049626287
102KR LTD	Sun Jan 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)				-£1,250.57	£0.00	£0.00	Empty Property	N	Sun Jan 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	UNITS S1 AND S2 2ND FLOOR	102 KIRKSTALL ROAD	LEEDS		LS3 1JA	CO	OFFICES AND PREMISES	12250	2010898631204
10TH AIREDALE SCOUT GROUP	Fri Apr 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	80	10		-£88.47	£0.00	-£6.67	Occupied Property	N		SCOUT HALL	R/O ST PETER & PAUL RC CHURCH	NEW ROAD, YEADON	LEEDS	LS19 7DA	LC3	HALL AND PREMISES	4250	2222192100719
116 CARDIGAN ROAD LIMITED	Wed Sep 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)				-£52.45	£0.00	£0.00	Empty Property	Y	Wed Sep 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	ROOM LG1 AT	116 CARDIGAN ROAD	LEEDS		LS6 3BJ	CO	OFFICES AND PREMISES	2850	2120273638739
116 CARDIGAN ROAD LIMITED	Wed Sep 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)				-£66.13	£0.00	£0.00	Empty Property	N	Wed Sep 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	ROOM LG2 AT	116 CARDIGAN ROAD	LEEDS		LS6 3BJ	CO	OFFICES AND PREMISES	3400	2120273638750
116 CARDIGAN ROAD LIMITED	Sat Aug 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)				-£137.16	£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	CO	STORE AND PREMISES	5300	2120273638772


CREATE TABLE n_23_10_2017 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatoty_relief" DOUBLE,
  "discretionary_relief" DOUBLE,
  "small_business_rate_relief" DOUBLE,
  "transitional_relief" VARCHAR,
  "transitional_premium" VARCHAR,
  "local_discount" VARCHAR,
  "occupation_status" VARCHAR,
  "exempty_empty_rates" VARCHAR,
  "empty_from" TIMESTAMP,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "description_code" VARCHAR,
  "description" VARCHAR,
  "rateable_value" BIGINT,
  "b_a_reference" BIGINT
);