Business Rates

property_reference_number Property Reference Number	ba_reference_number BA Reference Number	ratepayer Ratepayer	address Address	postcode Postcode	latitude Latitude	longitude Longitude	occupied Occupied	liability_start_date Liability Start Date	empty_from Empty From	rateable_value Rateable Value (Ł)	voa_code VOA Code	voa_description VOA Description	mandatory_relief Mandatory Relief (Ł)	small_business_rate_relief Small Business Rate Relief (Ł)	total_relief Total Relief (Ł)
72291086	2334451501953	WOODHOUSE GROVE SCHOOL	WOODHOUSE GROVE SCHOOL APPERLEY BRIDGE BRADFORD	BD10 0NR	53.840429	-1.699713	Y	Thu Apr 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)		515000	EP	SCHOOL AND PREMISES	-207648		-207648
72291085	2334451331923	WOODHOUSE GROVE SCHOOL	INTERNATIONAL HARVESTERS APPERLEY BRIDGE BRADFORD	BD10 0NU	#N/A	#N/A	Y	Tue Oct 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)		11250	LS	SPORTS GROUND AND PREMISES	-4536		-4536
72291100	2332083100646	JCT 600 LIMITED	APPERLEY MANOR APPERLEY LANE RAWDON LEEDS	BD10 0PQ	53.843174	-1.701289	Y	Fri Dec 15 2006 00:00:00 GMT+0000 (Coordinated Universal Time)		103000	CO	OFFICES AND PREMISES
72547379	2302642370441	DAVID PEAT PEAT PROPERTIES	UNIT 3 MANOR PARK WORKS KING STREET DRIGHLINGTON BRADFORD	BD11 1AA	53.755933	-1.659502	N	Sat Mar 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Mar 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	4000	IF3	WORKSHOP AND PREMISES
72721958	2302642641925	LIFTEC (LEEDS) LTD	UNITS 2 & 6 MANOR PARK WORKS KING STREET DRIGHLINGTON BRADFORD	BD11 1AA	53.755933	-1.659502	Y	Tue Mar 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)		6100	IF3	WORKSHOP AND PREMISES		-2874.15	-2874.15
72563477	2302642313213	PRIMESIGHT LTD	ADVERT RIGHT NO 2171 GABLE 135 KING STREET DRIGHLINGTON BRADFORD	BD11 1AA	53.755933	-1.659502	Y	Tue Sep 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)		840	CA	ADVERTISING RIGHT AND PREMISES
72547387	2302642369974	SENIOR ENGINEERING SERVICES LTD	UNITS 1/2 MANOR PARK INDUSTRIAL ESTATE KING STREET DRIGHLINGTON BRADFORD	BD11 1AA	53.755933	-1.659502	Y	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)		25250	IF3	WORKSHOP AND PREMISES
72352819	2302639314748	TEMPEST CONSTITUTIONAL CLUB	34 BRADFORD ROAD DRIGHLINGTON BRADFORD	BD11 1AB	53.75786	-1.663946	Y	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)		5900	CL2	CLUB AND PREMISES		-2896.9	-2896.9
72731319	2302653631193	WH PROPERTY & ENGINEERING CONSULTANTS LTD	UNIT 3 ATLAS HOUSE 5 BRADFORD ROAD DRIGHLINGTON BRADFORD	BD11 1AS	53.757266	-1.663632	Y	Wed May 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)		5100	CO	OFFICES AND PREMISES		-2504.1	-2504.1
72731317	2302653631182	AJD PROPERTIES LTD	UNITS 1 & 2 ATLAS HOUSE 5 BRADFORD ROAD DRIGHLINGTON BRADFORD	BD11 1AS	53.757266	-1.663632	Y	Mon Apr 16 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		9500	CO	OFFICES AND PREMISES


CREATE TABLE n_14_04_2019 (
  "property_reference_number" DOUBLE,
  "ba_reference_number" BIGINT,
  "ratepayer" VARCHAR,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "occupied" VARCHAR,
  "liability_start_date" TIMESTAMP,
  "empty_from" TIMESTAMP,
  "rateable_value" BIGINT,
  "voa_code" VARCHAR,
  "voa_description" VARCHAR,
  "exempt_from" TIMESTAMP,
  "exemption_type" VARCHAR,
  "mandatory_relief" DOUBLE,
  "discretionary_relief" DOUBLE,
  "local_discount" DOUBLE,
  "small_business_rate_relief" DOUBLE,
  "unnamed_19" VARCHAR,
  "total_relief" DOUBLE
);