Baselight

Business Rates - Rochdale Borough Council

Rochdale Borough Council

@ukgov.business_rates_rochdale_borough_council

Loading...
Loading...

About this Dataset

Business Rates - Rochdale Borough Council

This list includes all business properties liable to non-individuals. The list includes information such as property address, description, ratable value, liable party, empty property information and rate relief. The datasets represent a snapshot in time and will be updated half yearly.
Publisher name: Rochdale Borough Council
Last updated: 2025-03-04T04:00:11Z

Tables

Table 1

@ukgov.business_rates_rochdale_borough_council.table_1
  • 299.88 kB
  • 4,890 rows
  • 22 columns
Loading...
CREATE TABLE table_1 (
  "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" VARCHAR,
  "description" VARCHAR,
  "empty_y_n" VARCHAR,
  "empty_from_date" VARCHAR,
  "discretionary_rate_relief" BIGINT  -- Discretionary Rate Relief %,
  "mandatory_relief" BIGINT  -- Mandatory Relief %,
  "small_busienss_rate_relief_y_n" VARCHAR,
  "empty_exemption_type" VARCHAR,
  "chief_executive_relief_y_n" VARCHAR,
  "retail_hostitality_leisure_relief_y_n" VARCHAR  -- Retail Hostitality & Leisure Relief Y/N,
  "transitional_or_supporting_small_business_relief_y_n" VARCHAR
);

Table 10

@ukgov.business_rates_rochdale_borough_council.table_10
  • 294.28 kB
  • 5,294 rows
  • 22 columns
Loading...
CREATE TABLE table_10 (
  "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,
  "description" VARCHAR,
  "empty_y_n" VARCHAR,
  "empty_from" VARCHAR,
  "discretionary_relief" BIGINT,
  "mandatory_relief" BIGINT,
  "sbrr_y_n" VARCHAR,
  "s44a_y_n" VARCHAR,
  "hardship_y_n" VARCHAR,
  "retail_discount_y_n" VARCHAR,
  "expanded_retail_discount_y_n" VARCHAR
);

Table 11

@ukgov.business_rates_rochdale_borough_council.table_11
  • 315.72 kB
  • 5,976 rows
  • 19 columns
Loading...
CREATE TABLE table_11 (
  "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,
  "description" VARCHAR,
  "empty_y_n" VARCHAR,
  "empty_from" VARCHAR,
  "discretionary_relief" BIGINT  -- Discretionary Relief % %,
  "mandatory_relief" BIGINT  -- Mandatory Relief %,
  "small_business_rate_relief_y_n" VARCHAR,
  "retail_hospitality_and_leisure_relief_y_n" VARCHAR
);

Table 12

@ukgov.business_rates_rochdale_borough_council.table_12
  • 243.9 kB
  • 4,117 rows
  • 27 columns
Loading...
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  -- Charged Amount,
  "rateable_value" BIGINT,
  "property_description" VARCHAR,
  "charity_relief" VARCHAR,
  "discretionary" BIGINT,
  "mandatory" BIGINT,
  "rural_relief" VARCHAR,
  "discretionary_ca41a5" BIGINT  -- Discretionary,
  "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
);

Table 13

@ukgov.business_rates_rochdale_borough_council.table_13
  • 268.8 kB
  • 4,159 rows
  • 22 columns
Loading...
CREATE TABLE table_13 (
  "property_ref" VARCHAR,
  "liable_name_1" 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,
  "vo_code" VARCHAR,
  "property_description" VARCHAR,
  "empty" VARCHAR,
  "empty_from" VARCHAR,
  "charity" VARCHAR,
  "disc" BIGINT,
  "mand" BIGINT,
  "sbrr" VARCHAR,
  "s44a" VARCHAR,
  "local_discount" VARCHAR,
  "occupied" VARCHAR
);

Table 14

@ukgov.business_rates_rochdale_borough_council.table_14
  • 234.68 kB
  • 4,353 rows
  • 21 columns
Loading...
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  -- Disc %,
  "mand" BIGINT  -- Mand %,
  "sbrr_y_n" VARCHAR,
  "s44a_y_n" VARCHAR,
  "hardship_y_n" VARCHAR,
  "local_discount" VARCHAR,
  "retail_relief_y_n" VARCHAR
);

Table 15

@ukgov.business_rates_rochdale_borough_council.table_15
  • 304.44 kB
  • 5,334 rows
  • 21 columns
Loading...
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  -- Discretionary Relief %,
  "mandatory_relief" BIGINT  -- Mandatory Relief %,
  "small_business_rate_relief_y_n" VARCHAR,
  "supporting_small_business" VARCHAR,
  "expanded_retail_discount" VARCHAR,
  "non_la_nussery_discount" VARCHAR
);

Table 16

@ukgov.business_rates_rochdale_borough_council.table_16
  • 271.27 kB
  • 4,240 rows
  • 20 columns
Loading...
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
);

Table 17

@ukgov.business_rates_rochdale_borough_council.table_17
  • 320.04 kB
  • 5,869 rows
  • 21 columns
Loading...
CREATE TABLE table_17 (
  "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,
  "description" VARCHAR,
  "empty_y_n" VARCHAR,
  "empty_from" VARCHAR,
  "discretionary_relief" BIGINT  -- Discretionary Relief %,
  "mandatory_relief" BIGINT  -- Mandatory Relief %,
  "small_business_rate_relief_y_n" VARCHAR,
  "supporting_small_business_relief_y_n" VARCHAR,
  "expanded_retail_discount_relief_y_n" VARCHAR,
  "non_la_nursery_discount_y_n" VARCHAR
);

Table 18

@ukgov.business_rates_rochdale_borough_council.table_18
  • 232.61 kB
  • 4,273 rows
  • 20 columns
Loading...
CREATE TABLE table_18 (
  "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,
  "charity" VARCHAR,
  "disc" BIGINT,
  "mand" BIGINT,
  "sbrr" VARCHAR,
  "s44a" VARCHAR,
  "s49" VARCHAR,
  "local_discount" VARCHAR
);

Table 2

@ukgov.business_rates_rochdale_borough_council.table_2
  • 296.11 kB
  • 5,306 rows
  • 22 columns
Loading...
CREATE TABLE table_2 (
  "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" DOUBLE,
  "description" VARCHAR,
  "empty_y_n" VARCHAR,
  "empty_from" VARCHAR,
  "discretionary_relief" DOUBLE  -- Discretionary Relief % %,
  "mandatory_relief" DOUBLE  -- Mandatory Relief %,
  "sbrr_y_n" VARCHAR,
  "s44a_y_n" VARCHAR,
  "hardship_y_n" VARCHAR,
  "local_discount_y_n" VARCHAR,
  "retail" VARCHAR
);

Table 3

@ukgov.business_rates_rochdale_borough_council.table_3
  • 307.49 kB
  • 6,211 rows
  • 20 columns
Loading...
CREATE TABLE table_3 (
  "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  -- Discretionary Relief %,
  "mandatory_relief" BIGINT  -- Mandatory Relief %,
  "small_business_rate_relief_y_n" VARCHAR,
  "supporting_small_business_relief_y_n" VARCHAR,
  "retail_hospitality_and_leisure_relief_y_n" VARCHAR
);

Table 4

@ukgov.business_rates_rochdale_borough_council.table_4
  • 252.29 kB
  • 4,278 rows
  • 24 columns
Loading...
CREATE TABLE table_4 (
  "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,
  "vo_code" VARCHAR,
  "property_description" VARCHAR,
  "empty" VARCHAR,
  "empty_from" VARCHAR,
  "charity" VARCHAR,
  "disc" BIGINT,
  "mand" BIGINT,
  "sbrr" VARCHAR,
  "s44a" VARCHAR,
  "s49" VARCHAR,
  "local_discount" VARCHAR,
  "occupied" VARCHAR
);

Table 5

@ukgov.business_rates_rochdale_borough_council.table_5
  • 232.79 kB
  • 4,138 rows
  • 19 columns
Loading...
CREATE TABLE table_5 (
  "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_2010" BIGINT,
  "property_description" VARCHAR,
  "empty" VARCHAR,
  "empty_from" VARCHAR,
  "charity" VARCHAR,
  "disc" BIGINT,
  "mand" BIGINT,
  "occupied" VARCHAR
);

Table 6

@ukgov.business_rates_rochdale_borough_council.table_6
  • 238.78 kB
  • 4,116 rows
  • 20 columns
Loading...
CREATE TABLE table_6 (
  "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_2010" BIGINT,
  "property_description" VARCHAR,
  "empty" VARCHAR,
  "empty_from" VARCHAR,
  "charity" VARCHAR,
  "disc" BIGINT,
  "mand" BIGINT,
  "sbrr" VARCHAR,
  "occupied" VARCHAR
);

Table 7

@ukgov.business_rates_rochdale_borough_council.table_7
  • 261.01 kB
  • 4,107 rows
  • 20 columns
Loading...
CREATE TABLE table_7 (
  "property_ref" VARCHAR,
  "rate_payer" 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_2010" BIGINT,
  "property_description" VARCHAR,
  "empty" VARCHAR,
  "empty_from" VARCHAR,
  "charity" VARCHAR,
  "discretionary_relief" BIGINT  -- Discretionary Relief %,
  "mandatory_relief" BIGINT  -- Mandatory Relief %,
  "small_business_rate_relief" VARCHAR,
  "retail_relief" VARCHAR,
  "occupied" VARCHAR
);

Table 8

@ukgov.business_rates_rochdale_borough_council.table_8
  • 301.48 kB
  • 6,042 rows
  • 19 columns
Loading...
CREATE TABLE table_8 (
  "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,
  "description" VARCHAR,
  "empty_y_n" VARCHAR,
  "empty_from" VARCHAR,
  "discretionary_relief" BIGINT  -- Discretionary Relief %,
  "mandatory_relief" BIGINT  -- Mandatory Relief %,
  "small_business_rate_relief_y_n" VARCHAR,
  "retail_hospitality_and_leisure_relief_y_n" VARCHAR
);

Table 9

@ukgov.business_rates_rochdale_borough_council.table_9
  • 305.86 kB
  • 6,209 rows
  • 19 columns
Loading...
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  -- Discretionary Relief %,
  "mandatory_relief" BIGINT  -- Mandatory Relief %,
  "small_business_rate_relief_y_n" VARCHAR,
  "retail_hospitality_and_leisure_relief_y_n" VARCHAR
);

Share link

Anyone who has the link will be able to view this.