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

NNDR Data To April 2019

@ukgov.wirral_business_rates_nndr.nndr_data_to_april_2019

478.17 kB
5,041 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  -- 2017 RV,
  "n_2010_rv" DOUBLE  -- 2010 RV,
  "rv_chargeable" BIGINT,
  "charge_19_20" VARCHAR,
  "mindatefromsbrr" TIMESTAMP,
  "lowermultiplier" VARCHAR,
  "sbrr" VARCHAR,
  "transrelief" VARCHAR,
  "transprem" VARCHAR,
  "mindatefromrelief" TIMESTAMP,
  "maxdatetorelief" TIMESTAMP,
  "mandrelief" VARCHAR  -- MandRelief%,
  "mandreliefamount" VARCHAR,
  "discrelief" VARCHAR  -- DiscRelief%,
  "discreliefamount" VARCHAR,
  "localdiscount_type" VARCHAR,
  "localdiscountamount" VARCHAR,
  "voadescription" VARCHAR
);

NNDR Data To July 2019

@ukgov.wirral_business_rates_nndr.nndr_data_to_july_2019

484.39 kB
5,066 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  -- 2017 RV,
  "n_2010_rv" DOUBLE  -- 2010 RV,
  "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 (Type),
  "local_discount_amount" VARCHAR  -- Local Discount (Amount),
  "property_description" VARCHAR
);

Wirral Business Rates (NNDR)

@ukgov.wirral_business_rates_nndr.wirral_business_rates_nndr

409.4 kB
4,688 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  -- 2010 RV,
  "n_2005_rv" DOUBLE  -- 2005 RV,
  "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 %,
  "mand_relief_amount" VARCHAR,
  "disc_relief" VARCHAR  -- Disc Relief %,
  "disc_relief_amount" VARCHAR,
  "reoccupation_relief" VARCHAR
);