Here are some links to some of my recent work:
This app allows the user to type in their postcode to see how bad their area is for burglary. It shows you whether burglary is going up or down and identifies the problem locations in your neighbourhood.
To create this project I worked with the designer and developer on my team to analyse more than one million rows of crime data.
Hundreds of thousands of people have used this widget.
Tumble dryer fires
Working with Martin Bagot and Nicola Bartlett at the Mirror, I asked fire departments for the number of fires caused by tumble dryers. Within just a few days, we had collated data from most of the fire services in Britain to give a national picture of this dangerous trend – as well as numerous stories for our regional titles.
Where Should I Move To?
This widget caters to those considering leaving the UK in the aftermath of the Leave vote in the EU referendum. Select which criteria for living in a foreign country are important to you and the widget shows you which other EU country best matches your choices. I sourced the data that underpins the gadget and worked closely with our developer, Carlos Novoa, and our designer, Dmitri Thompson on the team to get it up quickly on the Monday following the result.
Property ultimately owned by offshore companies is huge business in Britain. I analysed the database collated by Private Eye to reveal the multi-billion scale of the market – and also to pick out some prominent examples in Liverpool.
I used Tableau to go into the Land Registry’s house price data, looking for flats sold in the Beetham Tower, Manchester – by far the tallest building in the city. I was able to show that it costs about £280,000 to buy a flat there. This story was viewed more than 100,000 times.
Further analysis of the Land Registry data showed that there was a puzzling lack of homes sold at the number 13. Was it superstition on behalf of the buyers – or the developers in the first place?
So-called ‘Fat Cat Tuesday‘ – the early January date by which FTSE 100 chief executives had already earned more than the average worker – inspired this idea. Type in your postcode and how much you earn and the Wage Gauge will give you your own ‘Fat Cat Tuesday’ date. But be warned – this will stretch into 2017 if you earn less than the average salary of £22,481.
Smoking in cars
I resolved to investigate crimes resulting from the law change banning smoking in cars with children present. After months of digging using Freedom of Information requests, I was able to expose a major loophole in the law: the ban on smoking in cars was effectively going unenforced. Police and local authorities simply didn’t have the systems in place adequately to enforce the new law.
Jobs taken by robots
I used the results of an American study into job losses to automation and cross-referenced them with the ONS estimates of the numbers of people in different types of jobs. The findings were stark – in Nottingham, about 20 per cent of people work in the jobs most at risk. How humanity handles automation will be one of the biggest challenges of the 21st century.