Business Rates - Rochdale Borough Council

property_reference Property Reference	account_holder_1 Account Holder 1	account_holder_2 Account Holder 2	liability_start_date Liability Start Date	property_name_1 Property Name 1	property_address_1 Property Address 1	property_address_2 Property Address 2	property_address_3 Property Address 3	property_address_4 Property Address 4	post_code Post Code	n__charged_amount Charged Amount	rateable_value Rateable Value	property_description Property Description	charity_relief Charity Relief	mandatory Mandatory	small_business_rate_relief Small Business Rate Relief	empty_relief Empty Relief
1.00E+13	MMA NORTHWEST LTD		01.09.2014		UNIT 3 CLAY COURT BUILDINGS	CRAWFORD STREET	ROCHDALE		OL16 5RS	Ł1,290.67	8000	Workshop and Premises			Y
1003708165442A	ROYAL MAIL GROUP PLC		01.04.2005	PROGRESS HOUSE	AINSWORTH STREET	ROCHDALE	LANCASHIRE		OL16 1AA	Ł53,179.00	107000	WAREHOUSE AND PREMISES
1.00E+13	SHOE DIRECTORY LTD		01.07.2014	C C G WINDSCREENS LTD	AINSWORTH STREET	ROCHDALE	LANCS		OL16 5QX	Ł8,228.00	17000	WAREHOUSE AND PREMISES
1.01E+13	INPOST UK LIMITED		03.10.2014		INPOST PARCEL LOCKER UKROC16346	ALBERT ROYDS STREET	ROCHDALE		OL16 5AA	Ł363.00	750	SITE OF ELECTRONIC DELIVERY LOCKERS & PREMISES
1.01E+13	FABTRAD LTD		27.03.2015	H YEARSLEY LTD	ALBERT ROYDS STREET	ROCHDALE	LANCASHIRE		OL16 5AA	Ł39,760.00	80000	COLD STORE AND PREMISES				Y
1.01E+13	CO-OPERATIVE GROUP LTD		01.04.2010		UNIT 1 MAYFIELD PARADE	ALBERT ROYDS STREET	ROCHDALE		OL16 2UE	Ł21,992.25	44250	Shop and Premises
1.01E+13	CO-OPERATIVE GROUP LTD		01.04.2010		ATM SITE AT	UNIT 1 MAYFIELD PARADE	ALBERT ROYDS STREET	ROCHDALE	OL16 2UE	Ł2,855.60	5900	Site of ATM
1.01E+13	THE ST VINCENT DE PAUL SOCIETY	(ENGLAND AND WALES)	01.11.2013	UNIT 5 MAYFIELD PARADE	ALBERT ROYDS STREET	ROCHDALE	LANCS		OL16 2UE	Ł1,689.80	17000	SHOP AND PREMISES	Y	80
1.01E+13	GLAMORGAN RETAIL LIMITED		30.08.2012	UNIT 3 MAYFIELD PARADE	ALBERT ROYDS STREET	ROCHDALE	LANCS		OL16 2UE	Ł8,946.00	18000	SHOP AND PREMISES
1.01E+13	TOTE BOOKMAKERS LTD		01.12.2006	UNIT 2 MAYFIELD PARADE	ALBERT ROYDS STREET	ROCHDALE	LANCS		OL16 2UE	Ł7,865.00	16250	SHOP AND PREMISES


CREATE TABLE table_12 (
  "property_reference" VARCHAR,
  "account_holder_1" VARCHAR,
  "account_holder_2" VARCHAR,
  "liability_start_date" 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,
  "post_code" VARCHAR,
  "n__charged_amount" VARCHAR,
  "rateable_value" BIGINT,
  "property_description" VARCHAR,
  "charity_relief" VARCHAR,
  "discretionary" BIGINT,
  "mandatory" BIGINT,
  "rural_relief" VARCHAR,
  "discretionary_ca41a5" BIGINT,
  "mandatory_1" BIGINT,
  "small_business_rate_relief" VARCHAR,
  "exemption" VARCHAR,
  "empty_relief" VARCHAR,
  "part_occupation_relief" VARCHAR,
  "hardship_relief" VARCHAR,
  "retail_relief" VARCHAR,
  "occupied_relief" VARCHAR
);