The School of Data Journalism is a joint initiative of the European Journalism Centre, the Open Knowledge Foundation, and the International Journalism Festival of Perugia. The third edition consisted of four days of workshops and panels, covering everything from crime investigations to data journalism using spreadsheets, social media data, data visualisation and mapping for journalism.
In this post you will find all the links shared during this training event, the video replays of the panel sessions and workshops, links to the slides of the panelists and instructors. If you have links shared during the sessions that we missed, post them in the comments section and we will update the list.
Video recordings and notes
Panel discussions
The year in data journalism around the world: developments and trends
Data journalism for small newsrooms
Data, fact-finding and breaking news
Data journalism in Italy and the Mediterranean area: from niche to mainstream
Workshops
From idea to story: planning the data journalism story
Data journalism tools: maps
Interactive storytelling
Investigating crime and corruption
Get your own data through aerial photography
Web scraping for non programmers
Privacy and Digital Security
Pictures
You can find some pictures here. Please do feel free to share your pictures with us!
Slides, tutorials, articles
Article on the “Year in data journalism” panel discussion (Martin Belam, Amp3d)
Article on “Year in data journalism” panel discussion (Alastair Reid, Journalism.co.uk)
Slides, data and cheat sheet from “From idea to story: planning the data journalism story” (Steve Doig)
Article “From idea to story: planning the data journalism story” (Alastair Reid, Journalism.co.uk)
Hands on tutorial on planning data journalism story (School of Data)
Slides and data from the session “Using Excel for Journalism” (Steve Doig)
Hands on tutorial on using Excel for Journalism (School of Data)
Slides, data and other resources from session “Investigating crime and corruption” (Giannina Segnini)
Detailed article summarising the session “Investigating crime and corruption”
Slides on interactive storytelling (Mariana Santos)
Sides on aerial mapping (Cindy Regalado)
Hands on tutorial on how to fly a kite, collect aerial data and put it together with mapknitter
Notes, examples and cheat sheet on building maps for journalists (Annabel Church)
Notes, cheat sheet and tools for web-scraping for journalists (Annabel Church)
Tools and other resources
Microsoft Excel or any other spreadsheet tool like Calc, Google Spreadsheets
http://www.storyboardthat.com/ – tool for creating storyboards
http://www.dafont.com/ – collection of fonts and icons for your animations and graphics
http://thenounproject.com/ – collection of free icons that can be used for animations and graphics Google Fusion Tables
http://infogr.am/ - great resource for creating beautiful out of the box infographics
http://topsy.com/, http://www.sysomos.com/ -tools for searching Twitter data
http://cartodb.com/ – mapping tool
http://datawrapper.de/ – beautiful tool to create simple graphs and maps oline
Google fusion table maps – allows you to easily create maps and helps you geocode your data
http://colorbrewer2.org/ - tool for selecting colours
Leaflet - desktop tool for mapping
QGIS – open source desktop tool for mapping
Storymap – allows you to create interactive maps and timelines
Timelinejs – - allows you to create interactive maps and timelines
import.io – tool for web-scraping
Scraper: a chrome extension to easily scrape data
Other data scraping tools: Kimono, morph.io, Scraperwiki
Table Capture for Chrome or Clipboard2Table for Firefox – browser extensions for scraping
http://mapknitter.org/ – map to stich together aerial photos
Security in a Box - a comprehensive resource for journalist on how to stay safe online
Me and My Shadow – an online tool allowing you to see the traces you leave behind when using technology and internet
Tools for investigating maritime database – a comprehensive list can be found here
http://ushahidi.com/ Open Source UGC mapping tool
http://twitcident.com/ a tool for mapping breaking news situations.
Source, an index of news developer source code, code walkthroughs and project breakdowns from journalist-coders
Open Refine (for data cleaning)
Gephi (for graph visualisations)
Hashtagify (visualisation of Twitter hashtags related to a particular #tag)
Investigative Dashboard (methodologies, resources, and links for journalists to track money, shareholders, and company ownership across international borders)
Tabula (open-source application that allows users to upload PDFs and extract the data in them in CSV format)
DataSift (platform that allows users to filter insights from social media and news sources, mentioned in panel on covering emergencies)
Storyful (service that mines social media to discover content relevant for news organisations and verifies it)
GeoFeedia (tool that enables location-based search for social media content)
Spokeo (organises information about people from public sources and make it available for search)
The Tor project (free software that helps defend against network surveillance and censorship)
Follow the Money: A Digital Guide for Tracking Corruption (a handbook for investigative journalists that shows methods, tips and tricks for for tracking companies across borders)
Organisations and initiatives
http://www.vox.com/
http://ampp3d.mirror.co.uk/
http://fivethirtyeight.com/
www.nytimes.com/upshot/
http://www.theguardian.com/news/datablog
http://www.datajournalism.it/
Data journalism projects
NSA Files Decoded by The Guardian
What your activity tracker sees and does not see by the NYT
Giant Slalom Newsgraphic, NYT
Gay rights in the US, state by state, The Guardian
http://11septiembre1973.latercera.com/en/
How many people are speaking English on rush hour trains out of Charing Cross, Amp3d
Watch Wayne Rooney’s earnings add up in real-time, Amp3d
Star Health, Code4Kenya
New York Times Electoral Explorer, 2008
New York Times President Map, 2012
Guardian Election map and swingometer, 2010
Mappa elettorale di YouTrend – Elezioni politiche, 2013
Mappa elettorale di YouTrend – Primarie PD, 2013