Back to index

Projects

Tools
  1. CSV Match

    ongoing

    Finds matches in two spreadsheets, optionally using various fuzzy-matching algorithms. Used by organisations including the Guardian, the Times, and the New Humanitarian who used it to identify a company the United Nations had a contract with who was also on its own sanctions list.

  2. Reconcile

    ongoing

    Enriches data, adding new columns based on lookups to online services. For example, taking a spreadsheet of company numbers and turning it into a list of directors of those companies.

  3. Newsagent

    ongoing

    Monitors data sources, alerts you when they change. Lets you watch any kind of online dataset, which is then periodically fetched, processed, and compared against the last time. Additions or deletions to that data trigger an alert being sent.

  4. NDJson-to-CSV

    ongoing

    Converts NDJson format data (such as the Companies House PSC data) into CSV. Data is streamed, so files much bigger than the available memory can be converted. Takes into account nested Json objects.

  5. Pantiler

    ongoing

    Converts geographic data into vector map tiles.

  6. Graphik

    past

    Creates simple static charts quickly – a tool for the non-technical. Can be easily customised to a organisation's house style using a stylesheet.

  7. CSV Pivot

    past

    Produces pivot tables, much like those in Excel, but in the terminal.

  8. Who Follows Who

    past

    Finds which Twitter accounts follow each other from a predefined list.

Prototypes
  1. London Overground capacity display

    An experimental display showing the predicted space in train carriages. Deployed at Shoreditch High Street station for the last quarter of 2017. Built in collaboration between Geovation and OpenCapacity with TfL.

  2. Track the dot

    Project managed an interdisciplinary creative team at Data4Change 2017 in Kampala, Uganda working with Kenyan NGO Chrips. My team developed a offline-first campaign based on Chrips's research on urban violence that targeted community leaders in north Kenya.

  3. We are Sudan

    A mobile-first website built at Data4Change 2016 in Beirut, Lebanon working with Sudanese NGO Kace. Developed with a team as part of a social media campaign based on Kace's research into quality of life as experienced by ordinary people in the country.