I put together the data behind this report on the UK’s Greenest Cities for NatWest, in collaboration with Professor William Powrie of the University of Southampton.
Category: Data Journalism/Research
Despite having forgotten what very little I learned about rugby when forced to play it 25 years ago I worked with Mark Johnstone of Content Hubble (who had to explain what all the statistics actually meant) on this interactive piece which compared the players of the different UK teams ahead of the selection for the British Lions tour.
I put together the data behind this piece on the most popular songs on Working From Home Spotify playlists to get an idea of what people were listening to during ‘the new normal’ for office workers.
I researched, wrote and then built the interactive element of this piece for Uswitch comparing loading times for websites across different commercial sectors.
For this piece I used OpenStreetMap data* to generate imagery and maps representing how much land in different cities is set aside as green space compared to how much is used for roads and buildings.
Coverage included: NBC New York, Planetizen, Boston Magazine
* supplemented by other sources where OSM was missing e.g. building footprints
I compiled the data and generated the maps for this piece, visualising US census information about commute times for 20 different cities to show how long different journeys into each city take, and which city’s commuters have it the worst.
Coverage included: NBC San Diego, Curbed, Star Tribune
For this Geotab piece I wrote scripts to combine data from the US National Elevation Dataset and the US Census’s dataset of every American road, in order to identify the highest section of road in every US state. I also wrote the accompanying copy for the piece.
Coverage included: Yahoo, The Denver Channel, Matador Network
[Piece is now offline due to client merging with another company]
For this piece I used Crimson Hexagon’s Instagram insights tool to analyse popular hashtags to provide data that was then used populate a map of New York with emojis indicating the place and time of day people were instagramming different food and drinks.
Coverage included: Thrillist, foodandwine.com, Patch