Improving the discoverability of worklessness data

Trafford Data Lab
Nov 5, 2018 · 2 min read

The Trafford Data Lab is involved in one of the six EU-funded OpenGovIntelligence (OGI) pilot projects which aim to make better use of linked open statistical data to help improve the design and delivery of public services. Each pilot involves a technical partner responsible for creating tools that help standardise the publication of multidimensional data and a public sector agency tasked with exploiting them for the benefit of public services.

The aim of the Trafford Worklessness Pilot is to help support Jobcentre Plus teams in Greater Manchester that deliver services that help people into work by co-creating web applications that visualise linked open statistical data on worklessness.

Our pilot web applications have been co-created with Jobcentre Plus staff in Stretford using linked open statistical data that are stored in the GM Data Store, are transformed using table2qb and queried using CubiQL which are both part of the OGI toolkit and developed by Swirrl. Each application uses a range of open-source JavaScript libraries like D3 and Leaflet and one is written in R using RStudio’s Shiny package.


A simple dashboard presenting summary statistics and time series data on unemployment claimant rates. Information can be viewed at electoral ward and local authority level to enable benchmarking. This tool provides commissioners of services, policy makers, managers and work coaches with an overview of worklessness across Greater Manchester.

Image for post
Image for post
Screenshot of the summarise app. Visit


Identify hot and cold spots of worklessness across Greater Manchester. Using a technique called ‘Local Indicators of Spatial Association’ (Anselin, 1995) the tool identifies statistically significant spatial clusters and outliers of worklessness using claimant count and other data. The tool is aimed at analysts who are interested in the spatial distribution of worklessness.

Image for post
Image for post
Screenshot of the scan app. Visit


An interactive mapping app to help link workers to locate services that support vulnerable clients find work. Food banks, GPs and in future, complex needs support like alcohol and drug services will be shown. The included reachability tool allows users to identify the closest services to a client’s home address within a specified travel time distance and the proximity of services to Jobcentre Plus locations.

Image for post
Image for post
Screenshot of the signpost app. Visit

For further information about the Trafford Worklessness Pilot please visit:

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store