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
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_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR
);
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,
"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,
"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,
"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,
"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,
"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,
"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,
"valuationofficepropertydescription" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR
);
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,
"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.