Business Rates - Rochdale Borough Council

property_reference Property Reference	account_holder_1 Account Holder 1	account_holder_2 Account Holder 2	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_post_code Property Post Code	liable_from Liable From	rv RV	description Description	empty_y_n Empty Y/N	sbrr_y_n SBRR Y/N	retail_discount_y_n Retail Discount Y/N	expanded_retail_discount_y_n Expanded Retail Discount Y/N
Ref:10034695731467	CHUNKS STEAK BOX LTD		DALE AUTO PARTS UNIT 1	CLAYCOURT BUILDING	CRAWFORD STREET	ROCHDALE	LANCS	OL16 5RS	03.09.2019	2000	OFFICES AND PREMISES	N	Y	N	N
Ref:1003708165442A	ROYAL MAIL GROUP PLC		PROGRESS HOUSE		AINSWORTH STREET	ROCHDALE	LANCASHIRE	OL16 1AA	01.04.2005	101000	WAREHOUSE AND PREMISES	N	N	N	N
Ref:10037099153853	VALUME LTD		C C G WINDSCREENS LTD		AINSWORTH STREET	ROCHDALE	LANCS	OL16 5QX	01.07.2014	26750	WAREHOUSE AND PREMISES	N	N	N	N
Ref:10055593003732	ROCHDALE BOROUGH COUNCIL				FABTRAD LTD	ALBERT ROYDS STREET	ROCHDALE	OL16 5AA	18.06.2020	132000	Warehouse and Premises	N	N	N	N
Ref:10055594929043	MCCOLL'S RETAIL GROUP PLC				UNIT 1 MAYFIELD PARADE	ALBERT ROYDS STREET	ROCHDALE	OL16 2UE	03.05.2017	35500	SHOP AND PREMISES	N	N	N	Y
Ref:10055595691394	SHEET ANCHOR INVESTMENTS 2	LIMITED	UNIT 5 MAYFIELD PARADE		ALBERT ROYDS STREET	ROCHDALE	LANCS	OL16 2UE	23.10.2020	11250	SHOP AND PREMISES	N	N	N	N
Ref:10055596411316	GLAMORGAN RETAIL LIMITED		UNIT 3 MAYFIELD PARADE		ALBERT ROYDS STREET	ROCHDALE	LANCS	OL16 2UE	30.08.2012	12250	SHOP AND PREMISES	N	N	Y	Y
Ref:10055596415123	TOTE BOOKMAKERS LTD		UNIT 2 MAYFIELD PARADE		ALBERT ROYDS STREET	ROCHDALE	LANCS	OL16 2UE	01.12.2006	10750	SHOP AND PREMISES	N	N	N	Y
Ref:10058X0002005B	J COONEY LTD		J COONEY CIVIL ENGINEERING		ALBION ROAD	ROCHDALE	LANCS	OL11 4HQ	01.04.2005	10500	WAREHOUSE AND PREMISES	N	Y	N	N
Ref:10058X00050075	ACRYATE RESEARCH AND DEVELOPMENT	LTD	UNIT 3		ALBION INDUSTRIAL ESTATE	ROCHDALE	LANCASHIRE	OL11 4JB	15.04.2016	11500	WORKSHOP AND PREMISES	N	Y	N	N


CREATE TABLE table_10 (
  "property_reference" VARCHAR,
  "account_holder_1" VARCHAR,
  "account_holder_2" 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_post_code" VARCHAR,
  "liable_from" VARCHAR,
  "rv" BIGINT,
  "description" VARCHAR,
  "empty_y_n" VARCHAR,
  "empty_from" VARCHAR,
  "discretionary_relief" BIGINT,
  "mandatory_relief" BIGINT,
  "sbrr_y_n" VARCHAR,
  "s44a_y_n" VARCHAR,
  "hardship_y_n" VARCHAR,
  "retail_discount_y_n" VARCHAR,
  "expanded_retail_discount_y_n" VARCHAR
);