In a very timely fashion, data.gov.uk has come up with a blogpost explaining for any local authorities who want to know (and are listening/reading) how to publish itemised local authority expenditure.
Publishing raw data quickly is an immediate priority, but in the medium term local authorities should work towards structured, regularly updated data published on the Web using open standards. Subject to other issues below, our immediate advice to local authorities is:
- Users will be interested in the core information held in the accounts system – such as expenditure code, amount paid, transaction date, beneficiary, and payment reference number. The expenditure code has to be explained and steps taken to help users identify the
- As a first stage, publish the raw data and any lookup table needed to interpret it in a spreadsheet as a CSV or XML file as soon as possible. This should be put on the council’s website as a document for anyone to download. Or even published in a service such as Google Docs
- There is not yet a national approach for publishing local authority expenditure data. This should not stop publication of data in its raw, machine-readable form. Observing such raw data being used is the only route to a national approach, should one be required
- Publishing raw data will allow the panel and others to assess how that data could/should be presented to users. Sight of the data is worth a hundred meetings. Members of the panel will study the data, take part in the discussion and revise this advice.
- As a second stage, informed by the discussion, the panel and users can then give feedback about publishing data (RDF, CSV, etc) in a way that can be consistent across all local authorities involving structured, regularly updated data published on the Web using openstandards.
There’s more too, about experiences of some of the councils which have published data. Very well worth reading.
- The following posts may be related...(the database guesses):