Business Rates - Rochdale Borough Council

rp_type RP Type	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	empty_y_n Empty Y/N	mandatory_relief Mandatory Relief %	small_business_rate_relief_y_n Small Business Rate Relief Y/N	retail_hospitality_and_leisure_relief_y_n Retail Hospitality And Leisure Relief Y/N
C	Ref: 12416X99146812	RIGHT START DAY NURSERIES LTD		AUNT MARYS STONE HOUSE		HEALEY DELL	ROCHDALE	LANCASHIRE		OL12 6BG	01.04.2017	25000	N		N	N
C	Ref: 201035002420X9	HOLLAND & BARRETT RETAIL LTD T/A	HOLLAND & BARRETT	UNIT 27G MIDDLETON SHOPPING	CENTRE	MIDDLETON	MANCHESTER			M24 4EL	01.04.2017	18500	N		N	N
C	Ref: 11924095359020	TRANSSWIFT FREIGHT SERVICES LTD		UNITS 9 & 10 AT		SCOTT INDUSTRIAL PARK	ROCHDALE	LANCS		OL16 5NA	01.04.2017	19750	N		N	N
C	Ref: 14264593120163	SHELL UK LTD		SHELL EAGLE		QUEENSWAY	ROCHDALE	LANCASHIRE		OL11 2TJ	01.04.2017	102000	N		N	N
C	Ref: 32095996621359	ROCHDALE BOROUGHWIDE CULTURAL	TRUST T/A YOUR TRUST	HEYWOOD SPORTS VILLAGE		WEST STARKEY STREET	HEYWOOD	LANCS		OL10 4TW	01.04.2017	377500	N	80	N	N
C	Ref: 13592200100057	CLEAR CHANNEL (UK) LTD		MAIDEN	42-44	MILNROW ROAD	ROCHDALE	LANCASHIRE		OL16 1UD	01.04.2017	28250	N		N	N
C	Ref: 30763897131163	TRUST DISTRIBUTION LTD		TRUST DISTRIBUTION		PHOENIX CLOSE INDUSTRIAL ESTATE	PARK STREET	HEYWOOD	LANCS	OL10 2AB	01.04.2017	97500	N		N	N
C	Ref: 10277700010082	RUMMA CONSULTING LTD				2 BAILLIE STREET	ROCHDALE	LANCASHIRE		OL16 1JG	01.04.2017	18500	N		N	Y
C	Ref: 31216397428164	HAMILTON LOGISTICS (MANCHESTER)	LTD			1B MARKET STREET	HEYWOOD	LANCS		OL10 1HT	01.04.2017	7200	N		Y	N
C	Ref: 14644096457736	ZEN INTERNET LIMITED		zen internet fibre optics	telecoms network in northern eng	SANDBROOK WAY	ROCHDALE	LANCS		OL11 1RY	01.04.2017	6000	N		N	N


CREATE TABLE table_9 (
  "rp_type" VARCHAR,
  "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,
  "empty_y_n" VARCHAR,
  "empty_from" VARCHAR,
  "discretionary_relief" BIGINT,
  "mandatory_relief" BIGINT,
  "small_business_rate_relief_y_n" VARCHAR,
  "retail_hospitality_and_leisure_relief_y_n" VARCHAR
);