Business Rates
Stockport Metropolitan Borough Council
@ukgov.stockport_council_business_rates
Stockport Metropolitan Borough Council
@ukgov.stockport_council_business_rates
All Business rates excluding void properties in Stockport.
Publisher name: Stockport Metropolitan Borough Council
Last updated: 2025-04-18T04:02:50Z
CREATE TABLE all_business_rates_excluding_void_properties (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_april_2021 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_april_2022 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_april_2023 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_april_2025 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_january_2021 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_january_2022 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_january_2023 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_january_2024 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_january_2025 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_july_2020 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_july_2023 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_july_2024 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_may_2021 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_october_2020 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_october_2021 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_october_2022 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_october_2023 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE all_business_rates_excluding_void_properties_october_2024 (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" DOUBLE,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);CREATE TABLE business_rates (
"placeref" BIGINT,
"propdesc" VARCHAR,
"rateableval" BIGINT,
"accountname" VARCHAR,
"liabstart" TIMESTAMP,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"address4" VARCHAR,
"address5" VARCHAR,
"postcode" VARCHAR,
"mandrlfcd" VARCHAR,
"discrlfcd" VARCHAR,
"addrlfcd" VARCHAR,
"mandrlf" DOUBLE,
"discrlf" DOUBLE,
"additionalrlf" BIGINT,
"sbrrlf" DOUBLE,
"trdisc_ssbcd" VARCHAR,
"trdisc_ssbamt" DOUBLE
);Anyone who has the link will be able to view this.