Sometimes an organisation will publish a spreadsheet where only a part of the full data is shown when you select from a drop-down menu. In order to get all the data, you’d have to manually select each option, and then copy the results into a new spreadsheet.
It’s not great.
In this post, I’ll explain some tricks for finding out exactly where the full data is hidden, and how to extract it without getting Repetitive Strain Injury. Here goes…
To get the data from this spreadsheet you have to select 51 different options from a dropdown menu
In a guest post for OJB Maria Crosas interviews Ferran Morales, the journalist behind The Story of Zainab, to understand how he tackled the challenge of processing and visualising data about refugees.
Ferran Morales showing infographics from Zainab’ story
Ferran Morales is a data journalist and graphic designer at El Mundo Deportivo. In February, with the team at Media Lab Prado, he published The Story of Zainab, a data-driven narrative following an 11-year-old refugee and her family, that had to leave their home in 2011 because of the war in Syria.
The project was created as part of Visualizar 2017, a workshop for prototyping data visualisation projects, and drew on data on refugees.
Women represent 49.5% of the world’s population, but they do not have a corresponding public, political and social influence. In recent years, more and more women have raised their voices, making society aware of their challenges — data journalists included. To commemorate International Women’s Day, Carla Pedret presentsa list of data journalism projects that detail the sacrifices, injustices and prejudices that women still have to face in the 21st century.
Bombings in Barcelona in 1938 (Image by Italian Airforce under CC)
In a guest post for OJB, Carla Pedret looks at a new data journalism project to catalogue what happened during the Spanish Civil War.
125,000 people died, disappeared or were repressed in the Spanish Civil War (1936-1939) and during the Franco dictatorship, according to historians. Many of their families still do not know, 40 years later, what exactly happened to them.
Using a combination of contact-led information and FOI requests, they uncovered the extent of the ambitions to dig deep into Scottish soil.
It was part of a steady flow of fracking stories from the Ferret team, ensuring those involved in making decisions were in no doubt of their responsibilities and recognised that every step would be scrutinised. Continue reading →
In a guest post for OJB, Steve Carufel interviews Dutch data journalist Thomas de Beusabout visualisation, storytelling — and useful new tools for data journalists.
Data journalism is, among other things, the art of resisting the temptation to show spectacular visualisations that fail to highlight the data behind a story.
Insights and relevant statistics can get lost in visual translation, so Thomas de Beus’ Colourful Facts is a great place to start thinking more about clarity and your audience — and less about spectacular graphic design (although you do not want to forego attractiveness entirely). Continue reading →
I took part in a BBC Academy podcast about data journalism last week, along with The Guardian’s Helena Bengtsson and the BBC’s Daniel Wainwright and John Walton, in the wake of the BBC’s annual plan and three-year strategy which included a focus on the “interrogation of data”.
Among other things we talked about why data journalism is increasingly important, what skills are needed (including the role of code), why I’m launching an MA in Data Journalism, and what sorts of stories can be done with those skills.
The best-known examples of data journalism tend to be based around text and visuals — but it’s harder to find data journalism in video and audio. Ahead of the launch of my new MA in Data Journalism I thought I would share my list of the examples of video data journalism that I use with students in exploring data storytelling across multiple platforms. If you have others, I’d love to hear about them.
FOI stories in broadcast journalism
Freedom of Information stories are one of the most common situations when broadcasters will have to deal with more in-depth data. These are often brought to life by through case studies and interviewing experts. Continue reading →
Eva Constantaras is a data journalist and trainer who recently wrote the Data Journalism Manual for the UN Development Program. In a special guest post she talks about the background to the manual, her experiences in working with journalists and professors who want to introduce data journalism techniques in developing nations, and why the biggest challenges not technological, but cultural.
There is a growing awareness that the challenge of teaching data journalism in many countries is split straight down the middle between teaching data and teaching journalism — where neither data science nor public interest journalism are particularly common. Open data can be a boon to democracy — but only if there are professionals capable and motivated to transform that data into information for the public. Continue reading →