Accessibility Settings

color options

monochrome muted color dark

reading tools

isolation ruler



How Can Online Research Tools Help Investigative Reporters?

Investigative DashboardHow can online research tools aid the work of investigative reporters and others looking into transnational financial flows, corporate structures, and the illicit activities of organized crime and global business?

Google and the Organized Crime and Corruption Reporting Project (OCCRP) brought together a small group of investigative journalists and technologists from around the world to examine the answers to this question at their first Investigathon in London during July.

While Google staff demonstrated how to use some of their tools, such as Image Search and Fusion Tables, the star of the event was Investigative Dashboard, a project of OCCRP developed by investigative journalist Paul Radu and media strategist Justin Arenstein. The platform connects journalists investigating transnational stories with researchers who are familiar with a particular geographic region. These researchers then retrieve information about companies or individuals from local registries and databases.

Dashboard-inspired group work sessions at the Investigathon highlighted the importance of data from company registries and official gazettes in investigative journalism. Knowing which companies share board members or have subsidiaries in other countries is crucial to understanding potential conflicts of interest–and potentially dodgy business schemes.


Photo: Organized Crime and Corruption Reporting Project.

The workshop highlighted the need for newsrooms to put this data on companies and control structures into context, alongside other evidence, over the course of an investigation. While such data are available in a globally consolidated form through paid services, few investigative reporters or news outlets are able to afford their steep fees.

OpenCorporates, an open data-powered alternative, makes data freely available, but the start-up doesn’t yet cover all jurisdictions of interest. And while OpenCorporates, and other sites such as the OffshoreLeaks database, OpenSpending, and OpenSecrets increasingly offer newsworthy data for reporters to mine, there needs to be another, investigation-specific layer on top of these sites.

Such a layer of tools would combine data about persons and companies from public data platforms with other evidence that research uncovers. This layer would also store information about the source and reliability of the data, and allow journalists to analyze the combined dataset to discover signs of illicit or illegal behavior.

While such tools for integrating and analyzing investigative evidence are available for those with deep pockets, there is also a need for an open source solution. This is why one of the goals of my ICFJ Knight International Journalism Fellowship is to build out grano, a toolkit for investigative journalists.

Starting with an influence-mapping tool, similar to Poderopedia and LittleSis, our first goal is to create an involuntary face book of the companies, people and institutions of interest to journalistic investigations. Once that basic infrastructure is matured, we want to take the step from making a database to making a workbench. grano will help investigators create a coherent representation of their investigations, by combining data from public sources with the evidence they have collected themselves. This will create both an analytical tool and a re-usable memory, either to be shared within institutions or even in public.

As a first prototype, we’re building out connectedAfrica, which we’ll launch in South Africa. This collaboration between the African Network of Centers for Investigative Reporting (ANCIR) and the Institute for Security Studies will begin by providing a public database focused on South Africa’s top politicians, detailing their business and political involvements. Our goal is to give users a way to explore connections between individuals, companies and public institutions, and to analyze the network for signs of dodgy behavior.

Based on the feedback from this experiment, we’re hoping to turn grano into a product that can support users who want to create similar structures for their own investigations – whether they are looking at company networks, political finance, government licensing, procurement, court cases, policy making — or the all of these combined.


Friedrich Lindenberg, an ICFJ Knight International Journalism Fellow, works with journalists and watchdog groups to develop data resources and investigative tools. This post first appeared on IJNet helps professional, citizen and aspiring journalists find training, improve skills and make connections, and is produced by the International Center for Journalists in seven languages. 

Republish our articles for free, online or in print, under a Creative Commons license.

Republish this article

Material from GIJN’s website is generally available for republication under a Creative Commons Attribution-NonCommercial 4.0 International license. Images usually are published under a different license, so we advise you to use alternatives or contact us regarding permission. Here are our full terms for republication. You must credit the author, link to the original story, and name GIJN as the first publisher. For any queries or to send us a courtesy republication note, write to

Read Next

Methodology Reporting Tools & Tips

What’s in a Name? Investigating People Across Borders

It’s increasingly common for criminals to operate across borders. So investigative reporters also need to know how to identify and investigate people whose names use different alphabets, are formed by unfamiliar conventions, or carry unexpected cultural signals. Read these tips from the OCCRP on best practices for investigating names from outside the English-speaking world.

Reporting Tools & Tips

GIJN Toolbox: Hunting for Secret Money and Financial Conflicts of Interest

In this edition of GIJN Toolbox, we profile three brand new — or newly expanded — tools to dig into financial secrecy and hidden gains from corruption or crime. Our list includes a user-friendly database to search for sanctions and conflict-of-interest red flags, a site that uses an algorithm to detect hidden bank accounts, and a newly expanded database on the true owners of offshore companies.