Business Rates - Rochdale Borough Council

property_ref Property Ref	liable_name_1 Liable Name 1	start_of_liability Start Of Liability	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	rateable_value_2017 Rateable Value 2017	property_description Property Description	empty Empty	empty_from Empty From	charity Charity	mand Mand	sbrr SBRR
Ref: 1142879539411	TELEFONICA UK LIMITED	01.04.2005	MM02 SITE REF 18218 OFF		DELL ROAD	ROCHDALE	LANCASHIRE		OL12 6BZ	6600	COMMUNICATION STATION AND PREMISES
Ref: 1153129644056	NEWBARN LTD	12.06.2012	SUITE 6		169 DRAKE STREET	ROCHDALE	LANCASHIRE		OL11 1EF	3050	OFFICE AND PREMISES
Ref: 1154695101035	MOBILE BROADBAND NETWORK LTD	20.01.2009	HUTCHISON 3G UK SITE REF		OL0042 ON ROOF OF DUKE STREET MILL	DUKE STREET	ROCHDALE	LANCASHIRE	OL12 0LT	12750	COMMUNICATION STATION AND PREMISES
Ref: 1334989746580	MARS REAL ESTATE INVESTMENT B.V.	27.10.2013	STALL 24 ROCHDALE MARKET HALL		THE MARKET	ROCHDALE			OL16 1EB	2025	MARKET STALL AND PREMISES	Y	27.10.2013
Ref: 1457695722557	VODAFONE LTD	01.04.2005	VODAFONE SITE REF 13134A AT		SANDHOLE FARM RUSKIN ROAD	ROCHDALE	LANCASHIRE		OL11 2RE	7200	COMMUNICATION STATION AND PREMISES
Ref: 1462393496713	MOBILE BROADBAND NETWORK LTD	01.04.2010			T-MOBILE (52059)	HOLLANDS FARM	ROOLEY MOOR ROAD	ROCHDALE	OL12 6BN	5700	COMMUNICATION STATION AND PREMISES
Ref: 3081115475731	JOHN LLOYD (HEYWOOD) LTD	07.04.2005	GND FLR LONGFORD HOUSE		HALL STREET	HEYWOOD	LANCASHIRE		OL10 1DP	14000	OFFICES AND PREMISES
Ref: 3192439832987	INDEPENDENT POWER NETWORKS LTD	01.04.2015	INDPENDENT DISTRIBUTION NETWORK	OPERATOR	SUTHERLAND ROAD	ROCHDALE			OL10 3PN	570	INDEPENDENT DISTRIBUTION NETWORK OPERATOR
Ref: 3223691949985	FAMILY DOCTOR ASSOC	18.04.2006			9 YORK STREET	HEYWOOD	LANCASHIRE		OL10 4NN	4850	OFFICES AND PREMISES			Y	80
Ref: 4459590421812	ENTERPRISE HARDWARE LTD	01.08.2016			7C CALDERSHAW INDUSTRIAL ESTATE	ROOLEY MOOR ROAD	ROCHDALE		OL12 7LQ	7000	WAREHOUSE AND PREMISES					Y


CREATE TABLE table_16 (
  "property_ref" VARCHAR,
  "liable_name_1" VARCHAR,
  "liable_name_2" VARCHAR,
  "start_of_liability" 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,
  "rateable_value_2017" BIGINT,
  "property_description" VARCHAR,
  "empty" VARCHAR,
  "empty_from" VARCHAR,
  "charity" VARCHAR,
  "disc" BIGINT,
  "mand" BIGINT,
  "sbrr" VARCHAR,
  "s44a" VARCHAR
);