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

17/10/2019

@ukgov.business_rates.n_17_10_2019

1.34 MB
22,819 rows
19 columns

CREATE TABLE n_17_10_2019 (
  "property_reference_number" DOUBLE,
  "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,
  "exemptions" VARCHAR,
  "exemptions_start_date" TIMESTAMP,
  "relief_types" VARCHAR,
  "relief_total" DOUBLE,
  "relief_mandatory" DOUBLE,
  "relief_discretionary" DOUBLE
);

18/05/2015

@ukgov.business_rates.n_18_05_2015

935.93 kB
19,456 rows
20 columns

CREATE TABLE n_18_05_2015 (
  "ratepayer" VARCHAR,
  "billing_authority_reference" DOUBLE,
  "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 (%),
  "local_discount" VARCHAR,
  "address" VARCHAR,
  "address_2" VARCHAR,
  "address_3" VARCHAR,
  "address_4" VARCHAR,
  "postcode" VARCHAR,
  "empty_property" VARCHAR,
  "empty_from" TIMESTAMP,
  "exempt_empty_rates" VARCHAR,
  "property_description_code" VARCHAR,
  "property_description" VARCHAR,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19
);

18/06/2014

@ukgov.business_rates.n_18_06_2014

904.94 kB
19,497 rows
19 columns

CREATE TABLE n_18_06_2014 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "rateable_value" BIGINT,
  "mandatory_relief" BIGINT  -- Mandatory Relief %,
  "discretionary_relief" BIGINT  -- Discretionary Relief %,
  "small_business_rate_relief" BIGINT  -- 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
);

20/04/2017

@ukgov.business_rates.n_20_04_2017

1.03 MB
20,827 rows
18 columns

CREATE TABLE n_20_04_2017 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatory_relief" BIGINT  -- Mandatory Relief %,
  "discretionary_relief" BIGINT  -- Discretionary Relief %,
  "small_business_relief" DOUBLE  -- Small Business Relief %,
  "transitional_relief" VARCHAR,
  "transitional_premium" VARCHAR,
  "property_status" VARCHAR,
  "empty_from" TIMESTAMP,
  "addr1" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "n_2017_rateable_value" BIGINT  -- 2017 Rateable Value,
  "description_code" VARCHAR,
  "description" VARCHAR,
  "b_a_reference" BIGINT
);

20/07/2015

@ukgov.business_rates.n_20_07_2015

756.54 kB
19,559 rows
18 columns

CREATE TABLE n_20_07_2015 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "rateable_value" BIGINT  -- Rateable Value (ś),
  "mandatory_relief" BIGINT  -- Mandatory Relief (%),
  "discretionary_relief" BIGINT  -- Discretionary Relief (%),
  "small_business_rate_relief" DOUBLE  -- Small Business Rate Relief (%),
  "retail_relief" VARCHAR,
  "local_discount" VARCHAR,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "empty_property" VARCHAR  -- Empty Property?,
  "exempt_empty_rates" VARCHAR,
  "empty_from" TIMESTAMP,
  "property_description_code" VARCHAR,
  "property_description" VARCHAR
);

23/10/2017

@ukgov.business_rates.n_23_10_2017

1.11 MB
20,937 rows
20 columns

CREATE TABLE n_23_10_2017 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatoty_relief" DOUBLE  -- Mandatoty Relief (%),
  "discretionary_relief" DOUBLE  -- 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
);

25/01/2016

@ukgov.business_rates.n_25_01_2016

959.85 kB
19,793 rows
19 columns

CREATE TABLE n_25_01_2016 (
  "billing_authority_reference" BIGINT,
  "ratepayer" VARCHAR,
  "charged_from" TIMESTAMP,
  "mandatory_relief" BIGINT  -- Mandatory Relief %,
  "discretionary_relief_percent" BIGINT  -- Discretionary Relief % Percent,
  "small_business_relief" DOUBLE  -- Small Business Relief %,
  "local_discount" DOUBLE  -- Local Discount £,
  "discount_type" VARCHAR,
  "empty_property" VARCHAR,
  "exempt_empty_rates" VARCHAR,
  "empty_from" TIMESTAMP,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "description_code" VARCHAR,
  "property_description" VARCHAR,
  "rateable_value" VARCHAR
);

26/06/2020

@ukgov.business_rates.n_26_06_2020

1.18 MB
22,804 rows
21 columns

CREATE TABLE n_26_06_2020 (
  "uprn" DOUBLE,
  "propref" DOUBLE,
  "ratepayer" VARCHAR,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "empty_prop" VARCHAR,
  "empty_from" TIMESTAMP,
  "liable_from" TIMESTAMP,
  "rateable_value" BIGINT,
  "description_code" VARCHAR,
  "property_description" VARCHAR,
  "exempt_epr" VARCHAR,
  "exemption_type" VARCHAR,
  "mand_relief" DOUBLE,
  "disc_relief" DOUBLE,
  "sbrr_relief" DOUBLE,
  "net_local_disc" DOUBLE,
  "total_discretionary" DOUBLE,
  "disc_type_code" VARCHAR
);