Baselight
Sign In

Business Ratepayers

Cambridgeshire Insight

@ukgov.business_ratepayers1

Business Ratepayers NNDR - South Cambs DC
@ukgov.business_ratepayers1.business_ratepayers_nndr_south_cambs_dc

A data set of SCDC NNDR ratepayers including reliefs and empty commercial property.

  • 202.7 KB
  • 3452 rows
  • 22 columns
name

Name

propertyaddress

PropertyAddress

postcode

PostCode

propertydescription

PropertyDescription

propertyrateablevalueplaceref

PropertyRateableValuePlaceRef

liabilityperiodstartdate

LiabilityPeriodStartDate

annualcharge

AnnualCharge

exemptionamount

ExemptionAmount

exemptioncode

ExemptionCode

rateablevalue

RateableValue

mandatoryamount

MandatoryAmount

mandatoryrelief

MandatoryRelief

charityreliefamount

CharityReliefAmount

discreliefamount

DiscReliefAmount

discretionarycharitablerelief

DiscretionaryCharitableRelief

additionalrlf

AdditionalRlf

additionalrelief

AdditionalRelief

sbrapplied

SBRApplied

sbrsupplement

SBRSupplement

sbramount

SBRAmount

chargetypevemptycommercialpropertyooccupied

ChargeTypeVEmptyCommercialPropertyOOccupied

reportdate

ReportDate

A & E MARQUEES LTDSHOWROOM,AT DOCKERILL FARM,WILLINGHAM ROAD,OVER,CAMBRIDGE,CB24 5PFSTORE3748609045Sun Jan 04 2015 00:00:00 GMT+0000 (Coordinated Universal Time)21124400-12112OFri Mar 27 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
CHADWICK EXPORT SERVICES LTDUNIT 8,HIGHGATE FARM,WILLINGHAM ROAD,OVER,CAMBRIDGE,CB24 5EUOFFICES AND PREMISES3748609028Sun Jan 04 2015 00:00:00 GMT+0000 (Coordinated Universal Time)32646800-12828.8OFri Mar 27 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
GAMLINGAY UNITED SERVICEMENS CLUB16 WARESLEY ROAD,GAMLINGAY,SANDY BEDS,,,SG19 3EJCLUB AND PREMISES3389700160Sun Jan 04 2015 00:00:00 GMT+0000 (Coordinated Universal Time)27365700-12736OFri Mar 27 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
1ST BALSHAM SCOUT GROUPSCOUT HUT, WOODHALL LANE,BALSHAM,CAMBRIDGE,,,CB21 4DUHALL3065758030Sun Jan 04 2015 00:00:00 GMT+0000 (Coordinated Universal Time)10082100828.24MAN207.06DISCTP27.3OFri Mar 27 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
1ST HARDWICK/HIGHFIELDS SCOUT GROUPSCOUT HUT, LIMES ROAD,HARDWICK,CAMBRIDGE,,,CB23 7QRHALL AND PREMISES3436008141Sun Jan 04 2015 00:00:00 GMT+0000 (Coordinated Universal Time)11522400946.56MAN236.64DISCTP31.2OFri Mar 27 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
1ST HISTON SCOUTS & GUIDESHISTON SCOUT HUT NEW ROAD,IMPINGTON,CAMBRIDGE,,,CB24 9LUHALL AND PREMISES3567258040Sun Jan 04 2015 00:00:00 GMT+0000 (Coordinated Universal Time)7681600631.04MAN157.76DISCTP20.8OFri Mar 27 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
2G LTDROOM 42,,NEWTON HALL,TOWN STREET,NEWTON,CAMBRIDGE,CB22 7ZEOFFICE3716758320Sun Jan 04 2015 00:00:00 GMT+0000 (Coordinated Universal Time)14162950-11416OFri Mar 27 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
2ND COTTENHAM SCOUTSSCOUT HUT R/O 28 MARGETT STREET,COTTENHAM,CAMBRIDGE,,,CB24 8QYHALL AND PREMISES3243500281Sun Jan 04 2015 00:00:00 GMT+0000 (Coordinated Universal Time)153632001262.08MAN315.52DISCTP41.6OFri Mar 27 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
4T MEDICAL LTD1B SUNRISE BUSINESS PARK,FLINT LANE,WATERBEACH,CAMBRIDGE,,CB25 9QZOFFICES & PREMISES3924158013Sun Jan 04 2015 00:00:00 GMT+0000 (Coordinated Universal Time)8401750OFri Mar 27 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
4T MEDICAL LTD1C SUNRISE BUSINESS PARK,FLINT LANE,WATERBEACH,CAMBRIDGE,,CB25 9QZOFFICES & PREMISES3924158015Sun Jan 04 2015 00:00:00 GMT+0000 (Coordinated Universal Time)15123150OFri Mar 27 2015 00:00:00 GMT+0000 (Coordinated Universal Time)

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
);