Baselight

Wirral Business Rates (NNDR)

Wirral Metropolitan Borough Council

@ukgov.wirral_business_rates_nndr

NNDR Data To April 2019
@ukgov.wirral_business_rates_nndr.nndr_data_to_april_2019

  • 466.96 KB
  • 5041 rows
  • 40 columns
organisationlabel

OrganisationLabel

organisationuri

OrganisationURI

accountname1

AccountName1

accountname2

AccountName2

propertyaddress1

PropertyAddress1

propertyaddress2

PropertyAddress2

propertyaddress3

PropertyAddress3

propertyaddress4

PropertyAddress4

propertyaddress5

PropertyAddress5

propertyaddress6

PropertyAddress6

propertypostcode

PropertyPostcode

bareference

BAReference

accountaddress1

AccountAddress1

accountaddress2

AccountAddress2

accountaddress3

AccountAddress3

accountaddress4

AccountAddress4

accountpostcode

AccountPostcode

emptyprop

EmptyProp

emptyfrom

EmptyFrom

liablefrom

LiableFrom

accountexemption

AccountExemption

propertyexemption

PropertyExemption

n_2017_rv

2017 RV

n_2010_rv

2010 RV

rv_chargeable

RV Chargeable

charge_19_20

Charge 19–20

mindatefromsbrr

MinDatefromSBRR

lowermultiplier

LowerMultiplier

sbrr

SBRR

transrelief

TransRelief

transprem

TransPrem

mindatefromrelief

MinDateFromRelief

maxdatetorelief

MaxDatetoRelief

mandrelief

MandRelief%

mandreliefamount

MandReliefAmount

discrelief

DiscRelief%

discreliefamount

DiscReliefAmount

localdiscount_type

LocalDiscount Type

localdiscountamount

LocalDiscountAmount

voadescription

VOADescription

Wirral Metropolitan Borough Councilhttp://opendatacommunities.org/ID/metropolitan-district-council/wirralLADBROKES BETTING & GAMING LTD171-173 FORD ROADWIRRALCH49 0TH00010580017307C/O MONTAGU EVANS LLP2ND FLOOR ABBEY HOUSE74 MOSLEY STREETMANCHESTERM2 3LWSat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)10000117504910£4,910.00SBRR Multiplier Used in Calculation£0.00£0.00£0.00£0.00£0.00BETTING SHOP AND PREMISES
Wirral Metropolitan Borough Councilhttp://opendatacommunities.org/ID/metropolitan-district-council/wirralADULT SOCIAL SERVICESROYDEN PARK COACH HSE 1ST FLRHILLBARK ROADWIRRALMERSEYSIDECH48 1NP0007620000060AACCOUNTANCY DIVISIONMARRISS HOUSEHAMILTON STREETBIRKENHEADCH41 5ALYSat Apr 01 1995 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)860475433£0.00£0.00-£154.54£0.00£0.00£0.00HALL AND PREMISES
Wirral Metropolitan Borough Councilhttp://opendatacommunities.org/ID/metropolitan-district-council/wirralLAMAR FABRICATIONS LTD(IN LIQUIDATION)UNIT 3 AT 110 CHURCH STREETBIRKENHEADMERSEYSIDECH41 5EQ000282800110A3C/O THE OFFICIAL RECEIVER2ND FLOOR ROSEBRAE COURTWOODSIDE FERRY APPROACHBIRKENHEADCH41 6DUYFri Aug 30 1996 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)212521251071£0.00£0.00£0.00£0.00£0.00£0.00GARAGE AND PREMISES
Wirral Metropolitan Borough Councilhttp://opendatacommunities.org/ID/metropolitan-district-council/wirralTECHNICAL SERVICES DIRECTORATEUNIT ADJ QUAY TECHNOLOGIES ATLASER ENGINEERINGCAMPBELTOWN ROADBIRKENHEAD MERSEYSIDECH41 9BP000290200008B1C/O ACCOUNTANCY DIVISIONMARRISS HOUSEHAMILTON STREETBIRKENHEADCH41 5ALYMon Jan 05 1998 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)Industrial Premises465077002343£2,343.60£0.00£0.00£874.17£0.00£0.00WORKSHOP AND PREMISES
Wirral Metropolitan Borough Councilhttp://opendatacommunities.org/ID/metropolitan-district-council/wirralMORRIS JONES & SON CARPETS LTDOFFICES 1ST FLOOR AT247 GREASBY ROADWIRRALCH49 3NE000787700247A6SHOP AT 247 GREASBY ROADWIRRALMERSEYSIDECH49 3NEYTue Jan 06 1998 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)355029501789£1,789.20£0.00-£125.13£0.00£0.00£0.00OFFICES AND PREMISES
Wirral Metropolitan Borough Councilhttp://opendatacommunities.org/ID/metropolitan-district-council/wirralLES PERRY ROOFING CONTRACTORSLTD398A POULTON ROADWALLASEYMERSEYSIDECH44 5SF000433100408J8FOXDALEDALE END ROADBARNSTONWIRRALCH61 1DDSat Apr 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)720720353£353.52SBRR Multiplier Used in Calculation£0.00£0.00£0.00£0.00£0.00WORKSHOP AND PREMISES
Wirral Metropolitan Borough Councilhttp://opendatacommunities.org/ID/metropolitan-district-council/wirralBEERS TIMBER & BUILDING SUPPLIESLTD2A ARGYLE STREET SOUTHBIRKENHEADMERSEYSIDECH41 9BX000281400039A41 BOUNDARY STREETLIVERPOOLL5 9UDTue Mar 07 2017 00:00:00 GMT+0000 (Coordinated Universal Time)15500180007610£5,073.67SBRR Multiplier Used in Calculation£0.00£0.00£0.00£0.00£0.00RTLD-£2,536.83WORKSHOP AND PREMISES
Wirral Metropolitan Borough Councilhttp://opendatacommunities.org/ID/metropolitan-district-council/wirralD & S FABRICATION AND WELDINGLTD24 WHEATLAND BUSINESS PARKWHEATLAND LANEWALLASEYMERSEYSIDECH44 7ER0004451A00240824 WHEATLAND BUSINESS PARKWHEATLAND LANEWALLASEYWIRRALCH44 7ERWed Jun 29 2016 00:00:00 GMT+0000 (Coordinated Universal Time)500045502455£0.00Mon Mar 13 2017 00:00:00 GMT+0000 (Coordinated Universal Time)SBRR Multiplier Used in Calculation-£2,330.00£0.00£0.00£0.00£0.00WAREHOUSE AND PREMISES
Wirral Metropolitan Borough Councilhttp://opendatacommunities.org/ID/metropolitan-district-council/wirralSPECSAVERS OPTICAL SUPERSTORESLTDMANAGEMENT OFF 30 BOROUGH PAVEMENTGRANGE PRECINCTBIRKENHEADMERSEYSIDECH41 2XX26080003009C/0 GERALD EVE LLP35 KINGS HILL AVENUEWEST MALLINGKENTME19 4DNWed Oct 11 2017 00:00:00 GMT+0000 (Coordinated Universal Time)550040002700£2,583.51SBRR Multiplier Used in Calculation£0.00-£230.69£0.00£0.00£0.00OFFICES AND PREMISES
Wirral Metropolitan Borough Councilhttp://opendatacommunities.org/ID/metropolitan-district-council/wirralSPECSAVERS OPTICAL SUPERSTORESLTD183-185 TELEGRAPH ROADWIRRALCH60 7SE86620018303C/O GERALD EVE35 KINGS HILL AVENUEWEST MALLINGKENTME19 4DNFri Oct 27 2017 00:00:00 GMT+0000 (Coordinated Universal Time)20000247509820£6,546.67SBRR Multiplier Used in Calculation£0.00£0.00£194.41£0.00£0.00RTLD-£3,273.33SHOP AND PREMISES

CREATE TABLE nndr_data_to_april_2019 (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "accountname1" VARCHAR,
  "accountname2" VARCHAR,
  "propertyaddress1" VARCHAR,
  "propertyaddress2" VARCHAR,
  "propertyaddress3" VARCHAR,
  "propertyaddress4" VARCHAR,
  "propertyaddress5" VARCHAR,
  "propertyaddress6" VARCHAR,
  "propertypostcode" VARCHAR,
  "bareference" VARCHAR,
  "accountaddress1" VARCHAR,
  "accountaddress2" VARCHAR,
  "accountaddress3" VARCHAR,
  "accountaddress4" VARCHAR,
  "accountpostcode" VARCHAR,
  "emptyprop" VARCHAR,
  "emptyfrom" TIMESTAMP,
  "liablefrom" TIMESTAMP,
  "accountexemption" VARCHAR,
  "propertyexemption" VARCHAR,
  "n_2017_rv" BIGINT,
  "n_2010_rv" DOUBLE,
  "rv_chargeable" BIGINT,
  "charge_19_20" VARCHAR,
  "mindatefromsbrr" TIMESTAMP,
  "lowermultiplier" VARCHAR,
  "sbrr" VARCHAR,
  "transrelief" VARCHAR,
  "transprem" VARCHAR,
  "mindatefromrelief" TIMESTAMP,
  "maxdatetorelief" TIMESTAMP,
  "mandrelief" VARCHAR,
  "mandreliefamount" VARCHAR,
  "discrelief" VARCHAR,
  "discreliefamount" VARCHAR,
  "localdiscount_type" VARCHAR,
  "localdiscountamount" VARCHAR,
  "voadescription" VARCHAR
);

Share link

Anyone who has the link will be able to view this.