Baselight
Sign In

Business Rates

Leeds City Council

@ukgov.business_rates

Loading...
Loading...

About this Dataset

Business Rates

Information on all business who pay business rates in Leeds. Information includes business name, rateable value and full postal address. For a visualisation of the information contained in this data set please visit ODI Leeds Information ----------- * Individuals who are registered and work from their home address have been removed for data protection purposes. * After Friday 27th October 2017, the business rates dataset will be updated quarterly. Blog ---- * Check out this blog written by strategist Edafe Onerhime. Edafe does not work for Leeds City Council and the comments contained in the blog are her views: * http://ekoner.com/2015/05/06/the-missing-guide-to-leeds-business-rates-open-data/
Publisher name: Leeds City Council
Last updated: 2024-09-14T10:06:15Z

Tables

01/09/2016

@ukgov.business_rates.n_01_09_2016
  • 967.71 kB
  • 20,233 rows
  • 20 columns
Loading... 
CREATE TABLE n_01_09_2016 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatory_relief" VARCHAR  -- Mandatory Relief %,
  "discretionary_relief" DOUBLE  -- Discretionary Relief %,
  "small_business_rate_relief" DOUBLE  -- Small Business Rate Relief %,
  "local_discount_2016_17" DOUBLE,
  "property_status" VARCHAR,
  "exempt_empty" VARCHAR,
  "empty_from" TIMESTAMP,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "rateable_value" BIGINT,
  "description_code" VARCHAR,
  "property_description" VARCHAR,
  "billing_authority_reference" BIGINT,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19
);

01/10/2018

@ukgov.business_rates.n_01_10_2018
  • 1.12 MB
  • 21,846 rows
  • 19 columns
Loading... 
CREATE TABLE n_01_10_2018 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandaory_relief" DOUBLE  -- Mandaory Relief (%)+,
  "discretionay_relief" DOUBLE  -- Discretionay Relief (%),
  "sbrr_percent" DOUBLE,
  "transitional_relief" VARCHAR,
  "transitional_premium" VARCHAR,
  "net_local_discount" VARCHAR,
  "propery_status" VARCHAR,
  "empty_from" TIMESTAMP,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "voa_description_code" VARCHAR,
  "description" VARCHAR,
  "rateable_value" BIGINT,
  "ba_referencenumber" BIGINT
);

02/03/2015

@ukgov.business_rates.n_02_03_2015
  • 906.42 kB
  • 19,438 rows
  • 19 columns
Loading... 
CREATE TABLE n_02_03_2015 (
  "ratepayer" VARCHAR,
  "billing_authority_reference" BIGINT,
  "liable_from" TIMESTAMP,
  "rateable_value" VARCHAR,
  "mandatory_relief" BIGINT  -- Mandatory Relief (%),
  "discretionary_relief" BIGINT  -- Discretionary Relief (%),
  "small_business_rate_relief" DOUBLE  -- Small Business Rate Relief (%),
  "retail_relief" VARCHAR,
  "address" VARCHAR,
  "address_2" VARCHAR,
  "address_3" VARCHAR,
  "address_4" VARCHAR,
  "postcode" VARCHAR,
  "empty_property" VARCHAR,
  "empty_from" TIMESTAMP,
  "empty_exemption_type" VARCHAR,
  "property_description_code" VARCHAR,
  "property_description" VARCHAR,
  "unnamed_18" VARCHAR  -- Unnamed: 18
);

02/04/2014

@ukgov.business_rates.n_02_04_2014
  • 911.87 kB
  • 19,306 rows
  • 17 columns
Loading... 
CREATE TABLE n_02_04_2014 (
  "account_holder1" VARCHAR,
  "liable_from" TIMESTAMP,
  "rateable_value" BIGINT,
  "n__mandatory_relief" BIGINT  -- % Mandatory Relief,
  "n__discretionary_relief" BIGINT  -- % Discretionary Relief,
  "n__small_business_rate_relief" BIGINT  -- % Small Business Rate Relief,
  "empty_property" VARCHAR,
  "empty_from" TIMESTAMP,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "exemption_reason" VARCHAR,
  "description_code" VARCHAR,
  "property_description" VARCHAR,
  "property_reference" BIGINT
);

03/07/2018

@ukgov.business_rates.n_03_07_2018
  • 1.04 MB
  • 21,669 rows
  • 20 columns
Loading... 
CREATE TABLE n_03_07_2018 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatoty_relief" BIGINT  -- Mandatoty Relief (%),
  "discretionary_relief" BIGINT  -- Discretionary Relief (%),
  "small_business_rate_relief" DOUBLE  -- Small Business Rate Relief (%),
  "transitional_relief" VARCHAR  -- Transitional Relief (£),
  "transitional_premium" VARCHAR  -- Transitional Premium (£),
  "local_discount" VARCHAR  -- Local Discount (£),
  "occupation_status" VARCHAR,
  "exempty_empty_rates" VARCHAR,
  "empty_from" TIMESTAMP,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "description_code" VARCHAR,
  "description" VARCHAR,
  "rateable_value" BIGINT  -- Rateable Value (£),
  "b_a_reference" BIGINT
);

04/11/2016

@ukgov.business_rates.n_04_11_2016
  • 1.03 MB
  • 20,311 rows
  • 18 columns
Loading... 
CREATE TABLE n_04_11_2016 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatory_relief" VARCHAR  -- Mandatory Relief %,
  "discretionary_relief" VARCHAR  -- Discretionary Relief %,
  "small_business_relief" VARCHAR  -- Small Business Relief %,
  "local_discount" VARCHAR  -- Local Discount (£),
  "property_status" VARCHAR,
  "exempt_epr" VARCHAR,
  "empty_from" TIMESTAMP,
  "addr1" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "rateable_value" BIGINT,
  "description_code" VARCHAR,
  "description" VARCHAR,
  "b_a_reference" BIGINT
);

05/02/2021

@ukgov.business_rates.n_05_02_2021
  • 1.65 MB
  • 22,989 rows
  • 22 columns
Loading... 
CREATE TABLE n_05_02_2021 (
  "uprn" DOUBLE,
  "b_a_reference" BIGINT,
  "account_holder1" VARCHAR,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "emptty_property" VARCHAR,
  "empty_from" TIMESTAMP,
  "liable_from" TIMESTAMP,
  "rv" BIGINT,
  "vo_prop_desc_code" VARCHAR,
  "vo_propdescrip" VARCHAR,
  "exempt_epr" VARCHAR,
  "exemption_type" VARCHAR,
  "mand_relief" VARCHAR,
  "disc_relief" VARCHAR,
  "sbrr_relief" VARCHAR,
  "net_local_disc" VARCHAR,
  "field18" BIGINT,
  "field19" DOUBLE,
  "field20" DOUBLE,
  "field21" VARCHAR,
  "field0" BIGINT
);

06/01/2017

@ukgov.business_rates.n_06_01_2017
  • 978.41 kB
  • 20,546 rows
  • 19 columns
Loading... 
CREATE TABLE n_06_01_2017 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatory_relief" DOUBLE  -- Mandatory Relief %,
  "discretionary_relief" DOUBLE  -- Discretionary Relief %,
  "small_business_relief" DOUBLE  -- Small Business Relief %,
  "local_discount" VARCHAR  -- Local Discount (È),
  "property_status" VARCHAR,
  "exempt_epr" VARCHAR,
  "empty_from" TIMESTAMP,
  "addr1" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "n_2010_rateable_value" BIGINT  -- 2010 Rateable Value,
  "n_2017_rateable_value" BIGINT  -- 2017 Rateable Value,
  "description_code" VARCHAR,
  "description" VARCHAR,
  "b_a_reference" BIGINT
);

06/11/2015

@ukgov.business_rates.n_06_11_2015
  • 916.53 kB
  • 19,594 rows
  • 19 columns
Loading... 
CREATE TABLE n_06_11_2015 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "rateable_value" BIGINT,
  "mandatory_relief" BIGINT  -- Mandatory Relief %,
  "discretionary_relief" BIGINT  -- Discretionary Relief %,
  "small_business_rate_relief" DOUBLE  -- Small Business Rate Relief %,
  "retail_relief" DOUBLE  -- Retail Relief (Ł),
  "local_discount" DOUBLE  -- Local Discount (Ł),
  "empty_property" VARCHAR,
  "exempt_empty_property_rates" VARCHAR,
  "empty_from" TIMESTAMP,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "description_code" VARCHAR,
  "description" VARCHAR,
  "property_reference" BIGINT
);

07/01/2020

@ukgov.business_rates.n_07_01_2020
  • 1.19 MB
  • 22,710 rows
  • 19 columns
Loading... 
CREATE TABLE n_07_01_2020 (
  "property_reference_number" DOUBLE,
  "ba_reference_number" DOUBLE,
  "ratepayer" VARCHAR,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "occupied" VARCHAR,
  "liability_start_date" TIMESTAMP,
  "empty_from" TIMESTAMP,
  "rateable_value" BIGINT,
  "voa_code" VARCHAR,
  "voa_description" VARCHAR,
  "exemption" VARCHAR,
  "exempt_from" TIMESTAMP,
  "relief_types" VARCHAR,
  "relief_total" DOUBLE,
  "relief_mandatory" DOUBLE,
  "relief_discretionary" DOUBLE
);

07/03/2016

@ukgov.business_rates.n_07_03_2016
  • 997.36 kB
  • 19,853 rows
  • 21 columns
Loading... 
CREATE TABLE n_07_03_2016 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatory_relief" DOUBLE  -- Mandatory Relief %,
  "discretionary_relief" DOUBLE  -- Discretionary Relief %,
  "small_business_rate_relief" DOUBLE  -- Small Business Rate Relief %,
  "local_discount_2016_17" VARCHAR,
  "discount_type" VARCHAR,
  "property_status" VARCHAR,
  "exempt_empty" VARCHAR,
  "empty_from" TIMESTAMP,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "rateable_value" VARCHAR,
  "description_code" VARCHAR,
  "property_description" VARCHAR,
  "billing_authority_reference" DOUBLE,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20
);

08/10/2014

@ukgov.business_rates.n_08_10_2014
  • 906.01 kB
  • 19,890 rows
  • 17 columns
Loading... 
CREATE TABLE n_08_10_2014 (
  "ratepayer" VARCHAR,
  "b_a_reference" DOUBLE,
  "rateable_value" DOUBLE,
  "empty" VARCHAR  -- Empty ?,
  "mandatory_relief_percent" DOUBLE,
  "discretionary_relief_percentage" DOUBLE,
  "small_business_rate_percentage" DOUBLE,
  "charged_from" TIMESTAMP,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "empty_from" TIMESTAMP,
  "exemption_type" VARCHAR,
  "vo_property_description_code" VARCHAR,
  "description" VARCHAR
);

09/12/2014

@ukgov.business_rates.n_09_12_2014
  • 941.35 kB
  • 19,897 rows
  • 19 columns
Loading... 
CREATE TABLE n_09_12_2014 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "rateable_value" VARCHAR,
  "mandatory_relief" DOUBLE  -- Mandatory Relief %,
  "discretionary_relief" DOUBLE  -- Discretionary Relief %,
  "small_business_rate_relief" DOUBLE  -- Small Business Rate Relief %,
  "retail_relief" VARCHAR,
  "empty_property" VARCHAR,
  "exempt_empty_rates" VARCHAR,
  "exemption_type" VARCHAR,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "empty_from" TIMESTAMP,
  "description_code" VARCHAR,
  "description" VARCHAR,
  "property_reference" BIGINT
);

10/05/2016

@ukgov.business_rates.n_10_05_2016
  • 787.04 kB
  • 19,985 rows
  • 18 columns
Loading... 
CREATE TABLE n_10_05_2016 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatory_relief" DOUBLE  -- Mandatory Relief (%),
  "discretionary_relief" DOUBLE  -- Discretionary Relief (%),
  "small_business_rare_relief" DOUBLE  -- Small Business Rare Relief (%),
  "local_discount" VARCHAR,
  "local_discount_type" VARCHAR,
  "property_status" VARCHAR,
  "exempt_empty_rates" VARCHAR,
  "addr1" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "empty_from" TIMESTAMP,
  "rateable_value" BIGINT,
  "description_code" VARCHAR,
  "description" VARCHAR
);

10/06/2021

@ukgov.business_rates.n_10_06_2021
  • 1.22 MB
  • 23,011 rows
  • 18 columns
Loading... 
CREATE TABLE n_10_06_2021 (
  "n_2_23258e_12" DOUBLE  -- 2.23258E+12,
  "billing_authority_reference" DOUBLE,
  "ratepayer" VARCHAR,
  "property_address" VARCHAR,
  "postcode" VARCHAR,
  "empty_property" VARCHAR,
  "empty_from" TIMESTAMP,
  "liable_from" TIMESTAMP,
  "rateable_value" BIGINT,
  "description_code" VARCHAR,
  "description" VARCHAR,
  "empty_exempt" VARCHAR,
  "exemption_type" VARCHAR,
  "mandatory_rate_relief" DOUBLE,
  "discretioinary_rate_relief" DOUBLE,
  "small_business_rate_relief" DOUBLE,
  "local_discount" DOUBLE,
  "discount_type" VARCHAR
);

11/09/2015

@ukgov.business_rates.n_11_09_2015
  • 919.7 kB
  • 19,580 rows
  • 19 columns
Loading... 
CREATE TABLE n_11_09_2015 (
  "account_holder1" VARCHAR,
  "liable_from" TIMESTAMP,
  "rateable_value" DOUBLE,
  "mandatory_relief" DOUBLE  -- Mandatory Relief (%),
  "discretionary_relief" DOUBLE  -- Discretionary Relief (%),
  "small_business_rate_relief" DOUBLE  -- Small Business Rate Relief (%),
  "retail_relief" VARCHAR  -- Retail Relief (£),
  "local_discount" VARCHAR  -- Local Discount (£),
  "empty_property" VARCHAR  -- Empty Property?,
  "exempt_empty" VARCHAR  -- Exempt Empty?,
  "empty_from" TIMESTAMP,
  "address_1" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "voa_description_code" VARCHAR,
  "description" VARCHAR,
  "b_a_reference" DOUBLE
);

13/04/2018

@ukgov.business_rates.n_13_04_2018
  • 1.08 MB
  • 21,392 rows
  • 20 columns
Loading... 
CREATE TABLE n_13_04_2018 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatoty_relief" VARCHAR  -- Mandatoty Relief (%),
  "discretionary_relief" VARCHAR  -- Discretionary Relief (%),
  "small_business_rate_relief" VARCHAR  -- Small Business Rate Relief (%),
  "transitional_relief" VARCHAR  -- Transitional Relief (£),
  "transitional_premium" VARCHAR  -- Transitional Premium (£),
  "local_discount" VARCHAR  -- Local Discount (£),
  "occupation_status" VARCHAR,
  "exempty_empty_rates" VARCHAR,
  "empty_from" TIMESTAMP,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "description_code" VARCHAR,
  "description" VARCHAR,
  "rateable_value" BIGINT  -- Rateable Value (£),
  "b_a_reference" BIGINT
);

13/06/2017

@ukgov.business_rates.n_13_06_2017
  • 1.02 MB
  • 20,898 rows
  • 18 columns
Loading... 
CREATE TABLE n_13_06_2017 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatory_relief" DOUBLE  -- Mandatory Relief %,
  "discretionary_relief" DOUBLE  -- Discretionary Relief %,
  "small_business_relief" DOUBLE  -- Small Business Relief %,
  "transitional_relief" VARCHAR,
  "transitional_premium" VARCHAR,
  "property_status" VARCHAR,
  "empty_from" TIMESTAMP,
  "exempt_empty" VARCHAR,
  "addr1" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "n_2017_rateable_value" BIGINT  -- 2017 Rateable Value,
  "description_code" VARCHAR,
  "b_a_reference" BIGINT
);

14/01/2019

@ukgov.business_rates.n_14_01_2019
  • 1.08 MB
  • 22,093 rows
  • 20 columns
Loading... 
CREATE TABLE n_14_01_2019 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandaory_relief" VARCHAR,
  "discretionay_relief" VARCHAR,
  "small_business_relief" VARCHAR,
  "transitional_relief" VARCHAR,
  "transitional_premium" VARCHAR,
  "net_local_discount" VARCHAR,
  "propery_status" VARCHAR,
  "empty_from" TIMESTAMP,
  "empty_exemption_reason" VARCHAR,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "voa_description_code" VARCHAR,
  "description" VARCHAR,
  "rateable_value" BIGINT,
  "ba_referencenumber" BIGINT
);

14/04/2019

@ukgov.business_rates.n_14_04_2019
  • 1.28 MB
  • 22,132 rows
  • 21 columns
Loading... 
CREATE TABLE n_14_04_2019 (
  "property_reference_number" DOUBLE,
  "ba_reference_number" BIGINT,
  "ratepayer" VARCHAR,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "occupied" VARCHAR,
  "liability_start_date" TIMESTAMP,
  "empty_from" TIMESTAMP,
  "rateable_value" BIGINT  -- Rateable Value (Ł),
  "voa_code" VARCHAR,
  "voa_description" VARCHAR,
  "exempt_from" TIMESTAMP,
  "exemption_type" VARCHAR,
  "mandatory_relief" DOUBLE  -- Mandatory Relief (Ł),
  "discretionary_relief" DOUBLE  -- Discretionary Relief (Ł),
  "local_discount" DOUBLE  -- Local Discount (Ł),
  "small_business_rate_relief" DOUBLE  -- Small Business Rate Relief (Ł),
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "total_relief" DOUBLE  -- Total Relief (Ł)
);

15/07/2016

@ukgov.business_rates.n_15_07_2016
  • 973.09 kB
  • 20,773 rows
  • 20 columns
Loading... 
CREATE TABLE n_15_07_2016 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatory_relief" BIGINT  -- Mandatory Relief %,
  "discretionary_relief" DOUBLE  -- Discretionary Relief %,
  "small_business_rate_relief" VARCHAR  -- Small Business Rate Relief %,
  "local_discount_2016_17" VARCHAR,
  "property_status" VARCHAR,
  "exempt_empty" VARCHAR,
  "empty_from" TIMESTAMP,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "rateable_value" BIGINT,
  "description_code" VARCHAR,
  "property_description" VARCHAR,
  "billing_authority_reference" BIGINT,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19
);

15/08/2014

@ukgov.business_rates.n_15_08_2014
  • 939.89 kB
  • 19,448 rows
  • 19 columns
Loading... 
CREATE TABLE n_15_08_2014 (
  "ratepayer" VARCHAR,
  "rateable_value" DOUBLE,
  "liable_from" VARCHAR,
  "property_description_code" VARCHAR,
  "property_description" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "address_3" VARCHAR,
  "address_4" VARCHAR,
  "postcode" VARCHAR,
  "billing_authority_reference" DOUBLE,
  "emptyes_prop" VARCHAR,
  "empty_from" VARCHAR,
  "exempt_empty" VARCHAR,
  "exemption_type" VARCHAR,
  "mandatory_relief" DOUBLE  -- Mandatory Relief %,
  "discretionary_relief_percent" DOUBLE,
  "small_business_rate_relief_percentage" DOUBLE,
  "retail_relief" DOUBLE  -- Retail Relief (Ł)
);

16/01/2018

@ukgov.business_rates.n_16_01_2018
  • 1.08 MB
  • 21,268 rows
  • 20 columns
Loading... 
CREATE TABLE n_16_01_2018 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatoty_relief" BIGINT  -- Mandatoty Relief (%),
  "discretionary_relief" BIGINT  -- Discretionary Relief (%),
  "small_business_rate_relief" DOUBLE  -- Small Business Rate Relief (%),
  "transitional_relief" VARCHAR  -- Transitional Relief (£),
  "transitional_premium" VARCHAR  -- Transitional Premium (£),
  "local_discount" VARCHAR  -- Local Discount (£),
  "occupation_status" VARCHAR,
  "exempty_empty_rates" VARCHAR,
  "empty_from" TIMESTAMP,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "description_code" VARCHAR,
  "description" VARCHAR,
  "rateable_value" BIGINT  -- Rateable Value (£),
  "b_a_reference" BIGINT
);

16/07/2019

@ukgov.business_rates.n_16_07_2019
  • 1.36 MB
  • 22,292 rows
  • 18 columns
Loading... 
CREATE TABLE n_16_07_2019 (
  "property_reference_number" VARCHAR,
  "ba_reference_number" BIGINT,
  "ratepayer" VARCHAR,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "occupied" VARCHAR,
  "liability_start_date" TIMESTAMP,
  "empty_from" TIMESTAMP,
  "rateable_value" BIGINT,
  "voa_code" VARCHAR,
  "voa_description" VARCHAR,
  "exemption" VARCHAR,
  "exemptions_start_date" VARCHAR,
  "total_relief" DOUBLE,
  "relief_mandatory" DOUBLE,
  "relief_discretionary" BIGINT
);

17/08/2017

@ukgov.business_rates.n_17_08_2017
  • 1.04 MB
  • 20,846 rows
  • 19 columns
Loading... 
CREATE TABLE n_17_08_2017 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatory_relief" VARCHAR  -- Mandatory Relief %,
  "discretionary_relief" VARCHAR  -- Discretionary Relief %,
  "small_business_relief" VARCHAR  -- Small Business Relief %,
  "transitional_relief" VARCHAR,
  "transitional_premium" VARCHAR,
  "property_status" VARCHAR,
  "empty_from" TIMESTAMP,
  "exempt_empty" VARCHAR,
  "addr1" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "description_code" VARCHAR,
  "description" VARCHAR,
  "n_2017_rateable_value" BIGINT  -- 2017 Rateable Value,
  "b_a_reference" BIGINT
);

Share link

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