Business Rates

ratepayer Ratepayer	liable_from Liable From	mandaory_relief Mandaory Relief (%)+	sbrr_percent Sbrr Percent	transitional_relief Transitional Relief	transitional_premium Transitional Premium	net_local_discount Net Local Discount	propery_status Propery Status	address Address	addr2 Addr2	addr3 Addr3	addr4 Addr4	postcode Postcode	voa_description_code VOA Description Code	description Description	rateable_value Rateable Value	ba_referencenumber BA ReferenceNumber
NAIL & BEAUTY SHOP LTD	Wed Mar 13 2002 00:00:00 GMT+0000 (Coordinated Universal Time)		100	Ł0.00	Ł0.00	Ł0.00	Occupied Property	12 ROBIN LANE	PUDSEY	LEEDS		LS28 7BN	CS	SHOP AND PREMISES	5700	2312002314303
LANDMARK TRUST	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	80		-Ł1,914.94	Ł0.00	Ł0.00	Occupied Property	NORTH HOUSE	18 WOODHALL ROAD	CALVERLEY	PUDSEY	LS28 5NL	CH1	SELF CATERING HOLIDAY UNIT AND PREMISES	6650	2321909337450
TOWN END CHEMICAL WORKS LTD	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)			Ł0.00	Ł0.00	Ł0.00	Occupied Property	UNITS 17/18	SILVER COURT	INTERCITY WAY	LEEDS	LS13 4LY	CW	WAREHOUSE AND PREMISES	78500	2323549348891
CLYDESDALE BANK PLC	Tue Apr 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)			Ł0.00	Ł0.00	Ł0.00	Occupied Property	ATM AT	66 STREET LANE	ROUNDHAY	LEEDS	LS8 2DQ	CX	SITE OF AUTOMATIC TELLER MACHINE AND PREMISES	5950	2201543369898
HAROLD NEWSOME LTD	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)			Ł0.00	Ł0.00	Ł0.00	Occupied Property	PARAGON WORKS	ELDER ROAD	BRAMLEY	LEEDS	LS13 4DL	IF	FACTORY AND PREMISES	59000	2100521303523
GREGGS PLC	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)			Ł0.00	Ł0.00	Ł0.00	Occupied Property	20 BOAR LANE	LEEDS			LS1 5EL	CS	SHOP AND PREMISES	36750	2050177356847
GREGGS PLC	Fri Aug 15 2003 00:00:00 GMT+0000 (Coordinated Universal Time)			Ł0.00	Ł0.00	Ł0.00	Occupied Property	26/27, CROSSGATES SHOPPING CENTRE	STATION ROAD	CROSSGATES	LEEDS	LS15 8ET	CS	SHOP AND PREMISES	39000	2111514357675
GREGGS PLC	Mon Feb 18 2002 00:00:00 GMT+0000 (Coordinated Universal Time)			Ł0.00	Ł0.00	Ł0.00	Occupied Property	GREGGS OF YORKSHIRE	ELMFIELD WAY	BRAMLEY	LEEDS	LS13 4UD	IF	BAKERY AND PREMISES	310000	2100537367453
GREGGS PLC	Mon Apr 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time)			-Ł741.31	Ł0.00	Ł0.00	Occupied Property	UNIT A13	THE LIGHT	THE HEADROW	LEEDS	LS1 8EQ	CS	SHOP AND PREMISES	25000	2051612368594
LEEDS BACON CO LTD	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)			Ł0.00	Ł0.00	Ł0.00	Occupied Property	GREENTHORPE MILLS	106 HENCONNER LANE	BRAMLEY	LEEDS	LS13 4JU	CW	WAREHOUSE AND PREMISES	41250	2100773303532


CREATE TABLE n_01_10_2018 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandaory_relief" DOUBLE,
  "discretionay_relief" DOUBLE,
  "sbrr_percent" DOUBLE,
  "transitional_relief" VARCHAR,
  "transitional_premium" VARCHAR,
  "net_local_discount" VARCHAR,
  "propery_status" VARCHAR,
  "empty_from" TIMESTAMP,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "voa_description_code" VARCHAR,
  "description" VARCHAR,
  "rateable_value" BIGINT,
  "ba_referencenumber" BIGINT
);