bad-data icon indicating copy to clipboard operation
bad-data copied to clipboard

Spreadsheet as image

Open davidread opened this issue 11 years ago • 3 comments

http://webarchive.nationalarchives.gov.uk/+/http://www.alderhey.com/Library/Images/Finance/09201.jpg

This hospital provided its spend data only as screenshots of spreadsheets monthly from April to September 2010. Optical Character Recognition or a LOT of typing would be required to extract the information. The dates are not even visible.

Efforts to parse and aggregate the data, such as https://openspending.org/ukgov-25k-spending are impossible. Not at all transparent.

The hospital made a further step to make this inaccessible - they deleted it from their website. We can only access it now because the National Archive provides a cached copy.

UK Government has made a huge efforts to be transparent, and the publication of spend transaction data across central government and NHS trusts was required by David Cameron. The Treasury published guidelines and examples of how the data was to be presented in CSV, which column names etc. There's been reasonable traction, although there are always some that slip through the gaps, like this one.

davidread avatar Feb 28 '14 11:02 davidread

@davidread this is great - would you be up for submitting a proper entry as per http://okfnlabs.org/bad-data/add/ ?

If not @nmashton may be able to help!

rufuspollock avatar Mar 03 '14 12:03 rufuspollock

Has the image gone missing from the web "archive" @davidread ? I can't seem to find it any more...

davidmiller avatar May 01 '14 18:05 davidmiller

Not what happened to the archive :/ We have a cache currently though:

http://data.gov.uk/data/resource_cache/a5/a56887ac-f511-4f4d-8756-cbe904b629a7/04201.jpg

On Thursday, May 1, 2014, David Miller [email protected] wrote:

Has the image gone missing from the web "archive" @davidreadhttps://github.com/davidread? I can't seem to find it any more...

— Reply to this email directly or view it on GitHubhttps://github.com/okfn/bad-data/issues/22#issuecomment-41937529 .

davidread avatar May 01 '14 21:05 davidread