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
  • 395.32 KB
  • 5970 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
  • 411.14 KB
  • 6115 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
  • 459.34 KB
  • 6400 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
  • 438.39 KB
  • 6472 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
  • 463.42 KB
  • 6485 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
  • 431.32 KB
  • 6213 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
  • 428.57 KB
  • 6359 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
  • 463.2 KB
  • 6459 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
  • 440.63 KB
  • 6467 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
  • 442.74 KB
  • 6520 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
  • 415.96 KB
  • 6307 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
  • 437.93 KB
  • 6506 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
  • 477.68 KB
  • 6553 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
  • 435.48 KB
  • 6290 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
  • 416.3 KB
  • 6226 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
  • 425.62 KB
  • 6314 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
  • 428.98 KB
  • 6424 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
  • 440.82 KB
  • 6495 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
  • 443.25 KB
  • 6522 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
  • 413.97 KB
  • 5839 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.