Business Rates

n_2_23258e_12 2.23258E+12	billing_authority_reference Billing Authority Reference	ratepayer Ratepayer	property_address Property Address	postcode Postcode	empty_property Empty Property	empty_from Empty From	liable_from Liable From	rateable_value Rateable Value	description_code Description Code	description Description	empty_exempt Empty Exempt	mandatory_rate_relief Mandatory Rate Relief	discretioinary_rate_relief Discretioinary Rate Relief	small_business_rate_relief Small Business Rate Relief	local_discount Local Discount	discount_type Discount Type
72543114	2222150000000	GUISELEY& DIST FACT WORKERS CLUB & INSTITUTE	6 TOWN STREET GUISELEY LEEDS	LS20 9DT			Sun Oct 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	6300	CL2	CLUB AND PREMISES	N			-3143.7
72753547	2054290000000	TOM MAXWELL FURNITURE & CABINETRY LTD	UNIT 35 AIRE PLACE MILLS KIRKSTALL ROAD LEEDS	LS3 1JJ			Sat May 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	8100	IF3	Workshop and Premises	N			-3709.69
72296830	2222150000000	YEADON AMATEUR OPERATIC & DRAMATIC SOCIETY	CEMETERY CHAPEL CEMETERY ROAD YEADON LEEDS	LS19 6AH			Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	3600	CW3	STORE AND PREMISES	N	-1474.56	-184.32
72554701	2232500000000	YORKSHIRE PRO PAVING & GROUNDWORKS LTD	1ST FLOOR 66A BOROUGHGATE OTLEY	LS21 1AE			Mon Feb 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	4650	CO	OFFICES AND PREMISES	N			-2320.35
72411553	2253380000000	GREEN AYURVEDA WELLNESS CENTRE & HOLISTIC SPA LTD	UNIT 452 BIRCH PARK THORP ARCH ESTATE WETHERBY	LS23 7FG			Sat Dec 31 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	16000	IF3	HEALTH SPA AND PREMISES	N				-3955.69	Retail, Hospitality & Leisure
72668792	2011340000000	GREEN DEAL ECO BOILERS & INSULATION LTD	UNIT 17 UNITY BUSINESS CENTRE ROUNDHAY ROAD LEEDS	LS7 1AB			Wed Jun 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2125	IF3	WORKSHOP AND PREMISES	N			-1060.38
72236252	2011800000000	CARING TOGETHER IN WOODHOUSE & LITTLE LONDON	127 WOODHOUSE STREET HEADINGLEY LEEDS	LS6 2UZ	Yes	Thu Oct 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Oct 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	5300	CS	SHOP AND PREMISES	N
72672313	2023670000000	YORKSHIRE OFFICE SUPPLIES & PRINT LIMITED	OFFICE 5 PHASE 1 BROOKLANDS COURT TUNSTALL ROAD LEEDS	LS11 5HL			Tue Jul 12 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	4000	CO	OFFICE AND PREMISES	N			-1996
72002841	2165140000000	MANNING STAINTON RENTALS & PROPERTY MANAGEMENT LTD	9 ALLERTON AVENUE MOORTOWN LEEDS	LS17 6RE			Tue Oct 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	23500	CS	SHOP AND PREMISES	N				-5809.92	Retail, Hospitality & Leisure
72776445	2130250000000	MANGUNI MAKHOSI STRATEGY & REPORTING LIMITED	OFFICE 10 2ND FLR EVANS BUSINESS CENTRE BURLEY TRADING EST, BURLEY ROAD LEEDS	LS4 2PU			Mon Aug 10 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	2850	CO	Offices and Premises	N


CREATE TABLE n_10_06_2021 (
  "n_2_23258e_12" DOUBLE,
  "billing_authority_reference" DOUBLE,
  "ratepayer" VARCHAR,
  "property_address" VARCHAR,
  "postcode" VARCHAR,
  "empty_property" VARCHAR,
  "empty_from" TIMESTAMP,
  "liable_from" TIMESTAMP,
  "rateable_value" BIGINT,
  "description_code" VARCHAR,
  "description" VARCHAR,
  "empty_exempt" VARCHAR,
  "exemption_type" VARCHAR,
  "mandatory_rate_relief" DOUBLE,
  "discretioinary_rate_relief" DOUBLE,
  "small_business_rate_relief" DOUBLE,
  "local_discount" DOUBLE,
  "discount_type" VARCHAR
);