Business Rates

ratepayer Ratepayer	liable_from Liable From	mandatory_relief Mandatory Relief %	discretionary_relief Discretionary Relief %	small_business_relief Small Business Relief %	local_discount Local Discount (£)	property_status Property Status	exempt_epr Exempt Epr	empty_from Empty From	addr1 Addr1	addr2 Addr2	addr3 Addr3	addr4 Addr4	postcode Postcode	rateable_value Rateable Value	description_code Description Code	description Description	b_a_reference B A Reference
GUISELEY& DIST FACT WORKERS CLUB & INSTITUTE	Sun Oct 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	£95.00	£0.00	Occupied Property	N		6 TOWN STREET	GUISELEY	LEEDS		LS20 9DT	6300	CL2	CLUB AND PREMISES	2222145437151
KARL JOHNSON T/A OASIS CARAVAN & CAMPING ACCESSORIES	Thu Oct 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	£100.00	£0.00	Occupied Property	N		OFFICE G8	WEST POINT	WESTLAND SQUARE	LEEDS	LS11 5SS	4400	CO	Offices and Premises	2023929529079
YEADON AMATEUR OPERATIC & DRAMATIC SOCIETY	Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	£80.00	£0.00	£0.00	£0.00	Occupied Property	N		CEMETERY CHAPEL	CEMETERY ROAD	YEADON	LEEDS	LS19 6AH	3250	CW3	STORE AND PREMISES	2222152355020
MARCO ISLAND DEVELOPMENTS LTD & ENTERPRISE INVESTMENTS LTD	Mon Oct 03 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	£0.00	£0.00	Empty Property	N	Mon Oct 03 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	ROYAL BANK OF SCOTLAND	COTE LANE	FARSLEY	PUDSEY	LS28 5GF	975000	CO	OFFICES AND PREMISES	2321923420430
WORLEYPARSONS INFRATRUTURE & ENVIRONMENT LTD	Tue May 05 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	£0.00	£0.00	Occupied Property	N		MOORFIELD COURT	11A ALMA ROAD	HEADINGLEY	LEEDS	LS6 2AH	39000	CO	OFFICES AND PREMISES	2120016310273
REDWOOD ENGINEERING & FABRICATION LTD	Sat Jun 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	£0.00	£0.00	Occupied Property	N		UNIT B2 SCOTCH PARK TRADING ESTATE	FORGE LANE	LEEDS		LS12 2PY	16500	IF3	WORKSHOP AND PREMISES	2104069309338
REDWOOD ENGINEERING & FABRICATION LTD	Sat Jun 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	£0.00	£0.00	Occupied Property	N		UNITS B3 & L	SCOTCH PARK TRADING ESTATE	FORGE LANE	LEEDS	LS12 2PY	23250	IF3	WORKSHOP AND PREMISES	2104069655060
BRITISH ASSOCIATION FOR ADOPTION & FOSTERING	Fri Jul 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	£0.00	£0.00	Occupied Property	N		G/F 4 ROYDS HALL ROAD	PAVILION BUSINESS PARK	LEEDS		LS12 6AJ	24750	CO	Offices and Premises	2214875637199
AQUAHEAT PLUMBING HEATING & GAS SERVICES LTD	Mon Jan 11 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	£0.00	£0.00	Occupied Property	N		UNIT M	CLAYTON WORKS BUSINESS CENTRE	MIDLAND ROAD	LEEDS	LS10 2RJ	2300	CO	OFFICES AND PREMISES	2073471486212
YORKSHIRE PRO PAVING & GROUNDWORKS LTD	Mon Feb 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	£0.00	£0.00	£100.00	£0.00	Occupied Property	N		1ST FLOOR	66A BOROUGHGATE	OTLEY		LS21 1AE	4500	CO	OFFICES AND PREMISES	2232496307534


CREATE TABLE n_04_11_2016 (
  "ratepayer" VARCHAR,
  "liable_from" TIMESTAMP,
  "mandatory_relief" VARCHAR,
  "discretionary_relief" VARCHAR,
  "small_business_relief" VARCHAR,
  "local_discount" VARCHAR,
  "property_status" VARCHAR,
  "exempt_epr" VARCHAR,
  "empty_from" TIMESTAMP,
  "addr1" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "rateable_value" BIGINT,
  "description_code" VARCHAR,
  "description" VARCHAR,
  "b_a_reference" BIGINT
);