This is a selected list. You can find all my work at the Financial Times on my profile page.
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.