Journalist Rachel Chitra used news reports to build a database on hate crimes and violence in India. Here she gives tips for reporters facing a data gap, and offers lessons learned from her research about how journalists can reliably step in to gather, clean, and publish data when the government fails to keep track of important information.
At GIJC21, two investigative journalists who have used their cutting-edge expertise in media manipulation to expose scamsters, far-right propagandists, and secret troll farms discussed tracking digital footprints, free resources for content verification — and the kind of tips that might just break a big story.
The war in Syria has dragged on for a decade, which has led to more than six million people being displaced within the country’s borders, and a similar number have fled the country as refugees. But what has happened to the money raised to help rebuild the country? Journalist Mohammed Bassiki dug deep into the documents and followed the money trail to find out.
What happens to the clothes we donate to charity? Or the clothes we buy online, try on, and then return? Two Finnish journalists used tracking devices in order to investigate these post-consumer supply chains, finding that many items make their way on a complex journey to Africa and the Middle East before sometimes ending up in landfill.
The illegal trafficking of wild animals and plants is damaging biodiversity worldwide and spreading diseases. It’s an international story, with great opportunities for investigations in virtually every country. GIJN’s new guide encourages deep reporting about the subject with tips and tools for covering a global trade.
In a GIJN webinar three journalists who have experience reporting on the #MeToo movement and sexual abuse told reporters how to investigate an often-hidden crime. Among their tips are preparing interviewees for the process, investigating the story doggedly, and using alternative forms of evidence to verify your story. Read these and other tips for investigating sexual abuse allegations in GIJN’s latest tipsheet.
When ProPublica reporters published a questionnaire in February reaching out to women who had experienced life-threatening complications in childbirth, they only expected a few hundred responses. Instead, they received thousands — and the structured call-out became the basis of their maternal mortality series.
What appeared to be a case of money laundering done through a network of laundromats and car washes turned out to be the largest corruption network in Brazilian history, and one that ultimately extended to at least 12 countries. If it weren’t for the collaborative efforts of journalists and media houses across the continent – and into Africa – the whole story could not have been told.
There is a huge amount of data available on pollution and disease caused by the Matanza River – widely known as River Riachuelo – the problem was transforming it into information that those affected could easily understand. In a special multimedia report, La Nación used open data and data visualization to illustrate the extent of the problem.
Egyptian traffic cops found a mobile launcher lying in a piece of pile near the airport of Cairo. The story was quickly dismissed by Egyptian media. But others believed it. In this detective & research adventure recorded by web research specialist Henk van Ess, you’ll learn how to find the truth midst of an information war.
Transnational investigations pose a different set of additional challenges. Coordinating journalists across borders, who have different priorities, and making them work as if they were sitting in the same newsroom, is not an easy task. Here are some lessons Investigate Europe has to share based on their experience.
When the president of the parliament states that there are some MPs “doing nothing,” you know what to do as a data journalist: you turn to the numbers. This is how I did that and how I got a scatter plot in a printed paper and an interactive one online.
At First Draft, we frequently receive emails from a whole range of people asking how they can start doing the sort of online open-source investigation and verification that they’ve seen us doing. The skills and methodologies used are all something that can be learnt through a little persistence, but here are a few pieces of advice to get you started.
When Gustavo Cerati, a legendary Argentinian musician and songwriter, was asked to share his best advice for new musicians, he refused—saying instead that “experiences are not transferable.” You may agree or may not with his statement, but if you’ve ever worn an Oculus Rift or a similar virtual reality (VR) headset, you’ll know we are getting closer and closer to transferable experiences.
Mexican newspaper El Universal has put a face to the 4,534 women who have gone missing in Mexico City and the State of Mexico over the last decade: Ausencias Ignoradas (Ignored Absences) aims to put pressure on the government and eradicate this situation.
In an extract from his book Finding Stories with Spreadsheets Paul Bradshaw explains how to use basic cleaning functions in spreadsheets to make it easier to combine data, including a case study where the same functions were used to speed up a research process for a story.
The trove of files that make up the Panama Papers is likely the largest dataset of leaked insider information in the history of journalism. For ICIJ’s Data and Research Unit, it offered a unique set of challenges. The overall size of the data (2.6 terabytes, 11.5 million files), the variety of file types (from spreadsheets, emails and PDFs to obscure and old formats no longer in use), and the logistics of making it all securely searchable for more than 370 journalists around the world are just a few of the hurdles faced over the course of the 12 month investigation.
The story published in the Washington Post’s Wonkblog ended up being about race, but it didn’t start out that way. Nick Diakopoulos, who leads the lab, wrote for the Wonkblog last year with a story on how surge pricing motivates Uber drivers to move to those surging areas, but does not increase the number of drivers on the road as Uber claims.
“Hello,” wrote the anonymous source to a German newspaper, “this is John Doe. Interested in data?” Thus began what would soon become an international financial investigation into what are being called the Panama Papers—an investigation so massive that even whistleblower Edward Snowden, on Twitter, called it the “biggest leak in the history of data journalism.”
Confiscati Bene, released in mid-December in Europe, is a pioneering data journalism collaboration that digs into the $4 billion of goods in the EU confiscated from criminals by European authorities. An international team of journalists and their allies sought to create a European database of seized assets and answer troubling questions about the accountability of the process. Confiscati Bene (literally, Well Confiscated) received support from GIJN member JournalismFund.eu; the main project can be seen at http://eu.confiscatibene.it.
Web scraping is a way to extract information presented on websites. As I explained it in the first installment of this article, web scraping is used by many companies. It’s also a great tool for reporters who know how to code, since more and more public institutions publish their data on their websites.
With web scrapers, which are also called “bots,” it’s possible to gather large amounts of data for stories. But what are the ethical rules that reporters have to follow while web scraping?
$8 billion in just a few hours earlier this year? It was because of a web scraper, a tool companies use—as do many data reporters. A web scraper is simply a computer program that reads the HTML code from webpages, and analyze it. With such a program, or “bot,” it’s possible to extract data and information from websites.
In this just-released video, investigative reporter Mark Schapiro goes in-depth on how to use investigative techniques in probing often complex environmental issues. Schapiro, a veteran of the original Center for Investigative Reporting, gave this talk in Hamburg at NR15, the July 2015 annual conference of Netzwerk Recherche, Germany’s investigative journalism association.
We’re already seeing the use of drones proliferate across a whole variety of stories — from incredible imagery of the vastness of the natural world to investigations that couldn’t be told with conventional cameras, to views of the inaccessible right under our noses. So how are the drone journalists of the future being trained for their work?
We’re back with another selection of web resources and reports that might be of interest to journalists around the world. On the list this week: new reports from the International Labour Organization, Congressional Research Service, and UK House of Commons; and tools to search domain ownership, load tweets into a spreadsheet, and search open data. Good hunting!
Search engines are an intrinsic part of the array of commonly used “open source” research tools. Together with social media, domain name look-ups and more traditional solutions such as newspapers, effective web searching will help you find vital information. Many people find that search engines often bring up disappointing results from dubious sources. A few tricks, however, can ensure that you corner the pages you are looking for, from sites you can trust. The same goes for searching social networks and other sources to locate people.
The good people at the Journalism in the Americas Blog, who just hosted the always interesting International Symposium on Online Journalism, alerted us to a useful new video, “Data Journalism: An Explication.” Here are journalists doing their best to define data journalism.The video comes from Cindy Royal, an associate professor, and Dale Blasingame, a lecturer, in the School of Journalism and Mass Communication at Texas State University.
