Business Rates

billing_authority_reference Billing Authority Reference	ratepayer Ratepayer	charged_from Charged From	mandatory_relief Mandatory Relief %	discretionary_relief_percent Discretionary Relief % Percent	small_business_relief Small Business Relief %	empty_property Empty Property	exempt_empty_rates Exempt Empty Rates	empty_from Empty From	address Address	addr2 Addr2	addr3 Addr3	addr4 Addr4	postcode Postcode	description_code Description Code	property_description Property Description	rateable_value Rateable Value
2050827484287	(A Q) NETWORKS LTD	Mon Aug 11 2008 00:00:00 GMT+0000 (Coordinated Universal Time)				No	No		11- 13 HUNSLET ROAD	LEEDS			LS10 1JQ	CO	OFFICES AND PREMISES	£14,750
2232500318644	02 FISH AND CHIPS LTD	Fri Jul 19 2013 00:00:00 GMT+0000 (Coordinated Universal Time)			100	No	No		17 BRIDGE STREET	OTLEY			LS21 1BQ	CS	SHOP AND PREMISES	£5,100
2024426329249	06 MARKETING LTD	Tue Apr 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)				No	No		UNIT 6B	MILLSHAW PARK CLOSE	LEEDS		LS11 0LW	CW	WAREHOUSE AND PREMISES	£18,250
2101662101039	1 STOP PROPERTY SHOP LIMITED	Mon Nov 18 2013 00:00:00 GMT+0000 (Coordinated Universal Time)			91.67	No	No		A J FASHIONS	185 TOWN STREET	ARMLEY	LEEDS	LS12 3RA	CS	SHOP AND PREMISES	£6,500
2041346306594	101 IT LTD	Mon Nov 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)			98.33	No	No		SUITE 1E	GLEDHOW MOUNT MANSION	ROXHOLME GROVE	LEEDS	LS7 4JJ	CO	OFFICES AND PREMISES	£6,100
2222192100719	10TH AIREDALE SCOUT GROUP	Fri Apr 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	80	10		No	No		SCOUT HALL	R/O ST PETER & PAUL RC CHURCH	NEW ROAD, YEADON	LEEDS	LS19 7DA	LC3	HALL AND PREMISES	£3,650
2120273638739	116 CARDIGAN ROAD LIMITED	Sat Aug 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)				Yes	Yes	Sat Aug 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	ROOM LG1 AT	116 CARDIGAN ROAD	LEEDS		LS6 3BJ	CO	Offices and Premises	£2,200
2120273638750	116 CARDIGAN ROAD LIMITED	Sat Aug 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)				Yes	No	Sat Aug 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	ROOM LG2 AT	116 CARDIGAN ROAD	LEEDS		LS6 3BJ	CO	Offices and Premises	£2,600
2120273638772	116 CARDIGAN ROAD LIMITED	Sat Aug 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)				Yes	No	Sat Aug 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	ROOM LG4 AT	116 CARDIGAN ROAD	LEEDS		LS6 3BJ	CO	Store and Premises	£4,500
2120273638794	116 CARDIGAN ROAD LIMITED	Sat Aug 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)				Yes	No	Sat Aug 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	ROOM GF2 AT	116 CARDIGAN ROAD	LEEDS		LS6 3BJ	CO	Offices and Premises	£3,150


CREATE TABLE n_25_01_2016 (
  "billing_authority_reference" BIGINT,
  "ratepayer" VARCHAR,
  "charged_from" TIMESTAMP,
  "mandatory_relief" BIGINT,
  "discretionary_relief_percent" BIGINT,
  "small_business_relief" DOUBLE,
  "local_discount" DOUBLE,
  "discount_type" VARCHAR,
  "empty_property" VARCHAR,
  "exempt_empty_rates" VARCHAR,
  "empty_from" TIMESTAMP,
  "address" VARCHAR,
  "addr2" VARCHAR,
  "addr3" VARCHAR,
  "addr4" VARCHAR,
  "postcode" VARCHAR,
  "description_code" VARCHAR,
  "property_description" VARCHAR,
  "rateable_value" VARCHAR
);