Tag Archives: innovation

Warm Homes Healthy People – Supporting commissioners with data

A request was made to the lab to provide some data to support research into appropriate areas of Trafford to focus on reaching vulnerable residents who are most likely to benefit from additional services and advice made available from the ‘Warm Homes, Healthy People’ project. The priority of the project is to ensure that the needs of Trafford’s most vulnerable residents are met, both physically by keeping them warm and fed over the winter months but also to avoid isolation by encouraging emotional support and wellbeing.  In order to formulate a strategy we must first identify small areas for concentrated attention, ideally specific streets or estates.

We have two main datasets available to support the initial investigations, firstly the geographical data provided nationally by the Office for National Statistics (ONS) on households classified as fuel poor and secondly a dataset provided by Trafford Assist on the number of applications made to the council for support with gas and electric payments. Ideally it would be preferable to include local data on excess winter deaths but unfortunately this data is not currently available to us at the point of writing this blog.

Fuel Poor Households

The coefficient for calculating fuel poverty has recently been refined in an attempt to improve its accuracy, with a drawback that we only have data coving periods 2011 and 2012 with which to draw conclusions. For definitions of the fuel poverty coefficient please visit here.

I extracted and updated the fuel poverty indicators and added them to the InfoTrafford server. I was then able to produce an interactive report which geographically maps the data and allows for correlation analysis between 2011/12 and also other available datasets.  I mapped to a variety of geographical layers including borough wide, political ward boundaries, middle layer super output areas (MSOAs) and lower layer super output areas (LSOAs) and was also able to aggregate ward level data to fit with our own Trafford Locality boundaries.

When looking at ward and locality level data it’s clear that there are significant differences in the proportion of households classified as fuel poor between the North and South of Trafford with the highest density around Clifford and Longford Wards. For the purposes of identifying smaller areas I began to look at the LSOA geography, which for the most part supports the findings of the wider areas.  There are LSOAs within Clifford and Longford that have a notably lower proportion of fuel poor than their neighbours which is affecting the overall rate of the ward.

fuelpoverty14

It is also worthwhile looking at the rate changes over time; albeit only for the two years we have available to us.

correlation

withchangeIt seems the areas with statistically significant increases align to what we know are the areas where deprivation is prevalent in Trafford, including LSOAs in Partington, Sale West, Sale, Broadheath and Broomwood.

Trafford Assist

Trafford Assist provide emergency help in the form of food, furniture and energy bills for Trafford residents who are struggling to meet their basic needs to remain healthy. Any household are permitted to request emergency assistance to a maximum of two applications a year, with a provisional additional allowance of one claim between November and February.  The following map shows the number of claimants for the purposes of assistance with energy bills during 2013 financial year.  Small numbers have been supressed.

assist

The interactive report is available at:

http://www.infotrafford.org.uk/dataviews/report/multiple?reportId=122&viewId=648&geoTypeId=48,15,33,61,17,55

Conclusions

There are large areas of Clifford, Longford and Stretford which have consistently high numbers of fuel poor households, though some of Trafford’s more deprived areas outside of these areas have also seen notable increase since 2011 though it would be unwise to build trends base on just two years of data. With each year’s addition it may be possible to build these trends.   Those areas with higher numbers of households actively seeking assistance do not align entirely with the story told by the fuel poverty indicators, particularly in the Clifford areas where there are very low numbers of emergency help applications for the number of fuel poor households.  Instead the higher number of claimants are around deprived areas where we are seeing a rise in fuel poverty including Partington, Sale West, Broomwood and Stretford.

The Warm Homes, Healthy People project have decided to adopt an borough-wide approach by focussing on the highlighted areas of high fuel poverty as well as pinpointing other areas throughout the borough where early escalating trends could be improved.

Hooray! It’s the Trafford Intelligence and Innovation Lab!

Cow jumping over moon
Wheeeee!

Here at InfoTrafford towers we are absolutely over the moon at the news that we’ve been awarded some money from the Cabinet Office and ODUG’s Release of Data Fund, to support a really exciting project that we’ve been planning.

Building on the success of InfoTrafford, we’re looking to develop a Partnership Innovation and Intelligence Lab, which will take the principles by which we developed InfoTrafford, and use them to bring together a greater range of datasets from our partners.

Accompanying these datasets will be the people from the respective organisations who understand the data – where it comes from, how to get it, and, crucially, what stories the data tells. This means that we will actually be sitting and working together – using our collective insight and knowledge to give us an incredible understanding of the needs and opportunities in Trafford.

Whilst this is the main purpose of the lab, there will be other things that we’ll be doing. We’ll be using the InfoTrafford platform to make available even more data, analyses and visualisations. A key focus will be to make it easier to find information on InfoTrafford. We’ll also be adding all Open Data that we produce to data.gov.uk, and investigating what we can do with datagm.org.uk.

Where appropriate (ie – not personal data, or subject to copyright), our data will also be modelled and uploaded to the GMDSP quad store, which will hopefully lead to synchronisation with other LAs in Greater Manchester. This is how we will achieve 5* status for our Open Data, and will be supported by Open Data Institute Certificates (we already have a ‘Pilot’ certificate for our streetlights data – the first Local Authority in the North to achieve any kind of certificate, and the first Local Authority anywhere to get Pilot..!)

We will also be looking at new technologies, and how we might use them in our quest to make Trafford even better. Sensor arrays, machine learning, and drones are all examples of emerging tech that has the possibility to help (re)design services, or alter demand – we just aren’t yet sure how.

The final thing that the lab will offer is an ‘Open Workspace’. The principle is that we will dedicate a space in the office to allow members of the developer community; voluntary sector and charities; professionals; and students, to come and look over our shoulder at the work that we’ll be doing. They (you..?) will be able to ask for data, see what we hold that we’ve not released yet, test bids or apps with us, or just see how we’re using data and technology in partnership with others.

So what happens next?

I’ve met with all the people who’ll be involved from the beginning, and as soon as we’ve got a space to call our own, we’ll be starting to work together. For a variety of reasons, we aren’t sure exactly when this will be…

I’ll also be presenting the Lab concept to the Trafford Partnership at the end of July (Slidedeck to be made available)

We’ll get cracking immediately with a few pieces of work:

We’re intending to run this entire thing in the open, so we’ll be blogging here whenever we see fit to. I’ll also be tweeting as and when, @_datapreneur, so that’s probably worth a follow, if you are interested. You can also email me, at jamie.whyte@trafford.gov.uk. You could also try phoning me on 07541495259, if you want…

Please feel free to get in touch!

Jamie