Wirral Business Rates (NNDR)

Wirral Metropolitan Borough Council

@ukgov.wirral_business_rates_nndr

Table List

3 tables(1.31 MB)

NNDR Data To July 2019

NNDR Data To April 2019

NNDR Data To July 2019

@ukgov.wirral_business_rates_nndr.nndr_data_to_july_2019

473.04 KB
5066 rows
40 columns

organisationlabel OrganisationLabel	organisationuri OrganisationURI	accountname1 AccountName1	accountname2 AccountName2	propertyaddress3 PropertyAddress3	propertyaddress4 PropertyAddress4	propertyaddress5 PropertyAddress5	propertyaddress6 PropertyAddress6	propertypostcode PropertyPostcode	bareference BAReference	accountaddress1 AccountAddress1	accountaddress2 AccountAddress2	accountaddress3 AccountAddress3	accountaddress4 AccountAddress4	accountpostcode AccountPostcode	liable_from Liable From	empty_from Empty From	n_2017_rv 2017 RV	n_2010_rv 2010 RV	rv_chargeable Rv Chargeable	charge_201920 Charge 201920	min_date_from_sbrr MIN Date From Sbrr	lower_multiplier Lower Multiplier	sbrr_relief Sbrr Relief	trans_relief Trans Relief	trans_prem Trans Prem	min_date_from_relief MIN Date From Relief	max_date_to_relief MAX Date To Relief	mandatory Mandatory	mand_relief Mand Relief	discretionary Discretionary	disc_relief Disc Relief	local_discount_type Local Discount (Type)	local_discount_amount Local Discount (Amount)	property_description Property Description
Wirral Metropolitan Borough Council	http://opendatacommunities.org/ID/metropolitan-district-council/wirral	SANTANDER UK PLC		OFFICES AT	32 GRANGE ROAD	WIRRAL	MERSEYSIDE	CH48 4DY	0007437000320A	C/O GL HEARN MANAGEMENT LTD	PO BOX 1821	SOUTHAMPTON		SO18 9NA	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 31 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	14000	14000	6874	Ł6,874.00		SBRR Multiplier Used in Calculation	Ł0.00	Ł0.00	Ł0.00				Ł0.00		Ł0.00			OFFICES AND PREMISES
Wirral Metropolitan Borough Council	http://opendatacommunities.org/ID/metropolitan-district-council/wirral	UTILITIES DEPT BEEFEATER	C/O GERALD EVE	GLEGG ARMS HOTEL	CHESTER ROAD	WIRRAL		CH60 3SD	82170000109	35 KINGS HILL AVENUE	WEST MALLING	KENT		ME19 4DN	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 31 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	281000	221000	141624	Ł141,624.00			Ł0.00	Ł0.00	Ł0.00				Ł0.00		Ł0.00			PUBLIC HOUSE AND PREMISES
Wirral Metropolitan Borough Council	http://opendatacommunities.org/ID/metropolitan-district-council/wirral	BOOTS UK LTD (STORE 1161)		209-215 GRANGE ROAD	BIRKENHEAD	MERSEYSIDE		CH41 2PH	24970021504	C/O GERALD EVE	35 KINGS HILL AVENUE	WEST MALLING	KENT	ME19 4DN	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 31 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	163000	226000	82152	Ł95,715.86			Ł0.00	Ł0.00	Ł22,990.78				Ł0.00		Ł0.00			SHOP AND PREMISES
Wirral Metropolitan Borough Council	http://opendatacommunities.org/ID/metropolitan-district-council/wirral	THE ROYAL BRITISH LEGION		ELMSLEA	PARK ROAD EAST	BIRKENHEAD	MERSEYSIDE	CH41 4BE	17120000502	EMSLEA	PARK ROAD EAST	BIRKENHEAD	WIRRAL	CH41 4BE	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 31 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	9400	8200	4737	Ł0.00			Ł0.00	-Ł129.82	Ł0.00	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Jan 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	80%	-Ł3,498.22	20%	-Ł874.56			OFFICES AND PREMISES
Wirral Metropolitan Borough Council	http://opendatacommunities.org/ID/metropolitan-district-council/wirral	CORAVIEW LTD		THORNTON HALL	NESTON ROAD	WIRRAL	MERSEYSIDE	CH63 1JF	65640001109	THORNTON HALL	NESTON ROAD	WIRRAL		CH63 1JF	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 31 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	344000	305000	173376	Ł173,376.00			Ł0.00	Ł0.00	Ł0.00				Ł0.00		Ł0.00			HOTEL AND PREMISES
Wirral Metropolitan Borough Council	http://opendatacommunities.org/ID/metropolitan-district-council/wirral	BOOTS HEARING CARE LTD		3	CHARING CROSS	BIRKENHEAD	MERSEYSIDE	CH41 6EJ	450000303	21 TRINITY SQUARE	LLANDUDNO			LL30 2RH	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 31 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	4200	4200	2062	Ł1,374.80		SBRR Multiplier Used in Calculation	Ł0.00	Ł0.00	Ł0.00				Ł0.00		Ł0.00	RTLD	-Ł687.40	SHOP AND PREMISES
Wirral Metropolitan Borough Council	http://opendatacommunities.org/ID/metropolitan-district-council/wirral	CARLTON LITTLE THEATRE TRUST		THE LITTLE THEATRE	7A GRANGE ROAD WEST	BIRKENHEAD	MERSEYSIDE	CH41 4BY	890000702	THE LITTLE THEATRE	7A GRANGE ROAD WEST	BIRKENHEAD	WIRRAL	CH41 4BY	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 31 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	8500	9500	4284	Ł0.00			Ł0.00	Ł0.00	Ł0.00	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Jan 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	80%	-Ł3,257.20	20%	-Ł814.30			THEATRE AND PREMISES
Wirral Metropolitan Borough Council	http://opendatacommunities.org/ID/metropolitan-district-council/wirral	CHRIS PLUCK		61 OXTON ROAD	BIRKENHEAD	WIRRAL		CH41 2TL	1290006104	61 OXTON ROAD	BIRKENHEAD	WIRRAL		CH41 2TL	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 31 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	5300	3750	2602	Ł0.00	Sun Oct 30 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	SBRR Multiplier Used in Calculation	-Ł1,658.76	-Ł811.04	Ł0.00				Ł0.00		Ł0.00			SHOP AND PREMISES
Wirral Metropolitan Borough Council	http://opendatacommunities.org/ID/metropolitan-district-council/wirral	LOOKERS PLC		19-23 WOODCHURCH ROAD	BIRKENHEAD	WIRRAL		CH42 9LG	1770001907	776 CHESTER ROAD	STRETFORD	MANCHESTER		M32 0QH	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 31 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	5100	5100	2504	Ł2,504.10		SBRR Multiplier Used in Calculation	Ł0.00	Ł0.00	Ł0.00				Ł0.00		Ł0.00			LAND USED FOR STORAGE AND PREMISES
Wirral Metropolitan Borough Council	http://opendatacommunities.org/ID/metropolitan-district-council/wirral	LOOKERS PLC		LOOKERS G B & E LTD	WOODCHURCH ROAD	BIRKENHEAD	WIRRAL	CH42 9LG	1770002007	776 CHESTER ROAD	STRETFORD	MANCHESTER		M32 0QH	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 31 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	108000	92000	54432	Ł54,432.00			Ł0.00	Ł0.00	Ł0.00				Ł0.00		Ł0.00			CAR SHOWROOM AND PREMISES


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