This is a selected list. You can find all my work at the Financial Times on my profile page.
Rrevealed Labour’s electoral strategy in the runup to the 2024 general election which would likely maximise Conservative losses in the south of England. I scraped and analysed data from Labour’s volunteering website, which directs activists to where they should campaign.
Revealed that Chinese suppliers now dominate the trade in ‘computer numerical control’ devices vital to Moscow’s military industries. I matched up customs data on the imports of CNC machinery with data on companies sanctioned by the US Treasury.
Winner at the Sopa and Sigma Awards. Revealed that thousands of mosques across China have been architecturally altered or destroyed in a government effort to suppress Islamic culture. I built a dataset of mosques in China based on data extracted from Baidu Maps. Along with others, I then tediously manually classified historic satellite imagery to create a database of what has changed.
Revealed that three companies won free carbon emission allowances worth millions of pounds for factories that were mothballed or slashing production, highlighting loopholes in the British net zero regime. I matched up data on emissions with data on free allocations of carbon credits, allowing us to identify the biggest disparities.
Revealed that the politically connected Indian conglomerate appears to have imported billions of dollars of coal at prices well above market value. I analysed customs records, matching up imports of coal at different levels of calorific content with the nearest index price, taking into account the shipping time.
Revealed that a common spelling error has misdirected sensitive Pentagon messages to a company running Mali’s internet domain. I processed mailbox data so it could be searched.
Identified three High Court judges that invested in tax avoidance schemes, including one judge who has ruled on tax avoidance cases. I matched up details of judges of the High Court with records from Companies House.
Reconstruction of the five-month journey of a ship that Washington says was used to secretly transport weapons to Russia. I sourced and processed ship tracking data, identifying declared stops from and to Novorossiysk including a four day gap outside Cape Town during which the arms were allegedly picked up.
Visual investigation into an apartment complex that collapsed during the Turkey-Syria earthquake which came to symbolise the corruption in the Turkish construction sector. I processed satellite imagery of development of the building and calculate its size. I also sourced CGI mock ups and images taken mid-construction which show potential flaws.
Shows how a once marginal bourse has been transformed by a conglomerate whose growth bankers and analysts say is hard to explain. I analysed data from key stocks to show how much of the total volume of trade was made up of large batches of identical numbers of shares traded simultaneously.
Revealed that nearly 40 individuals and entities declared as being under sanctions, including three Russian tycoons, hold British property through offshore vehicles. I connected up corporate data with land records and analysed the results to identify notable individuals in the data.
Revealed that the Qatari government had spent more than £190,000 on trips for 37 British MPs over the past five years rasing the question about whether the charm offensive is to counter criticism of its human rights record. I analysed transparency data published by the Electoral Commission, connecting trips with countries.
Tells the story of how London’s premier shopping destination came to be overrun by brightly lit shops selling colourful American sweets. I analysed corporate records and historic Google Streetview imagery, as well as the current situation of each of the units along the street, including speaking to those working there.
Opinion piece describing how data published by the government and parliament, ostensibly for transparency, do not actually allow important questions to be answered, inhibiting accountability. Informed by my experience working on an earlier piece looking into MP’s second jobs.
Revealed the UK government’s secretive venture capital fund has invested in a Netflix-style streaming service for jazz, a manufacturer of alcoholic teas, a yoghurt bar company, a talent agency for social media influencers and a yacht rental service. I identified 200 companies, including those named in the piece by extracting text from documents.
Revealed donations from individuals and companies in the property sector account for a quarter of donations made to the Conservative party, as critics say a planned liberalisation of England’s planning laws benefits housing developers. I linked Electoral Commission declarations to Companies House records, which have industry codes that identify those in the property sector.
Revealed many commercial groups including management consultancies and pharmaceutical companies have received years of detailed medical records from English hospitals, as the NHS considers third party access to GP records. I extracted, combined, classified, and analysed five years’ of data release records to determine who had received data, and whether opt-outs were being applied. I also produced the graphics used in the piece.
Data analysis.Revealed OakNorth bank has suffered several previously-unknown defaults, after earlier boasting of developing innovative software which meant they had made zero bad loans. I extracted and analysed data from Companies House to build up a picture of OakNorth’s loan book, and identified which companies were going through (or had gone through) insolvency processes.
Shortlisted for the British Journalism Awards. Revealed Thurrock council has used loans from 150 other local authorities and pension schemes to fund investments in renewable energy schemes. I analysed Companies House records to establish the corporate structure of the main scheme we focused on, identifing leads and checking claims using public records, as well as some general reporting and research.
Revealed Amazon is offering free shipping to highly contentious Israeli settlements in the occupied West Bank, but only to their Palestinian neighbours if they list their country as Israel. I scraped a list of addresses of Israeli settlements in the West Bank. I wrote some code to loop through each, enter it into Amazon, and see what shipping options were given.
Shortlisted for the Sigma Awards. Revealed some of the UK’s most popular health websites protected personal health data, including symptoms and drug names, is shared with hundreds of third parties including Google and Facebook. I used a list of the top 100 UK health websites, ran it through a tool built by researchers to study web traffic, and analysed the results. For sites we wanted to look at in more detail I used a separate tool to look inside the data and metadata inside the requests that make up that traffic.
Explainer video.Revealed western artificial intelligence researchers partnered with organisations linked to Chinese state surveillance. Also found researchers using images of faces scraped from social media and CCTV. I analysed academic papers to extract out authorship information so we could identify these collaborations. I then used the same technique to search for which papers mentioned working with sets of images known to have been collected without consent.
Feature.Revealed almost half of the UK corporate structures most associated with money laundering, Scottish Limited Partnerships (SLPs), failing to comply with ownership regulations – yet escaping punishment. I analysed records published by Companies House, extracting out the type of each company, then joining those records with another set of data listing the declared beneficial ownership to calculate rates of compliance.
Revealed close to one quarter of public sector contracts awarded in 2018 went to sole bidders, either because contracts were given directly to a specific company without a competitive tender, or because there was a competitive tender but only one company applied. I analysed government contract records published by the EU, transforming them from the format they are published in to something that could be interrogated. I also spoke with campaigners to understand the results.
Revealed the offshore links of some of the most prominent donors to UK political parties, as well as international celebrities, judges, sportsmen, businessmen, and aristocrats. I analysed a leaked list naming 53,000 people holding accounts in the offshore bank Kleinwort Benson together with other lists of people of interest scraped from various sources using a fuzzy matching process I developed to account for different naming conventions.
News story.