• Subscribe to our newsletter
The Media Online
  • Home
  • MOST Awards
  • News
    • Awards
    • Media Mecca
  • Print
    • Newspapers
    • Magazines
    • Publishing
  • Broadcasting
    • TV
    • Radio
    • Cinema
    • Video
  • Digital
    • Mobile
    • Online
  • Agencies
    • Advertising
    • Media agency
    • Public Relations
  • OOH
    • Events
  • Research & Education
    • Research
    • Media Education
      • Media Mentor
  • Press Office
    • Press Office
    • TMO.Live Blog
    • Events
    • Jobs
No Result
View All Result
  • Home
  • MOST Awards
  • News
    • Awards
    • Media Mecca
  • Print
    • Newspapers
    • Magazines
    • Publishing
  • Broadcasting
    • TV
    • Radio
    • Cinema
    • Video
  • Digital
    • Mobile
    • Online
  • Agencies
    • Advertising
    • Media agency
    • Public Relations
  • OOH
    • Events
  • Research & Education
    • Research
    • Media Education
      • Media Mentor
  • Press Office
    • Press Office
    • TMO.Live Blog
    • Events
    • Jobs
No Result
View All Result
The Media Online
No Result
View All Result
Home Press Newspapers

Data crunching is the future…

by Sharlene Sharim
November 29, 2011
in Newspapers
0 0
0
Data crunching is the future…
Share on FacebookShare on Twitter

Data crunching and mapping may sound like it belongs in a profession very different to journalism. But they are the tools of data journalism – the new addition to investigative reporting, writes Sharlene Sharim in a story first published in The Media magazine.

When investigative journalists Julian Rademeyer, Jacques Pauw and Andrew Trench broke the story on prospecting licences and the fight over mining rights in November 2010, they made history.

Published in the City Press, the article reveals the number of prospecting licences the ANC’s investment and fundraising company, Chancellor House Mineral Resources, acquired in recent years. It questions the ruling party’s entwinement in the economy. This story surfaced amid intense debate over the possible nationalisation of South Africa’s mines. And, while it is an excellent piece of investigative journalism, it is also described as ‘the first significant piece of data journalism’ in our country, according to Wits University fellow in investigative journalism, Margaret Renn.

Trench, national editor of investigations at Media24, wrote in his blog at the time the story was released that it “did not come about from a deep-throat informant, as much investigative reporting in South Africa does”. Instead, the story emerged from analysing more than 1.5 million items from the Department of Mineral Resources’ (DMR) database of mineral rights.

So, in a country where much investigative journalism is based – as Trench says – mostly on someone passing information on, this is an alternate avenue for journalists and an exceptional way of getting phenomenal stories that would otherwise remain hidden in databases.

The data for the City Press story was simply found on the DMR’s website. The department published records of all the mining and prospecting right applications made in South Africa in October 2010. This PDF document contains, among other things, the names of applicants and the longitude and latitudes coordinates for each site.

Trench says that, although he was able to extract the text from the files, he couldn’t do anything practical with them in Excel, as the size of the dataset would crash the programme. So he used a powerful programming language that he taught himself. “I wrote a custom Python script to search through all the records, find the ones we wanted and collate them into individual files. Then I cleaned up the smaller data sets of results we were interested in, using things like Excel and Google Refine.”

In his blog, he says: “Chancellor House was an obvious search since the entity had already declared an interest in the mining sector, but even so, I was surprised at the number of records which a query produced.”

Because the database contained the coordinates of the sites, Trench was also able to visualise the information. With the help of an online mapping tool called Scribblemaps, he pinpointed the locations of the prospecting rights that Chancellor House had obtained.

The rest, as they say, is journalism history. There is usually some data that begs to be mapped or analysed to provide a new picture, but it isn’t always obvious to those working on the story.

Renn recalls the LeadSA national poll on Primedia radio stations, in which listeners were asked whether they had bribed a metro police officer in recent months. From this, the journalists created a database of information that provided a fascinating story of massive corruption.

“But,” says Renn, “it begs for a map that says ‘watch out, avoid these crossroads, avoid those traffic lights, because these are the places where you’re most likely to be bribed’. I mean, you could have such fun with it.”Renn makes the point that, as incredible as data journalism is, it can’t exist on its own and is meant to be used in conjunction with all the usual techniques of investigative journalism.

Stefaans Brümmer, managing partner of the Mail & Guardian’s Centre for Investigative Journalism, and his team also incorporate principals of data journalism in their investigations.

When allegations of corruption surrounding government’s R30-billion arms deal surfaced, they literally followed the money, studying the transactions made. Brümmer says that these financial flows fed into their stories were all drawn from a database.

So, in the past, the most journalists were doing with data was finding the obvious or getting professionals to help analyse it. Now, they’re doing it for themselves.

Despite involving “quite a lot of technical skill”, Trench believes data journalism is important because, he says, “it opens up a whole new world of journalism for us to experiment with.” As it requires a learned skill that most don’t have, Trench has made a commitment to developing data journalism in his own newsroom.

The point is, as Renn and Tom Johnson – founder and co-director of the – testify, data journalism enables journalists “to get fresh new topics to write on”.

Johnson says there are several reasons why these techniques are still largely unknown. “Traditionally, journalism has been about writing, and it’s been either too difficult or too time-consuming to gather the necessary data and to do the necessary analysis.” He adds: “Although good writing is absolutely necessary, it is not sufficient to bring the necessary information to citizens.”

Johnson believes the digital revolution has brought about important change. Not only do we have much faster access to data, but the tools that allow us to analyse data enable us to do things that weren’t possible too long ago. “Thanks to computing, we can now transfer information to a map with the click of a button.”

Despite these new developments, Trench says we’re still scratching the surface, and Brümmer agrees. “This is one sector where there is lots of scope for improvement,” he says.

The biggest challenge is the expense. Costs are high because, as Johnson points out, it takes time to learn how to use and apply the tools. “Media owners have not invested sufficiently and continuously in training journalists. As a result, the topics covered in journalism are superficial,” he says.

Trench agrees that the barrier to entry is quite high, but believes that because data journalism improves the quality of stories, it will become more mainstream. “In future, editors, newsrooms and journalists will have to invest in their own education to remain relevant as the industry evolves,” he says.

Tags: Andrew TrenchChancellor HouseCity PressGoogle RefineInstitute of Analytic Journalism in the USAinvestigative reportingJacques PauwJulian RademeyerMail & GuardianMargaret RennMedia 24Python scriptStefaams Brummer

Sharlene Sharim

Sharlene Sharim is editor of Yip Sport.

Follow Us

  • twitter
  • threads
  • Trending
  • Comments
  • Latest
Kelders van Geheime: The characters are here

Kelders van Geheime: The characters are here

March 22, 2024
Dissecting the LSM 7-10 market

Dissecting the LSM 7-10 market

May 17, 2023
Keri Miller sets the record straight after being axed from ECR

Keri Miller sets the record straight after being axed from ECR

April 23, 2023
Getting to know the ES SEMs 8-10 (Part 1)

Getting to know the ES SEMs 8-10 (Part 1)

February 22, 2018
Sowetan proves that sex still sells

Sowetan proves that sex still sells

105
It’s black. It’s beautiful. It’s ours.

Exclusive: Haffajee draws a line in the sand over racism

98
The Property Magazine and Media Nova go supernova

The Property Magazine and Media Nova go supernova

44
Warrant of arrest authorised for Media Nova’s Vaughan

Warrant of arrest authorised for Media Nova’s Vaughan

41
AI in sponsorship: Beyond the buzzword

AI in sponsorship: Beyond the buzzword

May 9, 2025
Upping the ante: Tracking the year-on-year growth of gambling in SA

Upping the ante: Tracking the year-on-year growth of gambling in SA

May 9, 2025
Seven Days on Social Media: Tonya’s in hospital, the nation’s in chaos and SA doesn’t care about Joshlin

Seven Days on Social Media: Tonya’s in hospital, the nation’s in chaos and SA doesn’t care about Joshlin

May 9, 2025
Social media platforms are replacing Google

Social media platforms are replacing Google

May 8, 2025

Recent News

AI in sponsorship: Beyond the buzzword

AI in sponsorship: Beyond the buzzword

May 9, 2025
Upping the ante: Tracking the year-on-year growth of gambling in SA

Upping the ante: Tracking the year-on-year growth of gambling in SA

May 9, 2025
Seven Days on Social Media: Tonya’s in hospital, the nation’s in chaos and SA doesn’t care about Joshlin

Seven Days on Social Media: Tonya’s in hospital, the nation’s in chaos and SA doesn’t care about Joshlin

May 9, 2025
Social media platforms are replacing Google

Social media platforms are replacing Google

May 8, 2025

ABOUT US

The Media Online is the definitive online point of reference for South Africa’s media industry offering relevant, focused and topical news on the media sector. We deliver up-to-date industry insights, guest columns, case studies, content from local and global contributors, news, views and interviews on a daily basis as well as providing an online home for The Media magazine’s content, which is posted on a monthly basis.

Follow Us

  • twitter
  • threads

ARENA HOLDING

Editor: Glenda Nevill
glenda.nevill@cybersmart.co.za
Sales and Advertising:
Tarin-Lee Watts
wattst@arena.africa
Download our rate card

OUR NETWORK

TimesLIVE
Sunday Times
SowetanLIVE
BusinessLIVE
Business Day
Financial Mail
HeraldLIVE
DispatchLIVE
Wanted Online
SA Home Owner
Business Media MAGS
Arena Events

NEWSLETTER SUBSCRIPTION

 
Subscribe
  • About
  • Advertise
  • Privacy & Policy
  • Contact

Copyright © 2015 - 2023 The Media Online. All rights reserved. Part of Arena Holdings (Pty) Ltd

No Result
View All Result
  • Home
  • MOST Awards
  • News
    • Awards
    • Media Mecca
  • Print
    • Newspapers
    • Magazines
    • Publishing
  • Broadcasting
    • TV
    • Radio
    • Cinema
    • Video
  • Digital
    • Mobile
    • Online
  • Agencies
    • Advertising
    • Media agency
    • Public Relations
  • OOH
    • Events
  • Research & Education
    • Research
    • Media Education
      • Media Mentor
  • Press Office
    • Press Office
    • TMO.Live Blog
    • Events
    • Jobs

Copyright © 2015 - 2023 The Media Online. All rights reserved. Part of Arena Holdings (Pty) Ltd

Welcome Back!

Login to your account below

Forgotten Password?

Retrieve your password

Please enter your username or email address to reset your password.

Log In

Add New Playlist

Are you sure want to unlock this post?
Unlock left : 0
Are you sure want to cancel subscription?