Business Rates - Rochdale Borough Council

property_ref Property Ref	rate_payer Rate Payer	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	discretionary_relief Discretionary Relief %	mandatory_relief Mandatory Relief %	small_business_rate_relief Small Business Rate Relief
Ref:32226694915338	02 UK LTD	01.04.2005	MM02 SITE REF 11078 ON ROOF		ADJ UNIT 10	YEARGATE INDUSTRIAL ESTATE	HEYWOOD	LANCASHIRE	BL9 7HT	10750	COMMUNICATION STATION AND PREMISES
Ref:60427600850031	17TH ROCHDALE 1ST WARDLE SCOUTS	01.04.2005	WARDLE SCOUT GROUP		RAMSDEN ROAD	WARDLE	ROCHDALE	LANCASHIRE	OL12 9NX	3500	SCOUT HEADQUARTERS	Y		80
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	1200	Offices and Premises				Y
Ref:11036729579947	21ST CENTURY TATTOO LTD	04.07.2008			1-5 CHEETHAM STREET	ROCHDALE	LANCASHIRE		OL16 1PQ	5600	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	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	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	78000	WAREHOUSE AND PREMISES
Ref:14816800010089	37TH ROCHDALE SCOUT GROUP C/O	01.04.2005			37TH ROCHDALE SCOUTS	SILK STREET	ROCHDALE	LANCASHIRE	OL11 3ER	2075	HALL AND PREMISES	Y		80
Ref:30991292309834	3G AUTOPARTS LIMITED	01.11.2013	UNIT 45		HOOLEY BRIDGE IND ESTATE	HEYWOOD	LANCASHIRE		OL10 4AP	2125	WORKSHOP AND PREMISES				Y
Ref:31612X0001103A	3RD/4TH HEYWOOD (RAVENCROFT)	01.04.2005			3RD AND 4TH HEYWOOD SCOUT GROUP	REGENT STREET	HEYWOOD	LANCASHIRE	OL10 3BX	2425	SCOUT HUT & PREMISES	Y		80


CREATE TABLE table_7 (
  "property_ref" VARCHAR,
  "rate_payer" 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,
  "discretionary_relief" BIGINT,
  "mandatory_relief" BIGINT,
  "small_business_rate_relief" VARCHAR,
  "retail_relief" VARCHAR,
  "occupied" VARCHAR
);