Business Rates - Rochdale Borough Council

property_ref Property Ref	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	mandatory_relief Mandatory Relief %	small_business_rate_relief_y_n Small Business Rate Relief Y/n	supporting_small_business Supporting Small Business	expanded_retail_discount Expanded Retail Discount	non_la_nussery_discount Non-LA Nussery Discount
ref:40505393201415	AAA PEST CONTROL SERVICES LTD				AAA PEST CONTROL SERVICES LTD	HENDERSON STREET	LITTLEBOROUGH	LANCS	OL15 8DT	13.02.2017	3250	Workshop and Premises	N		Y	N	N	N
ref:60427600850031	17TH ROCHDALE 1ST WARDLE SCOUTS		WARDLE SCOUT GROUP		RAMSDEN ROAD	WARDLE	ROCHDALE	LANCASHIRE	OL12 9NX	01.04.2005	3500	SCOUT HEADQUARTERS	N	80	N	N	Y	N
ref:15678991008612	1860 GEL LIMITED				UNIT 1B	MOSS MILL INDUSTRIAL ESTATE	ROCHDALE		OL16 5LB	01.12.2016	14000	Warehouse and Premises	N		Y	N	N	N
ref:41774295167058	1ST CONTRACTS GROUP LIMITED		GND FLR 84A		WILLIAM STREET	LITTLEBOROUGH	LANCS		OL15 8JP	04.04.2017	2475	WAREHOUSE AND PREMISES	N		N	N	N	N
ref:40508800410063	1ST CONTRACTS GROUP LTD				84A WILLIAM STREET	LITTLEBOROUGH	LANCASHIRE		OL15 8JP	04.04.2017	11750	OFFICES AND PREMISES	N		N	N	N	N
ref:40511692018232	1ST CONTRACTS GROUP LTD				71A FEATHERSTALL ROAD	LITTLEBOROUGH	LANCS		OL15 8JZ	04.04.2017	10750	OFFICES AND PREMISES	N		N	N	N	N
ref:50337899174416	1ST SAFARI DAY NURSERIES	LIMITED			23 CLIFTON STREET	MILNROW	ROCHDALE	LANCASHIRE	OL16 4HP	01.01.2021	10750	DAY NURSERY AND PREMISES	N		N	N	N	Y
ref:13298X99173117	1ST SAFARI DAY NURSERIES LTD		SUPERTOTS NURSERY		MANCHESTER ROAD	ROCHDALE	LANCASHIRE		OL11 4HJ	01.01.2021	19250	DAY NURSERY AND PREMISES	N		N	N	N	Y
ref:30979794013489	20/20 INDUSTRIES LTD		GF 12 OFFICE THE OLD POLICE	STATION BUSINESS CENTRE	HIND HILL STREET	HEYWOOD	LANCS		OL10 1AQ	01.04.2011	1650	OFFICE	N		Y	N	N	N
ref:22203195848246	258 ONLINE LTD				8 LODGE STREET	MIDDLETON	MANCHESTER		M24 6AL	19.10.2020	5600	SHOP AND PREMISES	N		N	N	Y	N


CREATE TABLE table_15 (
  "property_ref" 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,
  "small_business_rate_relief_y_n" VARCHAR,
  "supporting_small_business" VARCHAR,
  "expanded_retail_discount" VARCHAR,
  "non_la_nussery_discount" VARCHAR
);