This is experimental and work-in-progress. Things might not work or even be correct.
Github

Business rates: status

As part of the Open Data Collaboration group we are exploring local council Business Rates data and we've defined a common format for sharing Business Rates data. This page gives the current status of each council at meeting the standards for sharing. If you are a Local Authority and aren't included, add the URL of your CSV file to our index. If the URL of the Business Rates data is out-of-date, update it and send us a pull request. Before you do, you might want to check your file in our business rates validator.

PosLocal authorityLast updatedRowsScoreValid required headingsIncludes required columnsIncludes emptiesValid coordsValid datesValid currency valuesHostedCORS
1Leeds2019-07-252229299.9710/1010/10Yes444782229222292YesYes
2Stockport2019-07-26604699.3010/1010/10Yes1141660466046YesYes
3Calderdale2019-07-22936197.429/109/10Yes1864693519351YesYes
4Hambleton2019-08-23430775.0010/1010/10Yes861443074307No-
5Scarborough2019-04-24238174.5410/1010/10Yes464023682368No-
6Bradford2019-01-171932372.419/109/10Yes385721925119294No-
7Selby2019-06-12267772.389/109/10Yes530226772677No-
8Camden?1900871.283/105/10No342921900819008YesYes
9Wakefield2019-01-171103768.457/108/10Yes217941091011037No-
10Harrogate2019-06-13746054.927/107/10No1482074607460No-
11Kirklees2019-02-081599154.817/107/10No318501590315903No-
12Barnet2019-08-15775339.690/102/10No007562YesYes
13Preston?595327.500/102/10No005953YesNo
14Lambeth2017-10-23642526.250/101/10No000YesYes
14South Gloucestershire2019-06-12728626.250/101/10No000YesYes
16Basingstoke and Deane2019-02-25465725.000/100/10No000YesYes
16North Somerset?638025.000/100/10No000YesYes
16Sheffield2019-02-251813225.000/100/10No000YesYes
19Leicester?2515824.990/100/10No0251300YesNo
20Exeter2019-04-16310116.251/102/10No000YesNo
20Manchester?1508916.251/102/10No000YesNo
20Nottingham2019-08-011169816.251/102/10No000YesNo
23Bolsover2019-01-03238315.001/101/10No000YesNo
23Mole Valley2019-04-05340415.001/101/10No000YesNo
23Oxford?652115.001/101/10No000YesNo
26East Cambridgeshire2019-06-05242013.750/101/10No000YesNo
26Harlow2019-05-10199513.750/101/10No000YesNo
26Lewes2019-04-04367113.750/101/10No000YesNo
26Wirral?504113.750/101/10No000YesNo
26Wokingham2019-05-08443313.750/101/10No000YesNo
31Babergh?012.500/100/10No000YesNo
31Blaby?012.500/100/10No000YesNo
31Cambridge2019-07-12451512.500/100/10No000YesNo
31Eastbourne2019-08-06262912.500/100/10No000YesNo
31Ipswich?472812.500/100/10No000YesNo
31Isle of Wight2019-05-09752012.500/100/10No000YesNo
31Kingston upon Thames?76712.500/100/10No000YesNo
31Northumberland2019-08-221313012.500/100/10No000YesNo
31Rochdale2019-03-19704212.500/100/10No000YesNo
31Rugby?9857612.500/100/10No000YesNo
31Ryedale2019-06-10302412.500/100/10No000YesNo
31Salford?012.500/100/10No000YesNo
31South Lakeland2019-06-19846612.500/100/10No000YesNo
31Thurrock2019-06-14435912.500/100/10No000YesNo
31Tunbridge Wells?55812.500/100/10No000YesNo
31York2019-06-0311073312.500/100/10No000YesNo
47Aberdeen City00.000/100/10No000NoNo
47Aberdeenshire00.000/100/10No000NoNo
47Adur00.000/100/10No000NoNo
47Allerdale00.000/100/10No000NoNo
47Amber Valley00.000/100/10No000NoNo
47Angus00.000/100/10No000NoNo
47Antrim and Newtownabbey00.000/100/10No000NoNo
47Ards and North Down00.000/100/10No000NoNo
47Argyll and Bute00.000/100/10No000NoNo
47Armagh City0.000/100/10No000NoNo
47Arun00.000/100/10No000NoNo
47Ashfield00.000/100/10No000NoNo
47Ashford00.000/100/10No000NoNo
47Aylesbury Vale00.000/100/10No000NoNo
47Barking and Dagenham00.000/100/10No000NoNo
47Barnsley00.000/100/10No000NoNo
47Barrow-in-Furness00.000/100/10No000NoNo
47Basildon00.000/100/10No000NoNo
47Bassetlaw00.000/100/10No000NoNo
47Bath and North East Somerset00.000/100/10No000NoNo
47Bedford00.000/100/10No000NoNo
47Belfast00.000/100/10No000NoNo
47Bexley00.000/100/10No000NoNo
47Birmingham00.000/100/10No000NoNo
47Blackburn with Darwen00.000/100/10No000NoNo
47Blackpool00.000/100/10No000NoNo
47Blaenau Gwent00.000/100/10No000NoNo
47Bolton00.000/100/10No000NoNo
47Boston00.000/100/10No000NoNo
47Bournemouth0.000/100/10No000NoNo
47Bracknell Forest0.000/100/10No000NoNo
47Braintree00.000/100/10No000NoNo
47Breckland00.000/100/10No000NoNo
47Brent00.000/100/10No000NoNo
47Brentwood00.000/100/10No000NoNo
47Bridgend00.000/100/10No000NoNo
47Brighton and Hove00.000/100/10No000NoNo
47Bristol0.000/100/10No000NoNo
47Broadland00.000/100/10No000NoNo
47Bromley00.000/100/10No000NoNo
47Bromsgrove00.000/100/10No000NoNo
47Broxbourne00.000/100/10No000NoNo
47Broxtowe00.000/100/10No000NoNo
47Burnley00.000/100/10No000NoNo
47Bury00.000/100/10No000NoNo
47Caerphilly00.000/100/10No000NoNo
47Cannock Chase00.000/100/10No000NoNo
47Canterbury00.000/100/10No000NoNo
47Cardiff00.000/100/10No000NoNo
47Carlisle00.000/100/10No000NoNo
47Carmarthenshire00.000/100/10No000NoNo
47Castle Point00.000/100/10No000NoNo
47Causeway Coast and Glens00.000/100/10No000NoNo
47Central Bedfordshire00.000/100/10No000NoNo
47Ceredigion00.000/100/10No000NoNo
47Charnwood00.000/100/10No000NoNo
47Chelmsford00.000/100/10No000NoNo
47Cheltenham00.000/100/10No000NoNo
47Cherwell00.000/100/10No000NoNo
47Cheshire East00.000/100/10No000NoNo
47Cheshire West and Chester00.000/100/10No000NoNo
47Chesterfield00.000/100/10No000NoNo
47Chichester00.000/100/10No000NoNo
47Chiltern00.000/100/10No000NoNo
47Chorley00.000/100/10No000NoNo
47City of Edinburgh00.000/100/10No000NoNo
47City of London00.000/100/10No000NoNo
47Clackmannanshire00.000/100/10No000NoNo
47Colchester00.000/100/10No000NoNo
47Conwy00.000/100/10No000NoNo
47Copeland00.000/100/10No000NoNo
47Corby00.000/100/10No000NoNo
47Cornwall00.000/100/10No000NoNo
47Cotswold00.000/100/10No000NoNo
47County Durham00.000/100/10No000NoNo
47Coventry00.000/100/10No000NoNo
47Craven00.000/100/10No000NoNo
47Crawley00.000/100/10No000NoNo
47Croydon00.000/100/10No000NoNo
47Dacorum00.000/100/10No000NoNo
47Darlington00.000/100/10No000NoNo
47Dartford00.000/100/10No000NoNo
47Daventry00.000/100/10No000NoNo
47Denbighshire00.000/100/10No000NoNo
47Derby00.000/100/10No000NoNo
47Derbyshire Dales00.000/100/10No000NoNo
47Derry City and Strabane00.000/100/10No000NoNo
47Doncaster00.000/100/10No000NoNo
47Dorset00.000/100/10No000NoNo
47Dover00.000/100/10No000NoNo
47Dudley00.000/100/10No000NoNo
47Dumfries and Galloway00.000/100/10No000NoNo
47Dundee City00.000/100/10No000NoNo
47Ealing00.000/100/10No000NoNo
47East Ayrshire00.000/100/10No000NoNo
47East Devon00.000/100/10No000NoNo
47East Dunbartonshire00.000/100/10No000NoNo
47East Hampshire00.000/100/10No000NoNo
47East Hertfordshire00.000/100/10No000NoNo
47East Lindsey00.000/100/10No000NoNo
47East Lothian00.000/100/10No000NoNo
47East Northamptonshire00.000/100/10No000NoNo
47East Renfrewshire00.000/100/10No000NoNo
47East Riding of Yorkshire00.000/100/10No000NoNo
47East Staffordshire00.000/100/10No000NoNo
47East Suffolk00.000/100/10No000NoNo
47Eastleigh00.000/100/10No000NoNo
47Eden00.000/100/10No000NoNo
47Elmbridge00.000/100/10No000NoNo
47Enfield00.000/100/10No000NoNo
47Epping Forest00.000/100/10No000NoNo
47Epsom and Ewell00.000/100/10No000NoNo
47Erewash00.000/100/10No000NoNo
47Falkirk00.000/100/10No000NoNo
47Fareham00.000/100/10No000NoNo
47Fenland00.000/100/10No000NoNo
47Fermanagh and Omagh00.000/100/10No000NoNo
47Fife00.000/100/10No000NoNo
47Flintshire00.000/100/10No000NoNo
47Folkestone and Hythe00.000/100/10No000NoNo
47Forest of Dean00.000/100/10No000NoNo
47Fylde00.000/100/10No000NoNo
47Gateshead00.000/100/10No000NoNo
47Gedling00.000/100/10No000NoNo
47Glasgow City00.000/100/10No000NoNo
47Gloucester00.000/100/10No000NoNo
47Gosport00.000/100/10No000NoNo
47Gravesham00.000/100/10No000NoNo
47Great Yarmouth00.000/100/10No000NoNo
47Greenwich00.000/100/10No000NoNo
47Guildford00.000/100/10No000NoNo
47Gwynedd00.000/100/10No000NoNo
47Hackney00.000/100/10No000NoNo
47Halton00.000/100/10No000NoNo
47Hammersmith and Fulham00.000/100/10No000NoNo
47Harborough00.000/100/10No000NoNo
47Haringey00.000/100/10No000NoNo
47Harrow00.000/100/10No000NoNo
47Hart00.000/100/10No000NoNo
47Hartlepool00.000/100/10No000NoNo
47Hastings00.000/100/10No000NoNo
47Havant00.000/100/10No000NoNo
47Havering00.000/100/10No000NoNo
47Herefordshire0.000/100/10No000NoNo
47Hertsmere00.000/100/10No000NoNo
47High Peak00.000/100/10No000NoNo
47Highland00.000/100/10No000NoNo
47Hillingdon00.000/100/10No000NoNo
47Hinckley and Bosworth00.000/100/10No000NoNo
47Horsham00.000/100/10No000NoNo
47Hounslow00.000/100/10No000NoNo
47Huntingdonshire00.000/100/10No000NoNo
47Hyndburn00.000/100/10No000NoNo
47Inverclyde00.000/100/10No000NoNo
47Isle of Anglesey00.000/100/10No000NoNo
47Isles of Scilly00.000/100/10No000NoNo
47Islington00.000/100/10No000NoNo
47Kensington and Chelsea00.000/100/10No000NoNo
47Kettering00.000/100/10No000NoNo
47King's Lynn and West Norfolk00.000/100/10No000NoNo
47Kingston upon Hull0.000/100/10No000NoNo
47Knowsley00.000/100/10No000NoNo
47Lancaster00.000/100/10No000NoNo
47Lewisham00.000/100/10No000NoNo
47Lichfield00.000/100/10No000NoNo
47Lincoln00.000/100/10No000NoNo
47Lisburn and Castlereagh00.000/100/10No000NoNo
47Liverpool00.000/100/10No000NoNo
47Luton00.000/100/10No000NoNo
47Maidstone00.000/100/10No000NoNo
47Maldon00.000/100/10No000NoNo
47Malvern Hills00.000/100/10No000NoNo
47Mansfield00.000/100/10No000NoNo
47Medway00.000/100/10No000NoNo
47Melton00.000/100/10No000NoNo
47Mendip00.000/100/10No000NoNo
47Merthyr Tydfil00.000/100/10No000NoNo
47Merton00.000/100/10No000NoNo
47Mid Devon00.000/100/10No000NoNo
47Mid Suffolk00.000/100/10No000NoNo
47Mid Sussex00.000/100/10No000NoNo
47Mid Ulster00.000/100/10No000NoNo
47Mid and East Antrim00.000/100/10No000NoNo
47Middlesbrough00.000/100/10No000NoNo
47Midlothian00.000/100/10No000NoNo
47Milton Keynes00.000/100/10No000NoNo
47Monmouthshire00.000/100/10No000NoNo
47Moray00.000/100/10No000NoNo
47Na h-Eileanan Siar00.000/100/10No000NoNo
47Neath Port Talbot00.000/100/10No000NoNo
47New Forest00.000/100/10No000NoNo
47Newark and Sherwood00.000/100/10No000NoNo
47Newcastle upon Tyne00.000/100/10No000NoNo
47Newcastle-under-Lyme00.000/100/10No000NoNo
47Newham00.000/100/10No000NoNo
47Newport00.000/100/10No000NoNo
47Newry0.000/100/10No000NoNo
47North Ayrshire00.000/100/10No000NoNo
47North Devon00.000/100/10No000NoNo
47North East Derbyshire00.000/100/10No000NoNo
47North East Lincolnshire00.000/100/10No000NoNo
47North Hertfordshire00.000/100/10No000NoNo
47North Kesteven00.000/100/10No000NoNo
47North Lanarkshire00.000/100/10No000NoNo
47North Lincolnshire00.000/100/10No000NoNo
47North Norfolk00.000/100/10No000NoNo
47North Tyneside00.000/100/10No000NoNo
47North Warwickshire00.000/100/10No000NoNo
47North West Leicestershire00.000/100/10No000NoNo
47Northampton00.000/100/10No000NoNo
47Norwich00.000/100/10No000NoNo
47Nuneaton and Bedworth00.000/100/10No000NoNo
47Oadby and Wigston00.000/100/10No000NoNo
47Oldham00.000/100/10No000NoNo
47Orkney Islands00.000/100/10No000NoNo
47Pembrokeshire00.000/100/10No000NoNo
47Pendle00.000/100/10No000NoNo
47Perth and Kinross00.000/100/10No000NoNo
47Peterborough00.000/100/10No000NoNo
47Plymouth00.000/100/10No000NoNo
47Portsmouth00.000/100/10No000NoNo
47Powys00.000/100/10No000NoNo
47Reading00.000/100/10No000NoNo
47Redbridge00.000/100/10No000NoNo
47Redcar and Cleveland00.000/100/10No000NoNo
47Redditch00.000/100/10No000NoNo
47Reigate and Banstead00.000/100/10No000NoNo
47Renfrewshire00.000/100/10No000NoNo
47Rhondda Cynon Taf00.000/100/10No000NoNo
47Ribble Valley00.000/100/10No000NoNo
47Richmond upon Thames00.000/100/10No000NoNo
47Richmondshire00.000/100/10No000NoNo
47Rochford00.000/100/10No000NoNo
47Rossendale00.000/100/10No000NoNo
47Rother00.000/100/10No000NoNo
47Rotherham00.000/100/10No000NoNo
47Runnymede00.000/100/10No000NoNo
47Rushcliffe00.000/100/10No000NoNo
47Rushmoor00.000/100/10No000NoNo
47Rutland00.000/100/10No000NoNo
47Sandwell00.000/100/10No000NoNo
47Scottish Borders00.000/100/10No000NoNo
47Sedgemoor00.000/100/10No000NoNo
47Sefton00.000/100/10No000NoNo
47Sevenoaks00.000/100/10No000NoNo
47Shetland Islands00.000/100/10No000NoNo
47Shropshire00.000/100/10No000NoNo
47Slough00.000/100/10No000NoNo
47Solihull00.000/100/10No000NoNo
47Somerset West and Taunton00.000/100/10No000NoNo
47South Ayrshire00.000/100/10No000NoNo
47South Bucks00.000/100/10No000NoNo
47South Cambridgeshire00.000/100/10No000NoNo
47South Derbyshire00.000/100/10No000NoNo
47South Hams00.000/100/10No000NoNo
47South Holland00.000/100/10No000NoNo
47South Kesteven00.000/100/10No000NoNo
47South Lanarkshire00.000/100/10No000NoNo
47South Norfolk00.000/100/10No000NoNo
47South Northamptonshire00.000/100/10No000NoNo
47South Oxfordshire00.000/100/10No000NoNo
47South Ribble00.000/100/10No000NoNo
47South Somerset00.000/100/10No000NoNo
47South Staffordshire00.000/100/10No000NoNo
47South Tyneside00.000/100/10No000NoNo
47Southampton00.000/100/10No000NoNo
47Southend-on-Sea00.000/100/10No000NoNo
47Southwark00.000/100/10No000NoNo
47Spelthorne00.000/100/10No000NoNo
47St Albans00.000/100/10No000NoNo
47St. Helens00.000/100/10No000NoNo
47Stafford00.000/100/10No000NoNo
47Staffordshire Moorlands00.000/100/10No000NoNo
47Stevenage00.000/100/10No000NoNo
47Stirling00.000/100/10No000NoNo
47Stockton-on-Tees00.000/100/10No000NoNo
47Stoke-on-Trent00.000/100/10No000NoNo
47Stratford-on-Avon00.000/100/10No000NoNo
47Stroud00.000/100/10No000NoNo
47Sunderland00.000/100/10No000NoNo
47Surrey Heath00.000/100/10No000NoNo
47Sutton00.000/100/10No000NoNo
47Swale00.000/100/10No000NoNo
47Swansea00.000/100/10No000NoNo
47Swindon00.000/100/10No000NoNo
47Tameside00.000/100/10No000NoNo
47Tamworth00.000/100/10No000NoNo
47Tandridge00.000/100/10No000NoNo
47Teignbridge00.000/100/10No000NoNo
47Telford and Wrekin00.000/100/10No000NoNo
47Tendring00.000/100/10No000NoNo
47Test Valley00.000/100/10No000NoNo
47Tewkesbury00.000/100/10No000NoNo
47Thanet00.000/100/10No000NoNo
47Three Rivers00.000/100/10No000NoNo
47Tonbridge and Malling00.000/100/10No000NoNo
47Torbay00.000/100/10No000NoNo
47Torfaen00.000/100/10No000NoNo
47Torridge00.000/100/10No000NoNo
47Tower Hamlets00.000/100/10No000NoNo
47Trafford00.000/100/10No000NoNo
47Uttlesford00.000/100/10No000NoNo
47Vale of Glamorgan00.000/100/10No000NoNo
47Vale of White Horse00.000/100/10No000NoNo
47Walsall00.000/100/10No000NoNo
47Waltham Forest00.000/100/10No000NoNo
47Wandsworth00.000/100/10No000NoNo
47Warrington00.000/100/10No000NoNo
47Warwick00.000/100/10No000NoNo
47Watford00.000/100/10No000NoNo
47Waverley00.000/100/10No000NoNo
47Wealden00.000/100/10No000NoNo
47Wellingborough00.000/100/10No000NoNo
47Welwyn Hatfield00.000/100/10No000NoNo
47West Berkshire00.000/100/10No000NoNo
47West Devon00.000/100/10No000NoNo
47West Dunbartonshire00.000/100/10No000NoNo
47West Lancashire00.000/100/10No000NoNo
47West Lindsey00.000/100/10No000NoNo
47West Lothian00.000/100/10No000NoNo
47West Oxfordshire00.000/100/10No000NoNo
47West Suffolk00.000/100/10No000NoNo
47Westminster00.000/100/10No000NoNo
47Wigan00.000/100/10No000NoNo
47Wiltshire00.000/100/10No000NoNo
47Winchester00.000/100/10No000NoNo
47Windsor and Maidenhead00.000/100/10No000NoNo
47Woking00.000/100/10No000NoNo
47Wolverhampton00.000/100/10No000NoNo
47Worcester00.000/100/10No000NoNo
47Worthing00.000/100/10No000NoNo
47Wrexham00.000/100/10No000NoNo
47Wychavon0.000/100/10No000NoNo
47Wycombe00.000/100/10No000NoNo
47Wyre00.000/100/10No000NoNo
47Wyre Forest00.000/100/10No000NoNo

Notes

Rows

The number of rows we found in the file. If you have empty or partial rows in your file, it will likely mess up other checks.

Valid required headings

This tells you how many of the required column headings match the format specification precisely. Headings with uppercase characters in the wrong place, extra spaces, or extra content won't count. This is used to calculate the score.

If you are getting a score of 9/10 but are convinced that you have the correct headings, it may be that your file contains a byte-order-mark as the first character and that is messing up our checking. If you are exporting from FME, this is turned on by default. Under "Encoding", you can set "Write Byte Order Mark for Unicode" to "No".

Includes required columns?

In the Business Rates format definition there are 10 columns that are listed as required. We've tried to identify how many exist by checking the column headings with a looser matching than the "Valid required headings" check. If your column headings are too different, we won't be able to find them. This is used to calculate the score.

Includes empties?

Does the file include a column Occupied that lists the empties? This is needed if we want to encourage empty properties to become occupied. This is used to calculate the score.

Valid coordinates?

Does the file contain Latitude and Longitude columns and do the cells contain things that look like coordinates? These are necessary if we want to put the properties on a map. If you are a Local Authority and only have postcodes, you can use the ONS Postcode Lookup to get latitudes and longitudes. We've even created a tool that will add latitude/longitude to CSV files with a Postcode column. This is used to calculate the score.

Valid dates

Dealing with dates is always a headache because there are so many different formats. The Government Digital Service recommend using ISO8601 which is an international standard. Dates should be YYYY-MM-DD. We've created the CSV Cleaner tool to help tidy dates into ISO8601 for you. Just drop your CSV file into it and click "Save". This is used to calculate the score.

Valid currency values

These should be given in GBP but just as a decimal number. Don't include commas or currency symbols which can be difficult to deal with consistently. This is used to calculate the score.

Is the file hosted by the Local Authority?

Ideally, files will be hosted and maintained by a Local Authority either on their own website or on a Data Store such as Data Mill North, Calderdale Data Works, Northern Data Hub, or York Open Data. That way the latest version of the Business Rates will be available. This is used to calculate the score.

Is CORS enabled?

If the file is hosted remotely, CORS will need to be enabled so that the file can be loaded by the webpage. This is used to calculate the score.

If you are hosting your file on AWS, you may need to update your CORS configuration. Jaime Scowcroft (Stockport MDC) suggests the following:

<CORSConfiguration>
	<CORSRule>
		<AllowedOrigin>*</AllowedOrigin>
		<AllowedMethod>GET</AllowedMethod>
		<AllowedMethod>HEAD</AllowedMethod>
		<MaxAgeSeconds>3000</MaxAgeSeconds>
		<AllowedHeader>Authorization</AllowedHeader>
	</CORSRule>
</CORSConfiguration>