What sort of information do we need to influence local health systems effectively? Recently, I came across a good piece of work from Ipsos MORI that raises the bar for good quality accessible information for local activists.
We are awash with data, its possible to get hold of useful information if people know where to look. However, finding the data is just the beginning. Too often it is presented in a way that makes it hard to use and interpret unless you have access to analytical expertise which most members of the public and local voluntary organisations don’t.
Not surprisingly much of this data is gathered by Government and national agencies so when we are trying to understand what is happening locally we usually have to look at national data sets and hope that this provides us with local information.
Here is a typical example of a national data set. I wanted to answer the question:
“How many homeless 16 to 17 year olds did Wakefield Council place into Bed and Breakfast in a given year?”
The web search “CLG Homeless Statistics” brings up the page “Homelessness Statistics”. Its a bit unclear where to go from here but a click on the sub heading “live tables” brings me to a page with over 30 spreadsheets and another sub heading “Detailed local authority level responses” a click on this takes me to a collection of 10 spreadsheets showing data by quarter.
I have arrived!
I open the most recent one and find that I am in a large spreadsheet with 8 pages and 330 or so rows (one for each housing authority in England) and some 50 or so columns. If you don’t want to download the spreadsheet you can get a feeling for its size from the screenshot below.
The data I want is in there – but I want a years worth of data – so will need to work my way through 4 of these spreadsheets.
I realise that digging out the Wakefield information is basic bread and butter work if you can use a spreadsheet.
My point is this is not easily accessible information.
Unfortunately providing information in the form of vast spreadsheets is the norm – have a look at the Health and Social Care Information Centre website it is littered with examples, here is one:
Provisional monthly HES for admitted patient care, outpatient and accident and emergency data April to September 2014
It need not be this way – there is something better.
For another piece of work I was doing I wanted to understand the following:
“How easy is it for people (by age) who work full time to get an appointment at their GP?”
I did a web search for the latest “GP patient survey” This took me straight to the delightfully simple GP Patient Survey Website which has been designed and maintained by Ipsos MORI on behalf of NHS England.
Clicking on “analyse the results” and then “Data Analysis” (this bit is not immediately obvious) takes me to a page where I can pick and choose what I want to look at – click a button and out pops a nice graph – answering my question!
This is a completely different experience. Here there is a helpful interface that allows anyone to gather together data that reflects their area of interest – with the ability to choose a wide range of variables and compare and contrast areas.
It works quickly and apparently reliably. It is possible to produce easily understandable graphs that are clear and straightforward. Ok, I did have to produce 2 graphs to cover the entire age range – but my question is answered!
Credit and the Challenge
Credit to Ipsos MORI and to NHSE – I think I could even give Tim Kelsey a compliment here – first time in this blog!
The question for me is why is this approach not used more often – we should expect more government data to be available in this way. Of course this is also a local issue. If we are to make it easy for local citizens to engage with and influence local health and wellbeing systems then this sort of approach needs to be used more by CCGs, Local Authorities and those putting together Joint Strategic Needs Assessments.
I am sure that there are more good examples out there – if you know of any let me know!
What do you think?