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	vo_code VO Code	property_description Property Description	empty Empty	empty_from Empty From	charity Charity	disc Disc	mand Mand	sbrr SBRR
Ref: 60427600850031	17TH ROCHDALE 1ST WARDLE SCOUTS	01.04.2005	WARDLE SCOUT GROUP		RAMSDEN ROAD	WARDLE	ROCHDALE	LANCASHIRE	OL12 9NX	3500	LC3	SCOUT HEADQUARTERS			Y		80
Ref: 15678991008619	1860 GEL LIMITED	01.12.2016	UNITS 1A - 1B		MOSS MILL INDUSTRIAL	ROCHDALE			OL16 5LB	17500	IF3	WORKSHOP AND PREMISES
Ref: 40508800410063	1ST CONTRACTS GROUP LTD	04.04.2017			84A WILLIAM STREET	LITTLEBOROUGH	LANCASHIRE		OL15 8JP	11750	CO	OFFICES AND PREMISES	Y	04.04.2017
Ref: 40511692018232	1ST CONTRACTS GROUP LTD	04.04.2017			71A FEATHERSTALL ROAD	LITTLEBOROUGH	LANCS		OL15 8JZ	10750	CO	OFFICES AND PREMISES	Y	04.04.2017
Ref: 30979794013489	20/20 INDUSTRIES LTD	01.04.2011	GF 12 OFFICE THE OLD POLICE	STATION BUSINESS CENTRE	HIND HILL STREET	HEYWOOD	LANCS		OL10 1AQ	1650	CO	OFFICE						Y
Ref: 11036729579947	21ST CENTURY TATTOO LTD	04.07.2008			1-5 CHEETHAM STREET	ROCHDALE	LANCASHIRE		OL16 1PQ	6300	CO	TATOO STUDIO & PREMISES						Y
Ref: 15419800110027	27TH ROCHDALE LOWERPLACE SCOUTS	01.04.2005			27TH RDALE (LOWERPLACE) SCOUT GROUP	WATKIN STREET	ROCHDALE	LANCASHIRE	OL16 4HJ	2600	LC3	CLUBROOM & PREMISES			Y	20	80
Ref: 41192300410068	29TH ROCHDALE SCOUTS C/O J R	01.04.2005			120 NEW ROAD	LITTLEBOROUGH	LANCASHIRE		OL15 8NL	2250	LC3	HALL AND PREMISES			Y		80
Ref: 3152799916535A	2SQUARED AGENCY LTD	20.05.2014	UNIT B4/ BAYS 1 AND 2	BROADLANDS	HEYWOOD DISTRIBUTION PARK	PILSWORTH ROAD	HEYWOOD		OL10 2TS	63000	CW	WAREHOUSE AND PREMISES
Ref: 14816800010089	37TH ROCHDALE SCOUT GROUP C/O	01.04.2005			37TH ROCHDALE SCOUTS	SILK STREET	ROCHDALE	LANCASHIRE	OL11 3ER	2075	LC3	HALL AND PREMISES			Y		80


CREATE TABLE table_13 (
  "property_ref" VARCHAR,
  "liable_name_1" 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,
  "vo_code" VARCHAR,
  "property_description" VARCHAR,
  "empty" VARCHAR,
  "empty_from" VARCHAR,
  "charity" VARCHAR,
  "disc" BIGINT,
  "mand" BIGINT,
  "sbrr" VARCHAR,
  "s44a" VARCHAR,
  "local_discount" VARCHAR,
  "occupied" VARCHAR
);