I am from Brazil, a country well-known for football and FIFA World Cup titles — and the host of the World Cup in 2014. Being a sceptical journalist, in 2019 I tried to discover the real impacts of that 2014 World Cup on the 213 million residents of Brazil: tracking the 121 infrastructure projects that the Brazilian government carried out for the competition and which were considered the “major social legacy” of the tournament.
In 2018 the Brazilian government had taken the website and official database on the 2014 FIFA World Cup infrastructure projects offline — so I had to make Freedom of Information (FOIA) requests to get data.
The investigation took 3 months and more than 230 FOIA requests to 33 different public bodies in Brazil. On August 23, my story was published.
Here is everything that I have learned from making those hundreds of FOIA requests:
Email newsletters are an excellent way for journalism students to build a profile in a field while also improving their specialist knowledge and editorial skills. I’ve put together a short video guide on some of the key techniques to use when starting an email newsletter — and why it’s a great way to stand out in the jobs market.
The video outlines three typical purposes of newsletters, the importance of visuals and links, and other key qualities of the genre. Watch it below.
This video was first made for journalism students on Birmingham City University’s MA in Multiplatform and Mobile Journalism. It also includes some advice on referencing reading and evidence in an evaluation of students’ work.
“Pajama Journalism”—reports you can do in nightclothes on a computer, without going anywhere or talking to anyone—should not define online news, but the practice is widespread. In a special guest post, Michael Bugeja argues that following just four basic principles of reporting can help improve this form of journalism.
If you follow me on Twitter you’ll know every so often I highlight a story which uses company accounts. This latest one has celebrity and fashion, and involves a charity that’s raising money through star-studded events — what more can you ask for?
🧵It's time for another journey into the world of telling stories through company accounts – this time Naomi Campbell's fashion charity is under investigation! The story is here: https://t.co/iRvYuDbTbF But how did the reporter find the details..?
For reporters satellite data offers unique opportunities for original investigations and visual storytelling. But how do you get started? And what should you be looking out for? In a guest post for the Online Journalism Blog, MA Data Journalism student Niels de Hoogspeaks to four journalists who regularly work with satellite data about how to start, best practices and —most importantly — mistakes to avoid.
While researching my post on developing curiosity in journalism I came across Terry Heick‘s 4 stages of curiosity. It outlines 4 steps that learners go through as they grapple with new knowledge: firstly finding out what they are expected to do (the process); then understanding the content involved; then how to transfer that to particular situations; and finally how it applies to, and changes, them.
But the same model can also be adapted to provide a framework for investigations. Here’s how:
In an extract from a new chapter in the ebook Finding Stories in Spreadsheets, I explain what regular expressions are — and how they can be used to extract information from spreadsheets.The ebook version of this tutorial includes a dataset and exercise to employ these techniques.
The story was an unusual one: the BBC Data Unit had been given access to a dataset on more than 200,000 works of art in galleries across the UK. What patterns could we find in the data that would allow us to tell a story about the nature of the nation’s paintings?
Some of the data was straightforward to work with: the ‘artist’ column was relatively clean, and allowed us to identify the most common male and female artist. It turned out that the latter – the Victorian botanist Marianne North – was relatively unknown. So, that was one story we could tell.
But other parts of the data were more problematic. The date column, for example, contained inconsistently formatted data: in the majority of cases a specific year had been entered, but in many others the data contained text such as “18th century” or “1900-1920” or “1800s”.
We also noticed that monarchs featured heavily in the art – but understandably there was no column that was specifically dedicated to classifying those. If we wanted to identify the most-painted monarchs we would have to create new data that somehow extracted those names from the paintings’ titles.
These problems – extracting data from existing data, particular text data – are what regular expressions are designed for. In this chapter I will explain what regular expressions are, and how to use them in spreadsheets.
Nas minhas aulas e treinamentos de jornalismo de dados, costumo falar sobre os tipos mais comuns de histórias que podem ser encontradas em bancos de dados. Então, selecionei 100 reportagens baseadas em dados, analisei-as e verifiquei com qual frequência cada um desses ângulos é utilizado.
Cheguei à conclusão de que, na verdade, existem sete ângulos principais para reportagens e histórias baseadas em dados. Muitas histórias incorporam outros ângulos como dimensões secundárias da narrativa (uma história de mudança pode passar a falar sobre a escala de algo, por exemplo), mas todas as histórias de jornalismo de dados que examinei levaram um desses ângulos como fio-condutor.
Neste post, examino como os sete ângulos mais comuns podem ajudar você a ter ideias para histórias e reportagens, assim como a variedade de execuções e as principais considerações para se ter em mente.
Government says journalist “extracted data improperly” — but the journalist affirms that he only used a browser’s Inspect Element tool, reports Beatriz Farrugia.
Data journalism has been at the centre of a political debate in Brazil for two weeks after President Jair Bolsonaro’s government made allegations against a data journalist — for extracting data from a web app developed by the Brazilian Ministry of Health to prescribe treatments against COVID-19.
The TrateCov app was launched in January 2021 for Brazilian doctors. Professionals were told they would be able to enter a patient’s profile and symptoms into the app, which would then suggest medication.
However, the data journalist Rodrigo Menegat analyzed the app’s source code and found that, regardless of the patient’s symptoms, age and health conditions, TrateCov indicated the use of chloroquine, hydroxychloroquine and ivermectin — drugs with no scientific evidence supporting their use in the treatment of coronavirus.
He announced his discovery on 20 January in a series of tweets. “Guys,” he wrote:
“I just put in the TrateCov app that my patient is a one week-old newborn who has a stomach ache and a runny nose. The app recommended chloroquine, ivermectin, azithromycin and everything else. Crime, crime, crime, crime.”
Other journalists and broadcasters tested the app and came to the same conclusion.
Soon after the complaints, the app was removed by the Brazilian Government.
Accused of committing cyber crime
Then on May 25th, during a public session of a parliamentary inquiry, Menegat was accused of having committed cyber crime by an official of the Brazilian Ministry of Health: Mayra Pinheiro.
The parliamentary inquiry, opened late last month, is investigating the Bolsonaro government’s response to the pandemic. More than 461,000 people have died in Brazil so far.
Approved by Brazil’s Supreme Court, the inquiry is pursuing multiple lines of investigation, such as why the Brazilian government promoted ineffective treatments and why three health ministers were removed over the pandemic.
Naming the data journalist, Pinheiro said Menegat performed an “improper data extraction”.
“He was unable to hack,” said Mayra. “He did an improper data extraction. Hacking is when you use someone’s password, enter a platform, a system. The term is not hacking. Today we have the official report that classifies it as improper data extraction.
“He did improper simulations. [The system] was taken down for investigation.”
In another testimony session to the parliamentary inquiry the previous week the former Health Minister General Eduardo Pazuello said that the app had been “stolen and hacked by a citizen”.
After the allegations the data journalist explained that he had only used the browser’s Inspect Element tool to analyse the source code.
“As a data journalist and developer, I only analyzed the source code which was public and available on the website of the TrateCov app, saved on a government server (https://tratecov.saude.gov.br) and accessible to any internet user curious enough to do this verification on their own.”
“The procedure has in no way altered any content on the platform”, he added.
Since the allegations Menegat has limited his social media accounts to avoid online attacks by government supporters.
“I am closing my Twitter account for more than an obvious reason, but I will be very pleased to show who wants to know how to use the Element Inspector to access source code from any website in the world,” wrote the journalist.
Other Brazilian data journalists showed support for Menegat and published content explaining the technique used to analyse the app.
Eariler this week I came across a fantastic example of using company accounts in journalism: Guardian media editor Jim Waterson‘s article on how the family that founded the sex-worker social media platform OnlyFans “extracted tens of millions of pounds from its parent company in the last year”.
THREAD! I've reverse-engineered @jimwaterson's excellent article on sex-worker social media platform OnlyFans to show you how to find all sorts of stories in company accounts. Here's the article – https://t.co/mnkRYcyAru – now let's begin…🧵 #bcujournos
Online Journalism Blog 