On this page we’ll gather all EIJC & Dataharvest 2018 material, ranging from speakers’ tip sheets and presentations over written accounts and wrap-up articles to photos. If you wrote something, be sure to share it with us!
Tip sheets / Hand-outs
- Anne Koch: GIJN – The place to go for tips on investigations, fundraising, networks, nonprofits
- Simon Woerpel – How to filter big csv files based on values occurring in specific columns
- Simon Woerpel – How to find stories in public data
- Steffen Kühne: ‘If you are interested in our story (and methodology) about racial discrimination in the rental housing market, go to https://www.hanna-und-ismail.de/english/
- Marcus Lindemann – Gadgets for investigative reporting
- Yordi Dam – Batch geocoder for journalists by LocalFocus
Hands-on sessions / Presentations
- Leila Haddou & Max Harlow – Don’t fear robots
- Leila Haddou & Max Harlow – Graph Databases 1
- Maarten Lambrechts – Data tools for everyday journalism
- Maarten Lambrechts – Statistic pitfalls in the news
- Robert Gebeloff – Everything you need to know to become a world class data journalist — in one fabulous session
- Robert Gebeloff – Introduction to mappig with QGIS
- Max Harlow – Finding needles in haystacks with fuzzy matching (command line tool)
- Marianne Bouchaert – Latest trends in Data Journalism
- Craig Shaw, Şebnem Arsu, Efe Kerem Sözeri – Can journalism networks help investigations under authoritarian regimes? The case of Turkey
- Mark Lee Hunter – collaborating with ngos 230518
- Marcus Lindemann – Strategies to find personal information
- Journalism with a cause and journalism funded by interest organizations: business model or grey-zone?
- Albrecht Ude – Presentation: Researching the Deep Web : Finding and Using Databases
- Albrecht Ude – Detecting Fake News: Checking Sources and Facts
- Marlies de Brouwer & Tania Röttger – Presentation basics FOIA
- Laura Motet – Investigating the drop in women health care use(1)
- Catherine Riva & Serena Tinari – Investigating Health (Re-Check)
- Tabea Grzeszyk – Call out your bias! Embracing diversity through cross-border collaboration
- Jose Miguel Calatayud – 2018-05-27 JMCalatayud – Data.Citizen – EIJC18
All Python materials will be collected in this Github repo. For the time being, use these links:
- Learning the Python basics, by Adriana Homolova and Winny de Jong, notebook.
- How to load and manipulate files in Python, by Robert Gebeloff, empty notebook, notebook with answers.
- Scraping websites, by Barnaby Skinner, data + notebook.
- Analysing tens of thousands of files in one go, by Barnaby Skinner, data + notebook.
- Python Pandas: analysing tender data, by Adriana Homolova, notebook, cheatsheet + data.
- CSVMatch, a command line tool to find (fuzzy) matches between two CSV files, by Max Harlow.
- Reconcile, a command line tool to enrich data by doing batch lookups against online services, by Max Harlow.
- Tabula, a tool for liberating data tables stored in PDF’s.
- Flourish for polished, beautiful datavisualisations.
- Public available data portals, a list by Simon Woerpel.
- Elvis, public procurement data visualised in a network, by Adriana Homolova and team.
- Lists of subsidiaries from SEC filings – great for researching multinational companies, via Helena Bengtsson.
- European regional data, presented by Peter Sherlock and John Walsh. slides and factsheet
- Melanie De Vrieze – Joris Luyendijk’s keynote address: Bringing journalism into a new era
- Joris Luyendijk’s full speech
- Luuk Sengers – Python, R or SQL? The tribal ‘war’ of data journalism
- Tarjei Abelsen – Kongegraver Eiliv Frich Flydal har satt spor etter seg på Slottet. Nå kan metodene bli eksportvare til resten av Europa
Pieter Fannes – A graphic representation of #EIJC18
Photos & Videos
More photos and videos on Facebook.
Students from Thomas More Journalism School got the chance to report about the conference. See the videos below.