Earlier this year I spoke at the BBC’s Data Fusion Day (you can find a liveblog of the event on Help Me Investigate) about data journalism workflows. The presentation slides are embedded below (the title is firmly tongue-in-cheek), but I thought I’d explain a bit more in a series of posts – beginning here.
Data journalism workflow 1: Set up data newswires
Most newsrooms take a newswire of some sort – national and international news from organisations like the Press Association, Reuters, and Associated Press.
Data journalism is no exception. If you want to find stories in data, it helps to know what data is coming out, when it comes out.
Sid Ryan wanted to see if planning applications near planning committee members were more or less likely to be accepted. In two guest posts on Help Me Investigate he shows how to research people online (in this case the councillors), and how to map planning applications to identify potential relationships.
The posts take in a range of techniques including:
Scraping using Scraperwiki and the Google Drive spreadsheet function importXML
Mapping in Google Fusion Tables
Registers of interests
Using advanced search techniques
Using Land Registry enquiries
Using Companies House and Duedil
Other ways to find information on individuals, such as Hansard, LinkedIn, 192.com, Lexis Nexis, whois and FriendsReunited
If you find it useful, please let me know – and if you can add anything… please do.