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_address_4 Property Address 4	property_post_code Property Post Code	liable_from Liable From	rv RV	description Description	empty_y_n Empty Y/N	small_busienss_rate_relief_y_n Small Busienss Rate Relief Y/N	chief_executive_relief_y_n Chief Executive Relief Y/N	retail_hostitality_leisure_relief_y_n Retail Hostitality & Leisure Relief Y/N	transitional_or_supporting_small_business_relief_y_n Transitional Or Supporting Small Business Relief Y/N
Ref:10034695731467	CHUNKS STEAK BOX LTD		DALE AUTO PARTS UNIT 1	CLAYCOURT BUILDING	CRAWFORD STREET	ROCHDALE	LANCS		OL16 5RS	03.09.2019	È2,000.00	OFFICES AND PREMISES	N	Y	N	N	N
Ref:10034698801255	KAINAAT KEBABS LTD		UNIT 2		CLAY COURT BUILDINGS	CRAWFORD STREET	ROCHDALE		OL16 5RS	20.10.2021	È13,000.00	WAREHOUSE AND PREMISES	N	Y	N	N	N
Ref:1003708165442A	ROYAL MAIL GROUP PLC		PROGRESS HOUSE		AINSWORTH STREET	ROCHDALE	LANCASHIRE		OL16 1AA	01.04.2005	È101,000.00	WAREHOUSE AND PREMISES	N	N	N	N	N
Ref:10037099153853	VALUME LTD		C C G WINDSCREENS LTD		AINSWORTH STREET	ROCHDALE	LANCS		OL16 5QX	01.07.2014	È30,250.00	Warehouse And Premises	N	N	N	N	N
Ref:10055590184032	INPOST UK LIMITED				INPOST PARCEL LOCKER	GO LOCAL EXTRA, BELFIELD HALL FARM	ALBERT ROYDS STREET	ROCHDALE	OL16 5AA	01.04.2022	È1,500.00	INPOST DELIVERY LOCKER	N	N	N	N	N
Ref:10055590642185	ARQIVA LTD		ARQIVA SITE NO 305285		LAND ADJ TO ALBERT ROYDS STREET	BELLSHILL CERESCENT	ROCHDALE		OL16 2TS	31.08.2020	È4,650.00	COMMUNICATION STATION AND PREMISES	N	N	N	N	N
Ref:10055593003732	GRAHAM POOLE ROAD TRANSPORT	LTD			BELFIELD HALL FARM	ALBERT ROYDS STREET	ROCHDALE		OL16 5AA	01.04.2020	È132,000.00	Warehouse and Premises	N	N	N	N	N
Ref:10055594929043	MCCOLLS RETAIL GROUP PLC	(IN ADMINISTRATION)			UNIT 1 MAYFIELD PARADE	ALBERT ROYDS STREET	ROCHDALE		OL16 2UE	09.05.2022	È35,500.00	SHOP AND PREMISES	N	N	N	N	N
Ref:10055596411316	GLAMORGAN RETAIL LIMITED		UNIT 3 MAYFIELD PARADE		ALBERT ROYDS STREET	ROCHDALE	LANCS		OL16 2UE	30.08.2012	È12,250.00	SHOP AND PREMISES	N	N	N	Y	N
Ref:10055596415123	TOTE BOOKMAKERS LTD		UNIT 2 MAYFIELD PARADE		ALBERT ROYDS STREET	ROCHDALE	LANCS		OL16 2UE	01.12.2006	È10,750.00	SHOP AND PREMISES	N	N	N	N	N


CREATE TABLE table_1 (
  "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" VARCHAR,
  "description" VARCHAR,
  "empty_y_n" VARCHAR,
  "empty_from_date" VARCHAR,
  "discretionary_rate_relief" BIGINT,
  "mandatory_relief" BIGINT,
  "small_busienss_rate_relief_y_n" VARCHAR,
  "empty_exemption_type" VARCHAR,
  "chief_executive_relief_y_n" VARCHAR,
  "retail_hostitality_leisure_relief_y_n" VARCHAR,
  "transitional_or_supporting_small_business_relief_y_n" VARCHAR
);