Dataset: Wirral Business Rates (NNDR)

About this Dataset

Wirral Business Rates (NNDR)

These datasets contain details of all current Business Rates accounts held with Wirral Borough Council including credits. The datasets represent a snapshot in time and will be updated quarterly. The data has been redacted to comply with the Data Protection Act.
Publisher name: Wirral Metropolitan Borough Council
Last updated: 2023-04-21T04:41:09Z

Tables

Wirral Business Rates (NNDR)

@ukgov.wirral_business_rates_nndr.wirral_business_rates_nndr

399.8 KB
4688 rows
38 columns


CREATE TABLE wirral_business_rates_nndr (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "account_name_1" VARCHAR,
  "account_name_2" VARCHAR,
  "property_address_1" VARCHAR,
  "property_address_2" VARCHAR,
  "property_address_3" VARCHAR,
  "property_address_4" VARCHAR,
  "property_address_5" VARCHAR,
  "property_address_6" VARCHAR,
  "property_postcode" VARCHAR,
  "ba_reference" VARCHAR,
  "account_address_1" VARCHAR,
  "account_address_2" VARCHAR,
  "account_address_3" VARCHAR,
  "account_address_4" VARCHAR,
  "account_postcode" VARCHAR,
  "liability_start" TIMESTAMP,
  "empty_prop" VARCHAR,
  "empty_from" TIMESTAMP,
  "account_exemption" VARCHAR,
  "property_exemption" VARCHAR,
  "n_2010_rv" BIGINT,
  "n_2005_rv" DOUBLE,
  "voa_description" VARCHAR,
  "rv_chargeable" BIGINT,
  "charge_16_17" VARCHAR,
  "min_date_from_sbrr" TIMESTAMP,
  "lower_multiplier" VARCHAR,
  "sbrr" VARCHAR,
  "trans_relief" VARCHAR,
  "min_date_from_relief" TIMESTAMP,
  "max_date_to_relief" TIMESTAMP,
  "mand_relief" VARCHAR,
  "mand_relief_amount" VARCHAR,
  "disc_relief" VARCHAR,
  "disc_relief_amount" VARCHAR,
  "reoccupation_relief" VARCHAR
);

NNDR Data To July 2019

@ukgov.wirral_business_rates_nndr.nndr_data_to_july_2019

473.04 KB
5066 rows
40 columns


CREATE TABLE nndr_data_to_july_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,
  "liable_from" TIMESTAMP,
  "empty_prop" VARCHAR,
  "empty_from" TIMESTAMP,
  "account_exemption" VARCHAR,
  "property_exemption" VARCHAR,
  "n_2017_rv" BIGINT,
  "n_2010_rv" DOUBLE,
  "rv_chargeable" BIGINT,
  "charge_201920" VARCHAR,
  "min_date_from_sbrr" TIMESTAMP,
  "lower_multiplier" VARCHAR,
  "sbrr_relief" VARCHAR,
  "trans_relief" VARCHAR,
  "trans_prem" VARCHAR,
  "min_date_from_relief" TIMESTAMP,
  "max_date_to_relief" TIMESTAMP,
  "mandatory" VARCHAR,
  "mand_relief" VARCHAR,
  "discretionary" VARCHAR,
  "disc_relief" VARCHAR,
  "local_discount_type" VARCHAR,
  "local_discount_amount" VARCHAR,
  "property_description" VARCHAR
);

NNDR Data To April 2019

@ukgov.wirral_business_rates_nndr.nndr_data_to_april_2019

466.96 KB
5041 rows
40 columns


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