Business Rates

uprn Uprn	b_a_reference B A Reference	account_holder1 Account Holder1	address Address	postcode Postcode	liable_from Liable From	rv Rv	vo_prop_desc_code Vo Prop Desc Code	vo_propdescrip Vo Propdescrip	exempt_epr Exempt Epr	mand_relief Mand Relief	disc_relief Disc Relief	sbrr_relief Sbrr Relief	net_local_disc Net Local Disc	field18 Field18	field19 Field19	field20 Field20	field21 Field21	field0 Field0
72557453	2324572551662	MARKS & SPENCER PLC	MARKS & SPENCER PLC OWLCOTES SHOPPING CENTRE VARLEY STREET STANNINGLEY, PUDSEY	LS28 6AN	Mon Mar 26 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2880000	CS	Shop and Premises	N	£0.00	£0.00	£0.00	-£1,474,560.00	2324572551662		2324572551662	-£1,474,560.00	2324572551662
72557455	2324572659903	ASDA STORES LTD	ASDA STORES LTD OWLCOTES CENTRE PUDSEY	LS28 6AN	Wed Apr 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2670000	CS9	Superstore and Premises	N	£0.00	£0.00	£0.00	-£1,384,823.13	2324572659903		2324572659903	-£1,384,823.13	2324572659903
72027083	2050201353564	MARKS & SPENCER PLC	44/45/47 BRIGGATE LEEDS	LS1 6HD	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	2390000	CS	SHOP AND PREMISES	N	£0.00	£0.00	£0.00	-£1,223,680.00	2050201353564		2050201353564	-£1,223,680.00	2050201353564
72507829	2084080578117	TESCO STORES LTD	TESCO EXTRA UNIT 5 SEACROFT GREEN SHOPPING CENTRE SEACROFT CRESCENT LEEDS	LS14 6PA	Mon Feb 19 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2170000	CS9	SUPERSTORE AND PREMISES	N	£0.00	£0.00	£0.00	-£1,111,040.00	2084080578117		2084080578117	-£1,111,040.00	2084080578117
72394479	2293371667194	ASDA STORES LTD	ASDA STORES LTD, ASDA SUPERMARKET HOWLEY PARK ROAD MORLEY LEEDS	LS27 0BP	Wed Apr 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2160000	CS9	SUPERSTORE AND PREMISES	N	£0.00	£0.00	£0.00	-£1,105,920.00	2293371667194		2293371667194	-£1,105,920.00	2293371667194
72247070	2031820519542	ASDA STORES LTD	ASDA STORES LTD YORK ROAD LEEDS	LS14 6UF	Thu Apr 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	1910000	CS9	SUPERSTORE AND PREMISES	N	£0.00	£0.00	£0.00	-£977,920.00	2031820519542		2031820519542	-£977,920.00	2031820519542
72723248	2055202619896	PRIMARK STORES LTD	342 TRINITY LEEDS ALBION STREET LEEDS	LS1 5AR	Tue Dec 03 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	1840000	CS	SHOP AND PREMISES	N	£0.00	£0.00	£0.00	-£942,080.00	2055202619896		2055202619896	-£942,080.00	2055202619896
72027144	2050201368836	DEBENHAMS RETAIL PLC	121 BRIGGATE LEEDS	LS1 6LX	Tue May 14 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	1800000	CS	SHOP AND PREMISES	N	£0.00	£0.00	£0.00	-£921,600.00	2050201368836		2050201368836	-£921,600.00	2050201368836
72747164	2055236663190	JOHN LEWIS PLC	UNIT 45 VICTORIA GATE HAREWOOD STREET LEEDS	LS2 7AR	Thu Oct 20 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1800000	CS	SHOP AND PREMISES	N	£0.00	£0.00	£0.00	-£921,600.00	2055236663190		2055236663190	-£921,600.00	2055236663190
72369232	2024776554445	SAINSBURY'S SUPERMARKETS LTD	SAVACENTRE WHITE ROSE SHOPPING CENTRE LEEDS	LS11 8LS	Thu Jan 04 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1710000	CS9	Superstore and Premises	N	£0.00	£0.00	£0.00	-£875,520.00	2024776554445	-110114810099	2134891364544	-£875,520.00	2024776554445


CREATE TABLE n_05_02_2021 (
  "uprn" DOUBLE,
  "b_a_reference" BIGINT,
  "account_holder1" VARCHAR,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "emptty_property" VARCHAR,
  "empty_from" TIMESTAMP,
  "liable_from" TIMESTAMP,
  "rv" BIGINT,
  "vo_prop_desc_code" VARCHAR,
  "vo_propdescrip" VARCHAR,
  "exempt_epr" VARCHAR,
  "exemption_type" VARCHAR,
  "mand_relief" VARCHAR,
  "disc_relief" VARCHAR,
  "sbrr_relief" VARCHAR,
  "net_local_disc" VARCHAR,
  "field18" BIGINT,
  "field19" DOUBLE,
  "field20" DOUBLE,
  "field21" VARCHAR,
  "field0" BIGINT
);