Business Ratepayers by UK Government | Finance and Economics

About this Dataset

Business Ratepayers

National non domestic ratepayers
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:41:05Z

Tables

Business Ratepayers NNDR - South Cambs DC

@ukgov.business_ratepayers1.business_ratepayers_nndr_south_cambs_dc

202.7 KB
3452 rows
22 columns


CREATE TABLE business_ratepayers_nndr_south_cambs_dc (
  "name" VARCHAR,
  "propertyaddress" VARCHAR,
  "postcode" VARCHAR,
  "propertydescription" VARCHAR,
  "propertyrateablevalueplaceref" BIGINT,
  "liabilityperiodstartdate" TIMESTAMP,
  "annualcharge" DOUBLE,
  "exemptionamount" DOUBLE,
  "exemptioncode" VARCHAR,
  "rateablevalue" BIGINT,
  "mandatoryamount" DOUBLE,
  "mandatoryrelief" VARCHAR,
  "charityreliefamount" DOUBLE,
  "discreliefamount" BIGINT,
  "discretionarycharitablerelief" VARCHAR,
  "additionalrlf" VARCHAR,
  "additionalrelief" DOUBLE,
  "sbrapplied" BIGINT,
  "sbrsupplement" DOUBLE,
  "sbramount" DOUBLE,
  "chargetypevemptycommercialpropertyooccupied" VARCHAR,
  "reportdate" TIMESTAMP
);

Business Rates Valuation List - South Cambs DC

@ukgov.business_ratepayers1.business_rates_valuation_list_south_cambs_dc

178.1 KB
4675 rows
17 columns


CREATE TABLE business_rates_valuation_list_south_cambs_dc (
  "listaltered" VARCHAR,
  "communitycode" BIGINT,
  "bareference" VARCHAR,
  "propertycategorycode" VARCHAR,
  "propertydescription" VARCHAR,
  "propertyaddress" VARCHAR,
  "streetdescriptor" VARCHAR,
  "locality" VARCHAR,
  "posttown" VARCHAR,
  "administrativearea" VARCHAR,
  "postcode" VARCHAR,
  "effectivedate" VARCHAR,
  "partiallydomesticsignal" VARCHAR,
  "rateablevalue" BIGINT,
  "scatcode" VARCHAR,
  "appealsettlementcode" VARCHAR,
  "uniquepropertyref" DOUBLE
);