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_postcode Property Postcode	liable_from Liable From	rv RV	property_description Property Description	charity_y_n Charity Y/N	disc Disc %	mand Mand %	sbrr_y_n SBRR Y/N	s44a_y_n S44a Y/N	hardship_y_n Hardship Y/N	local_discount Local Discount	retail_relief_y_n Retail Relief Y/N
1.00E+13	MIRZA TRAVEL SERVICES LTD		DALE AUTO PARTS UNIT 1	CLAYCOURT BUILDING	CRAWFORD STREET	ROCHDALE	LANCS		OL16 5RS	22.03.2018	2000	OFFICES AND PREMISES	N			N	N	N	N	N
1003708165442A	ROYAL MAIL GROUP PLC		PROGRESS HOUSE		AINSWORTH STREET	ROCHDALE	LANCASHIRE		OL16 1AA	01.04.2005	101000	WAREHOUSE AND PREMISES	N			N	N	N	N	N
1.00E+13	SHOE DIRECTORY LTD		C C G WINDSCREENS LTD		AINSWORTH STREET	ROCHDALE	LANCS		OL16 5QX	01.07.2014	16750	WAREHOUSE AND PREMISES	N			N	N	N	N	N
1.01E+13	INPOST UK LIMITED				INPOST PARCEL LOCKER UKROC16346	ALBERT ROYDS STREET	ROCHDALE		OL16 5AA	03.10.2014	1500	SITE OF ELECTRONIC DELIVERY LOCKERS & PREMISES	N			N	N	N	N	N
1.01E+13	FABTRAD LTD				FABTRAD LTD	ALBERT ROYDS STREET	ROCHDALE		OL16 5AA	01.04.2015	132000	Warehouse and Premises	N			N	N	N	N	N
1.01E+13	MCCOLL'S RETAIL GROUP PLC				UNIT 1 MAYFIELD PARADE	ALBERT ROYDS STREET	ROCHDALE		OL16 2UE	03.05.2017	30000	SHOP AND PREMISES	N			N	N	N	N	N
1.01E+13	CARDTRONICS UK LTD				ATM SITE AT	UNIT 1 MAYFIELD PARADE	ALBERT ROYDS STREET	ROCHDALE	OL16 2UE	03.05.2017	5900	SITE OF ATM	N			N	N	N	N	N
1.01E+13	SPRINGHILL HOSPICE	(SERVICES) LTD	UNIT 5 MAYFIELD PARADE		ALBERT ROYDS STREET	ROCHDALE	LANCS		OL16 2UE	01.11.2016	11250	SHOP AND PREMISES	Y	20	80	N	N	N	N	N
1.01E+13	GLAMORGAN RETAIL LIMITED		UNIT 3 MAYFIELD PARADE		ALBERT ROYDS STREET	ROCHDALE	LANCS		OL16 2UE	30.08.2012	12250	SHOP AND PREMISES	N			N	N	N	Y	Y
1.01E+13	TOTE BOOKMAKERS LTD		UNIT 2 MAYFIELD PARADE		ALBERT ROYDS STREET	ROCHDALE	LANCS		OL16 2UE	01.12.2006	10750	SHOP AND PREMISES	N			N	N	N	N	N


CREATE TABLE table_14 (
  "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_postcode" VARCHAR,
  "liable_from" VARCHAR,
  "rv" BIGINT,
  "property_description" VARCHAR,
  "charity_y_n" VARCHAR,
  "disc" BIGINT,
  "mand" BIGINT,
  "sbrr_y_n" VARCHAR,
  "s44a_y_n" VARCHAR,
  "hardship_y_n" VARCHAR,
  "local_discount" VARCHAR,
  "retail_relief_y_n" VARCHAR
);