Portfolio

Here are some links to some of my recent work:

  • Burglary Unmasked

    burglary-unmasked2

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

Tumble(15.2.16)splash-page-001tumble(15.2.16)lead-page-001

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?

where should I live result2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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.

  • Offshore property

    offshore

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.

  • Skyscraper living

beetham tower

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.

  • Superstitious houses

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?

  • Wage Gauge

wage gauge

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

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.

  • Crime O’Clock

crime video

Our designer Dmitri Thompson, video expert Mark Magill and I created these unique videos showing exactly how often certain crimes take place in Merseyside, using the Home Office’s open data tables.

  • Jobs taken by robots

    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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s