Improving the discoverability of worklessness data

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.

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.

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.

Screenshot of the signpost app. Visit

For further information about the Trafford Worklessness Pilot please visit: