Business Rates - Rochdale Borough Council

property_ref Property Ref	liable_name_1 Liable Name 1	liable_name_2 Liable Name 2	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_2010 Rateable Value 2010	property_description Property Description	charity Charity	disc Disc	mand Mand
6.04E+13	17TH ROCHDALE 1ST WARDLE SCOUTS	C/O MRS ANGELA TAIT	01.04.2005	WARDLE SCOUT GROUP		RAMSDEN ROAD	WARDLE	ROCHDALE	LANCASHIRE	OL12 9NX	3500	SCOUT HEADQUARTERS	Y		80
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	1200	Offices and Premises
1.10E+13	21ST CENTURY TATTOO LTD		04.07.2008			1-5 CHEETHAM STREET	ROCHDALE	LANCASHIRE		OL16 1PQ	5600	TATOO STUDIO & PREMISES
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
4.12E+13	29TH ROCHDALE SCOUTS C/O J R	COLLINGE	01.04.2005			120 NEW ROAD	LITTLEBOROUGH	LANCASHIRE		OL15 8NL	2250	HALL AND PREMISES	Y		80
3152799916535A	2SQUARED AGENCY LTD		20.05.2014	UNIT B4/ BAYS 1 AND 2	BROADLANDS	HEYWOOD DISTRIBUTION PARK	PILSWORTH ROAD	HEYWOOD		OL10 2TS	78000	WAREHOUSE AND PREMISES
1.48E+13	37TH ROCHDALE SCOUT GROUP C/O	KEN GRACEY	01.04.2005			37TH ROCHDALE SCOUTS	SILK STREET	ROCHDALE	LANCASHIRE	OL11 3ER	2075	HALL AND PREMISES	Y		80
31612X0001103A	3RD/4TH HEYWOOD (RAVENCROFT)	SCOUT GROUP	01.04.2005			3RD AND 4TH HEYWOOD SCOUT GROUP	REGENT STREET	HEYWOOD	LANCASHIRE	OL10 3BX	2425	SCOUT HUT & PREMISES	Y		80
3.20E+13	4 SEASONS GARDEN MAINTENANCE LTD		10.03.2014			FOUR SEASONS GARDEN	MAINTENANCE	VALE STREET	HEYWOOD	OL10 1PQ	4100	Workshop and Premises
1.22E+13	4COURT HEALTHCARE LTD		02.02.2011	4 COURT HEALTH CARE LTD AT	HEYBROOK SERVICE STATION	HALIFAX ROAD	ROCHDALE	LANCS		OL16 2NJ	8000	SHOP AND PREMISES


CREATE TABLE table_5 (
  "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_2010" BIGINT,
  "property_description" VARCHAR,
  "empty" VARCHAR,
  "empty_from" VARCHAR,
  "charity" VARCHAR,
  "disc" BIGINT,
  "mand" BIGINT,
  "occupied" VARCHAR
);