Baselight

Business Rates

Stockport Metropolitan Borough Council

@ukgov.stockport_council_business_rates

Loading...
Loading...

About this Dataset

Business Rates

All Business rates excluding void properties in Stockport.
Publisher name: Stockport Metropolitan Borough Council
Last updated: 2025-04-18T04:02:50Z

Tables

All Business Rates (excluding Void Properties)

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties
  • 404.81 kB
  • 5,970 rows
  • 26 columns
Loading...
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
);

All Business Rates Excluding Void Properties April 2021

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_april_2021
  • 421 kB
  • 6,115 rows
  • 26 columns
Loading...
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
);

All Business Rates (excluding Void Properties) - April 2022

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_april_2022
  • 470.37 kB
  • 6,400 rows
  • 26 columns
Loading...
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
);

All Business Rates (excluding Void Properties) - April 2023

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_april_2023
  • 448.91 kB
  • 6,472 rows
  • 26 columns
Loading...
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
);

All Business Rates (excluding Void Properties) - April 2025

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_april_2025
  • 474.54 kB
  • 6,485 rows
  • 26 columns
Loading...
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
);

All Business Rates Excluding Void Properties January 2021

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_january_2021
  • 441.67 kB
  • 6,213 rows
  • 26 columns
Loading...
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
);

All Business Rates (excluding Void Properties) - January 2022

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_january_2022
  • 438.86 kB
  • 6,359 rows
  • 26 columns
Loading...
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
);

All Business Rates (excluding Void Properties) - January 2023

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_january_2023
  • 474.32 kB
  • 6,459 rows
  • 26 columns
Loading...
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
);

All Business Rates (excluding Void Properties) - January 2024

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_january_2024
  • 451.21 kB
  • 6,467 rows
  • 26 columns
Loading...
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
);

All Business Rates (excluding Void Properties) - January 2025

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_january_2025
  • 453.37 kB
  • 6,520 rows
  • 26 columns
Loading...
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
);

All Business Rates Excluding Void Properties - July 2020

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_july_2020
  • 425.94 kB
  • 6,307 rows
  • 26 columns
Loading...
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
);

All Business Rates (excluding Void Properties) - July 2023

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_july_2023
  • 448.44 kB
  • 6,506 rows
  • 26 columns
Loading...
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
);

All Business Rates (excluding Void Properties) - July 2024

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_july_2024
  • 489.14 kB
  • 6,553 rows
  • 26 columns
Loading...
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
);

All Business Rates Excluding Void Properties May 2021

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_may_2021
  • 445.93 kB
  • 6,290 rows
  • 26 columns
Loading...
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
);

All Business Rates Excluding Void Properties - October 2020

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_october_2020
  • 426.29 kB
  • 6,226 rows
  • 26 columns
Loading...
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
);

All Business Rates (excluding Void Properties) - October 2021

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_october_2021
  • 435.83 kB
  • 6,314 rows
  • 26 columns
Loading...
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
);

All Business Rates (excluding Void Properties) - October 2022

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_october_2022
  • 439.27 kB
  • 6,424 rows
  • 26 columns
Loading...
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
);

All Business Rates (excluding Void Properties) - October 2023

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_october_2023
  • 451.4 kB
  • 6,495 rows
  • 26 columns
Loading...
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
);

All Business Rates (excluding Void Properties) - October 2024

@ukgov.stockport_council_business_rates.all_business_rates_excluding_void_properties_october_2024
  • 453.89 kB
  • 6,522 rows
  • 26 columns
Loading...
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
);

Business Rates

@ukgov.stockport_council_business_rates.business_rates
  • 423.91 kB
  • 5,839 rows
  • 26 columns
Loading...
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
);

Share link

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