Business Rates - Rochdale Borough Council

property_ref Property Ref	liable_name_1 Liable Name 1	start_of_liability Start Of Liability	property_name_1 Property Name 1	property_name_2 Property Name 2	property_address_1 Property Address 1	property_address_2 Property Address 2	property_address_3 Property Address 3	property_address_4 Property Address 4	property_postcode Property Postcode	rateable_value_2017 Rateable Value 2017	property_description Property Description	charity Charity	disc Disc	mand Mand	sbrr SBRR
4.05E+13	AAA PEST CONTROL SERVICES LTD	13.02.2017			AAA PEST CONTROL SERVICES LTD	HENDERSON STREET	LITTLEBOROUGH	LANCS	OL15 8DT	3250	Workshop and Premises				Y
6.04E+13	17TH ROCHDALE 1ST WARDLE SCOUTS	01.04.2005	WARDLE SCOUT GROUP		RAMSDEN ROAD	WARDLE	ROCHDALE	LANCASHIRE	OL12 9NX	3500	SCOUT HEADQUARTERS	Y		80
1.57E+13	1860 GEL LIMITED	01.12.2016			UNIT 1B	MOSS MILL INDUSTRIAL ESTATE	ROCHDALE		OL16 5LB	14000	Warehouse and Premises
4.18E+13	1ST CONTRACTS GROUP LIMITED	04.04.2017	GND FLR 84A		WILLIAM STREET	LITTLEBOROUGH	LANCS		OL15 8JP	2475	WAREHOUSE AND PREMISES
4.05E+13	1ST CONTRACTS GROUP LTD	04.04.2017			84A WILLIAM STREET	LITTLEBOROUGH	LANCASHIRE		OL15 8JP	11750	OFFICES AND PREMISES
4.05E+13	1ST CONTRACTS GROUP LTD	04.04.2017			71A FEATHERSTALL ROAD	LITTLEBOROUGH	LANCS		OL15 8JZ	10750	OFFICES AND PREMISES
3.10E+13	20/20 INDUSTRIES LTD	01.04.2011	GF 12 OFFICE THE OLD POLICE	STATION BUSINESS CENTRE	HIND HILL STREET	HEYWOOD	LANCS		OL10 1AQ	1650	OFFICE				Y
1.10E+13	21ST CENTURY TATTOO LTD	04.07.2008			1-5 CHEETHAM STREET	ROCHDALE	LANCASHIRE		OL16 1PQ	6300	TATOO STUDIO & PREMISES				Y
1.54E+13	27TH ROCHDALE LOWERPLACE SCOUTS	01.04.2005			27TH RDALE (LOWERPLACE) SCOUT GROUP	WATKIN STREET	ROCHDALE	LANCASHIRE	OL16 4HJ	2600	CLUBROOM & PREMISES	Y	20	80
2.14E+13	29K ADVISERS S8P1 LTD	30.11.2018	SUITE 9 1ST FLR	71-73	LONG STREET	MIDDLETON	MANCHESTER		M24 6UN	1350	OFFICE


CREATE TABLE table_18 (
  "property_ref" VARCHAR,
  "liable_name_1" VARCHAR,
  "liable_name_2" VARCHAR,
  "start_of_liability" VARCHAR,
  "property_name_1" VARCHAR,
  "property_name_2" VARCHAR,
  "property_address_1" VARCHAR,
  "property_address_2" VARCHAR,
  "property_address_3" VARCHAR,
  "property_address_4" VARCHAR,
  "property_postcode" VARCHAR,
  "rateable_value_2017" BIGINT,
  "property_description" VARCHAR,
  "charity" VARCHAR,
  "disc" BIGINT,
  "mand" BIGINT,
  "sbrr" VARCHAR,
  "s44a" VARCHAR,
  "s49" VARCHAR,
  "local_discount" VARCHAR
);