Business Rates
Stockport Metropolitan Borough Council
@ukgov.stockport_council_business_rates
Stockport Metropolitan Borough Council
@ukgov.stockport_council_business_rates
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.