South Lakeland District Council Business Rates
South Lakeland District Council
@ukgov.south_lakeland_district_council_business_rates
South Lakeland District Council
@ukgov.south_lakeland_district_council_business_rates
Full list of non-domestic properties in South Lakeland, Business Rates list showing the rateable value, any reliefs, annual charge and the properties occupied status. As of September 2018, we are able to include date of liability/occupation in this main list, this list will replace the separate New Liabilities List. We are unable to extract date of vacancy from our system. Please note: we remove sole trader information as it is personal data exempt under section 40 (2) of the Freedom of Information Act 2000.
Publisher name: South Lakeland District Council
Last updated: 2025-01-28T04:03:35Z
CREATE TABLE business_rates_as_at_7_may_2020 (
"effectivedate" TIMESTAMP,
"organisationnamelabel" VARCHAR,
"organisationuri" VARCHAR,
"servicecategorylabel" VARCHAR,
"servicecategoryuri" VARCHAR,
"licence" VARCHAR,
"accountname" VARCHAR,
"propertyname1" VARCHAR,
"propertyname2" VARCHAR,
"propertyaddress1" VARCHAR,
"propertyaddress2" VARCHAR,
"propertyaddress3" VARCHAR,
"propertyaddress4" VARCHAR,
"propertypostcode" VARCHAR,
"currentrateablevalue" DOUBLE,
"mandatoryreliefamount" DOUBLE,
"discretionaryreliefdamount" DOUBLE,
"transitionalreliefamount" DOUBLE,
"transtionalpremiumamount" DOUBLE,
"smallbusinessratesreliefamount" DOUBLE,
"netlocaldiscountamount" DOUBLE,
"retaildiscount" VARCHAR,
"chargedamount" DOUBLE,
"empty" VARCHAR,
"emptyfromdate" VARCHAR,
"exempt" VARCHAR,
"propertyreference" VARCHAR,
"dateliablefrom" TIMESTAMP,
"rateablepropertytype" VARCHAR,
"valuationofficepropertydescription" VARCHAR,
"unnamed_30" VARCHAR -- Unnamed: 30,
"unnamed_31" VARCHAR -- Unnamed: 31,
"unnamed_32" VARCHAR -- Unnamed: 32,
"unnamed_33" VARCHAR -- Unnamed: 33,
"unnamed_34" VARCHAR -- Unnamed: 34,
"unnamed_35" VARCHAR -- Unnamed: 35,
"unnamed_36" VARCHAR -- Unnamed: 36,
"unnamed_37" VARCHAR -- Unnamed: 37,
"unnamed_38" VARCHAR -- Unnamed: 38,
"unnamed_39" VARCHAR -- Unnamed: 39
);CREATE TABLE business_rates_full_list_as_at_11_december_2019 (
"effectivedate" TIMESTAMP,
"organisationnamelabel" VARCHAR,
"organisationuri" VARCHAR,
"servicecategorylabel" VARCHAR,
"servicecategoryuri" VARCHAR,
"licence" VARCHAR,
"accountname" VARCHAR,
"propertyname1" VARCHAR,
"propertyname2" VARCHAR,
"propertyaddress1" VARCHAR,
"propertyaddress2" VARCHAR,
"propertyaddress3" VARCHAR,
"propertyaddress4" VARCHAR,
"propertypostcode" VARCHAR,
"currentrateablevalue" BIGINT,
"mandatoryreliefamount" DOUBLE,
"discretionaryreliefdamount" DOUBLE,
"transitionalreliefamount" DOUBLE,
"transtionalpremiumamount" DOUBLE,
"smallbusinessratesreliefamount" DOUBLE,
"netlocaldiscountamount" DOUBLE,
"chargedamount" DOUBLE,
"empty" VARCHAR,
"emptyfromdate" VARCHAR,
"exempt" VARCHAR,
"propertyreference" VARCHAR,
"dateliablefrom" TIMESTAMP,
"billedtodate" TIMESTAMP,
"ratepayertype_company_person" VARCHAR -- RatepayerType(Company/Person),
"valuationofficepropertydescription" VARCHAR
);CREATE TABLE business_rates_full_list_as_at_15_august_2019 (
"effectivedate" TIMESTAMP,
"organisationnamelabel" VARCHAR,
"organisationuri" VARCHAR,
"servicecategorylabel" VARCHAR,
"servicecategoryuri" VARCHAR,
"licence" VARCHAR,
"accountname" VARCHAR,
"propertyname1" VARCHAR,
"propertyname2" VARCHAR,
"propertyaddress1" VARCHAR,
"propertyaddress2" VARCHAR,
"propertyaddress3" VARCHAR,
"propertyaddress4" VARCHAR,
"propertypostcode" VARCHAR,
"currentrateablevalue" BIGINT,
"mandatoryreliefamount" DOUBLE,
"discretionaryreliefdamount" DOUBLE,
"transitionalreliefamount" DOUBLE,
"transtionalpremiumamount" DOUBLE,
"smallbusinessratesreliefamount" DOUBLE,
"netlocaldiscountamount" DOUBLE,
"chargedamount" DOUBLE,
"empty" VARCHAR,
"emptyfromdate" VARCHAR,
"exempt" VARCHAR,
"propertyreference" VARCHAR,
"dateliablefrom" TIMESTAMP,
"billedtodate" TIMESTAMP,
"ratepayertype_company_person" VARCHAR -- RatepayerType(Company/Person),
"valuationofficepropertydescription" VARCHAR
);CREATE TABLE business_rates_full_list_as_at_1_april_2019 (
"effectivedate" TIMESTAMP,
"organisationnamelabel" VARCHAR,
"organisationuri" VARCHAR,
"servicecategorylabel" VARCHAR,
"servicecategoryuri" VARCHAR,
"licence" VARCHAR,
"accountname" VARCHAR,
"propertyname1" VARCHAR,
"propertyname2" VARCHAR,
"propertyaddress1" VARCHAR,
"propertyaddress2" VARCHAR,
"propertyaddress3" VARCHAR,
"propertyaddress4" VARCHAR,
"propertypostcode" VARCHAR,
"currentrateablevalue" BIGINT,
"mandatoryreliefamount" DOUBLE,
"discretionaryreliefdamount" DOUBLE,
"transitionalreliefamount" DOUBLE,
"transtionalpremiumamount" DOUBLE,
"smallbusinessratesreliefamount" DOUBLE,
"netlocaldiscountamount" DOUBLE,
"chargedamount" DOUBLE,
"empty" VARCHAR,
"emptyfromdate" VARCHAR,
"exempt" VARCHAR,
"propertyreference" VARCHAR,
"dateliablefrom" TIMESTAMP,
"ratepayertype_company_person" VARCHAR -- RatepayerType(Company/Person),
"valuationofficepropertydescription" VARCHAR
);CREATE TABLE business_rates_full_list_as_at_1_october_2019 (
"effectivedate" TIMESTAMP,
"organisationnamelabel" VARCHAR,
"organisationuri" VARCHAR,
"servicecategorylabel" VARCHAR,
"servicecategoryuri" VARCHAR,
"licence" VARCHAR,
"accountname" VARCHAR,
"propertyname1" VARCHAR,
"propertyname2" VARCHAR,
"propertyaddress1" VARCHAR,
"propertyaddress2" VARCHAR,
"propertyaddress3" VARCHAR,
"propertyaddress4" VARCHAR,
"propertypostcode" VARCHAR,
"currentrateablevalue" BIGINT,
"mandatoryreliefamount" DOUBLE,
"discretionaryreliefdamount" DOUBLE,
"transitionalreliefamount" DOUBLE,
"transtionalpremiumamount" DOUBLE,
"smallbusinessratesreliefamount" DOUBLE,
"netlocaldiscountamount" DOUBLE,
"chargedamount" DOUBLE,
"empty" VARCHAR,
"emptyfromdate" VARCHAR,
"exempt" VARCHAR,
"propertyreference" VARCHAR,
"dateliablefrom" TIMESTAMP,
"billedtodate" TIMESTAMP,
"ratepayertype_company_person" VARCHAR -- RatepayerType(Company/Person),
"valuationofficepropertydescription" VARCHAR
);CREATE TABLE business_rates_full_list_as_at_22_november_2018 (
"effectivedate" TIMESTAMP,
"organisationnamelabel" VARCHAR,
"organisationuri" VARCHAR,
"servicecategorylabel" VARCHAR,
"servicecategoryuri" VARCHAR,
"licence" VARCHAR,
"accountname" VARCHAR,
"propertyname1" VARCHAR,
"propertyname2" VARCHAR,
"propertyaddress1" VARCHAR,
"propertyaddress2" VARCHAR,
"propertyaddress3" VARCHAR,
"propertyaddress4" VARCHAR,
"propertypostcode" VARCHAR,
"currentrateablevalue" DOUBLE,
"mandatoryreliefamount" DOUBLE,
"discretionaryreliefdamount" DOUBLE,
"transitionalreliefamount" DOUBLE,
"transtionalpremiumamount" DOUBLE,
"smallbusinessratesreliefamount" DOUBLE,
"netlocaldiscountamount" DOUBLE,
"chargedamount" DOUBLE,
"emptyfromdate" VARCHAR,
"empty" VARCHAR,
"exempt" VARCHAR,
"propertyreference" VARCHAR,
"dateliablefrom" VARCHAR,
"ratepayertype_company_person" VARCHAR -- RatepayerType(Company/Person),
"valuationofficepropertydescription" VARCHAR
);CREATE TABLE business_rates_full_list_as_at_25_may_2019 (
"effectivedate" TIMESTAMP,
"organisationnamelabel" VARCHAR,
"organisationuri" VARCHAR,
"servicecategorylabel" VARCHAR,
"servicecategoryuri" VARCHAR,
"licence" VARCHAR,
"accountname" VARCHAR,
"propertyname1" VARCHAR,
"propertyaddress1" VARCHAR,
"propertyaddress2" VARCHAR,
"propertyaddress3" VARCHAR,
"propertyaddress4" VARCHAR,
"propertypostcode" VARCHAR,
"currentrateablevalue" BIGINT,
"mandatoryreliefamount" DOUBLE,
"discretionaryreliefdamount" DOUBLE,
"transitionalreliefamount" DOUBLE,
"transtionalpremiumamount" DOUBLE,
"smallbusinessratesreliefamount" DOUBLE,
"netlocaldiscountamount" DOUBLE,
"chargedamount" DOUBLE,
"empty" VARCHAR,
"emptyfromdate" VARCHAR,
"exempt" VARCHAR,
"propertyreference" VARCHAR,
"dateliablefrom" TIMESTAMP,
"ratepayertype_company_person" VARCHAR -- RatepayerType(Company/Person),
"valuationofficepropertydescription" VARCHAR
);CREATE TABLE business_rates_full_list_as_at_29_january_2019 (
"effectivedate" TIMESTAMP,
"organisationnamelabel" VARCHAR,
"organisationuri" VARCHAR,
"servicecategorylabel" VARCHAR,
"servicecategoryuri" VARCHAR,
"licence" VARCHAR,
"accountname" VARCHAR,
"propertyname1" VARCHAR,
"propertyname2" VARCHAR,
"propertyaddress1" VARCHAR,
"propertyaddress2" VARCHAR,
"propertyaddress3" VARCHAR,
"propertyaddress4" VARCHAR,
"propertypostcode" VARCHAR,
"currentrateablevalue" BIGINT,
"mandatoryreliefamount" BIGINT,
"discretionaryreliefdamount" BIGINT,
"transitionalreliefamount" BIGINT,
"transtionalpremiumamount" BIGINT,
"smallbusinessratesreliefamount" BIGINT,
"netlocaldiscountamount" BIGINT,
"chargedamount" BIGINT,
"emptyfromdate" VARCHAR,
"empty" VARCHAR,
"exempt" VARCHAR,
"propertyreference" VARCHAR,
"dateliablefrom" TIMESTAMP,
"ratepayertype_company_person" VARCHAR -- RatepayerType(Company/Person),
"valuationofficepropertydescription" VARCHAR,
"unnamed_29" VARCHAR -- Unnamed: 29,
"unnamed_30" VARCHAR -- Unnamed: 30,
"unnamed_31" VARCHAR -- Unnamed: 31,
"unnamed_32" VARCHAR -- Unnamed: 32
);CREATE TABLE business_rates_full_list_as_at_29_september_2018 (
"effectivedate" TIMESTAMP,
"organisationnamelabel" VARCHAR,
"organisationuri" VARCHAR,
"servicecategorylabel" VARCHAR,
"servicecategoryuri" VARCHAR,
"licence" VARCHAR,
"accountname" VARCHAR,
"propertyname1" VARCHAR,
"propertyname2" VARCHAR,
"propertyaddress1" VARCHAR,
"propertyaddress2" VARCHAR,
"propertyaddress3" VARCHAR,
"propertyaddress4" VARCHAR,
"propertypostcode" VARCHAR,
"currentrateablevalue" BIGINT,
"mandatoryreliefamount" DOUBLE,
"discretionaryreliefdamount" DOUBLE,
"transitionalreliefamount" DOUBLE,
"transtionalpremiumamount" DOUBLE,
"smallbusinessratesreliefamount" DOUBLE,
"netlocaldiscountamount" DOUBLE,
"chargedamount" DOUBLE,
"emptyfromdate" VARCHAR,
"empty" VARCHAR,
"exempt" VARCHAR,
"propertyreference" VARCHAR,
"dateliablefrom" VARCHAR,
"ratepayertype_company_person" VARCHAR -- RatepayerType(Company/Person),
"valuationofficepropertydescription" VARCHAR
);CREATE TABLE business_rates_full_list_as_at_5_february_2020 (
"effectivedate" TIMESTAMP,
"organisationnamelabel" VARCHAR,
"organisationuri" VARCHAR,
"servicecategorylabel" VARCHAR,
"servicecategoryuri" VARCHAR,
"licence" VARCHAR,
"accountname" VARCHAR,
"propertyname1" VARCHAR,
"propertyname2" VARCHAR,
"propertyaddress1" VARCHAR,
"propertyaddress2" VARCHAR,
"propertyaddress3" VARCHAR,
"propertyaddress4" VARCHAR,
"propertypostcode" VARCHAR,
"currentrateablevalue" DOUBLE,
"mandatoryreliefamount" DOUBLE,
"discretionaryreliefdamount" DOUBLE,
"transitionalreliefamount" DOUBLE,
"transtionalpremiumamount" DOUBLE,
"smallbusinessratesreliefamount" DOUBLE,
"netlocaldiscountamount" DOUBLE,
"retaildiscount" VARCHAR,
"chargedamount" DOUBLE,
"empty" VARCHAR,
"emptyfromdate" VARCHAR,
"exempt" VARCHAR,
"propertyreference" VARCHAR,
"dateliablefrom" TIMESTAMP,
"billedtodate" TIMESTAMP,
"valuationofficepropertydescription" VARCHAR
);CREATE TABLE sldc_business_rates_as_at_24_july_2017 (
"organisationnamelabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"servicecategorylabel" VARCHAR,
"servicecategoryuri" VARCHAR,
"licence" VARCHAR,
"accountname" VARCHAR,
"postaddress1" VARCHAR,
"postaddress2" VARCHAR,
"postaddress3" VARCHAR,
"postaddress4" VARCHAR,
"postaddress5" VARCHAR,
"postcode" VARCHAR,
"propertyreference" VARCHAR,
"propertyaddress1" VARCHAR,
"propertyaddress2" VARCHAR,
"propertyaddress3" VARCHAR,
"propertyaddress4" VARCHAR,
"propertyaddress5" VARCHAR,
"propertypostcode" VARCHAR,
"occupied" VARCHAR,
"exempemptiondescription" VARCHAR,
"mandatoryreliefdescription" VARCHAR,
"discretionaryreliefdescription" VARCHAR,
"smallbusinessraterelief" VARCHAR,
"propertydescription" VARCHAR,
"rateablevalue" BIGINT
);CREATE TABLE sldc_business_rates_as_at_2_november_2017 (
"effectivedate" TIMESTAMP,
"organisationnamelabel" VARCHAR,
"organisationuri" VARCHAR,
"servicecategorylabel" VARCHAR,
"servicecategoryuri" VARCHAR,
"licence" VARCHAR,
"accountname" VARCHAR,
"postaddress1" VARCHAR,
"postaddress2" VARCHAR,
"postaddress3" VARCHAR,
"postaddress4" VARCHAR,
"postaddress5" VARCHAR,
"postpostcode" VARCHAR,
"propertyref" VARCHAR,
"propertyaddress1" VARCHAR,
"propertyaddress2" VARCHAR,
"propertyaddress3" VARCHAR,
"propertyaddress4" VARCHAR,
"propertyaddress5" VARCHAR,
"propertypostcode" VARCHAR,
"occupied" VARCHAR,
"propertydescription" VARCHAR,
"rateablevalue" BIGINT,
"exemptiondescription" VARCHAR,
"otherreliefdescription" VARCHAR,
"discretionaryreliefdescription" VARCHAR,
"smallbusinessraterelief" VARCHAR,
"supportingsmallbusiness_relief" VARCHAR
);CREATE TABLE sldc_business_rates_as_at_9_april_2017 (
"organisationnamelabel" VARCHAR,
"organisationuri" VARCHAR,
"effectivedate" TIMESTAMP,
"servicecategorylabel" VARCHAR,
"servicecategoryuri" VARCHAR,
"licence" VARCHAR,
"accountname" VARCHAR,
"postaddress1" VARCHAR,
"postaddress2" VARCHAR,
"postaddress3" VARCHAR,
"postaddress4" VARCHAR,
"postaddress5" VARCHAR,
"postcode" VARCHAR,
"propertyref" VARCHAR,
"propaddress1" VARCHAR,
"propaddress2" VARCHAR,
"propaddress3" VARCHAR,
"propaddress4" VARCHAR,
"propaddress5" VARCHAR,
"proppostcode" VARCHAR,
"occupied" VARCHAR,
"exemptiondescription" VARCHAR,
"mandatoryreliefdescription" VARCHAR,
"discretionaryreliefdescription" VARCHAR,
"smallbusinessraterelief" VARCHAR,
"propertydescription" VARCHAR,
"rateablevalue" BIGINT,
"annualnetcharge" DOUBLE
);Anyone who has the link will be able to view this.