Business Rates

ratepayer Ratepayer	liable_from Liable From	mandatory_relief Mandatory Relief %	discretionary_relief Discretionary Relief %	small_business_rate_relief Small Business Rate Relief %	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			Occupied Property	N		11- 13 HUNSLET ROAD	LEEDS			LS10 1JQ	14750	CO	OFFICES AND PREMISES	2050827484287
(AQ) NETWORKS LTD	Wed Apr 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Ł0.00			Occupied Property	N		AQL KIOSK	BISHOPGATE STREET	LEEDS		LS1 5DY	100	MT2	WIFI KIOSK AND PREMISES	2050162101942
06 MARKETING LTD	Tue Apr 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Ł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)	Ł0.00		100	Occupied Property	N		SUITE 2 LONGWOOD HALL	60 BRADFORD ROAD	STANNINGLEY	LEEDS	LS28 6DX	3350	CO	OFFICES AND PREMISES	2321954649042
101 IT LIMITED	Tue Mar 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Ł0.00		100	Occupied Property	N		SUITES 23 & 24	AIREDALE HOUSE	423 KIRKSTALL ROAD	LEEDS	LS4 2EW	5100	CO	Offices and Premises	2130899643007
10TH AIREDALE SCOUT GROUP	Fri Apr 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	Ł80.00	10		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			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	Fri Jul 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Ł0.00			Empty Property	N	Fri Jul 22 2016 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			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			Occupied Property	N		ROOMS GF3 & GF4 AT	116 CARDIGAN ROAD	LEEDS		LS6 3BJ	5700	CO	Offices and Premises	2120273640301


CREATE TABLE n_01_09_2016 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatory_relief" VARCHAR,
  "discretionary_relief" DOUBLE,
  "small_business_rate_relief" DOUBLE,
  "local_discount_2016_17" DOUBLE,
  "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
);