Business Rates

uprn UPRN	propref Propref	ratepayer Ratepayer	address Address	postcode Postcode	latitude Latitude	longitude Longitude	empty_prop Empty Prop	empty_from Empty From	liable_from Liable From	rateable_value Rateable Value	description_code Description Code	property_description Property Description	exempt_epr Exempt Epr	mand_relief Mand Relief	sbrr_relief Sbrr Relief	net_local_disc Net Local Disc	total_discretionary Total Discretionary
72560596	2010110000000	GET AWAY GIRLS	67 BAYSWATER GROVE HAREHILLS LEEDS	LS8 5LN	53.8108	-1.51922			Thu Nov 30 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	8500	CO	OFFICES AND PREMISES	N	-3481.6
72015840	2010110000000	INCHMERY LTD	111/113 BAYSWATER ROAD HAREHILLS LEEDS	LS8 5NT	53.80956	-1.5182	Y	Tue Apr 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Aug 06 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	10750	CS	SHOP AND PREMISES	N
72015822	2010110000000	BAYSWATER GROUP LTD	94 BAYSWATER ROAD HAREHILLS LEEDS	LS8 5NT	53.80956	-1.5182			Tue Nov 14 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	5800	CS	SHOP AND PREMISES	N		-2894.2
72015919	2010110000000	LEEDS ANIMATION WORKSHOP LTD	45 BAYSWATER ROW LEEDS	LS8 5LF	53.81119	-1.5192			Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	3100	CO	OFFICES AND PREMISES	N		-1546.9
72673717	2010110000000	CLEAR CHANNEL UK LIMITED	ADSHEL SITE REF 0704 0862 OPP BECKETT WING BECKETT STREET LEEDS	LS9 7LS	53.80276	-1.52446			Wed Nov 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	850	CA	ADVERTISING RIGHT AND PREMISES	N
72673735	2010110000000	CLEAR CHANNEL UK LIMITED	ADVERTISING RIGHT 0704 0863 AT ST JAMES HOSPITAL BECKETT STREET LEEDS	LS9 7JZ	53.80528	-1.52297			Wed Nov 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	850	CA	ADVERTISING RIGHT AND PREMISES	N
72670087	2010110000000	CLEAR CHANNEL UK LIMITED	ADVERT RIGHT SITE REF 0704 0904 OPP BECKETT WING BECKETT STREET LEEDS	LS9 7TF	53.80686	-1.52035			Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	850	CA	ADVERTISING RIGHT AND PREMISES	N
72563680	2010110000000	THACKRAY MEDICAL MUSEUM CO LTD	THACKRAY MEDICAL MUSEUM BECKETT STREET BURMANTOFTS LEEDS	LS9 7LN	53.80818	-1.51867			Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	262500	EM1	MUSEUM AND PREMISES	N	-107520		-26880	-26880
72673719	2010110000000	LEEDS TEACHING HOSPITALS NHS TRUST	POST GRADUATE MEDICAL EDUCATION CENTRE BECKETT STREET BURMANTOFTS LEEDS	LS9 7LP	53.8038	-1.52349			Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	11750	CO	LECTURE ROOMS AND PREMISES	N
72748995	2010120000000	BHE (ST JAMES) LIMITED	UNIT 18 GLEDHOW WING ST JAMES HOSPITAL BECKETT STREET LEEDS	LS9 7TF	53.80686	-1.52035	Y	Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Aug 29 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	4200	CS	SHOP AND PREMISES	N


CREATE TABLE n_26_06_2020 (
  "uprn" DOUBLE,
  "propref" DOUBLE,
  "ratepayer" VARCHAR,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "empty_prop" VARCHAR,
  "empty_from" TIMESTAMP,
  "liable_from" TIMESTAMP,
  "rateable_value" BIGINT,
  "description_code" VARCHAR,
  "property_description" VARCHAR,
  "exempt_epr" VARCHAR,
  "exemption_type" VARCHAR,
  "mand_relief" DOUBLE,
  "disc_relief" DOUBLE,
  "sbrr_relief" DOUBLE,
  "net_local_disc" DOUBLE,
  "total_discretionary" DOUBLE,
  "disc_type_code" VARCHAR
);