Loading…
This event has ended. View the official site or create your own event → Check it out
This event has ended. Create your own
The European Investigative Journalism and Dataharvest Conference organised by Journalismfund.eu, is the most relevant networking event for investigative and data journalists in Europe. Dataharvest EIJC17 will take place on Friday 19, Saturday 20 and Sunday morning 21 May 2017, with a pre-conference Hack Day on Thursday 18 May.
View analytic

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

Thursday, May 18
 

09:58

Pre-Dataharvest Hack Day
During the Dataharvest Hack day volunteer data developers and data journalists will work with selected European data sets and tools and prepare them for the journalists who attend the conference. Coders and others interested in open data gather for the Pre-Dataharvest Hack Day and work on datasets of public interest. Participating in the Hack Day is free but you must confirm your attendance here: http://www.journalismfund.eu/hack-day-0. The preparation of the datasets is discussed on this discourse page where participants are welcome to suggest a topic: https://discourse.thesponge.eu/c/dataharvest/eijc17

Speakers
avatar for Georgiana Bere

Georgiana Bere

Developer, OpenTrials
I am a programmer and a data geek interested in government transparency and anti-waste initiatives. Most of my work revolves around public procurements from EU countries.
avatar for Adriana Homolova

Adriana Homolova

Data Journalist, Investico/One World
Adriana Homolová is a data journalist based in Amsterdam. She works as a data journalist at Investico a platform for investigative journalism and for the print and online magazine One World. She is passionate about coding, vector graphics and investigating government spending... Read More →
avatar for Friedrich Lindenberg

Friedrich Lindenberg

Tech Coordinator, OCCRP
Friedrich Lindenberg is a coder and data journalist working on web technology for new narrative and investigative techniques. He was an 2014 ICFJ Knight International Journalism Fellow with Code for Africa, and a 2013 Knight-Mozilla OpenNews Fellow at Spiegel Online. Previously... Read More →
avatar for Victor Nitu

Victor Nitu

Developer, The Sponge Media Innovation Lab
Victor Nitu is developer at The Sponge Media Innovation Lab.
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

OKFN
Stefan is a software engineer and creator of civic applications. He has created Mapnificent, a public transport utility, and Frag Den Staat, Germany's Freedom of Information portal.


Thursday May 18, 2017 09:58 - 18:00
C1.25 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

09:59

Pre-Dataharvest Train the Trainers
What is the best way to train data journalism skills? How do you plan a workshop that shares your knowledge and empowers reporters? When do you slow down and when do you accelerate your training pace? How do you deal with disruptive trainees or a mix of skill levels across the classroom? How do you charge someone with enthusiasm for learning while preparing them for hard work after a three-session jumpstart into a new coding language? And how can trainers keep a class engaged over a two-day bootcamp? Data Harvest is proud to host its first Train the Trainers course for data journalism teachers. Some of the world's best DDJ veteran educators will introduce their methods and share their wisdom accumulated while training worldwide over the past 20 years. The workshop brings together Helena Bengtsson, Jodi Upton, Brant Houston, Luuk Sengers, Nils Mulvad and Jonathan Stoneman. Participants will immerse in open discussions, hands-on demonstrations with live critique, and take home a unique workshop report collecting all presentations, tip sheets and used data. Check out the programme here: https://docs.google.com/spreadsheets/d/1s3fIyC3UE-2hdsQss29OlFeuOSZ1DWmlUCLmPT1fFAY/edit?usp=sharing

Speakers
avatar for Helena Bengtsson

Helena Bengtsson

Editor, Data Projects, The Guardian
Helena Bengtsson is Editor, Data Projects at the Guardian in London, UK. She previously worked as the database editor at Sveriges Television, Sweden’s national television broadcaster. In 2006 and 2007, she was database editor at the Center for Public Integrity in Washington, D.C. She was awarded the Stora Journalistpriset (Great Journalism Award) in 2010 for Valpejl.se, a website profiling every candidate in that season’s Swedish elections and in 2016 for Innovator of the year. Twitter... Read More →
avatar for Brant Houston

Brant Houston

Global Investigative Journalism Network (GIJN), Chair
Brant Houston is the Knight Chair in Investigative Reporting at the University of Illinois where he teaches investigative and data journalism and oversees an online newsroom. He previously was executive director of Investigative Reporters and Editors, a group of 5,000 members, an... Read More →
avatar for Nils Mulvad

Nils Mulvad

Editor, Kaas & Mulvad
Nils Mulvad er redaktør og grunnlegger av Kaas & Mulvad. Fra 2001 til 2006 var han direktør for Danish International Center for Analytical Reporting, DICAR. Fra 2001 var han assosiert professor ved den Danske Journalisthøyskolen. Nils Mulvad var en av de to grunnleggerne av Global Investigative Journalism Network og sitter i organisasjonens styre.----NILS MULVAD is editor at Kaas & Mulvad. From 2001-2006 he was executive director of the Danish International Center for Analytical Reporting, Dicar. From 2001 and onwards he worked as associate professor at The Danish School of Media and Journalism. With former IRE-director Brant Houston he was the main responsible for the two first Global Investigative Journalism Conferences in 2001 and 2003 in Copenhagen and was co-founder of the Global Investigative Journalism Network... Read More →
avatar for Luuk Sengers

Luuk Sengers

Trainer, Lecturer, Investigative Journalist, Freelance journalist
Luuk Sengers (1966) is an independent investigative journalist, university lecturer and media trainer. He writes about environmental issues (his recent stories appeared in AD, Trouw and De Groene Amsterdammer) and he educates students, media professionals and activists in investi... Read More →
avatar for Jonathan Stoneman

Jonathan Stoneman

Freelance trainer
I am a freelance trainer mainly concentrating on how to get the most out of open data, where to find it, what tools to use, and how to analyse it and find stories.
avatar for Jodi Upton

Jodi Upton

Senior database editor, USA Today
Jodi Upton is the Senior Database Editor at USA TODAY, where she leads the database team in analysis on stories from mass killings to the job market to football coach contracts. Her team supports breaking news, investigative projects and everything in between, as well as data-dri... Read More →


Thursday May 18, 2017 09:59 - 18:00
C2.15

13:00

Lunch & Networking
Thursday May 18, 2017 13:00 - 14:00
Foyer

15:55

Coffee
Thursday May 18, 2017 15:55 - 16:15
Foyer
 
Friday, May 19
 

10:00

Welcome
Welcome to Dataharvest/EIJC 2017! Let's play ball!

Speakers
avatar for Brigitte Alfter

Brigitte Alfter

Managing Editor, Journalismfund.eu vzw
Journalist in Europe / Co-founder and managing editor of Journalismfund.eu / co-founder and program responsible European Investigative Journalism Conference and Dataharvest.eu / co-founder Wobbing.eu, Farmsubsidy.org, I-Scoop.org / member of www.icij.org, www.fuj.dk, www.netzwerk... Read More →


Friday May 19, 2017 10:00 - 10:20
Auditorium Z1/13 Hanswijk

10:20

Networking welcome
Friday May 19, 2017 10:20 - 11:00
Lobby

11:00

KEYNOTE: From LuxLeaks to trade secrets
In 2014 Edouard Perrin from French TV Press Agency Premières Lignes was in the core team of the ICIJ-LuxLeaks research team. He was the first to obtain the Lux Leaks data and other extremely important material. Since 2011 he has traced and uncovered tax avoidance and tax evasion. In 2016 and 2017 he had to appear before a court in Luxembourg along with the two whistleblowers of the Lux Leaks case. But in the meantime the EU has passed a controversial directive to protect trade secrets, which journalists in Europe must be aware of, if they want to cover business in the future.

Moderators
avatar for Brigitte Alfter

Brigitte Alfter

Managing Editor, Journalismfund.eu vzw
Journalist in Europe / Co-founder and managing editor of Journalismfund.eu / co-founder and program responsible European Investigative Journalism Conference and Dataharvest.eu / co-founder Wobbing.eu, Farmsubsidy.org, I-Scoop.org / member of www.icij.org, www.fuj.dk, www.netzwerk... Read More →

Speakers
avatar for Edouard Perrin

Edouard Perrin

Reporter, Premières Lignes
Edouard Perrin, France, is a reporter with production company Premières Lignes. He previously worked with French public television station France 2.Perrin is currently an investigative journalist with Premières Lignes' Cash Investigation series. In a 2012 investigation in conjunction with the BBC, Perrin revealed for the first time details of secret agreements between the Luxembourg tax authorities and multinational corporations that allowed companies to drastically reduce their tax bills. Perrin was awarded the Louise Weiss prize for European Journalism for his part in the investigation.In 2014, Perrin worked with ICIJ on the... Read More →


Friday May 19, 2017 11:00 - 12:00
Auditorium Z1/13 Hanswijk

12:00

#PanamaPapers - lessons learned
Panama Papers was the largest cooperation in journalism history, and of course not everything went perfect. Which lessons did the participants learn that others can benefit from knowing?

Speakers
avatar for Kristof Clerix

Kristof Clerix

Journalist, Knack
Kristof Clerix (*1978), Belgium, works as a reporter for the Belgian weekly news magzine Knack and previously reported for a Belgian magazine on international affairs. As member of the International Consortium of Investigative Journalists (ICIJ), he collaborated on LuxLeaks, SwissLeaks, Evicted&Abandoned, the Panama Papers and Bahamas Leaks. | | Clerix has been working as a journalist in Belgium since 2002. After two years freelancing for the Belgian daily... Read More →
avatar for Delphine Reuter

Delphine Reuter

IHECS
Delphine Reuter is a Belgian freelance journalist, based in Brussels. A graduate from IHECS and Columbia University's Graduate School of Journalism, she has led and taken part in cross-border investigative projects related to financial crime, environmental crime, migration, etc... Read More →
avatar for Cécile Schilis-Gallego

Cécile Schilis-Gallego

Data journalist and researcher, ICIJ
Cécile Schilis-Gallego is a data journalist and researcher for ICIJ. She graduated in 2014 from Columbia Journalism School (US) and Sciences Po Journalism School (France) with a master's degree in investigative reporting. She is a 2014-2015 Brown Institute Magic Grantee, working... Read More →
avatar for Vanessa Wormer

Vanessa Wormer

Data journalist, Süddeutsche Zeitung
Vanessa Wormer is a data journalist at Süddeutsche Zeitung in Munich and member of the Panama Papers investigation team. In 2015 she passed the Lede Program in Computing and Data Science at Columbia Journalism School in New York City. Vanessa is curious about how technology can... Read More →


Friday May 19, 2017 12:00 - 13:00
Auditorium Z1/13 Hanswijk

12:00

EU for beginners
If you want to do journalism beyond the narrow national borders, you need a basic understanding of how the EU works. Sigrid Melchior is a longtime Brussels correspondent for Swedish media and based in Brussels. She has published a succesful handbook on covering the EU in Swedish, an English version is forthcoming. In this session she will provide a beginners' guide to the EU institutions from a journalistic point of view: Understand the power structures to cover decision making and administration. NOTE: This workshop will be followed by a workshop on covering EU- and EU-regulated spending.

Speakers
avatar for Sigrid Melchior

Sigrid Melchior

Journalist
Swedish journalist based in Brussels, reporting on EU and European affairs.


Friday May 19, 2017 12:00 - 13:00
Z3/04

12:00

Data tour - Eurostat - introduction to European statistics
Eurostat publishes statistical data on a wide range of subjects at European level that enable comparisons between countries and regions. Meet Chris Laevaert of Eurostat who will guide you through the nitty-gritty of automatically downloading data, the website, the interactive infographics and specific services offered to journalists.

Speakers
CL

Christiaan Laevaert

Team Leader Internet, Eurostat
Chris Laevaert joined the Digital dissemination Unit of Eurostat in 2005 and is now team leader Internet, where he is responsible for the management of the Eurostat website including the associated visualisations. He is an active member of the Dissemination Working Group in the European Statistical System, which discusses and exchanges best practices in the area of dissemination of statistical information. Since 30 years, he is an official of the European Commission and was involved in various projects in the field of informatics engineering as well as the institution's Data... Read More →


Friday May 19, 2017 12:00 - 13:00
Z3/02

12:00

Why you should distrust polls
The past year, election and referendum outcomes have surprised many because they were not in line with polling results. There were many reasons for this: bad polling methodologies, but also misinterpretation of polling results by both reporters and the public. In this session, Maarten Lambrechts explains and demonstrates the pitfalls in interpreting polling results for reporting and for making predictions.

Speakers
avatar for Maarten Lambrechts

Maarten Lambrechts

Freelance Data Journalist
Maarten Lambrechts is a freelance data journalist, data designer and visualization consultant.


Friday May 19, 2017 12:00 - 13:00
C2.17 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

12:00

Easy scraping with Import.io I
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Easy scraping with Import.io - Workshop I/II:
Basic scraping using New Extractor
How to use URL-building for the extractor
You can use Import.io for free for 500 queries pr. Month. If you need more, Dataharvest has made a special agrement with Import.io for a discount for journalists. We will cover reporting needs and software options. Only 25 people allowed in, first come first serve.

Speakers
avatar for Nils Mulvad

Nils Mulvad

Editor, Kaas & Mulvad
Nils Mulvad er redaktør og grunnlegger av Kaas & Mulvad. Fra 2001 til 2006 var han direktør for Danish International Center for Analytical Reporting, DICAR. Fra 2001 var han assosiert professor ved den Danske Journalisthøyskolen. Nils Mulvad var en av de to grunnleggerne av Global Investigative Journalism Network og sitter i organisasjonens styre.----NILS MULVAD is editor at Kaas & Mulvad. From 2001-2006 he was executive director of the Danish International Center for Analytical Reporting, Dicar. From 2001 and onwards he worked as associate professor at The Danish School of Media and Journalism. With former IRE-director Brant Houston he was the main responsible for the two first Global Investigative Journalism Conferences in 2001 and 2003 in Copenhagen and was co-founder of the Global Investigative Journalism Network... Read More →


Friday May 19, 2017 12:00 - 13:00
Z1/16

12:00

Excel I
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Excel 1 - This is for the beginner who wants to know how to use spreadsheets for journalism. You will learn how to sort and filter data, which actually is the methods used for about 80% of all data journalism. (Quote from Aron that I can't find right now) We will talk about how to make and structure your own spreadsheets and how to tackle spreadsheets from statistical agencies. By the end of this session you will feel much more comfortable the next time a spreadsheet lands in your inbox. Only 25 people allowed in, first come first serve.

Speakers
avatar for Helena Bengtsson

Helena Bengtsson

Editor, Data Projects, The Guardian
Helena Bengtsson is Editor, Data Projects at the Guardian in London, UK. She previously worked as the database editor at Sveriges Television, Sweden’s national television broadcaster. In 2006 and 2007, she was database editor at the Center for Public Integrity in Washington, D.C. She was awarded the Stora Journalistpriset (Great Journalism Award) in 2010 for Valpejl.se, a website profiling every candidate in that season’s Swedish elections and in 2016 for Innovator of the year. Twitter... Read More →
avatar for John Bones

John Bones

Managing Director, SKUP
John Bones is Managing Director at SKUP, the Norwegian Foundation for Investigative Reporting. For many years, Bones was the datajournalism specialist at VG, the most read daily newspaper in Norway, and previously was editor and politics editor. Started his career at Adresseavise... Read More →


Friday May 19, 2017 12:00 - 13:00
Z1/14

12:00

SQL for journalists I
Limited Capacity filling up

SQL for journalists 1/3: What to do when Excel is not enough to crunch your data and hardcore coding is not your style? SQL is like Excel, but on steroids! The first of 3 workshops will introduce you to the lingua franca of programming and a popular relational database. We'll cover what it does; creating a database, importing a spreadsheet; and main SELECT STATEMENTS - Crina Boros Note: Familiarity with Excel is recommended for those wishing to attend. Only 25 people allowed in, first come first serve.

Speakers
avatar for Crina Boros

Crina Boros

Investigative & Data Journalist | CAR Trainer, Investigate Europe | Trainer at the Centre for Investigative Journalism (CIJ)
London-based investigative Journalist and CAR trainer at the Centre for Investigative Journalism (CIJ), Crina specialises in data analysis, transparency cross-border and accountability-driven reporting. She currently freelances for Investigate Europe and and mentors at newsPeeks... Read More →


Friday May 19, 2017 12:00 - 13:00
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

12:00

Local and European - global journalism made in Bristol
The Bristol Cable is a citywide media co-operative publishing in print and online. It produces public interest journalism and has a dynamic and democratic structure for its 1600 paying members. The Cable is redefining local journalism both in terms of content and business model. It conducts original investigations, amplifies local voices, hosts educational training, and provides national and international context to situate its coverage. The Cable has investigated a range of issues, from Bristol entities found in the Snowden Leaks, to tax dodging property developers, and the shady deals between city council and corporations. The Bristol Cable is among the more interesting local journalism start-ups in a time when local media ownership in many European countries is getting more and more centralised.

Speakers
avatar for Alon Aviram

Alon Aviram

co-founder, The Bristol Cable media coop
Alon Aviram is a co-founder and operations coordinator at the Bristol Cable, the UK's only citywide media co-operative. He has investigated a range of areas, including police surveillance, worker exploitation and housing. With over 1600 paying members, the Bristol Cable is demonstrating a re-imagined, democratic local media that can hold power to account... Read More →
avatar for Lorna Stephenson

Lorna Stephenson

The Bristol Cable
Lorna Stephenson works for The Bristol Cable.


Friday May 19, 2017 12:00 - 13:00
C2.23 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

12:00

Digital security I
Digital security is vital for investigative journalists, and we have dedicated a separate track to tips and tools – and practical assistance to secure your gear, your sources and yourself. Introduction to the track of sessions, how to be more conscious about security and to navigate the threats.

Speakers
avatar for Aslak Ransby

Aslak Ransby

Programmer and security trainer.
I'm @aslakransby on twitter.
avatar for Freja Wedenborg

Freja Wedenborg

Danish journalist and author of Cryptoguide for journalists, www.cryptoguide.dk. Teaching digital self defense at the Danish School of Media and Journalism. I'm @FrejaWedenborg at Twitter.


Friday May 19, 2017 12:00 - 13:00
C2.25

12:00

Fact-checking - get it right every time!
Get it right – all of it, all the time! The Swedish weekly investigative TV program Uppdrag Granskning (Mission Investigate) has strict rules for quality control and fact checking. The process starts at the very beginning with a Devil´s advocate examining the idea. At the end every fact needs to be questioned and verified – line by line. Selection of facts and basis for conclusions are scrutinized. The method has built trust, both in the audience and between journalists and sensitive sources. UG editor Nils Hanson, who with his team invented the quality control system, shares his methods.

Speakers
avatar for Nils Hanson

Nils Hanson

Editor-in-Chief, Swedish Television (SVT
is the Editor-in-Chief of Uppdrag Granskning (Mission Investigate) at the public service television company Swedish Television (SVT). The investigative one-hour television programme is aired primetime once a week, 45 times a year. Nils, a former investigative reporter, has 36 peo... Read More →


Friday May 19, 2017 12:00 - 13:00
Auditorium Z1/15 Donche

12:00

Master class: Follow the money I
You don't always need the Panama Papers to get Panama Papers. In fact, a share of the records used in the historic groundbreaking investigation was actually gathered from offshore public record depositories around the world. In this session, you will learn how to access the records from tax heavens that seem impossible to get.

Case Study
Exposing Crime and Corruption: How Do They Operate
Research Process: Investigating People and Companies
Understanding Public Records
Online Business Databases
Tracking Offshore Companies - (Bring your own laptops)

Speakers
avatar for Miranda Patrucic

Miranda Patrucic

Regional Editor, Organized Crime and Corruption Reporting Project
Miranda Patrucic is toonaangevend redacteur bij The Organized Crime and Corruption Reporting Project (OCCRP) en verantwoordelijk voor de regio van de Balkan tot Centraal-Azië. Ze krijgt half november in Washington de prestigieuze Knight International Award 2016 uitgereikt. Patrucic is gespecialiseerd in het onthullen van corruptieschandalen, bijvoorbeeld... Read More →


Friday May 19, 2017 12:00 - 13:00
C2.27

12:00

Ponzi schemes - Norway, Estonia, and your country?
International Ponzi schemes: Businesses running Ponzi schemes in Norway, Estonia ... and your country? Meet the team behind the story and hear the methodology of researching business scam. The team focuses on one of the many new mlm-companies Ultimate Business World (ubwglobal.com), which has/had huge international ambitions, but started to have many problems after stories published in Estonia and Norway. NOTE: This presentation is followed by a networking round table, where cross-border collaboration with the data unearthed by Piret Reiljan and Rune Ytreberg and potentially other data will be discussed.

Speakers
avatar for Piret Reiljan

Piret Reiljan

Head of investigative desk, Estonian business daily Äripäev
Piret Reiljan is an Estonian investigative journalist. She has been working as a journalist for the Estonian business daily Äripäev since 2006 and since 2017 she is head of investigative desk. | She covers a wide range of topics, including tax frauds, investment frauds and cor... Read More →
avatar for Rune Ytreberg

Rune Ytreberg

Journalist, Dagens Næringsliv
Cover oil, fish, politics and business in northern Norway, Spitsbergen and northwest Russia. Interested in databases, mapping, semiotic search.


Friday May 19, 2017 12:00 - 13:00
Z3/11

12:00

Wobbing /FOI for beginners
Freedom of information legislation, WoB, Liberté d’informer, Right to Information – all these names cover the right of the public to know what their institutions do. They are powerful tools to unearth credible information, but how to get started? And which laws to use – which are strongest, most suitable for the topic you work with? This presentation helps you to understand the overall structures so you can get started. In principle these laws resembles each other: the citizens get the right to access to information, while fields like privacy, business and security enjoy varying degrees of protection. There are regional, national and international laws in hierarchic structures and it can make sense to use thematic or other countries laws than ones own.

Speakers
avatar for Staffan Dahllöf

Staffan Dahllöf

Freelance reporter
Staffan Dahllöf (1955) is a freelance reporter based in Copenhagen. Dahllöf is a member of the Farmsubsidy team. In 1993 he was co-editor and co-author of "Journalisternas EG-handbok", a guide in Swedish on EC/EU reporting. Since 1994 he has been engaged in courses on EU report... Read More →
avatar for Tania Röttger

Tania Röttger

Reporterin, Correctiv
Tania Röttger studierte Sozial-, Rechts- und Wirtschaftswissenschaften in London und Berlin und arbeitete danach in einem Londoner Recherchebüro, wo sie die Auskunftsrechte als Instrument investigativer Recherche kennenlernte.Tanja Röttger arbeitet als Journalistin des gemeinnützigen Recherche-Zentrums... Read More →


Friday May 19, 2017 12:00 - 13:00
C2.30

13:00

Lunch
Friday May 19, 2017 13:00 - 14:00
Lobby

14:00

Film screening: The EU Commission, the defense lobbies and the refugee crisis
Watch the documentary by Investigate Europe and VICE Greece - with English subtitles - and meet Nikolas Leontopoulos and others from the team behind this cross-border research investigating how the security industry lobby shaped the EU Commission's response to the refugee crisis.

Speakers
avatar for Nikolas Leontopoulos

Nikolas Leontopoulos

Journalist, Investigate Europe | VICE Greece
I am an Athens-based journalist, born in 1971. I worked for ten years for the Greek daily Eleftherotypia. Since 2009 I have been reporting on the financial and the migration crisis for a number of international media. I collaborated in investigations with Reuters on banks, shipping and the media in Greece, and contributed reporting in the... Read More →
avatar for Harald Schumann

Harald Schumann

Sernior Reporter, Tagesspiegel
European journalism must follow the economic integration. The purely national perspective produces almost ever bad results and repeats only the propaganda those in power want us to report....


Friday May 19, 2017 14:00 - 15:00
Z3/14

14:00

Unveiling the migration business
The Migration Machine – does Europe care? On the night of April 9, 2016, around 500 adults and children drowned in the Mediterranean, the largest loss of life that year. Seven months later no official body, national or multinational, had held anyone to account for the deaths or even opened an inquiry into the shipwreck. A Reuters investigation identified many of the dead, the owners of the ship, showed how the brokers got in contact with the migrants on social media and proved it possible to map the brokers’ network and identify them. The investigation demonstrates the gaps in international law enforcement that make it easy for human smugglers to pursue their deadly trade in the Mediterranean. But it also shows what could be done if authorities chose to make a priority of investigating migrant deaths. Stephen Grey of Reuters explains the methods the team used for “The Migration Machine”. (followed by networking session on how to investigate migration). http://www.reuters.com/investigates/special-report/migration/#story/60

Moderators
avatar for Sylke Gruhnwald

Sylke Gruhnwald

Chairwoman and journalist, Journalismfund.eu
Sylke Gruhnwald is chairwoman of Journalismfund.eu and investigative reporter with the Swiss magazine «Beobachter». Studies of Sinology and Business Administration. Worked for «The Economist Group», its «Economist Intelligence Unit» as well as the Swiss daily newspaper «Neue Zürcher Zeitung» and the Swiss public broadcaster «Schweizer Radio und Fernsehen». sgr. is co-founder of... Read More →

Speakers
avatar for Stephen Grey

Stephen Grey

reporter, Reuters
I am a London-based writer and reporter, working as a correspondent on a special projects team of the Reuters news agency.I have covered the subject of national security in its many forms, including terrorism, the work of security agencies, as well military conflict, including in... Read More →


Friday May 19, 2017 14:00 - 15:00
Z3/02

14:00

Data tools for everyday journalism
Smaller newsrooms don't always have the means to hire coders or buy expensive software to work with data. In this session Maarten Lambrechts shows some easy to use (no coding required), fast and free tools to gather, transform, analyse and visualise data. Think Import.io, Open Refine, Carto, Chartbuilder and Datawrapper.

Speakers
avatar for Maarten Lambrechts

Maarten Lambrechts

Freelance Data Journalist
Maarten Lambrechts is a freelance data journalist, data designer and visualization consultant.


Friday May 19, 2017 14:00 - 15:00
C2.17 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

14:00

Data tour – European Structural and Investment funds – ESI Funds
The five 5 ESI Funds represent over 40% of the EU budget (EUR 454 billion in the period 2014-2020). They are delivered through over 530 national or regional programmes and provide a clear local or national link to the EU's efforts to improve investment and economic, social and environmental development. The multi layered and multi annual nature of these funds make a challenge to present and explain simply! Meet John WALSH from the European Commission (DG Regional and Urban Policy) who will give you a short introduction into the ESI Funds Open Data platform - https://cohesiondata.ec.europa.eu/ - and then walk you through the financial and policy achievements provided by the platform (FAQ: http://ec.europa.eu/regional_policy/en/faq/about_open_data/ )

Speakers

Friday May 19, 2017 14:00 - 15:00
Z3/09

14:00

How not to be wrong
As journalists, we're obsessed with getting it right. But after two decades in data journalism, I've come to think of it differently. I want to be right -- but first I want not to be wrong. It's a semantic distinction that keeps my reporting level-headed and focussed. In this talk, I'll discuss how to grapple with uncertainties that arise during data analysis, how to describe findings more precisely, and how to turn hostile sources into a reporting asset.

Speakers
avatar for Robert Gebeloff

Robert Gebeloff

Database Projects Editor, The New York Times
Robert Gebeloff has been a database projects editor at The New York Times since 2008. He was a finalist for the Pulitzer Prize in 2015 for a series about corporate legal attacks on the rights of U.S. consumers and employees to sue, and again in 2016 for stories about racial dispa... Read More →


Friday May 19, 2017 14:00 - 15:00
C2.21

14:00

Easy scraping with Import.io II
Limited Capacity filling up

Easy scraping with Import.io - Workshop II/II:
Using Chrome Inspect to find hidden URL's
Building URL's in spreadsheet
Using one extractor as URL-input to another extractor
Export data to csv. Only 25 people allowed in, first come first serve.

Speakers
avatar for Nils Mulvad

Nils Mulvad

Editor, Kaas & Mulvad
Nils Mulvad er redaktør og grunnlegger av Kaas & Mulvad. Fra 2001 til 2006 var han direktør for Danish International Center for Analytical Reporting, DICAR. Fra 2001 var han assosiert professor ved den Danske Journalisthøyskolen. Nils Mulvad var en av de to grunnleggerne av Global Investigative Journalism Network og sitter i organisasjonens styre.----NILS MULVAD is editor at Kaas & Mulvad. From 2001-2006 he was executive director of the Danish International Center for Analytical Reporting, Dicar. From 2001 and onwards he worked as associate professor at The Danish School of Media and Journalism. With former IRE-director Brant Houston he was the main responsible for the two first Global Investigative Journalism Conferences in 2001 and 2003 in Copenhagen and was co-founder of the Global Investigative Journalism Network... Read More →


Friday May 19, 2017 14:00 - 15:00
Z1/16

14:00

Excel II
Limited Capacity filling up

Excel 2: For this class you either have to have been in the previous class - or feel a little bit more comfortable with spreadsheets than an absolute beginner. In this session we will talk about functions and how they are used for doing stories. How do you split a name into first, last and other stuff? How do you work with dates? By the end of this session you will know how to manipulate data so that you can use it. Only 25 people allowed in, first come first serve.

Speakers
avatar for Helena Bengtsson

Helena Bengtsson

Editor, Data Projects, The Guardian
Helena Bengtsson is Editor, Data Projects at the Guardian in London, UK. She previously worked as the database editor at Sveriges Television, Sweden’s national television broadcaster. In 2006 and 2007, she was database editor at the Center for Public Integrity in Washington, D.C. She was awarded the Stora Journalistpriset (Great Journalism Award) in 2010 for Valpejl.se, a website profiling every candidate in that season’s Swedish elections and in 2016 for Innovator of the year. Twitter... Read More →
avatar for John Bones

John Bones

Managing Director, SKUP
John Bones is Managing Director at SKUP, the Norwegian Foundation for Investigative Reporting. For many years, Bones was the datajournalism specialist at VG, the most read daily newspaper in Norway, and previously was editor and politics editor. Started his career at Adresseavise... Read More →


Friday May 19, 2017 14:00 - 15:00
Z1/14

14:00

SQL for journalists II
Limited Capacity filling up

SQL for journalists 2/3: We'll expand on the power of the Golden Query by introducing functions, filters and analysing data using code for reporting. We'll also start joining tables - Crina Boros Note: Familiarity with SQL Select Statements is necessary, and with Excel recommended for those wishing to attend. Only 25 people allowed in, first come first serve.

Speakers
avatar for Crina Boros

Crina Boros

Investigative & Data Journalist | CAR Trainer, Investigate Europe | Trainer at the Centre for Investigative Journalism (CIJ)
London-based investigative Journalist and CAR trainer at the Centre for Investigative Journalism (CIJ), Crina specialises in data analysis, transparency cross-border and accountability-driven reporting. She currently freelances for Investigate Europe and and mentors at newsPeeks... Read More →


Friday May 19, 2017 14:00 - 15:00
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

14:00

Will interest organisations pay journalism in the future? The practitioners
We've seen interest organisations using journalistic methods. We've even seen interest organisations declaring their research to be journalism. But what about credibility, when information is provided by one party in a case? What about editorial independence? Some argue that future funding for in-depth journalism will come from interest organisations. in this sessoin you meet Stefan Verwer from Oxfam Novib an interest organisation that supports journalism and Ides Debruyne from Journalismfund.eu/Fonds Pascal Decroos which offers an arm's lenght model for channelling money to journalism while protecting editorial independence. But does it work? Margo Smit, the ombudslady of the Dutch public broadcaster will be the devils advocat.

Moderators
avatar for Margo Smit

Margo Smit

Ombudsman, Onderzoeksjournalist, NOS, Margo Smit Journalistiek
Margo Smit is an independent investigative journalist, journalism teacher and (part-time) ombudsman at Dutch public television NPO (all the journalistic output in the Dutch public broadcasting system). Previously, since August 1, 2015, she was ombudsman for newscaster NOS. Till August 2015, she was director of the Dutch-Flemish Association of Investigative Journalists... Read More →

Speakers
avatar for Ides Debruyne

Ides Debruyne

Managing Director, Journalismfund.eu vzw
Ides Debruyne is co-founder of Journalismfund.eu vzw (formerly known as the Belgian Pascal Decroos Fund for Investigative Journalism) and the Dutch-Flemish Association of Investigative Journalists (VVOJ). He is managing director of Journalismfund.eu. Debruyne is co-organizer of the... Read More →
avatar for Stefan Verwer

Stefan Verwer

program leader EVEN IT UP! Tax budgets and citizen participation, Oxfam Novib
Leads on the Even it Up! campaign at Oxfam Novib and responsible for programming work on fair taxation, budget monitoring (pro-poor policies) and citizen participation. Convening the one Oxfam Fiscal Accountability for Inequality Reduction program (FAIR), working in 40 countries... Read More →



Friday May 19, 2017 14:00 - 15:00
Auditorium Z1/15 Donche

14:00

Local journalism / Round table
Meet Lorna Stephenson, Alon Aviram from Bristol Cable and Megan Lucero from the Bureau Local and Andras Löke from Budapest. They’ll shortly present their local journalism projects, after that the round table is open to all interested in developing local journalism, exchanging best practice and potentially collaborating throughout Europe in the future.

Moderators
avatar for Brigitte Alfter

Brigitte Alfter

Managing Editor, Journalismfund.eu vzw
Journalist in Europe / Co-founder and managing editor of Journalismfund.eu / co-founder and program responsible European Investigative Journalism Conference and Dataharvest.eu / co-founder Wobbing.eu, Farmsubsidy.org, I-Scoop.org / member of www.icij.org, www.fuj.dk, www.netzwerk... Read More →

Speakers
avatar for Alon Aviram

Alon Aviram

co-founder, The Bristol Cable media coop
Alon Aviram is a co-founder and operations coordinator at the Bristol Cable, the UK's only citywide media co-operative. He has investigated a range of areas, including police surveillance, worker exploitation and housing. With over 1600 paying members, the Bristol Cable is demonstrating a re-imagined, democratic local media that can hold power to account... Read More →
avatar for Megan Lucero

Megan Lucero

Director of Bureau Local, The Bureau of Investigative Journalism
Megan Lucero is the Director of the Bureau Local, a journalism and technology hub working with local reporters to investigate stories that matter across the UK. Megan, formerly the Data Editor at The Times and Sunday Times, was part of the first data journalism team at The Times... Read More →
avatar for Andras Löke

Andras Löke

Editor-in-chef, Ittlakunk.hu
Founder and editor-in-chief of Ittlakunk.hu, a group of 23 hyperlocal websites covering 23 Budapest neighborhoods used by 800.000 unique visitors a month. In 2009-10 he assisted the project of the Swiss Ringier Group for creating a quality Sunday paper in Hungary. Before that, he... Read More →
avatar for Lorna Stephenson

Lorna Stephenson

The Bristol Cable
Lorna Stephenson works for The Bristol Cable.


Friday May 19, 2017 14:00 - 15:00
C2.23 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

14:00

Digital Security II
How can you be more conscious about security and navigate the threats? We are all under constant surveillance, and your contact with a source or other journalistic work sometimes requires extra protection. We teach you to analyze the risks and the needed level of security. Introduction to i.e. Signal, Tor, Full Disk Encryption and strong passphrases. All programs are free and open source, so anyone can look into the code and ensure that they deliver the promised protection.

Speakers
avatar for Aslak Ransby

Aslak Ransby

Programmer and security trainer.
I'm @aslakransby on twitter.
avatar for Freja Wedenborg

Freja Wedenborg

Danish journalist and author of Cryptoguide for journalists, www.cryptoguide.dk. Teaching digital self defense at the Danish School of Media and Journalism. I'm @FrejaWedenborg at Twitter.


Friday May 19, 2017 14:00 - 15:00
C2.25

14:00

Structured Internet research: beyond Google and Wikipedia
Researching the internet means more than typing a search into Google and then clicking on the link to Wikipedia. Successful research does not begin at Google, it begins in your brain. First think about, who might know the answer or if there is a specific search-tool for your question. Major parts of the internet, the "deep web", are unreachable for search engines. Moreover, wide parts of the social web exclude them. So structure your research: what are you looking for, where are you looking, and which specific tools and methods exist. The more you know about the structure of the internet, the more effective your searches will be.

Speakers
avatar for Albrecht Ude

Albrecht Ude

Journalist, Researcher, Recherche-Trainer
Albrecht Ude is based in Berlin (Germany) and Friesland, | works as freelancing journalist, researcher and research-trainer (online-researches, source checking, fact checking and security issues). | writes for several newspapers and magazines, print and online. | focusses on structured internet researches, privacy and security, censorship and civil rights in the digital world. | teaches at journalist’s academies, publishing companies and broadcasting stations inhouse, also at universities. | engages as editor in chief of the newsletter of the German investigative journalists association “netzwerk recherche”. | | Homepage at... Read More →


Friday May 19, 2017 14:00 - 15:00
Auditorium Z1/13 Hanswijk

14:00

The Internet of Things is kaputt
Digital strangers have access to your bedroom: Data protection and the right to privacy is under threat. In 2020, between 25 and 30 billion devices are going to be on the Internet – and many of them are of poor quality and easy to hack. Süddeutsche Zeitung proved how easy it was to get into people’s homes, to get unauthorized access to surveillance cameras in shops, pharmacies and play grounds. Conclusion: The Internet of Things is out of control. Vanessa Wormer, Jannis Brühl and Benedict Witzenberger discuss methods and ethical considerations in the project.

Speakers
avatar for Jannis Brühl

Jannis Brühl

Ressort Aktuelles, Süddeutsche Zeitung
Jannis Brühl, 33, schreibt für SZ.de und die Süddeutsche Zeitung aus und über Nordrhein-Westfalen. Er arbeitete frei für die Nürnberger Nachrichten und SZ.de, wo er mit Schwerpunkt Wirtschaft volontierte. 2013 gewann er mit denVolontären der SZ den Nachwuchs-Wächterpreis... Read More →
avatar for Elena Erdmann

Elena Erdmann

Elena is a phd student in Machine Learning at TU Dortmund. Her research interest include automated text analysis and digital humanities. She is excited about data journalism and the way technology is used in the newsroom. Last year, she gathered some experience in journalism as a member of Journocode, a Google News Fellow at Wirtschaftswoche and in a project at... Read More →
avatar for Benedict Witzenberger

Benedict Witzenberger

Data journalist, Süddeutsche Zeitung
avatar for Vanessa Wormer

Vanessa Wormer

Data journalist, Süddeutsche Zeitung
Vanessa Wormer is a data journalist at Süddeutsche Zeitung in Munich and member of the Panama Papers investigation team. In 2015 she passed the Lede Program in Computing and Data Science at Columbia Journalism School in New York City. Vanessa is curious about how technology can... Read More →


Friday May 19, 2017 14:00 - 15:00
Z3/11

14:00

EU spending for beginners
EU finances and EU regulated spending can appear complex. But once you understand the model, it's your starting point for covering European politics and EU as well as large parts of national spending in a meaningful way. In this introduction course Sigrid Melchior, Brussels correspondent for Swedish media and author to two handbooks on covering the EU, will give you an introduction in where the EU budget gets its money from. But also - and prominently - an understanding of the structures of EU's own spending, EU-spending via member states and EU-regulated spending of national funds - for example via public tender legislation. NOTE: Sigrid will also provide a workshop on the working of the EU, it is recommended to attend both.

Speakers
avatar for Sigrid Melchior

Sigrid Melchior

Journalist
Swedish journalist based in Brussels, reporting on EU and European affairs.


Friday May 19, 2017 14:00 - 15:00
Z3/04

14:00

Master class: Follow the money II
You don't always need the Panama Papers to get Panama Papers. In fact, a share of the records used in the historic groundbreaking investigation was actually gathered from offshore public record depositories around the world. In this session, you will learn how to access the records from tax heavens that seem impossible to get.

Case Study
Exposing Crime and Corruption: How Do They Operate
Research Process: Investigating People and Companies
Understanding Public Records
Online Business Databases
Tracking Offshore Companies - (Bring your own laptops)

Speakers
avatar for Miranda Patrucic

Miranda Patrucic

Regional Editor, Organized Crime and Corruption Reporting Project
Miranda Patrucic is toonaangevend redacteur bij The Organized Crime and Corruption Reporting Project (OCCRP) en verantwoordelijk voor de regio van de Balkan tot Centraal-Azië. Ze krijgt half november in Washington de prestigieuze Knight International Award 2016 uitgereikt. Patrucic is gespecialiseerd in het onthullen van corruptieschandalen, bijvoorbeeld... Read More →


Friday May 19, 2017 14:00 - 15:00
C2.27

14:00

Personal Data Wobbing
As online companies have more and more power, it becomes critical that journalists investigate and challenge their practices. For this, personal data protection laws are completely underused. In this workshop, we will briefly explain how those laws work, and give concrete examples of their use investigating Cambridge Analytica, Uber, Tinder, Facebook, the advertising technology business, etc. We will then help those present request their data from the companies that they wish. If time permits, we will also present our tool PersonalData.IO"

Speakers
avatar for Paul-Olivier Dehaye

Paul-Olivier Dehaye

co-founder, PersonalData.IO
personal data / wobbing / Cambridge Analytica / algorithmic accountability / data economy /mathematics / startups helping journalists


Friday May 19, 2017 14:00 - 15:00
C2.30

15:00

Coffee
Friday May 19, 2017 15:00 - 15:15
Lobby

15:15

Ethical decision-making in cross-border collaboration
Do we go undercover? Can we lie to a source to get to the truth? Is hidden camera a forbidden tool? We have different traditions and different answers to the ethical dilemmas in the corners of Europe. Four experienced investigative journalists and editors look at dilemmas from their national and international viewpoints.

Moderators
avatar for Elisa Simantke

Elisa Simantke

editorial coordinator, Investigate Europe
Elisa Simantke, born 1986, works as the editorial coordinator of Investigate Europe - a new cross border research team. She studied economy and politics at the University of Cologne and journalism at the Journalism School Cologne. She worked for the daily newspaper Berliner Tages... Read More →

Speakers
avatar for Stefan Candea

Stefan Candea

Stefan Candea is a freelance journalist, EIC.network
Stefan Candea is a freelance journalist and co-founder in 2001 of the Romanian Centre for Investigative Journalism (CRJI), an investigative non-profit registered in Bucharest, Romania. He started Sponge , an open and collaborative media innovation Lab for Eastern Europe. The Lab created an in-depth magazine... Read More →
avatar for Sylke Gruhnwald

Sylke Gruhnwald

Chairwoman and journalist, Journalismfund.eu
Sylke Gruhnwald is chairwoman of Journalismfund.eu and investigative reporter with the Swiss magazine «Beobachter». Studies of Sinology and Business Administration. Worked for «The Economist Group», its «Economist Intelligence Unit» as well as the Swiss daily newspaper «Neue Zürcher Zeitung» and the Swiss public broadcaster «Schweizer Radio und Fernsehen». sgr. is co-founder of... Read More →
avatar for Nils Hanson

Nils Hanson

Editor-in-Chief, Swedish Television (SVT
is the Editor-in-Chief of Uppdrag Granskning (Mission Investigate) at the public service television company Swedish Television (SVT). The investigative one-hour television programme is aired primetime once a week, 45 times a year. Nils, a former investigative reporter, has 36 peo... Read More →
avatar for Margo Smit

Margo Smit

Ombudsman, Onderzoeksjournalist, NOS, Margo Smit Journalistiek
Margo Smit is an independent investigative journalist, journalism teacher and (part-time) ombudsman at Dutch public television NPO (all the journalistic output in the Dutch public broadcasting system). Previously, since August 1, 2015, she was ombudsman for newscaster NOS. Till August 2015, she was director of the Dutch-Flemish Association of Investigative Journalists... Read More →


Friday May 19, 2017 15:15 - 16:15
Auditorium Z1/13 Hanswijk

15:15

European security for sale
Two significant cross-border investigations about the EU security industry have been published recently. Meet Maaike Goslinga and Kristof Clerix from the Security for Sale team coordinated by Dutch De Correspondent and meet Nikolas Leontopoulos from Investigate Europe. Read what’s been published http://journalismfund.eu/securityforsale, http://www.investigate-europe.eu/en/category/publications/

Speakers
avatar for Kristof Clerix

Kristof Clerix

Journalist, Knack
Kristof Clerix (*1978), Belgium, works as a reporter for the Belgian weekly news magzine Knack and previously reported for a Belgian magazine on international affairs. As member of the International Consortium of Investigative Journalists (ICIJ), he collaborated on LuxLeaks, SwissLeaks, Evicted&Abandoned, the Panama Papers and Bahamas Leaks. | | Clerix has been working as a journalist in Belgium since 2002. After two years freelancing for the Belgian daily... Read More →
avatar for Maaike Goslinga

Maaike Goslinga

The International Editor, De Correspondent
As the International Editor of the Dutch online platform De Correspondent I am responsible for all international collaborations and investigations. My mission is to erase borders in how we approach topics and themes and set up extensive networks with journalists abroad, which enh... Read More →
avatar for Nikolas Leontopoulos

Nikolas Leontopoulos

Journalist, Investigate Europe | VICE Greece
I am an Athens-based journalist, born in 1971. I worked for ten years for the Greek daily Eleftherotypia. Since 2009 I have been reporting on the financial and the migration crisis for a number of international media. I collaborated in investigations with Reuters on banks, shipping and the media in Greece, and contributed reporting in the... Read More →


Friday May 19, 2017 15:15 - 16:15
Auditorium Z1/15 Donche

15:15

Unveiling the migration business - network
The Migration Machine (Networking): Migration and the routes into Europe are some of the most covered issues right now. Participants share experiences and ideas. Moderator: Nicolas Kayser-Bril, participants Stephen Grey (Reuter), Delphine Reuter (ICIJ/IHECS), Paulo Pena (El Público/Investigate Europe)

Speakers
avatar for Stephen Grey

Stephen Grey

reporter, Reuters
I am a London-based writer and reporter, working as a correspondent on a special projects team of the Reuters news agency.I have covered the subject of national security in its many forms, including terrorism, the work of security agencies, as well military conflict, including in... Read More →
avatar for Paulo Pena

Paulo Pena

Reporter at large, Público
I'm a Lisbon based investigative reporter, born in 1973. I work in Público, covering mostly political and economical issues. Since 2016 I'm also a member of the Investigate Europe team.
avatar for Delphine Reuter

Delphine Reuter

IHECS
Delphine Reuter is a Belgian freelance journalist, based in Brussels. A graduate from IHECS and Columbia University's Graduate School of Journalism, she has led and taken part in cross-border investigative projects related to financial crime, environmental crime, migration, etc... Read More →


Friday May 19, 2017 15:15 - 16:15
Z3/02

15:15

Data harvested during the Hack Day I
In this session the coders and data journalists will present their work from the Dataharvest Hackday. The datasets to be presented are: FRI 15.15
Water & Conflict - Lisa Dupuy, Ludo Hekman
In a post-conflict zone, the water management is an important indicator for the chances of security and stability. However, a lot of the data is missing, not available or not shared. We will present some of the insight we gathered from looking into the data that is available.

Open trials - Ben Meghreblian, Victor Nițu
OpenTrials is a collaboration between Open Knowledge International and Dr Ben Goldacre from the University of Oxford DataLab. It aims to locate, match, and share all publicly accessible data and documents, on all trials conducted, on all medicines and other treatments, globally.

SAT 9.30
Media Ownership - Chiara Sighele & co
Media ownership data on the company structures and shareholders are in many cases difficult to find, not publicly available or reaching a dead end in tax havens. We will present some of the findings from digging into the European TV channels data, as well as Bulgarian newspapers ownership.

SAT 16.30
Farm subsidies - Stefan Wehrmeyer
The Common Agricultural Policy hands out billions a year. Interested in where it goes? Learn more about our FarmSubsidy data sets!

OpenSanctions - Friedrich Lindenberg
OpenSanctions is a global database of persons and companies of political, criminal, or economic interest. We have combined sanctioned entities, politically exposed persons, and other public information into a single dataset.

Speakers
avatar for Georgiana Bere

Georgiana Bere

Developer, OpenTrials
I am a programmer and a data geek interested in government transparency and anti-waste initiatives. Most of my work revolves around public procurements from EU countries.
avatar for Friedrich Lindenberg

Friedrich Lindenberg

Tech Coordinator, OCCRP
Friedrich Lindenberg is a coder and data journalist working on web technology for new narrative and investigative techniques. He was an 2014 ICFJ Knight International Journalism Fellow with Code for Africa, and a 2013 Knight-Mozilla OpenNews Fellow at Spiegel Online. Previously... Read More →
avatar for Victor Nitu

Victor Nitu

Developer, The Sponge Media Innovation Lab
Victor Nitu is developer at The Sponge Media Innovation Lab.
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

OKFN
Stefan is a software engineer and creator of civic applications. He has created Mapnificent, a public transport utility, and Frag Den Staat, Germany's Freedom of Information portal.


Friday May 19, 2017 15:15 - 16:15
C2.17 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

15:15

Data Tour - European Open Data Portal
The European Data Portal harvests the metadata of public sector information available on public data portals across European countries. Portals can be national, regional, local or domain specific and cover the 28 EU Member States, EEA, countries involved in the EU's neighbourhood policy, Switzerland and EU portals such as the EU Open Data Portal. Going beyond the harvesting of metadata, the strategic objective of the European Data Portal is to improve accessibility and increase the value of Open Data. The European Data Portal addresses the whole data value chain: from data publishing to data re-use. Within the portal, sections are dedicated to searching datasets, providing data, using data, training and a library https://www.europeandataportal.eu/en/what-we-do/our-activities. NOTE - THERE ARE TWO EUROPEAN OPEN DATA PORTALS - SEE ALSO THE SESSION ON THE EU DATA PORTAL ON SATURDAY

Speakers
avatar for Heleen Vollers

Heleen Vollers

European Data Portal / Capgemini
Expert in Open Data and Public Affairs Member of "Insights & Data". I lead a tailored support service for representatives of national Open Data portals in Europe, as part of the three-year European Commission's European Data Portal project. I also lead annual research to measure the level of Open Data maturity across Europe... Read More →


Friday May 19, 2017 15:15 - 16:15
Z3/11

15:15

Who lobbies the EU? Understanding the data and structures
Transparency International has followed the career path of 512 former Commissoiners and MEPs made available via the EU Integrity Watch database http://www.integritywatch.eu/, a recent report indicates concerning conflicts of interests. Raphaël Kergueno from Transparency International is the man behind the dataset. Also on this panel Theresa Crysman will introduce the working of Lobbyfacts, a tool provided by a Brussels lobbywatcher NGOs based upon the EU's own transparency register. At this panel you'll get an introduction about the background of the data and the working of the platform https://lobbyfacts.eu/ BOTH SPEAKERS ALSO WILL BE AVAILABLE FOR THE LOBBY-WORKSHOP FOLLOWING THIS PRESENTATION.

Speakers
avatar for Theresa Crysmann

Theresa Crysmann

Media Officer, Corporate Europe Observatory
Corporate Europe Observatory is a Brussels-based NGO which exposes and challenges the corporate capture of EU policy-making.
avatar for Raphaël Kergueno

Raphaël Kergueno

Policy officer, Transparency International EU


Friday May 19, 2017 15:15 - 16:15
C2.21

15:15

Excel III
Limited Capacity filling up

Excel 3 - Just as the previous class you have to be somewhat comfortable with spreadsheets. This is a treat, knowing how to use pivot tables is the one tool that will give you power to analyse large datasets. With this method you will be able to analyse a budget - or a salary list, find interesting facts and sum up money or count occurrences. How many times did each politician go to Brussels? How much was the cost for each of them? Which department spends the most money? By the end of this session you will be able to handle big and complicated datasets. Only 25 people allowed in, first come first serve.

Speakers
avatar for Helena Bengtsson

Helena Bengtsson

Editor, Data Projects, The Guardian
Helena Bengtsson is Editor, Data Projects at the Guardian in London, UK. She previously worked as the database editor at Sveriges Television, Sweden’s national television broadcaster. In 2006 and 2007, she was database editor at the Center for Public Integrity in Washington, D.C. She was awarded the Stora Journalistpriset (Great Journalism Award) in 2010 for Valpejl.se, a website profiling every candidate in that season’s Swedish elections and in 2016 for Innovator of the year. Twitter... Read More →
avatar for John Bones

John Bones

Managing Director, SKUP
John Bones is Managing Director at SKUP, the Norwegian Foundation for Investigative Reporting. For many years, Bones was the datajournalism specialist at VG, the most read daily newspaper in Norway, and previously was editor and politics editor. Started his career at Adresseavise... Read More →


Friday May 19, 2017 15:15 - 16:15
Z1/14

15:15

SQL for journalists III
Limited Capacity filling up

SQL for journalists 3/3: Building on SQL 1 & 2, we'll make tables talk to each other, clean dirty data and update tables - Crina Boros Note: Familiarity with SQL Select Statements is necessary, and with Excel recommended for those wishing to attend. Only 25 people allowed in, first come first serve.

Speakers
avatar for Crina Boros

Crina Boros

Investigative & Data Journalist | CAR Trainer, Investigate Europe | Trainer at the Centre for Investigative Journalism (CIJ)
London-based investigative Journalist and CAR trainer at the Centre for Investigative Journalism (CIJ), Crina specialises in data analysis, transparency cross-border and accountability-driven reporting. She currently freelances for Investigate Europe and and mentors at newsPeeks... Read More →


Friday May 19, 2017 15:15 - 16:15
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

15:15

How to convince your publisher that European stories can be sustainable?
Christophe Leclerq of EURACTIV has interviewed 30 top editors and publishers from six countries on European journalism, under the project Media4EU, in cooperation with academics and experts. This notably leads to an pilot project to exchange 'rising stars', not only journalists, between different media. [Possibly called Erasmus4media or stars4media, this project is endorsed by 12 MEPs and may be funded by the EU and/or non-profits.] In this workshop, Christophe will give a short presentation on his findings and then open for a discussion on what editors want, notably how to facilitate exchanges between like-minded media.

Moderators
avatar for Ides Debruyne

Ides Debruyne

Managing Director, Journalismfund.eu vzw
Ides Debruyne is co-founder of Journalismfund.eu vzw (formerly known as the Belgian Pascal Decroos Fund for Investigative Journalism) and the Dutch-Flemish Association of Investigative Journalists (VVOJ). He is managing director of Journalismfund.eu. Debruyne is co-organizer of the... Read More →

Speakers
avatar for Christophe Leclerq

Christophe Leclerq

Founder, Euractiv.com
He is founder of the EURACTIV media network & Fondation EURACTIV, plus adviser & commentator. | Mr Leclercq also moderates conferences, speaks at policy and corporate events, and helps boards and media associations. He leads the new project #Media4EU Tour d’Europe.He also teach... Read More →


Friday May 19, 2017 15:15 - 16:15
Z3/14

15:15

Local investigations: a new model
Making investigative data journalism local and accessible in digitised society: a UK model

Speakers
avatar for Megan Lucero

Megan Lucero

Director of Bureau Local, The Bureau of Investigative Journalism
Megan Lucero is the Director of the Bureau Local, a journalism and technology hub working with local reporters to investigate stories that matter across the UK. Megan, formerly the Data Editor at The Times and Sunday Times, was part of the first data journalism team at The Times... Read More →


Friday May 19, 2017 15:15 - 16:15
C2.23 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

15:15

Threat modelling I
Threat modeling' is a way information security professionals think about how to protect systems against attacks. For everyday users however, it's more fruitful to think about what your goals are and what risks you take when using digital tools to achieve them. Over the course of the two sessions, Henrik Chulu will illustrate how a little infrastructural and computer literacy goes a long way in establishing a baseline of digital security and introduce a way of thinking about risk mitigation that is not dependent of certain tools, but rather on critical thinking and good digital hygiene.
Security begins with technical literacy. How do the things you use daily work? What risks are you facing in the digital world? What can you do to limit them?


Speakers
avatar for Henrik Chulu

Henrik Chulu

Digital literacy and safety trainer
I will help you understand your operational environment in order to make better decisions about your safety and effectiveness. Co-founder of Bitbureauet. Independent researcher, writer, speaker and trainer.


Friday May 19, 2017 15:15 - 16:15
C2.25

15:15

Master class: Follow the money III
You don't always need the Panama Papers to get Panama Papers. In fact, a share of the records used in the historic groundbreaking investigation was actually gathered from offshore public record depositories around the world. In this session, you will learn how to access the records from tax heavens that seem impossible to get.

Case Study
Exposing Crime and Corruption: How Do They Operate
Research Process: Investigating People and Companies
Understanding Public Records
Online Business Databases
Tracking Offshore Companies - (Bring your own laptops)

Speakers
avatar for Miranda Patrucic

Miranda Patrucic

Regional Editor, Organized Crime and Corruption Reporting Project
Miranda Patrucic is toonaangevend redacteur bij The Organized Crime and Corruption Reporting Project (OCCRP) en verantwoordelijk voor de regio van de Balkan tot Centraal-Azië. Ze krijgt half november in Washington de prestigieuze Knight International Award 2016 uitgereikt. Patrucic is gespecialiseerd in het onthullen van corruptieschandalen, bijvoorbeeld... Read More →


Friday May 19, 2017 15:15 - 16:15
C2.27

15:15

Uncovering international economic crime with cross-border collaboration / networking
Businesses running Ponzi schemes in Norway, Estonia ... and your country? Whitewashing of money via your country? Anne Skjerning has followed international whitewashing of money and will open with a short presentation. Skjerning, Ytreberg and Reiljan are looking forward to meet journalists interested in networking on economic crime across borders. NOTE: This networking round table is an obvious follow-up of the presentation by Piret Reiljan and Rune Ytreberg describing their reent investigation into crossborder ponzi-schemes.

Speakers
avatar for Piret Reiljan

Piret Reiljan

Head of investigative desk, Estonian business daily Äripäev
Piret Reiljan is an Estonian investigative journalist. She has been working as a journalist for the Estonian business daily Äripäev since 2006 and since 2017 she is head of investigative desk. | She covers a wide range of topics, including tax frauds, investment frauds and cor... Read More →
avatar for Rune Ytreberg

Rune Ytreberg

Journalist, Dagens Næringsliv
Cover oil, fish, politics and business in northern Norway, Spitsbergen and northwest Russia. Interested in databases, mapping, semiotic search.


Friday May 19, 2017 15:15 - 16:15
Z3/04

15:15

Getting your documents out through FOI tactics
Well-prepared requests for information can be a very sharp tool when fighting to get a particular documentation or piece of information. Peter Verhaeghe gives an introduction into tactical wobbing and considerations such as which law is the strongest for my topic, which authority is most likely to hold and which authority is most likely to release the information, which information to request first and which information not to request or only request later?

Speakers
avatar for Peter Verhaeghe

Peter Verhaeghe

vice-chair, Straten-Generaal
Peter Verhaeghe is vice-chair of StRaten-generaal, an activistic citizen organisation (in Antwerp, Belgium) to foster and improve the quality of life. Peter is the FOIA specialist.


Friday May 19, 2017 15:15 - 16:15
C2.30

16:15

Coffee
Friday May 19, 2017 16:15 - 16:30
Lobby

16:30

Dealing with legal threats in cross-border journalism in Europe - the EIC case
We see more and more cross-border collaborations – but the experience with and practice of the legal aspects of this new journalistic method are yet scarce. The recent EIC.network publication on Football Leaks has some interesting aspects to consider: A whistleblower to be protected – with contacts to one of the journalists on the team. An injunction against one of the media in one country – publish or not publish in the others? And what about libel tourism via – say – the UK or Ireland? The legal challenge in of crossborder collaborations is new and will not disappear. The question for this panel is how to balance the interest of freedom of expression versus the danger of being sued across borders. On the panel you’ll meet Dr. Sascha Sajuntz, in-house lawyer at Der Spiegel and author, as well as other lawyers (tbc) of the EIC.network. You’ll also meet William Bourdon, the French defence lawyer of Lux Leaks and other whistleblowers in international cases, Jan Oster, Dutch media scholar and author of a recent book about comparative media law in Europe and Jonathan McCullen from the London based internationally active Media Legal Defence Initiative. Speakers: William Bourdon, lawyer, Cabinet Bourdon, France https://cabinet-bourdon.com/en/equipe/, Jan Oster, lecturer, University of Leiden, Netherlands https://www.universiteitleiden.nl/en/staffmembers/jan-oster/publications, Dr. Sascha Sajuntz, in-house lawyer at Der Spiegel, Germany www.spiegel.de, TBC Rikke Laulund, in-house lawyer Politiken, Denmark, TBC lawyer / legal advisors at Mediapart, France and El Mundo, Spain, Jonathan McCully, Media Legal Defence Initiative, United Kingdom, http://www.mediadefence.org/users/jonathan-mccully

Moderators
avatar for Brigitte Alfter

Brigitte Alfter

Managing Editor, Journalismfund.eu vzw
Journalist in Europe / Co-founder and managing editor of Journalismfund.eu / co-founder and program responsible European Investigative Journalism Conference and Dataharvest.eu / co-founder Wobbing.eu, Farmsubsidy.org, I-Scoop.org / member of www.icij.org, www.fuj.dk, www.netzwerk... Read More →

Speakers
avatar for William Bourdon

William Bourdon

President and Founder, Sherpa
William Bourdon is a lawyer with Bourdon-Voituriez-Burget in Paris, where he works primarily on cases of business, media and penal law. He also does human rights work. He represented Franco-Chilean families in the complaint filed in October 1998 against General Augusto Pinochet a... Read More →
avatar for Stefan Candea

Stefan Candea

Stefan Candea is a freelance journalist, EIC.network
Stefan Candea is a freelance journalist and co-founder in 2001 of the Romanian Centre for Investigative Journalism (CRJI), an investigative non-profit registered in Bucharest, Romania. He started Sponge , an open and collaborative media innovation Lab for Eastern Europe. The Lab created an in-depth magazine... Read More →
avatar for Jan Oster

Jan Oster

University Lecturer, Universiteit Leiden
Jan Oster (Dr. iur., University of Mainz/Germany, 2009) is assistant professor (universitair docent) for EU Law and Institutions at the Department of History. He teaches minor/pre-master courses and graduate courses on EU Law, Law and Economics of European Integration, Justice an... Read More →
avatar for Sascha Sajuntz

Sascha Sajuntz

Der Spiegel
Dr. Sascha Sajuntz is the in-house lawyer of Der Spiegel.


Friday May 19, 2017 16:30 - 17:30
Auditorium Z1/13 Hanswijk

16:30

Security and civil liberties / Round table
Security technology, research into security, security industry, public spending on security, militarisation of borders, surveillance – enough to bear in mind when thinking of civil liberties and public spending – for example. Come to the round table, share your own experience in researching these fields and get an overview over what colleagues have published.

Moderators
avatar for Staffan Dahllöf

Staffan Dahllöf

Freelance reporter
Staffan Dahllöf (1955) is a freelance reporter based in Copenhagen. Dahllöf is a member of the Farmsubsidy team. In 1993 he was co-editor and co-author of "Journalisternas EG-handbok", a guide in Swedish on EC/EU reporting. Since 1994 he has been engaged in courses on EU report... Read More →

Speakers
avatar for Kristof Clerix

Kristof Clerix

Journalist, Knack
Kristof Clerix (*1978), Belgium, works as a reporter for the Belgian weekly news magzine Knack and previously reported for a Belgian magazine on international affairs. As member of the International Consortium of Investigative Journalists (ICIJ), he collaborated on LuxLeaks, SwissLeaks, Evicted&Abandoned, the Panama Papers and Bahamas Leaks. | | Clerix has been working as a journalist in Belgium since 2002. After two years freelancing for the Belgian daily... Read More →
avatar for Maaike Goslinga

Maaike Goslinga

The International Editor, De Correspondent
As the International Editor of the Dutch online platform De Correspondent I am responsible for all international collaborations and investigations. My mission is to erase borders in how we approach topics and themes and set up extensive networks with journalists abroad, which enh... Read More →
avatar for Nikolas Leontopoulos

Nikolas Leontopoulos

Journalist, Investigate Europe | VICE Greece
I am an Athens-based journalist, born in 1971. I worked for ten years for the Greek daily Eleftherotypia. Since 2009 I have been reporting on the financial and the migration crisis for a number of international media. I collaborated in investigations with Reuters on banks, shipping and the media in Greece, and contributed reporting in the... Read More →


Friday May 19, 2017 16:30 - 17:30
C2.11

16:30

Let's not misunderstand each other - journo-coder collaborations
The anecdotes how journalists and coders misunderstand each other are legio. But it does not need to be like that. Database editor at the Guardian and formerly at the Swedish broadcaster SVT and coder turned coder-journo Friedrich Lindenberg from OCCRP will give you an entertaining introduction in do's and don'ts of journo-coder collaborations.

Speakers
avatar for Helena Bengtsson

Helena Bengtsson

Editor, Data Projects, The Guardian
Helena Bengtsson is Editor, Data Projects at the Guardian in London, UK. She previously worked as the database editor at Sveriges Television, Sweden’s national television broadcaster. In 2006 and 2007, she was database editor at the Center for Public Integrity in Washington, D.C. She was awarded the Stora Journalistpriset (Great Journalism Award) in 2010 for Valpejl.se, a website profiling every candidate in that season’s Swedish elections and in 2016 for Innovator of the year. Twitter... Read More →
avatar for Friedrich Lindenberg

Friedrich Lindenberg

Tech Coordinator, OCCRP
Friedrich Lindenberg is a coder and data journalist working on web technology for new narrative and investigative techniques. He was an 2014 ICFJ Knight International Journalism Fellow with Code for Africa, and a 2013 Knight-Mozilla OpenNews Fellow at Spiegel Online. Previously... Read More →


Friday May 19, 2017 16:30 - 17:30
C2.21

16:30

The downloaders - tracking users of child pornography
A journalist and a data engineer were determined to trace those who downloaded child pornography thus creating the market demand for such material. The two were able to trace log-files of downloaders and traced a number of the men in Norway. For months they worked with the material and ended up confronting downloaders individually in different parts of the country. From the beginning they applied a set of ethical guidelines such as never opening any of the suspected files, a close cooperation with law enforcement and careful approach to the downloaders. Following their initial publication in Norway the team shared some of the almost 100.000 data entries of downloads from all over the world with colleagues in Sweden – under a strict agreements on the ethics. ttp://www.vg.no/spesial/2015/nedlasterne/?lang=en

Speakers
avatar for Håkon Høydal

Håkon Høydal

Journalist, VG Helg
Håkon F. Høydal er journalist i VG Helg, hvor han har jobbet med å skrive dokumentarer siden magasinets begynnelse. Han har studert historie, religionsvitenskap og sosialantropologi ved Universitetene i Bergen og Oslo. Han trives best i en kajakk.


Friday May 19, 2017 16:30 - 17:30
C1.25 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

16:30

Numbed by numbers
Limited Capacity seats available

Numbed by numbers? You went into journalism to avoid maths, and now your screen's full of numbers? My session's for you! 1630 Friday #EIJC17

Speakers
avatar for Jonathan Stoneman

Jonathan Stoneman

Freelance trainer
I am a freelance trainer mainly concentrating on how to get the most out of open data, where to find it, what tools to use, and how to analyse it and find stories.


Friday May 19, 2017 16:30 - 17:30
Z1/14

16:30

Open Refine
Limited Capacity filling up

Make your data life easier with Open Refine - Learn how to clean data with Open Refine and how to make the program work for you in dirty data situations. Only 25 people allowed in, first come first serve. This workshop will be trained in a computer lab. However, if you liked to use your own laptop, you would need to install Open Refine prior to the class and test that it is working. The programme can be found here: http://openrefine.org/download.html.

Speakers
avatar for Anuska Delic

Anuska Delic

Journalist, DeloData project leader, Delo daily
Investigative and data journalist with Slovenia's leading daily broadsheet newspaper Delo. There Delić leads DeloData, a project aimed at establishing and developing data journalism within Delo's newsroom. | | Delić, who has recently been in a court trial for allegedly publ... Read More →


Friday May 19, 2017 16:30 - 17:30
Z1/16

16:30

SQL for journalists IV
Limited Capacity filling up

SQL IV: You now know how to write basic queries and join tables. In this class, will extend your power ever further by incorporating string functions and some advanced mathematical techniques for analyzing data. Only 25 people allowed in, first come first serve.

Speakers
avatar for Robert Gebeloff

Robert Gebeloff

Database Projects Editor, The New York Times
Robert Gebeloff has been a database projects editor at The New York Times since 2008. He was a finalist for the Pulitzer Prize in 2015 for a series about corporate legal attacks on the rights of U.S. consumers and employees to sue, and again in 2016 for stories about racial dispa... Read More →


Friday May 19, 2017 16:30 - 17:30
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

16:30

How to turn a long-term investigation into a book
You have spent months investigating a subject. Maybe you have published a series and made a web documentary. Now you want to reach a new audience and publish a book. How do you go about it? How do you structure a book? Which new possibilities do you have to use your research material? Harald Schuman, Leila Miñano and Stephen Grey have experience from the German, French, and British market.

Speakers
avatar for Stephen Grey

Stephen Grey

reporter, Reuters
I am a London-based writer and reporter, working as a correspondent on a special projects team of the Reuters news agency.I have covered the subject of national security in its many forms, including terrorism, the work of security agencies, as well military conflict, including in... Read More →
avatar for Leila Miñano

Leila Miñano

journalist, Youpress/Investigate Europe
Leïla is a member of Youpress, a free-lance collective based in Paris covering international news around the world. She has reported for several medias such as Vanity Fair, Mediapart, Libération, Marianne, Le Parisien Magazine, Le Figaro Magazine. She has written two books : La... Read More →
avatar for Harald Schumann

Harald Schumann

Sernior Reporter, Tagesspiegel
European journalism must follow the economic integration. The purely national perspective produces almost ever bad results and repeats only the propaganda those in power want us to report....


Friday May 19, 2017 16:30 - 17:30
Z3/11

16:30

Making money with good journalism - testing the models one by one
52 good ideas for business models (as a minimum) – which one(s) will make a breakthrough to support investigative journalism in the future? At this panel you will meet several entrepreneurial journalism initiatives trying to make money with their journalism. Which one works in which context? Has there been a breakthrough seizable enough to replicate? Meet Apache.be , online only based upon investment and aiming to return this investment within a reasonable time. Meet Athens Life (tbc) one of the new digital first outlets, who offer longform, analytical and explanatory journalism. Meet Investigative Journalism, who have a mission of producing investigative journalism on complex European themes while testing business models. Meet Bristol Cable, who build a local collectively supported community medium. Meet hyperlocal journalism from Budapest (http://ittlakunk.hu/). And meet De Cooperatie.nl, a collective of freelancers paying someone to sell their work so they can focus on their journalism.

Moderators
avatar for Ides Debruyne

Ides Debruyne

Managing Director, Journalismfund.eu vzw
Ides Debruyne is co-founder of Journalismfund.eu vzw (formerly known as the Belgian Pascal Decroos Fund for Investigative Journalism) and the Dutch-Flemish Association of Investigative Journalists (VVOJ). He is managing director of Journalismfund.eu. Debruyne is co-organizer of the... Read More →

Speakers
avatar for Alon Aviram

Alon Aviram

co-founder, The Bristol Cable media coop
Alon Aviram is a co-founder and operations coordinator at the Bristol Cable, the UK's only citywide media co-operative. He has investigated a range of areas, including police surveillance, worker exploitation and housing. With over 1600 paying members, the Bristol Cable is demonstrating a re-imagined, democratic local media that can hold power to account... Read More →
avatar for Teun Gautier

Teun Gautier

Founder, De Cooperatie
Former director of De Groene Amsterdammer, o-founder of De Corresponent and Founder of De Cooperatie.
avatar for Andras Löke

Andras Löke

Editor-in-chef, Ittlakunk.hu
Founder and editor-in-chief of Ittlakunk.hu, a group of 23 hyperlocal websites covering 23 Budapest neighborhoods used by 800.000 unique visitors a month. In 2009-10 he assisted the project of the Swiss Ringier Group for creating a quality Sunday paper in Hungary. Before that, he... Read More →
avatar for Tassos Morfis

Tassos Morfis

Co-Founder, AthensLive
Tassos Morfis (male) is the Chief Editor and co-founder of AthensLive. He has worked as a journalist for the Greek digital magazine Popaganda, a news producer for the Athens-based production company FOS PHOTOS (fosphotos.com), and a stringer for foreign media including Channel4 i... Read More →
avatar for Elisa Simantke

Elisa Simantke

editorial coordinator, Investigate Europe
Elisa Simantke, born 1986, works as the editorial coordinator of Investigate Europe - a new cross border research team. She studied economy and politics at the University of Cologne and journalism at the Journalism School Cologne. She worked for the daily newspaper Berliner Tages... Read More →
avatar for Bram Souffreau

Bram Souffreau

Director of the non-editorial operations, Apache
Bram Souffreau is the co-founder (in 2009) of Apache, an online news site of investigative and in-depth journalism. He is responsible for the non-editorial part (web development, customer relations, administration, accounting) of Apache.be. Bram is also president of IPS... Read More →



Friday May 19, 2017 16:30 - 17:30
Auditorium Z1/15 Donche

16:30

Threat modelling II
Second session on “Threat modelling”. How to think about risk mitigation that is not dependent of certain tools, but rather on critical thinking and good digital hygiene. The session focuses on
• Hands-on Risk-assessment
• Mission-oriented, human-centered security culture
• Structured security review process with handouts
• Questions and (hopefully) answers.


Speakers
avatar for Henrik Chulu

Henrik Chulu

Digital literacy and safety trainer
I will help you understand your operational environment in order to make better decisions about your safety and effectiveness. Co-founder of Bitbureauet. Independent researcher, writer, speaker and trainer.


Friday May 19, 2017 16:30 - 17:30
C2.25

16:30

Telling the Story Through a Game
Public budget data is hard to understand and to communicate. Nevertheless, to better address corruption and misuse of public money, it is necessary to gain a better understanding of the topic.
The Good, The Bad and The Accountant is an interactive, game-like experience, where users play the role of a fictional general manager in a large European city and have to take a series of decisions that show the complexity of corruption and cronyism in the public administration.
Throughout the game, hints are given to users so that they understand how corruption and mismanagement occur and how they can spot it in real life.
Journalism++ presents the making-of of this serious game, the impacts and the lessons learned on gamification.

Speakers
avatar for Anne-Lise Bouyer

Anne-Lise Bouyer

COO/Project manager, Journalism++
Anne-Lise Bouyer is a French data-driven investigative journalist based in Berlin and project manager at Journalism++, an agency for datajournalism. | After studying computer engineering, she worked as a project manager in a web agency and for OWNI.fr, the French news startup tha... Read More →
avatar for Nicolas Kayser-Bril

Nicolas Kayser-Bril

Co- founder and CEO, Journalism++
Nicolas Kayser-Bril is the co-founder and CEO of Journalism++. Journalism++ is a network of datajournalists that aims to build great stories and tools with data.


Friday May 19, 2017 16:30 - 17:30
C2.27

17:40

CAR Lightning Talks
CAR Lightning talks are five-minute talks about any subject. Anyone who is attending Dataharvest can pitch their idea for a talk. Journalismfund.eu will then decide on the seven or eight talks that will eventually be presented. Check out the selected ideas here: http://www.journalismfund.eu/pitch-lightning-talk-and-present-eijc17-dataharvest

Moderators
avatar for Marjorie Blomme

Marjorie Blomme

Editorial Co-ordinator, Journalismfund.eu
Marjorie Blomme is Journalismfund.eu's editorial co-ordinator for the Connecting Continents grant programme. She answers questions regarding the grants and is in charge of preparing the applications for the jury and following up on the ongoing investigations. | | Marjorie is bas... Read More →

Friday May 19, 2017 17:40 - 18:30
Z1/14

18:00

Networking reception at Mechelen city hall
Drinks in Mechelen's great city hall. Get to know each other in a slightly different setting in a beautiful historical building! PUBLIC SERVICE ANNOUNCEMENT: Use the Befferstraat entrance and not the Grand Place one.

 
Saturday, May 20
 

09:30

Bye bye, lone wolf - cross-border journalism pushed by media
"I used to hunt as a lone wolf or in a small pack, not anymore." Cross-border networked journalism is developing swiftly these years. This panel brings together three very different examples of networks: The EIC network initiated by a major news medium and working in a mixed team of media, investigative centres and freelance journalists; the Investigate Europe team of individual journalists who joined forces to develop adequate coverage of European affairs.

Moderators
avatar for Brigitte Alfter

Brigitte Alfter

Managing Editor, Journalismfund.eu vzw
Journalist in Europe / Co-founder and managing editor of Journalismfund.eu / co-founder and program responsible European Investigative Journalism Conference and Dataharvest.eu / co-founder Wobbing.eu, Farmsubsidy.org, I-Scoop.org / member of www.icij.org, www.fuj.dk, www.netzwerk... Read More →

Speakers
avatar for Alain Lallemand

Alain Lallemand

reporter, Le Soir
Defense, National security, Organized crime
avatar for Jörg Schmitt

Jörg Schmitt

Coordinator, Der Spiegel
Geboren 1967 im hessischen Marburg. Studierte Journalistik, Wirtschaftspolitik und Jura in München und arbeitet inzwischen seit über 20 Jahren als investigativer Journalist. Zunächst für den "Stern", später für das "manager magazin", seit 2003 für den SPIEGEL. Spezialgebie... Read More →
avatar for Harald Schumann

Harald Schumann

Sernior Reporter, Tagesspiegel
European journalism must follow the economic integration. The purely national perspective produces almost ever bad results and repeats only the propaganda those in power want us to report....
avatar for Elisa Simantke

Elisa Simantke

editorial coordinator, Investigate Europe
Elisa Simantke, born 1986, works as the editorial coordinator of Investigate Europe - a new cross border research team. She studied economy and politics at the University of Cologne and journalism at the Journalism School Cologne. She worked for the daily newspaper Berliner Tages... Read More →


Saturday May 20, 2017 09:30 - 10:30
Auditorium 2 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

09:30

Why Turkey is a difficult place for journalists
Turkey is a difficult place for journalists, and some cover Turkey from abroad. At this panel you'll meet three journalists based in Germany who cover cases involving Turkey - from abroad. Zeynep Sentek contributed to the EIC.network football leaks on tax avoidance in professional football, https://eic.network/projects/football-leaks, Hans-Martin Tillack worked at Stern and with Correctiv about a German weapon producer http://www.stern.de/wirtschaft/news/stern-exklusiv--rheinmetall-beteiligt-sich-an-panzerproduktion-in-der-tuerkei-7357932.html

Speakers
avatar for Zeynep Sentek

Zeynep Sentek

Journalist, The Black Sea (theblacksea.eu)
Journalist specialising in investigations, human rights, workers' rights, and military issues. Doctoral researcher at Heidelberg University. | | Works freelance and also coordinates The Black Sea's Turkey investigations, and is part of the European Investigative Collabora... Read More →
avatar for Craig Shaw

Craig Shaw

Freelance journalist
Craig Shaw is a British journalist. | | He specialises in corruption, human rights and cross-border investigations and has published in leading European media. He jointly coordinates the Turkish investigations for theBlackSea.EU as part of the European Investigative Collaborati... Read More →
avatar for Hans-Martin Tillack

Hans-Martin Tillack

Reporter, Stern
Hans-Martin Tillack is working as an investigative reporter in the Berlin office of the German weekly magazine stern. From 1999 to 2004 he was the EU correspondent for stern in Brussels, Belgium. He is also the author of three books, on the EU, on corruption and on lobbyists and... Read More →


Saturday May 20, 2017 09:30 - 10:30
Aula 1 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

09:30

Data harvested during the Hack Day II
In this session the coders and datajournalists will present their work from the Dataharvest Hackday. In this session the coders and data journalists will present their work from the Dataharvest Hackday. The datasets to be presented are: FRI 15.15
Water & Conflict - Lisa Dupuy, Ludo Hekman
In a post-conflict zone, the water management is an important indicator for the chances of security and stability. However, a lot of the data is missing, not available or not shared. We will present some of the insight we gathered from looking into the data that is available.

Open trials - Ben Meghreblian, Victor Nițu
OpenTrials is a collaboration between Open Knowledge International and Dr Ben Goldacre from the University of Oxford DataLab. It aims to locate, match, and share all publicly accessible data and documents, on all trials conducted, on all medicines and other treatments, globally.

SAT 9.30
Media Ownership - Chiara Sighele & co
Media ownership data on the company structures and shareholders are in many cases difficult to find, not publicly available or reaching a dead end in tax havens. We will present some of the findings from digging into the European TV channels data, as well as Bulgarian newspapers ownership.

SAT 16.30
Farm subsidies - Stefan Wehrmeyer
The Common Agricultural Policy hands out billions a year. Interested in where it goes? Learn more about our FarmSubsidy data sets!

OpenSanctions - Friedrich Lindenberg
OpenSanctions is a global database of persons and companies of political, criminal, or economic interest. We have combined sanctioned entities, politically exposed persons, and other public information into a single dataset.

Speakers
avatar for Georgiana Bere

Georgiana Bere

Developer, OpenTrials
I am a programmer and a data geek interested in government transparency and anti-waste initiatives. Most of my work revolves around public procurements from EU countries.
avatar for Friedrich Lindenberg

Friedrich Lindenberg

Tech Coordinator, OCCRP
Friedrich Lindenberg is a coder and data journalist working on web technology for new narrative and investigative techniques. He was an 2014 ICFJ Knight International Journalism Fellow with Code for Africa, and a 2013 Knight-Mozilla OpenNews Fellow at Spiegel Online. Previously... Read More →
avatar for Victor Nitu

Victor Nitu

Developer, The Sponge Media Innovation Lab
Victor Nitu is developer at The Sponge Media Innovation Lab.
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

OKFN
Stefan is a software engineer and creator of civic applications. He has created Mapnificent, a public transport utility, and Frag Den Staat, Germany's Freedom of Information portal.


Saturday May 20, 2017 09:30 - 10:30
C2.17 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

09:30

Digging into the medicinal business
Poor countries often pay more for their medicines or vaccines than rich countries. In theory, the free market contributes to better accessibility to medicines – but in practice, it opens up an unregulated space for companies to make profit on medicines and vaccines, barely taking into consideration their responsibility towards public health. Accessing information on how big pharma companies and drug distributors react, ignore local regulations, and negotiate prices with governments, is difficult and shows the opacity of this market. Eva Belmonte (Civio.es) will talk about Medicamentalia, a global investigation about prices of medicines and vaccines. She will explain the pool procurement mechanism and how Europe signed an agreement to buy together medicines, but never used it. The session will be followed by a networking discussion among participants interested in or working on similar issues.

Speakers
avatar for Eva Belmonte

Eva Belmonte

Managing Editor, Civio Foundation
Eva Belmonte (Spain, 1982) is a journalist specialised in public data analysis. She is Managing Editor at Fundación Civio, a non-profit newsroom based in Madrid, where she designs, develops and supervises data journalism projects such as medicamentalia.org (comparing the prices... Read More →


Saturday May 20, 2017 09:30 - 10:30
C1.25 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

09:30

Opening clinical trials data
The information architecture of evidence-based medicine is broken - whole clinical trials are routinely left unpublished, exposing the medical literature to avoidable bias and exaggeration. When trials are published, the results are often misreported in academic journal articles. The same trials can be found reporting different results in different places, and the information in journal articles has been shown to be less complete than – and discrepant with – other sources like clinical study reports. Furthermore, key documents such as Case Report Forms and Ethics Committee paperwork are often left inaccessible, even though we know they can contain important information. We seek to help address this by building OpenTrials (explorer.opentrials.net) - an open, freely accessible database that can store, or link to, all publicly accessible data and documents on all trials in one place, building user-friendly windows onto this information. We have also built an open Application Programming Interface (API) allowing data scientists, programmers, and other power users to query the data at scale. We hope that placing all the information in one place will support informed decision-making by doctors, researchers, and patients. Additionally we hope that it will change norms surrounding sharing trial information, as it becomes easier to identify missing sources of information. From a investigative and data journalism perspective, there exist many potential stories in the data, including most/least transparent trial sponsors and focusing on particular drug/disease areas.

Speakers
avatar for Georgiana Bere

Georgiana Bere

Developer, OpenTrials
I am a programmer and a data geek interested in government transparency and anti-waste initiatives. Most of my work revolves around public procurements from EU countries.
avatar for Ben Meghreblian

Ben Meghreblian

Community Manager, OpenTrials
Ben is the Community Manager for OpenTrials, an Open Knowledge International project aiming to produce an open, easy-to-use, linked database of information about the world's clinical trials. He has a background in psychology and IT, and previously worked on the AllTrials... Read More →
avatar for Victor Nitu

Victor Nitu

Developer, The Sponge Media Innovation Lab
Victor Nitu is developer at The Sponge Media Innovation Lab.


Saturday May 20, 2017 09:30 - 10:30
C2.11

09:30

Access I
Limited Capacity seats available

If you like Excel, try Access next. It offers a few more options than Excel and some prefer it for it’s clean interface. In the first session we will hit the filter buttons from different angles. Also for virgins that have never touched Excel. Only 25 people allowed in, first come first serve.

Speakers
avatar for Winny de Jong

Winny de Jong

Datajournalist, OneWorld
Winny de Jong is data journalist. According to some she is a ‘workaholic’, and a ’strategist’, who gives ‘EPIC presentations’. Winny usually speaks about the importance of data literacy, how to develop ideas, and her data journalistic workflow. She has presented before for organizations like TEDx... Read More →
avatar for Luuk Sengers

Luuk Sengers

Trainer, Lecturer, Investigative Journalist, Freelance journalist
Luuk Sengers (1966) is an independent investigative journalist, university lecturer and media trainer. He writes about environmental issues (his recent stories appeared in AD, Trouw and De Groene Amsterdammer) and he educates students, media professionals and activists in investi... Read More →


Saturday May 20, 2017 09:30 - 10:30
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

09:30

Introduction to R for journalists I
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

R1/3 - R? Programming? Stats? Terrified? Don't be! We're going to start from the beginning with R and RStudio. In the first class, R I, we'll talk about the origins of R, what it can be used for, take a tour around the RStudio GUI and import data into RStudio. - Caelainn Barr (Advanced). Only 25 people allowed in, first come first serve.

Speakers
avatar for Caelainn Barr

Caelainn Barr

Data journalist, Guardian News & Media
Caelainn Barr is a data journalist at the Guardian in London. She has previously worked at the Wall Street Journal; Bloomberg; The Irish Times and The Bureau of Investigative Journalism. She is a graduate of the Stabile Center for Investigative Journalism at Columbia University.


Saturday May 20, 2017 09:30 - 10:30
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

09:30

QGIS I - Introduction to GIS with QGIS
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

INTRO TO GIS WITH QGIS --Learn how to uncover interesting patterns in your data with mapping software. This session will introduce QGIS, the free mapping app used in newsrooms throughout the world. (Beginners). Only 25 people allowed in, first come first serve.

Speakers
avatar for Robert Gebeloff

Robert Gebeloff

Database Projects Editor, The New York Times
Robert Gebeloff has been a database projects editor at The New York Times since 2008. He was a finalist for the Pulitzer Prize in 2015 for a series about corporate legal attacks on the rights of U.S. consumers and employees to sue, and again in 2016 for stories about racial dispa... Read More →



Saturday May 20, 2017 09:30 - 10:30
C3.15

09:30

Understanding the Internet - digital security
Digital surveillance and data traffic – how does it work, and where can your data get snatched? Interactive session where we show how data is transmitted over the internet and who can see and access it on the way from A to B. Maximum participants 20 - please register on Sched (if many are interested, the session will be repeated)

Speakers
avatar for Aslak Ransby

Aslak Ransby

Programmer and security trainer.
I'm @aslakransby on twitter.
avatar for Freja Wedenborg

Freja Wedenborg

Danish journalist and author of Cryptoguide for journalists, www.cryptoguide.dk. Teaching digital self defense at the Danish School of Media and Journalism. I'm @FrejaWedenborg at Twitter.


Saturday May 20, 2017 09:30 - 10:30
C2.25

09:30

Covering Finance - introduction
Finance Uncovered trains journalists and campaigners to investigate tax avoidance, money laundering and corruption and then supports its trained network to get complex, cross-border stories into the public domain. The team also conducts finance reporting itself. In this presentatoin the director of the training organisation, a journalist himself, will give an introduction to how transnational corporations, major infrastructure projects and sanction busting billionaire tycoons do "business".

Speakers
avatar for Nick Mathiason

Nick Mathiason

Founder and co-director, Finance Uncovered
Nick Mathiason was Guardian and Observer business correspondent for ten years. Before he became co-director of Finance Uncovered, he worked at the Bureau of Investigative Journalism in London. Nick has also worked at the Big Issue magazine and for the Financial Transparency Coal... Read More →


Saturday May 20, 2017 09:30 - 10:30
C2.30

09:30

Misuse of EU funds - how MEPs channelled money via their own foundations
Follow the money - A Danish journalist found indications of abuse of funds to European parties via a foundation set up by MEPs. But also MEPs from other countries were involved so he established contacts to journalists in the relevant. Together they unveiled misuse of EU funds dedicated to European parties and MEPS had to repay the money. Meet two of the team members, Peter Jeppesen from Denmark and Sarunas Cerniauskas from Lithuania. And read the work report by the Polish team member Wojtek Ciesla http://www.investigate-europe.eu/en/poland-eu-money-fraud-scandal/

Speakers
avatar for Sarunas Cerniauskas

Sarunas Cerniauskas

Editor at the Investigative Journalism Department, 15min.lt
One of the leading investigative journalists in Lithuanian, specializing in politics, corruption and data journalism. Awarded for pieces that disclosed major corruption and fraud cases. Former politics' reporter at delfi.lt, currently - head of the Investigative Journalism Depart... Read More →
avatar for Peter Jeppesen

Peter Jeppesen

Journalist, Ekstra Bladet
Peter Jeppesen is a journalist at Ekstra Bladet.


Saturday May 20, 2017 09:30 - 10:30
C2.23 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

10:30

Coffee
Saturday May 20, 2017 10:30 - 10:45
Cafeteria

10:45

Editorial coordination across borders - which tools are necessary?
Cross-border journalism is spreading. Communication within the team is crucial, tools are plentiful… so which solution to go for? Does technology determine how we collaborate in a team? Do we have a centralised structure or decentralised? Which team members need to know what and when? How do we want to collaborate, and which tech solution supports our particular structure? At this panel you can meet tech- and team members of large networks such as ICIJ, OCCRP, EIC but also of newly started or ad-hoc networks such as Investigate-Europe and Migrants Files.

Moderators
avatar for Paul-Olivier Dehaye

Paul-Olivier Dehaye

co-founder, PersonalData.IO
personal data / wobbing / Cambridge Analytica / algorithmic accountability / data economy /mathematics / startups helping journalists

Speakers
avatar for Stefan Candea

Stefan Candea

Stefan Candea is a freelance journalist, EIC.network
Stefan Candea is a freelance journalist and co-founder in 2001 of the Romanian Centre for Investigative Journalism (CRJI), an investigative non-profit registered in Bucharest, Romania. He started Sponge , an open and collaborative media innovation Lab for Eastern Europe. The Lab created an in-depth magazine... Read More →
avatar for Benedikt Hebeisen

Benedikt Hebeisen

Developer, virtualworx
Benedikt Hebeisen is a freelance developer & trainer for web and data solutions with focus on security and privacy. Tech support for Investigate Europe.
avatar for Friedrich Lindenberg

Friedrich Lindenberg

Tech Coordinator, OCCRP
Friedrich Lindenberg is a coder and data journalist working on web technology for new narrative and investigative techniques. He was an 2014 ICFJ Knight International Journalism Fellow with Code for Africa, and a 2013 Knight-Mozilla OpenNews Fellow at Spiegel Online. Previously... Read More →
avatar for Cécile Schilis-Gallego

Cécile Schilis-Gallego

Data journalist and researcher, ICIJ
Cécile Schilis-Gallego is a data journalist and researcher for ICIJ. She graduated in 2014 from Columbia Journalism School (US) and Sciences Po Journalism School (France) with a master's degree in investigative reporting. She is a 2014-2015 Brown Institute Magic Grantee, working... Read More →


Saturday May 20, 2017 10:45 - 11:45
Auditorium 2 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

10:45

Investigate Europe - the making of a European team
It has been repeated for decades: The EU is covered mainly with strong national bias. This does not help the citizens. Two years ago a small group of journalists were so annoyed, they decided to do something about it. Within two years they set up Investigate Europe, a nine-journalists from eight countries team. The task: Cover complex European topics. Like any other start-up they sacrfiice oceans of time and some also have lowered their previous salary expectations. Recently they published their second large research, a third is on the way www.investigate-europe.eu

Speakers
avatar for Nikolas Leontopoulos

Nikolas Leontopoulos

Journalist, Investigate Europe | VICE Greece
I am an Athens-based journalist, born in 1971. I worked for ten years for the Greek daily Eleftherotypia. Since 2009 I have been reporting on the financial and the migration crisis for a number of international media. I collaborated in investigations with Reuters on banks, shipping and the media in Greece, and contributed reporting in the... Read More →
avatar for Paulo Pena

Paulo Pena

Reporter at large, Público
I'm a Lisbon based investigative reporter, born in 1973. I work in Público, covering mostly political and economical issues. Since 2016 I'm also a member of the Investigate Europe team.
avatar for Harald Schumann

Harald Schumann

Sernior Reporter, Tagesspiegel
European journalism must follow the economic integration. The purely national perspective produces almost ever bad results and repeats only the propaganda those in power want us to report....
avatar for Elisa Simantke

Elisa Simantke

editorial coordinator, Investigate Europe
Elisa Simantke, born 1986, works as the editorial coordinator of Investigate Europe - a new cross border research team. She studied economy and politics at the University of Cologne and journalism at the Journalism School Cologne. She worked for the daily newspaper Berliner Tages... Read More →


Saturday May 20, 2017 10:45 - 11:45
C2.01 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

10:45

Digging into the medicinal business / Networking
Digging into the medicinal business - networking

Speakers
avatar for Eva Belmonte

Eva Belmonte

Managing Editor, Civio Foundation
Eva Belmonte (Spain, 1982) is a journalist specialised in public data analysis. She is Managing Editor at Fundación Civio, a non-profit newsroom based in Madrid, where she designs, develops and supervises data journalism projects such as medicamentalia.org (comparing the prices... Read More →
avatar for Marta Orosz

Marta Orosz

Reporter, CORRECTIV
Marta Orosz works as a reporter for the Berlin-based investigative newsroom Correctiv.org. She has been engaged in long-term investigations on TTIP and on the far-right group Pegida. As a Germany correspondent for Hungarian media, her other focus is politics and economy in Easter... Read More →


Saturday May 20, 2017 10:45 - 11:45
C2.17 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

10:45

Access II
Limited Capacity seats available

You think pivot tables in Excel are the answer to your dreams? Try the group-by function in Access and get hooked! Only 25 people allowed in, first come first serve.

Speakers
avatar for Winny de Jong

Winny de Jong

Datajournalist, OneWorld
Winny de Jong is data journalist. According to some she is a ‘workaholic’, and a ’strategist’, who gives ‘EPIC presentations’. Winny usually speaks about the importance of data literacy, how to develop ideas, and her data journalistic workflow. She has presented before for organizations like TEDx... Read More →
avatar for Luuk Sengers

Luuk Sengers

Trainer, Lecturer, Investigative Journalist, Freelance journalist
Luuk Sengers (1966) is an independent investigative journalist, university lecturer and media trainer. He writes about environmental issues (his recent stories appeared in AD, Trouw and De Groene Amsterdammer) and he educates students, media professionals and activists in investi... Read More →


Saturday May 20, 2017 10:45 - 11:45
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

10:45

Introduction to R for journalists II
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

R2/3 - In R II we'll get down to some data wrangling and learn how to clean, join and carry out some basic functions in R. These sessions will work best if you come to classes I-III as we will be building on knowledge and datasets from class to class. (Advanced). Only 25 people allowed in, first come first serve.

Speakers
avatar for Caelainn Barr

Caelainn Barr

Data journalist, Guardian News & Media
Caelainn Barr is a data journalist at the Guardian in London. She has previously worked at the Wall Street Journal; Bloomberg; The Irish Times and The Bureau of Investigative Journalism. She is a graduate of the Stabile Center for Investigative Journalism at Columbia University.


Saturday May 20, 2017 10:45 - 11:45
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

10:45

QGIS II - The art of the spatial join
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

QGIS II - THE ART OF THE SPATIAL JOIN: We often join data tables together to gain new insights for an analysis. With maps, we can join data together based not on a common ID field, but based on location. In this class, you'll learn an important reporting technique that can only be performed with mapping software. (Intermediate, and attending the Intro to GIS session is strongly recommended.) Only 25 people allowed in, first come first serve.

Speakers
avatar for Robert Gebeloff

Robert Gebeloff

Database Projects Editor, The New York Times
Robert Gebeloff has been a database projects editor at The New York Times since 2008. He was a finalist for the Pulitzer Prize in 2015 for a series about corporate legal attacks on the rights of U.S. consumers and employees to sue, and again in 2016 for stories about racial dispa... Read More →



Saturday May 20, 2017 10:45 - 11:45
C3.15

10:45

Hearing Voices - the award-winning story about the use of voice recordings in court
Can the voice of a person reveal his or her identity, and can forensic voice science be used just as DNA or fingerprints in legal cases? The Hearing voices research unveiled controversial cases and present shortcomings of the method. This award winning team not only collaborated across borders to unveil these practices causing legal incertainty. It also collaborated with journalists and scientists side by side and thus follows the new trend of journo-scholar collaborations. Meet Astrid Viciano and Michele Catanzaro. Read more http://journalismfund.eu/hearingvoices

Speakers
avatar for Michele Catanzaro

Michele Catanzaro

Freelance
Michele Catanzaro (Rome, 1979) is a freelance journalist based in Barcelona (Spain). He has a PhD in physics and writes for Nature, El Periódico, Chemistry World and others.Catanzaro is the co-author of the book "Networks. A Very Short Introduction" (OUP, 2013) and the documentary "Fast Track Injustice. The Óscar Sánchez Case" (2014). His work has been recognized by the King of Spain International Journalism Award, the Golden Nymph Award and the BBVA-Innovadata Prize. Michele Catanzaro was involved in 2 projects supported by Journalismfund.eu... Read More →
avatar for Astrid Viciano

Astrid Viciano

Science Reporter, Medical Doctor, Süddeutsche Zeitung
Astrid Viciano is a Spanish/German journalist and MD who works as a staff reporter at the weekend science section of Süddeutsche Zeitung in Munich, focusing on investigative cross-border projects regarding medical, scientific and social topics. Viciano has previously worked as a staff reporter at Focus, Die Zeit and Stern. From 2012 until 2016, she worked as a freelance reporter from Paris, from 2009 and 2011 she worked from Los Angeles. She has written for German and foreign media, and has published articles in German, English, French and Spanish. Viciano has won several journalism awards, grants, and fellowships.Astrid Viciano was involved in... Read More →



Saturday May 20, 2017 10:45 - 11:45
C2.30

10:45

Finding your way on the dark net
The Sunday Times recently exposed dark net marketplaces, unmasking a government contractor selling high-tech auto-theft equipment and a major dealer of illegal steroids. Other users ranged from middle-class students to professional poker players. Louis Goddard gives a behind-the-scenes look at the story, showing how the team used open source techniques to extract key location and contact data – including email addresses and geotags – from several marketplace backups, going on to link this data to named individuals in the UK. He will also show how the same data might be used by journalists elsewhere in the world, e.g. in the Netherlands, where many of the dealers identified by the investigation source their products. The session will be followed by an informal networking meeting. http://www.thetimes.co.uk/edition/news/dark-net-dealers-dragged-into-the-light-kx05bc3jd

Speakers
avatar for Louis Goddard

Louis Goddard

Data Journalist, The Times / The Sunday Times
I'm a Data Journalist working for The Times and The Sunday Times. I recently finished a PhD in contemporary poetry at the University of Sussex. Before that, I worked as a technology journalist and completed my undergraduate and masters degrees at the universities of Oxford and Ca... Read More →


Saturday May 20, 2017 10:45 - 11:45
C2.25

10:45

Search focused and fast (NEW TIME)
Cool tools for your research. BBC’s research expert Paul Myers has found new tools to unveil information.

Speakers
avatar for Paul Myers

Paul Myers

Internet research specialist, BBC
Met Paul Myers keert een oude bekende naar de conferentie terug. Al bijna twee decennia is hij een toonaangevende online search specialist.  Hij werkt voor de BBC als onderzoeksjournalist en geeft daarnaast trainingen over onder andere online research, datajournalistiek en omgaan met bewijs aan mensen van onder meer The Guardian, the Times en CNN. Hij blogt... Read More →


Saturday May 20, 2017 10:45 - 11:45
Auditorium 1 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

10:45

Tracking criminals' and billionaires' money
Many criminals and billionaires hide their money from authorities and channel it through fake companies to tax shelters. Hear two examples of how it is still possible to investigate the cases and follow the money.

Speakers
avatar for Matteo Civillini

Matteo Civillini

Freelance journalist, IRPI.eu
Matteo Civillini is a freelance journalist and member of Investigative Reporting Project Italy (IRPI), a centre for investigative journalism based in Italy. After obtaining an MA in Investigative Journalism from City University London, he joined the Italian bureau of VICE News. I... Read More →
avatar for Blaz Zgaga

Blaz Zgaga

freelance investigative journalist
Blaž Zgaga is a freelance investigative journalist living in Slovenia and is co-author of the trilogy In the Name of the State, which explores arms smuggling in the Balkans during the conflicts of the 1990s. After disclosure of a US DIA secret operation in 2000, he was prosecute... Read More →


Saturday May 20, 2017 10:45 - 11:45
C2.23 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

10:45

Wobbing tools
”Wobbing like a Norwegian” with a state provided online archive or using FOI-tools provided by journalists and activists is an opportunity to make FOI requests easier for citizens. While the Norwegian state authorities provide searchable document lists online with the necessary underlying server power to serve all their citizens, in other countries and on Norwegian regional level journalists or transparency advocates provide online tools to request access. At this workshop four such tools will be introduced and it will be discussed when and how they are useful to journalists and what to watch out for. Browse them here https://oep.no/?lang=en, http://innsyn.no/, https://www.asktheeu.org/, https://fragdenstaat.de/ The Norwegian tools will be provided by Tarjej Leer-Salvesen, who uses the state document register and – in lack of a regional register – built one himself on behalf of his regional newspaper, it is called Innsyn.no and could be replicated in other countries if necessary. Olivier Hoedemann is a Brussels-based lobbywatcher with long experience in using FOIs in his native Netherlands and the EU including bringing EU-legislation to the European Court of Justice, he has tested AskTheEU often enough to share his tactical considerations. Stefan Wehrmeyer is a datajournalist with German investigative journalism centre Correctiv and one of the co-founders of German FOI-tool FragDenStaat.

Speakers
avatar for Olivier Hoedeman

Olivier Hoedeman

Research and Campaign Coordinator, Corporate Europe Observatory
Olivier Hoedeman is research and campaign coordinator at Corporate Europe Observatory - exposing the power of corporate lobbying in the EU.
avatar for Tarjei Leer-Salvesen

Tarjei Leer-Salvesen

Journalist, Fædrelandsvennen
Tarjei Leer-Salvesen is a journalist based in Kristiansand, Norway, working for the regional newspaper Fædrelandsvennen (www.fvn.no). He has been working with investigative journalistic methods for documentary films as well as print publications such as Klassekampen, Dagbladet... Read More →
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

OKFN
Stefan is a software engineer and creator of civic applications. He has created Mapnificent, a public transport utility, and Frag Den Staat, Germany's Freedom of Information portal.


Saturday May 20, 2017 10:45 - 11:45
C1.25 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

11:00

Security café
Come and get help with your digital security problems. We will help you install the programs, that are mentioned in the security workshops (among others Signal, PGP, ToR and Full Disk Encryption), and do our best to solve other security worries and problems.

Speakers
avatar for Henrik Chulu

Henrik Chulu

Digital literacy and safety trainer
I will help you understand your operational environment in order to make better decisions about your safety and effectiveness. Co-founder of Bitbureauet. Independent researcher, writer, speaker and trainer.
avatar for Benedikt Hebeisen

Benedikt Hebeisen

Developer, virtualworx
Benedikt Hebeisen is a freelance developer & trainer for web and data solutions with focus on security and privacy. Tech support for Investigate Europe.
avatar for Aslak Ransby

Aslak Ransby

Programmer and security trainer.
I'm @aslakransby on twitter.
avatar for Albrecht Ude

Albrecht Ude

Journalist, Researcher, Recherche-Trainer
Albrecht Ude is based in Berlin (Germany) and Friesland, | works as freelancing journalist, researcher and research-trainer (online-researches, source checking, fact checking and security issues). | writes for several newspapers and magazines, print and online. | focusses on structured internet researches, privacy and security, censorship and civil rights in the digital world. | teaches at journalist’s academies, publishing companies and broadcasting stations inhouse, also at universities. | engages as editor in chief of the newsletter of the German investigative journalists association “netzwerk recherche”. | | Homepage at... Read More →
avatar for Freja Wedenborg

Freja Wedenborg

Danish journalist and author of Cryptoguide for journalists, www.cryptoguide.dk. Teaching digital self defense at the Danish School of Media and Journalism. I'm @FrejaWedenborg at Twitter.


Saturday May 20, 2017 11:00 - 17:00
Cafeteria

11:45

Coffee
Saturday May 20, 2017 11:45 - 12:00
Cafeteria

12:00

KEYNOTE: The Power of Algorithms - Algorithmic Accountability Reporting
Algorithms are coming to adjudicate decisions in nearly all facets of the public and private sectors. But despite the potential for efficiency gains, algorithms fed by big data can also amplify structural discrimination or produce errors that deny services to individuals – the close monitoring of such systems is paramount. Algorithmic accountability reporting is a new form of journalism that is emerging to apply the core journalistic functions of watchdogging and investigative reporting to algorithms. In this talk Diakopoulos will discuss how algorithmic accountability reporting is used by journalists as a method for articulating the power structures, biases, and influences that computational artifacts play in society.

Moderators
avatar for Brigitte Alfter

Brigitte Alfter

Managing Editor, Journalismfund.eu vzw
Journalist in Europe / Co-founder and managing editor of Journalismfund.eu / co-founder and program responsible European Investigative Journalism Conference and Dataharvest.eu / co-founder Wobbing.eu, Farmsubsidy.org, I-Scoop.org / member of www.icij.org, www.fuj.dk, www.netzwerk... Read More →

Speakers
avatar for Nicholas Diakopoulos

Nicholas Diakopoulos

Assistant Professor, University of Maryland
Nicholas Diakopoulos is an Assistant Professor at the University of Maryland, College Park Philip Merrill College of Journalism with courtesy appointments in the College of Information Studies and Department of Computer Science. He is Director of the Computational Journalism Lab... Read More →


Saturday May 20, 2017 12:00 - 13:00
Auditorium 2 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

12:00

Access III
Limited Capacity seats available

In this session we will join data from different tables. Here is where Access definitely rules over Excel. Only 25 people allowed in, first come first serve.

Speakers
avatar for Winny de Jong

Winny de Jong

Datajournalist, OneWorld
Winny de Jong is data journalist. According to some she is a ‘workaholic’, and a ’strategist’, who gives ‘EPIC presentations’. Winny usually speaks about the importance of data literacy, how to develop ideas, and her data journalistic workflow. She has presented before for organizations like TEDx... Read More →
avatar for Luuk Sengers

Luuk Sengers

Trainer, Lecturer, Investigative Journalist, Freelance journalist
Luuk Sengers (1966) is an independent investigative journalist, university lecturer and media trainer. He writes about environmental issues (his recent stories appeared in AD, Trouw and De Groene Amsterdammer) and he educates students, media professionals and activists in investi... Read More →


Saturday May 20, 2017 12:00 - 13:00
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

12:00

Introduction to R for journalists III
Limited Capacity filling up

R3/3 - In the third and final class, R III, we'll explore some of the statistical packages in R, use ggplot2 for visual analysis and dip into using R to pull data from APIs. These sessions will work best if you come to classes I-III as we will be building on knowledge and datasets from class to class. (Advanced). Only 25 people allowed in, first come first serve.

Speakers
avatar for Caelainn Barr

Caelainn Barr

Data journalist, Guardian News & Media
Caelainn Barr is a data journalist at the Guardian in London. She has previously worked at the Wall Street Journal; Bloomberg; The Irish Times and The Bureau of Investigative Journalism. She is a graduate of the Stabile Center for Investigative Journalism at Columbia University.


Saturday May 20, 2017 12:00 - 13:00
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

12:00

Make parsing great again - with Regex
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

MAKE PARSING GREAT AGAIN - WITH REGEX: In the real world, raw data is often messy. Regex is a tool that helps you dive into a pile of text and pull out meaningful information. In this class, you'll learn how to turn unstructured data -- Donald Trump's Twitter feed - into a clean text file, ready to import into your favorite database manager. (Intermediate / Advanced. Only 25 people allowed in, first come first serve.

Speakers
avatar for Robert Gebeloff

Robert Gebeloff

Database Projects Editor, The New York Times
Robert Gebeloff has been a database projects editor at The New York Times since 2008. He was a finalist for the Pulitzer Prize in 2015 for a series about corporate legal attacks on the rights of U.S. consumers and employees to sue, and again in 2016 for stories about racial dispa... Read More →


Saturday May 20, 2017 12:00 - 13:00
C3.15

13:00

Lunch
Saturday May 20, 2017 13:00 - 14:00
Cafeteria

14:00

Getting Started with Algorithmic Accountability Reporting
This session with introduce the resources of AlgorithmTips.org to help you get started with algorithmic accountability reporting. Participants in this interactive session will collaboratively explore the use of algorithms at various levels of government by running targeted search queries on governmental sites. Potential leads will be fleshed out to help orient and situate the algorithm in terms of how it’s used and how it may matter to the public. The appropriateness of various methods for undertaking investigation of the found algorithms will be discussed.

Moderators
avatar for Brigitte Alfter

Brigitte Alfter

Managing Editor, Journalismfund.eu vzw
Journalist in Europe / Co-founder and managing editor of Journalismfund.eu / co-founder and program responsible European Investigative Journalism Conference and Dataharvest.eu / co-founder Wobbing.eu, Farmsubsidy.org, I-Scoop.org / member of www.icij.org, www.fuj.dk, www.netzwerk... Read More →

Speakers
avatar for Nicholas Diakopoulos

Nicholas Diakopoulos

Assistant Professor, University of Maryland
Nicholas Diakopoulos is an Assistant Professor at the University of Maryland, College Park Philip Merrill College of Journalism with courtesy appointments in the College of Information Studies and Department of Computer Science. He is Director of the Computational Journalism Lab... Read More →


Saturday May 20, 2017 14:00 - 15:00
C1.25 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

14:00

Football Leaks - the making of
The Football Leaks investigation brought news about dirty deals in professional football on frontpages all over Europe last winter. The research was carried out by a large team, initiated by German news magazine flagship Spiegel but embracing as well as freelancers, Spanish classic newspaper El Mundo and French online only Médiapart. Meet Jörg Schmitt, research editor at Der Spiegel and meet Nicola Naber from Der Spiegel Fact-Checking Department

Speakers
avatar for Stefan Candea

Stefan Candea

Stefan Candea is a freelance journalist, EIC.network
Stefan Candea is a freelance journalist and co-founder in 2001 of the Romanian Centre for Investigative Journalism (CRJI), an investigative non-profit registered in Bucharest, Romania. He started Sponge , an open and collaborative media innovation Lab for Eastern Europe. The Lab created an in-depth magazine... Read More →
avatar for Nicola Naber

Nicola Naber

Dokumentation, Der Spiegel
Born 1979, studied economics, works at Spiegel's fact-checking department since 2007. Specialized in financial markets.
avatar for Jörg Schmitt

Jörg Schmitt

Coordinator, Der Spiegel
Geboren 1967 im hessischen Marburg. Studierte Journalistik, Wirtschaftspolitik und Jura in München und arbeitet inzwischen seit über 20 Jahren als investigativer Journalist. Zunächst für den "Stern", später für das "manager magazin", seit 2003 für den SPIEGEL. Spezialgebie... Read More →
avatar for Zeynep Sentek

Zeynep Sentek

Journalist, The Black Sea (theblacksea.eu)
Journalist specialising in investigations, human rights, workers' rights, and military issues. Doctoral researcher at Heidelberg University. | | Works freelance and also coordinates The Black Sea's Turkey investigations, and is part of the European Investigative Collabora... Read More →


Saturday May 20, 2017 14:00 - 15:00
C2.01 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

14:00

Digging into extraction data / Hands-on
Natural Resource Governance Institute (NRGI), and Open Oil (tbc) will present tips and tricks on how to navigate project level disclosures along with other key datasets from oil, gas and mining sector. The workshop will also feature presentation of tools for data driven investigations of oil, gas and mining companies such as ResourceProjects.org (a searchable database of project level payments), ResourceContracts.org (a searchable database of contracts) and Aleph (a searchable database of security filings from oil, gas and mining companies). The workshop will include presentations and examples of how the data can be used.

Speakers
avatar for Anders Pedersen

Anders Pedersen

Acting Manager of Data Projects, Natural Resource Governance Institute


Saturday May 20, 2017 14:00 - 15:00
C2.21

14:00

Is Your Doctor Paid by the Drug Producer? I
The project “Euros for doctors” details what payments individual doctors have received by pharmaceutical companies. The readers can look for their doctor to see what funding he have received. Payments from pharmaceutical companies have been shown to influence which medicines the doctors prescribe, with possible detrimental effects for the patient. The project, coordinated by Correctiv.org, has collected a database of 35.000 names of doctors and organizations with the corresponding payments. What started off as a national project, now includes Switzerland and Austria. The plan is now to expand it to more countries, as data is available for more EU-member states. The team presents its experience with getting, cleaning, and publishing data, as well as coverage, impact, and legal implications. After the workshop there will be a hands-on workshop, where participants are led through the workflow. https://correctiv.org/en/investigations/euros-doctors

Speakers
avatar for Eva Belmonte

Eva Belmonte

Managing Editor, Civio Foundation
Eva Belmonte (Spain, 1982) is a journalist specialised in public data analysis. She is Managing Editor at Fundación Civio, a non-profit newsroom based in Madrid, where she designs, develops and supervises data journalism projects such as medicamentalia.org (comparing the prices... Read More →
avatar for Hristio Boytchev

Hristio Boytchev

Reporter, CORRECTIV
Hristio Boytchev ist Reporter bei correctiv.org. Hristio hat als freier Medizin- und Wissenschaftsjournalist für „Stern“, „DER SPIEGEL“ und „Nature“ gearbeitet. Davor hat er Biologie an der TU Dresden und Journalismus an der Universidad Complutense de Madrid studiert. Hristio hat 2011 das Programm... Read More →
avatar for Sylke Gruhnwald

Sylke Gruhnwald

Chairwoman and journalist, Journalismfund.eu
Sylke Gruhnwald is chairwoman of Journalismfund.eu and investigative reporter with the Swiss magazine «Beobachter». Studies of Sinology and Business Administration. Worked for «The Economist Group», its «Economist Intelligence Unit» as well as the Swiss daily newspaper «Neue Zürcher Zeitung» and the Swiss public broadcaster «Schweizer Radio und Fernsehen». sgr. is co-founder of... Read More →
avatar for Patrick Stotz

Patrick Stotz

Data journalist, Spiegel Online
As a data journalist at Spiegel Online, I turn data into visualizations, stories and maps, covering a wide range of topics. Once upon a time I studied urban planning before my fascination for interactive maps led me to data journalism, joining Spiegel Online in 2015.
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

OKFN
Stefan is a software engineer and creator of civic applications. He has created Mapnificent, a public transport utility, and Frag Den Staat, Germany's Freedom of Information portal.


Saturday May 20, 2017 14:00 - 15:00
C2.17 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

14:00

The European CO2 market
Who is really in control of the European CO2 market? Follow the money to see where the power lies, they say. Ana Lutzky followed the CO2 upstream, from the subsidiaries to the parent company. To understand the possible reasons of the European CO2 market’s failure, she extracted CO2 emission data on the 14 000 industrial sites subject to the emissions trading scheme all over Europe, and looked at one particular aspect of it: its concentration. The investigation showed that 40 big companies are holding back their governments on CO2 market regulation. What about your country? FOllowed by workshop.

Speakers
avatar for Ana Lutzky

Ana Lutzky

Journalist, AEF Développement durable
Journalist living in Paris, digging into datajournalism field for more or less three years, covering corporate responsibility and governance for the French newswire AEF. | Amongst latest work : | - calculated how many people live around 19 French nuclear plants for Fukushima ani... Read More →



Saturday May 20, 2017 14:00 - 15:00
C2.11

14:00

Creating beautiful online maps in minutes
Limited Capacity filling up

BEAUTIFUL ONLINE MAPS IN MINUTES: There are a bevy of tools available to turn data into maps. In this session, you'll learn how to illustrate your story with an interactive map using the free Leaflet javascript library. The class will show how to initiate a fresh map, how to load data, and how to change the characteristics of the map based on the underlying data. (Intermediate / Advanced). Only 25 people allowed in, first come first serve.

Speakers
avatar for Robert Gebeloff

Robert Gebeloff

Database Projects Editor, The New York Times
Robert Gebeloff has been a database projects editor at The New York Times since 2008. He was a finalist for the Pulitzer Prize in 2015 for a series about corporate legal attacks on the rights of U.S. consumers and employees to sue, and again in 2016 for stories about racial dispa... Read More →


Saturday May 20, 2017 14:00 - 15:00
C3.15

14:00

Python I
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Python I - Introduction to Python: We'll start by setting up Python and learn to install new packages. We'll
learn how to use python in the console and to write and execute small scripts. We'll discuss basic concepts such as variables, if and for.
Requirements: None. However, if you have never programmed bevore, this will only be a very quick walk-through the most basic concepts. Only 25 people allowed in, first come first serve.

Speakers
avatar for Elena Erdmann

Elena Erdmann

Elena is a phd student in Machine Learning at TU Dortmund. Her research interest include automated text analysis and digital humanities. She is excited about data journalism and the way technology is used in the newsroom. Last year, she gathered some experience in journalism as a member of Journocode, a Google News Fellow at Wirtschaftswoche and in a project at... Read More →


Saturday May 20, 2017 14:00 - 15:00
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

14:00

STATS I
Limited Capacity seats available

Introduction to statistics - Picking the right tool depends on what your data looks like. We cover: categorical and continuous data, descriptive statistics, normal distribution, polls, margins of error and other basics. Then we'll work on the first and simplest test, correlation. In this series we'll use data from sports, student test scores and spending, among others; each class will build on the next. Familiarity with Excel navigation and formulas; beginner statistics. NOTE: We'll be using the Analysis ToolPak in Excel on PCs provided by the venue. You can use your own computer, HOWEVER, be aware that many versions of Excel for Mac do not have the full ToolPak capability. Check your computer before you attend the class by doing the following:

Start Excel for Mac.
Click Tools, and then click Add-Ins.
Click the Data Analysis ToolPak. Then, click OK.
Locate Data Analysis ToolPak on the Data tab.
If it does not install, you can't use ToolPak. Only 25 people allowed in, first come first serve.

Speakers
avatar for Jodi Upton

Jodi Upton

Senior database editor, USA Today
Jodi Upton is the Senior Database Editor at USA TODAY, where she leads the database team in analysis on stories from mass killings to the job market to football coach contracts. Her team supports breaking news, investigative projects and everything in between, as well as data-dri... Read More →


Saturday May 20, 2017 14:00 - 15:00
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

14:00

Funding quality journalism: Entrepreneurial, foundation supported or both?
Adessium Foundation has commissioned a study on "Financing quality journalism", which was conducted by Teun Gautier and Pieter Oostlander. The study offers a long list of possible opportunities. Entrepreneurial journalists are adapting some of the models to their realities already, testing, adapting and – some of them – finding new revenue models. Along the way they rely on support by donors. Meet four donors from four different countries who provide significant support to quality journalim in Europe and hear their considerations.

Speakers
avatar for Algirdas Lipstas

Algirdas Lipstas

Deputy Director, Program on Independent Journalism, OSF
Algirdas Lipstas joined the Media Program (now the Program on Independent Journalism) as project manager in charge primarily of support to journalism training projects. This included work with mid-career journalism training institutions in Open Society’s “traditional region... Read More →
avatar for Stephanie Reuter

Stephanie Reuter

Director, Rudolf Augstein Stiftung
Stephanie Reuter is the director of the German Rudolf Augstein Foundation. Before joining Augstein in 2011 she managed the secretariate of the Institute for Culture and Media Management at the University for Music and Theatre in Hamburg. Having studied journalism and cultural management she has not only worked with major German media such as press agency dpa and broadcasters ZDF and SWR, but also in the foundation sector... Read More →
avatar for Sahar Yadegari

Sahar Yadegari

Program Manager at Adessium Foundation, Adessium Foundation
Sahar Yadegari is program manager at Adessium Foundation.


Saturday May 20, 2017 14:00 - 15:00
Auditorium 2 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

14:00

Journalist-scholar collaborations: a model to pursue? / Round table
So much knowledge is held and such forceful methods are practiced by scholars. While traditionally journalists worked with scholars as their sources, and scholars worked with journalists as communication partners, recent years have brought more and more examples of genuine collaboration. This conference gathers some of these examples to see, what works and what is difficult. At this round table we'll consider opportunities and challenges, how can both groups collaborate without loosing independence and thus credibility, without compromising the quality of their work, which types of collaboration make sense and which do not.This round table brings together some of those working with collaborations between scholars and journalists. And this round table has the objective to answer two questions: Are the first examples so promising we should strive to develop this new collaborative approach further, and if so, how?

Moderators
avatar for Ides Debruyne

Ides Debruyne

Managing Director, Journalismfund.eu vzw
Ides Debruyne is co-founder of Journalismfund.eu vzw (formerly known as the Belgian Pascal Decroos Fund for Investigative Journalism) and the Dutch-Flemish Association of Investigative Journalists (VVOJ). He is managing director of Journalismfund.eu. Debruyne is co-organizer of the... Read More →

Speakers
avatar for Georgiana Bere

Georgiana Bere

Developer, OpenTrials
I am a programmer and a data geek interested in government transparency and anti-waste initiatives. Most of my work revolves around public procurements from EU countries.
avatar for Michele Catanzaro

Michele Catanzaro

Freelance
Michele Catanzaro (Rome, 1979) is a freelance journalist based in Barcelona (Spain). He has a PhD in physics and writes for Nature, El Periódico, Chemistry World and others.Catanzaro is the co-author of the book "Networks. A Very Short Introduction" (OUP, 2013) and the documentary "Fast Track Injustice. The Óscar Sánchez Case" (2014). His work has been recognized by the King of Spain International Journalism Award, the Golden Nymph Award and the BBVA-Innovadata Prize. Michele Catanzaro was involved in 2 projects supported by Journalismfund.eu... Read More →
avatar for Ben Meghreblian

Ben Meghreblian

Community Manager, OpenTrials
Ben is the Community Manager for OpenTrials, an Open Knowledge International project aiming to produce an open, easy-to-use, linked database of information about the world's clinical trials. He has a background in psychology and IT, and previously worked on the AllTrials... Read More →
avatar for Marcel Metze

Marcel Metze

Editor-in-chief, Metze Research
Dutch Journal of Medicine (editorial advisor) and Tobacco Investigations Desk (editor-in-chief).
avatar for Victor Nitu

Victor Nitu

Developer, The Sponge Media Innovation Lab
Victor Nitu is developer at The Sponge Media Innovation Lab.
avatar for Katharina Rasch

Katharina Rasch

Data scientist
avatar for Astrid Viciano

Astrid Viciano

Science Reporter, Medical Doctor, Süddeutsche Zeitung
Astrid Viciano is a Spanish/German journalist and MD who works as a staff reporter at the weekend science section of Süddeutsche Zeitung in Munich, focusing on investigative cross-border projects regarding medical, scientific and social topics. Viciano has previously worked as a staff reporter at Focus, Die Zeit and Stern. From 2012 until 2016, she worked as a freelance reporter from Paris, from 2009 and 2011 she worked from Los Angeles. She has written for German and foreign media, and has published articles in German, English, French and Spanish. Viciano has won several journalism awards, grants, and fellowships.Astrid Viciano was involved in... Read More →



Saturday May 20, 2017 14:00 - 15:00
C2.23 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

14:00

Wobbing round table
Experience shows that it makes sense to collaborate across borders when looking for information. Experience also shows that there are Europe-wide trends on practices. At this round table you will not only meet some of more the experienced and committed practitioners of freedom of information requests, you will also contribute to strengthen the network of those who actively use this legislation Europe-wide.

Moderators
avatar for Tania Röttger

Tania Röttger

Reporterin, Correctiv
Tania Röttger studierte Sozial-, Rechts- und Wirtschaftswissenschaften in London und Berlin und arbeitete danach in einem Londoner Recherchebüro, wo sie die Auskunftsrechte als Instrument investigativer Recherche kennenlernte.Tanja Röttger arbeitet als Journalistin des gemeinnützigen Recherche-Zentrums... Read More →

Speakers
avatar for Staffan Dahllöf

Staffan Dahllöf

Freelance reporter
Staffan Dahllöf (1955) is a freelance reporter based in Copenhagen. Dahllöf is a member of the Farmsubsidy team. In 1993 he was co-editor and co-author of "Journalisternas EG-handbok", a guide in Swedish on EC/EU reporting. Since 1994 he has been engaged in courses on EU report... Read More →
avatar for Paul-Olivier Dehaye

Paul-Olivier Dehaye

co-founder, PersonalData.IO
personal data / wobbing / Cambridge Analytica / algorithmic accountability / data economy /mathematics / startups helping journalists
avatar for Anuska Delic

Anuska Delic

Journalist, DeloData project leader, Delo daily
Investigative and data journalist with Slovenia's leading daily broadsheet newspaper Delo. There Delić leads DeloData, a project aimed at establishing and developing data journalism within Delo's newsroom. | | Delić, who has recently been in a court trial for allegedly publ... Read More →
avatar for Olivier Hoedeman

Olivier Hoedeman

Research and Campaign Coordinator, Corporate Europe Observatory
Olivier Hoedeman is research and campaign coordinator at Corporate Europe Observatory - exposing the power of corporate lobbying in the EU.
avatar for Tarjei Leer-Salvesen

Tarjei Leer-Salvesen

Journalist, Fædrelandsvennen
Tarjei Leer-Salvesen is a journalist based in Kristiansand, Norway, working for the regional newspaper Fædrelandsvennen (www.fvn.no). He has been working with investigative journalistic methods for documentary films as well as print publications such as Klassekampen, Dagbladet... Read More →
avatar for Olivier Petitjean

Olivier Petitjean

Basta / Observatoire des multinationales
avatar for Martin Stoll

Martin Stoll

Editor - Boardmember, SonntagsZeitung / Öffentlichkeitsgesetz.ch
Martin Stoll is correspondent for the weekly newspaper SonntagsZeitung in Berne and an expert in Swiss-Foia. He is the deputy chairmain of Investigativ.ch and the director the Siwss Foia-organization Öffentlichkeitsgesetz.ch... Read More →
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

OKFN
Stefan is a software engineer and creator of civic applications. He has created Mapnificent, a public transport utility, and Frag Den Staat, Germany's Freedom of Information portal.


Saturday May 20, 2017 14:00 - 15:00
C2.30

15:00

Coffee
Saturday May 20, 2017 15:00 - 15:15
Cafeteria

15:15

Algorithm Accountability - European network on journalists and algorithm accountability
In May 2016 German journalists and IT-experts founded Algorithmwatch.org. They'll share the experience of the first year and open up for a networking round on algorithm watching journalism throughout Europe.

Moderators
avatar for Brigitte Alfter

Brigitte Alfter

Managing Editor, Journalismfund.eu vzw
Journalist in Europe / Co-founder and managing editor of Journalismfund.eu / co-founder and program responsible European Investigative Journalism Conference and Dataharvest.eu / co-founder Wobbing.eu, Farmsubsidy.org, I-Scoop.org / member of www.icij.org, www.fuj.dk, www.netzwerk... Read More →

Speakers
avatar for Nicholas Diakopoulos

Nicholas Diakopoulos

Assistant Professor, University of Maryland
Nicholas Diakopoulos is an Assistant Professor at the University of Maryland, College Park Philip Merrill College of Journalism with courtesy appointments in the College of Information Studies and Department of Computer Science. He is Director of the Computational Journalism Lab... Read More →
avatar for Lorenz Matzat

Lorenz Matzat

Journalist, AlgorithmWatch
Lorenz Matzat is a journalist and entrepreneur in Berlin. He is co-founder of AlgorithmWatch, a non-profit initiative to evaluate and shed light on algorithmic decision making processes that have a social relevance, meaning they are used either to predict or prescribe human actio... Read More →
avatar for Matthias Spielkamp

Matthias Spielkamp

Journalist, Algorithm Watch and iRights.international
Matthias is a journalist and entrepreneur in Berlin. In 2016, he co-founded Algorithm Watch, an advocacy organisation focused on algorithmic accountability. In 2004, he co-funded the online magazine iRights.info – about legal issues in the digital world, which in 2006 received the Grimme Online Award, Germany’s most prestigious award for online journalism. He now serves as its publisher. | Matthias is the founder and director of... Read More →


Saturday May 20, 2017 15:15 - 16:15
C1.25 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

15:15

Knowledge sharing in collaborative teams - the tools available
Networking tool diversity? Document sharing tools and possibilities to share comments/annotations in cross-border teams are crucial. Meet the connoisseurs of document sharing and annotation both working on new tools from Investigative Dashboard/OCCRP and Liquid Investigations.

Moderators
avatar for Paul-Olivier Dehaye

Paul-Olivier Dehaye

co-founder, PersonalData.IO
personal data / wobbing / Cambridge Analytica / algorithmic accountability / data economy /mathematics / startups helping journalists

Speakers
avatar for Friedrich Lindenberg

Friedrich Lindenberg

Tech Coordinator, OCCRP
Friedrich Lindenberg is a coder and data journalist working on web technology for new narrative and investigative techniques. He was an 2014 ICFJ Knight International Journalism Fellow with Code for Africa, and a 2013 Knight-Mozilla OpenNews Fellow at Spiegel Online. Previously... Read More →
avatar for Sebastian Mondial

Sebastian Mondial

Investigative Data Specialist & Lecturer, Liquid Investigations
I work in data and investigative journalism, sometimes also as a security expert. In 2017 I will mostly work on Liquid Investigations and teach Students in Data-Journalism at the HDM Stuttgart. If time allows, I have the privilege to work with some of the finest investigative jou... Read More →


Saturday May 20, 2017 15:15 - 16:15
C2.01 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

15:15

Data tour - EU data via the EU's Open Data Portal
The EU institutions provide a single access point to their open data through the EU Open Data Portal. The portal provides info about the datasets the EU holds including metadata. Also if you - through your specialisation - are aware of datasets held by the EU, you can pitch them to the team behind the portal. Meet Glen Campbell and Corina Buruiana from the Publications Office of the European Union who will give you a short introduction into the EU's open data policy and then walk you through the opportunities provided by the portal https://data.europa.eu/euodp/en/about. NOTE: THERE ARE TWO EUROPEAN DATA PORTALS, THIS ONE FOCUSES ON DATA HELD BY THE EU INSTITUTIONS.


Speakers
avatar for Corina Buruiana

Corina Buruiana

Promotion and development, Publications Office of the EU, European Commission
I'm part of the team behind the EU Open Data Portal - helping with its promotion and development, within the EU institutions and beyond.
avatar for Glen Campbell

Glen Campbell

Outreach and onboarding, Publications Office of the EU, European Commission
I am one of a team helping to promote the EU Open Data Portal as a single point of access to data from the EU institutions, agencies and other bodies. I help people to find the data they want and other people to put the data out there for reuse.


Saturday May 20, 2017 15:15 - 16:15
Auditorium 2 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

15:15

Digging into extraction data - the global natural resources business: (NEW TIME)
Across the world, governments and companies are involved in natural resource projects, generating billions of dollars. Continued effort in making the sector more transparent has led to an increasing amount of information becoming available. The European Union Accounting Directive (from 2013) requires extractives companies based in EU countries to disclose payments they make to governments anywhere in the world. Natural Resource Governance Institute (NRGI) will present the findings and data from analysis of extractives company payments worth more than 1,000 projects reported across more than 100 countries using disclosures from EU based companies. They will share suggestions on how to use the data for research and investigations.

Speakers
avatar for Anders Pedersen

Anders Pedersen

Acting Manager of Data Projects, Natural Resource Governance Institute


Saturday May 20, 2017 15:15 - 16:15
C2.21

15:15

Is Your Doctor Paid by the Drug Producer? II
Workshop and networking - Correctiv.org has collected a database of 35.000 names of doctors who have received payment from pharmaceutical companies. The team offers a hands-on workshop, where participants are led through the workflow of finding the data relevant for their own country. https://correctiv.org/en/investigations/euros-doctors

Speakers
avatar for Eva Belmonte

Eva Belmonte

Managing Editor, Civio Foundation
Eva Belmonte (Spain, 1982) is a journalist specialised in public data analysis. She is Managing Editor at Fundación Civio, a non-profit newsroom based in Madrid, where she designs, develops and supervises data journalism projects such as medicamentalia.org (comparing the prices... Read More →
avatar for Hristio Boytchev

Hristio Boytchev

Reporter, CORRECTIV
Hristio Boytchev ist Reporter bei correctiv.org. Hristio hat als freier Medizin- und Wissenschaftsjournalist für „Stern“, „DER SPIEGEL“ und „Nature“ gearbeitet. Davor hat er Biologie an der TU Dresden und Journalismus an der Universidad Complutense de Madrid studiert. Hristio hat 2011 das Programm... Read More →
avatar for Sylke Gruhnwald

Sylke Gruhnwald

Chairwoman and journalist, Journalismfund.eu
Sylke Gruhnwald is chairwoman of Journalismfund.eu and investigative reporter with the Swiss magazine «Beobachter». Studies of Sinology and Business Administration. Worked for «The Economist Group», its «Economist Intelligence Unit» as well as the Swiss daily newspaper «Neue Zürcher Zeitung» and the Swiss public broadcaster «Schweizer Radio und Fernsehen». sgr. is co-founder of... Read More →
avatar for Patrick Stotz

Patrick Stotz

Data journalist, Spiegel Online
As a data journalist at Spiegel Online, I turn data into visualizations, stories and maps, covering a wide range of topics. Once upon a time I studied urban planning before my fascination for interactive maps led me to data journalism, joining Spiegel Online in 2015.
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

OKFN
Stefan is a software engineer and creator of civic applications. He has created Mapnificent, a public transport utility, and Frag Den Staat, Germany's Freedom of Information portal.


Saturday May 20, 2017 15:15 - 16:15
C2.17 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

15:15

The European CO2 market - working the data
Let's unite forces and explore. Ana Lutzky shows how you can access the data on CO2 trade in your country. Fancy improving the python scraper to leverage fresh 2016 data? Do you prefer focusing on Polish/Greek/German coal plants? Or do you plan to dig up the "ghost plants" of the EU in cement sector, and track the "fat cats"? Let's talk about our experiences in this area and - if interested - exchange mail addresses to start a network and keep in touch.

Speakers
avatar for Ana Lutzky

Ana Lutzky

Journalist, AEF Développement durable
Journalist living in Paris, digging into datajournalism field for more or less three years, covering corporate responsibility and governance for the French newswire AEF. | Amongst latest work : | - calculated how many people live around 19 French nuclear plants for Fukushima ani... Read More →



Saturday May 20, 2017 15:15 - 16:15
C2.11

15:15

Intro to the command line I
Limited Capacity filling up

Intro to the command line: Add to your data tool box by harnessing the mighty power of the command line, the little black box full of potential. We'll teach you how to navigate your operating system, mouse free, manage files and folders, sanity check your data and manipulate csvs. The possibilities are endless the future is bright! - Only 25 people allowed in, first come first serve. NOTE: It's a bring your own laptop session (Mac or Linux based) or else just watch along.

Speakers
avatar for Karrie Kehoe

Karrie Kehoe

Data Journalist, RTÉ Investigations Unit
Karrie Kehoe wrangles data at the RTÉ Investigations Unit. Before RTÉ she worked at The Times, The Sunday Times and the Thomson Reuters Foundation. Karrie has used data analysis to investigate compensation payments in Afghanistan, Court judgements in Ireland and waste and corru... Read More →


Saturday May 20, 2017 15:15 - 16:15
C3.15

15:15

Python II
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Python II - This is an introduction to handling data with python. Thus, we'll read data from csv, manipulate/clean a dataset and draw a basic plot. Finally, we'll explore useful python libraries.
Requirements: Ideally, you would have attended Python1 tutorial or already have these skills. Otherwise, you should at least have installed Python3 and Pip and have a basic familiarity to programing. Only 25 people allowed in, first come first serve.

Speakers
avatar for Elena Erdmann

Elena Erdmann

Elena is a phd student in Machine Learning at TU Dortmund. Her research interest include automated text analysis and digital humanities. She is excited about data journalism and the way technology is used in the newsroom. Last year, she gathered some experience in journalism as a member of Journocode, a Google News Fellow at Wirtschaftswoche and in a project at... Read More →


Saturday May 20, 2017 15:15 - 16:15
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

15:15

STATS II
Limited Capacity seats available

Statistics II. As data gets more complicated, we use different tools. We cover: two tools to look at differences between groups, such as gender and graduation rates, or race/ethnicity and voting. (t-test and ANOVA). Familiarity with Excel navigation and formulas; intermediate statistics. NOTE: We'll be using the Analysis ToolPak in Excel on PCs provided by the venue. You can use your own computer, HOWEVER, be aware that many versions of Excel for Mac do not have the full ToolPak capability. Check your computer before you attend the class by doing the following:

Start Excel for Mac.
Click Tools, and then click Add-Ins.
Click the Data Analysis ToolPak. Then, click OK.
Locate Data Analysis ToolPak on the Data tab.
If it does not install, you can't use ToolPak. Only 25 people allowed in, first come first serve.

Speakers
avatar for Jodi Upton

Jodi Upton

Senior database editor, USA Today
Jodi Upton is the Senior Database Editor at USA TODAY, where she leads the database team in analysis on stories from mass killings to the job market to football coach contracts. Her team supports breaking news, investigative projects and everything in between, as well as data-dri... Read More →


Saturday May 20, 2017 15:15 - 16:15
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

15:15

Protect privacy - anonymize your data I
Making the datasets from an investigation public allows readers to verify the reported facts and scrutinize the conclusions. But it may also release enough facts to identify individuals in the data. Unfortunately, we are pretty unique - in the combination of our describing attributes (date of birth, sex, location, profession, etc) as well as in our observable behaviour (e.g. combinations of articles bought in an online shop or films watched on netflix). This uniqueness can make it easy to re-identify people in a dataset, even if names and other obvious identifiers have been removed. Data anonymization is about making us less unique, by removing/replacing just enough information so that people can no longer be identified – while still retaining enough information to make the dataset useful to others. It can be hard to strike the balance between privacy and utility (in fact, it is more or less an unsolved problem). In the first session Katharina Rasch gives an introduction to data anonymization, demonstrates different methods, and looks at examples of data anonymization gone wrong. The second session aims to bring people together with an interest in or experience in developing anonymization methods. Both sessions are aimed at journalists and data scientists alike, no previous experience in data analysis is required.

Speakers
avatar for Katharina Rasch

Katharina Rasch

Data scientist


Saturday May 20, 2017 15:15 - 16:15
C2.25

15:15

FOI / Wobbing in the EU
Requesting access to documents with the EU institutions follows the general structures of freedom of information legislation with some specialities. The EU regulations were all passed in the digital age and thus have particularly strong wording in that field; on the difficult side the EU’s institutions are dealing with a diversity of national administrative cultures, which obviously influence the practice of granting access to documents; finally the law is less than two decades old and legal practice via the EU-ombudsman and the European Court of Justice is only emerging. In this workshop FOI veterans journalist Staffan Dahllöf and transparency advocate Olivier Hoedeman will give you a practical introduction on how to wob the EU. Staffan Dahllöf has decade long experience with wobbing on several levels, he has done systematic comparative between the Nordic countries and the EU, as well as systematic wobbing within the EU system, he is the author of a recent report on transparency in the EU http://oeiceurope.com/wp-content/uploads/2016/02/Transparency_report_Final_52p.pdf and on the team of journalists taking the European Parliament to court over lacking access to documents. Olivier Hoedeman, Brussels based EU-lobbywatcher from the Corporate Europe Observatory uses wobbing as a systematic tool to get insights into the working of the EU-institutions with regards to lobbyists.

Speakers
avatar for Staffan Dahllöf

Staffan Dahllöf

Freelance reporter
Staffan Dahllöf (1955) is a freelance reporter based in Copenhagen. Dahllöf is a member of the Farmsubsidy team. In 1993 he was co-editor and co-author of "Journalisternas EG-handbok", a guide in Swedish on EC/EU reporting. Since 1994 he has been engaged in courses on EU report... Read More →
avatar for Olivier Hoedeman

Olivier Hoedeman

Research and Campaign Coordinator, Corporate Europe Observatory
Olivier Hoedeman is research and campaign coordinator at Corporate Europe Observatory - exposing the power of corporate lobbying in the EU.


Saturday May 20, 2017 15:15 - 16:15
C2.30

16:15

Coffee
Saturday May 20, 2017 16:15 - 16:30
Cafeteria

16:30

Cross-border journalism - get started, step-by-step
Cross-border journalism is not only for the star journalists at the major media. Everyone can learn the method by understanding the process. Brigitte Alfter is author of the Handbook on Cross-border Journalism and will give her step-by-step introduction to the method. You are welcome to bring examples of stories, you would like to research across borders to supplement the examples Brigitte has.

Speakers
avatar for Brigitte Alfter

Brigitte Alfter

Managing Editor, Journalismfund.eu vzw
Journalist in Europe / Co-founder and managing editor of Journalismfund.eu / co-founder and program responsible European Investigative Journalism Conference and Dataharvest.eu / co-founder Wobbing.eu, Farmsubsidy.org, I-Scoop.org / member of www.icij.org, www.fuj.dk, www.netzwerk... Read More →


Saturday May 20, 2017 16:30 - 17:30
C2.01 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

16:30

Data harvested during the Hack Day III
In this session the coders and datajournalists will present their work from the Dataharvest Hackday. In this session the coders and data journalists will present their work from the Dataharvest Hackday. The datasets to be presented are: FRI 15.15
Water & Conflict - Lisa Dupuy, Ludo Hekman
In a post-conflict zone, the water management is an important indicator for the chances of security and stability. However, a lot of the data is missing, not available or not shared. We will present some of the insight we gathered from looking into the data that is available.

Open trials - Ben Meghreblian, Victor Nițu
OpenTrials is a collaboration between Open Knowledge International and Dr Ben Goldacre from the University of Oxford DataLab. It aims to locate, match, and share all publicly accessible data and documents, on all trials conducted, on all medicines and other treatments, globally.

SAT 9.30
Media Ownership - Chiara Sighele & co
Media ownership data on the company structures and shareholders are in many cases difficult to find, not publicly available or reaching a dead end in tax havens. We will present some of the findings from digging into the European TV channels data, as well as Bulgarian newspapers ownership.

SAT 16.30
Farm subsidies - Stefan Wehrmeyer
The Common Agricultural Policy hands out billions a year. Interested in where it goes? Learn more about our FarmSubsidy data sets!

OpenSanctions - Friedrich Lindenberg
OpenSanctions is a global database of persons and companies of political, criminal, or economic interest. We have combined sanctioned entities, politically exposed persons, and other public information into a single dataset.

Speakers
avatar for Georgiana Bere

Georgiana Bere

Developer, OpenTrials
I am a programmer and a data geek interested in government transparency and anti-waste initiatives. Most of my work revolves around public procurements from EU countries.
avatar for Friedrich Lindenberg

Friedrich Lindenberg

Tech Coordinator, OCCRP
Friedrich Lindenberg is a coder and data journalist working on web technology for new narrative and investigative techniques. He was an 2014 ICFJ Knight International Journalism Fellow with Code for Africa, and a 2013 Knight-Mozilla OpenNews Fellow at Spiegel Online. Previously... Read More →
avatar for Victor Nitu

Victor Nitu

Developer, The Sponge Media Innovation Lab
Victor Nitu is developer at The Sponge Media Innovation Lab.
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

OKFN
Stefan is a software engineer and creator of civic applications. He has created Mapnificent, a public transport utility, and Frag Den Staat, Germany's Freedom of Information portal.


Saturday May 20, 2017 16:30 - 17:30
C2.17 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

16:30

Integrating data journalism in the newsroom
How to collaborate when no one understands what you do? Database editor at the Guardian and formerly at the Swedish broadcaster SVT, Helena Bengtson, along with datajournalist at the Guardian Caeilinn Barr will explain to journalists and editors alike why it is so difficult to integrate a data desk in the newsroom - even though everybody knows it's the right thing to do and endorses it.

Speakers
avatar for Caelainn Barr

Caelainn Barr

Data journalist, Guardian News & Media
Caelainn Barr is a data journalist at the Guardian in London. She has previously worked at the Wall Street Journal; Bloomberg; The Irish Times and The Bureau of Investigative Journalism. She is a graduate of the Stabile Center for Investigative Journalism at Columbia University.
avatar for Helena Bengtsson

Helena Bengtsson

Editor, Data Projects, The Guardian
Helena Bengtsson is Editor, Data Projects at the Guardian in London, UK. She previously worked as the database editor at Sveriges Television, Sweden’s national television broadcaster. In 2006 and 2007, she was database editor at the Center for Public Integrity in Washington, D.C. She was awarded the Stora Journalistpriset (Great Journalism Award) in 2010 for Valpejl.se, a website profiling every candidate in that season’s Swedish elections and in 2016 for Innovator of the year. Twitter... Read More →


Saturday May 20, 2017 16:30 - 17:30
C2.21

16:30

Command line tools II
Limited Capacity seats available

Command line tools: So you know what a unix command is? Time to kick it up a notch and super charge your data wrangling using powerful tools like csvkit and csvcat. We'll teach you how to merge, explore, filter and analyse large data sets from the command line. No prior programming knowledge required. Only 25 people allowed in, first come first serve. NOTE: It's a bring your own laptop session (Mac or Linux based) or else just watch along.

Speakers
avatar for Karrie Kehoe

Karrie Kehoe

Data Journalist, RTÉ Investigations Unit
Karrie Kehoe wrangles data at the RTÉ Investigations Unit. Before RTÉ she worked at The Times, The Sunday Times and the Thomson Reuters Foundation. Karrie has used data analysis to investigate compensation payments in Afghanistan, Court judgements in Ireland and waste and corru... Read More →


Saturday May 20, 2017 16:30 - 17:30
C3.15

16:30

Python III
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Python III - Scraping with Python: Basic scraping
In this tutorial, we will be learn how to scrape (static) websites from the internet.
Requirements: Basic familiarity to Python (at least from Participation in the Python2 Tutorial), a distribution of Python3 and Pip on your computer. Only 25 people allowed in, first come first serve.

Speakers
avatar for Elena Erdmann

Elena Erdmann

Elena is a phd student in Machine Learning at TU Dortmund. Her research interest include automated text analysis and digital humanities. She is excited about data journalism and the way technology is used in the newsroom. Last year, she gathered some experience in journalism as a member of Journocode, a Google News Fellow at Wirtschaftswoche and in a project at... Read More →


Saturday May 20, 2017 16:30 - 17:30
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

16:30

STATS III
Limited Capacity seats available

Statistics III. When many variables may explain something - such as performance in sports or on tests -- a different tool is needed: linear or multiple regression. We cover how to set up and run a regression and how to interpret the results. Familiarity with Excel navigation and formulas; intermediate and advanced statistics. NOTE: We'll be using the Analysis ToolPak in Excel on PCs provided by the venue. You can use your own computer, HOWEVER, be aware that many versions of Excel for Mac do not have the full ToolPak capability. Check your computer before you attend the class by doing the following:

Start Excel for Mac.
Click Tools, and then click Add-Ins.
Click the Data Analysis ToolPak. Then, click OK.
Locate Data Analysis ToolPak on the Data tab.
If it does not install, you can't use ToolPak. Only 25 people allowed in, first come first serve.

Speakers
avatar for Crina Boros

Crina Boros

Investigative & Data Journalist | CAR Trainer, Investigate Europe | Trainer at the Centre for Investigative Journalism (CIJ)
London-based investigative Journalist and CAR trainer at the Centre for Investigative Journalism (CIJ), Crina specialises in data analysis, transparency cross-border and accountability-driven reporting. She currently freelances for Investigate Europe and and mentors at newsPeeks... Read More →


Saturday May 20, 2017 16:30 - 17:30
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

16:30

Messed up Facts - Henk & Paul
Paul Myers and Henk van Ess together face one of their biggest professional challenges: they must answer questions of the audience with a terrible twist.
For each challenge, a "Wheel of Misfortune" will start, crippling their arsenal of research techniques to a minimum. Possible handicaps are that
they can't use Google at all or should be able to answer the question only with punctuation and numbers. Will they survive "Messed up facts"?
And do you have some questions for them? Send them to henkandpaul@journalismfund.eu

Moderators
avatar for Eva Jung

Eva Jung

Investigative Journalist, Berlingske
For six years a member of Danish newspaper Berlingske's investigative team. Board member for Danish Association for Investigative Journalism and Global Investigative Journalism Network. Soon to be Brussels correspondent - would like to partner up for EU-related investigations.

Speakers
avatar for Henk van Ess

Henk van Ess

Investigative Team, Bellingcat UK
Dutch born Henk van Ess is obsessed by finding news in data.  European media houses, like Axel Springer, Persgroep, European Broadcasting Union and Schibsted love his literal and lateral thinking and hire Henk on a regular basis to spill his secrets. He rarely appears in public conferences, so this is your chance to find out the best tricks in internet research... Read More →
avatar for Paul Myers

Paul Myers

Internet research specialist, BBC
Met Paul Myers keert een oude bekende naar de conferentie terug. Al bijna twee decennia is hij een toonaangevende online search specialist.  Hij werkt voor de BBC als onderzoeksjournalist en geeft daarnaast trainingen over onder andere online research, datajournalistiek en omgaan met bewijs aan mensen van onder meer The Guardian, the Times en CNN. Hij blogt... Read More →


Saturday May 20, 2017 16:30 - 17:30
Auditorium 1 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

16:30

Protect privacy - anonymize your data II
Networking - Work in data anonymization is still driven mostly from academia. Besides there being a lack of established tooling, there is also a lack of standards for how people in practice do data anonymization. Aim of this session is to bring people together that, for example:

• Have already run into this issue in their journalistic work and can share their experiences
• Want to form a network of journalists and data experts they can work together with if they run into data anonymization issues
• Have interest in working together more closely to establish a set of best practices for data anonymization.

Speakers
avatar for Katharina Rasch

Katharina Rasch

Data scientist


Saturday May 20, 2017 16:30 - 17:30
C2.25

16:30

AI manipulation - how to trace it?
Advances in the field of artificial intelligence (AI) are fast-paced. Through "machine learning" software can manipulate TV pictures like changing mouth movements of politicians, etc., in near real-time. In this talk, the focus is on what is nowadays possible in the digital field of manipulation through AI of text, data, (moving) images and audio material. How can such manipulations be identified in investigations and which counter-strategies are conceivable? Example: http://www.theverge.com/2016/12/20/14022958/ai-image-manipulation-creation-fakes-audio-video

Speakers
avatar for Lorenz Matzat

Lorenz Matzat

Journalist, AlgorithmWatch
Lorenz Matzat is a journalist and entrepreneur in Berlin. He is co-founder of AlgorithmWatch, a non-profit initiative to evaluate and shed light on algorithmic decision making processes that have a social relevance, meaning they are used either to predict or prescribe human actio... Read More →


Saturday May 20, 2017 16:30 - 17:30
C1.25 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

17:40

Open Refine
Speakers
avatar for Ruben Verborgh

Ruben Verborgh

Semantic Hypermedia Researcher, UGent
I’m a researcher in semantic hypermedia at IDLab, a group of Ghent University/imec, and a postdoctoral fellow of the Research Foundation Flanders. I love to discuss about the Semantic Web, hypermedia clients, Web APIs, Linked Data, Web architecture, and much more. If you like these things too, then... Read More →


Saturday May 20, 2017 17:40 - 18:40
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

17:40

Python IV
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Python IV - Scraping with Python: Advanced scraping
We'll see how we can scrape websites, despite lazy loading and load text from (machine-readable) PDF files.
Requirements: Basic familiarity to Python and Scraping (at least from Participation in the Python2 and 3 Tutorial), a distribution of Python3 and Pip on your computer. - Only 25 people allowed in, first come first serve.

Speakers
avatar for Elena Erdmann

Elena Erdmann

Elena is a phd student in Machine Learning at TU Dortmund. Her research interest include automated text analysis and digital humanities. She is excited about data journalism and the way technology is used in the newsroom. Last year, she gathered some experience in journalism as a member of Journocode, a Google News Fellow at Wirtschaftswoche and in a project at... Read More →


Saturday May 20, 2017 17:40 - 18:40
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

17:40

Text mining
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Text mining.

Speakers
avatar for Friedrich Lindenberg

Friedrich Lindenberg

Tech Coordinator, OCCRP
Friedrich Lindenberg is a coder and data journalist working on web technology for new narrative and investigative techniques. He was an 2014 ICFJ Knight International Journalism Fellow with Code for Africa, and a 2013 Knight-Mozilla OpenNews Fellow at Spiegel Online. Previously... Read More →


Saturday May 20, 2017 17:40 - 18:40
C3.15
 
Sunday, May 21
 

09:30

Cross-border collaboration as a safety net for journalists under pressure?
Working in a team across borders means you have frequent contact with journalists in other countries. If one team member gets under pressure in his or her country, the others will be aware of it swiftly. And if one team member is not able to publish, the publication may be possible in other countries. Presentation of cases and discussion about the security aspects of crossborder collaborations. This session is sponsored by the European Centre for Press and Media Freedom and organised by Journalismfund.eu

Speakers
avatar for Zeynep Sentek

Zeynep Sentek

Journalist, The Black Sea (theblacksea.eu)
Journalist specialising in investigations, human rights, workers' rights, and military issues. Doctoral researcher at Heidelberg University. | | Works freelance and also coordinates The Black Sea's Turkey investigations, and is part of the European Investigative Collabora... Read More →
avatar for Blaz Zgaga

Blaz Zgaga

freelance investigative journalist
Blaž Zgaga is a freelance investigative journalist living in Slovenia and is co-author of the trilogy In the Name of the State, which explores arms smuggling in the Balkans during the conflicts of the 1990s. After disclosure of a US DIA secret operation in 2000, he was prosecute... Read More →


Sunday May 21, 2017 09:30 - 10:30
Auditorium 2 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

09:30

The Russian Laundromat - an extensive cross-border project
20 billion dirty dollars from Russia. 21 British shell companies. 15 judges awaiting trial in Moldova. 70.000 bank transfers to countries all over the world. Reporters in 30 countries working together to analyze the data. The Russian Laundromat made headlines in media all over the world in March. Learn about the methods and obstacles of this cross border cooperation.

Speakers
avatar for Sarunas Cerniauskas

Sarunas Cerniauskas

Editor at the Investigative Journalism Department, 15min.lt
One of the leading investigative journalists in Lithuanian, specializing in politics, corruption and data journalism. Awarded for pieces that disclosed major corruption and fraud cases. Former politics' reporter at delfi.lt, currently - head of the Investigative Journalism Depart... Read More →
avatar for Sylke Gruhnwald

Sylke Gruhnwald

Chairwoman and journalist, Journalismfund.eu
Sylke Gruhnwald is chairwoman of Journalismfund.eu and investigative reporter with the Swiss magazine «Beobachter». Studies of Sinology and Business Administration. Worked for «The Economist Group», its «Economist Intelligence Unit» as well as the Swiss daily newspaper «Neue Zürcher Zeitung» and the Swiss public broadcaster «Schweizer Radio und Fernsehen». sgr. is co-founder of... Read More →
avatar for Eva Jung

Eva Jung

Investigative Journalist, Berlingske
For six years a member of Danish newspaper Berlingske's investigative team. Board member for Danish Association for Investigative Journalism and Global Investigative Journalism Network. Soon to be Brussels correspondent - would like to partner up for EU-related investigations.
avatar for Friedrich Lindenberg

Friedrich Lindenberg

Tech Coordinator, OCCRP
Friedrich Lindenberg is a coder and data journalist working on web technology for new narrative and investigative techniques. He was an 2014 ICFJ Knight International Journalism Fellow with Code for Africa, and a 2013 Knight-Mozilla OpenNews Fellow at Spiegel Online. Previously... Read More →


Sunday May 21, 2017 09:30 - 10:30
C2.01 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

09:30

How to deal with mail leaks
In this workshop, we're going to explore different ways to get the most out of emails. Using Refine, Gephi and R, the goal would be to figure out the network behind the mailbox and gather some stats about the senders in order to analyze them and potentially visualize most interesting findings. With examples from the recent leaks during the presidential campaign. Only 25 people allowed in, first come first serve.

Speakers
avatar for Alexandre Léchenet

Alexandre Léchenet

Data Journalist
Journaliste spécialisé dans l'analyse de données, la réflexion sur de nouveaux formats ainsi que sur les sciences, les données personnelles et les nouvelles technologies de l'information et de la communication (réseaux sociaux, données personnelles, données publiques... Read More →


Sunday May 21, 2017 09:30 - 10:30
Auditorium 1 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

09:30

Tracking unofficial lobbying in public data. The case of Poland
The editorial team of MamPrawoWiedziec.pl for the last 5 years has been publishing articles on Polish parliamentarians and their activities. Currently we are the most reliable source on the Polish parliamentary data. Our research and analyses have led us to discover a new relevant topic which we can investigate in the public data. We called it “grey” or “shadow lobbying”. Although in Poland there is an act regulating the issue of lobbying, only a part of the lobbyists are obliged to register officially. These are professional companies representing other entities. Trade unions, NGOs or other companies do not have to register. However, they play an important role in creating the law - they are the shadow lobbyists. At the moment we have at our disposal many html, csv and pdf files containing information about the lobbyists’ activities, especially taking place in the parliament (committee sessions, opinions, legislation projects). Their shortcoming is high dispersion rendering it difficult to efficiently juxtapose and analyse them. In order to facilitate monitoring the activities of particular lobbyists, both official and shadow, it is necessary to link and map the data. No medium has undertaken such an action, and the data concerning lobbying are rarely used by editorial boards. Journalists take up the issue of lobbying on particular examples, but there is no full, systematic information allowing for tracking all the groups of interest acting in the government and in the parliament. We believe that using this data is essential for tracking and analysing lobbying activities. That is why are developing a methodology and have already prepared two analyses based on some of the available data. During the presentation in Mechelen we would like to present the results of our research and introduce the audience to a project of a new IT tool for readers and journalists which we plan to create. We realise that the problem of untransparent lobbying is a case not only in Poland but in all CEE countries. We hope to share our methodology, experience and ideas with journalists and data activists from other European countries.

Speakers
avatar for Magdalena Wnuk

Magdalena Wnuk

Senior Analyst, Art 61


Sunday May 21, 2017 09:30 - 10:30
C2.21

09:30

Graph Databases I
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

"Graph Databases: 1 In data journalism, we tend to use relational databases - data in table form - using tools such as Excel or SQL to do our analysis and find stories. Graph databases are different, but are incredibly useful to find connections or patterns within our data that would be difficult, if not impossible, to spot using a relational database. Often we are interested in the relationships between people, organisations and other networks such as the recent Panama Papers investigations.
The session will provide a hands-on introduction to Neo4j, the most commonly used graph software. We will build a graph database of public procurement deals listed in the Europe-wide TED database and match them with corporate information to enable us to see at a glance who is behind them. - Leila Haddou, Max Harlow, Adrian Blanco
Only 25 people allowed in, first come first serve.

Speakers
avatar for Adrian Blanco

Adrian Blanco

Data Journalist, El Confidencial
Adrian Blanco is a Spanish data journalist currently working at El Confidencial.Data stuff, visualizations, reporting and a bit of coding. He runs Journocoders Madrid. | | He was part of the project "The right to be forgotten", funded by Journalismfund.eu... Read More →
avatar for Leila Haddou

Leila Haddou

Data Journalist, Financial Times
Freelance investigative and data journalist currently working at the Financial Times. I have previously worked for the Guardian on the Datablog and data-led investigations covering offshore tax leaks, corporate land banking and issues surrounding social justice. Skilled in using advanced internet research, public records, data analysis and freedom of information regulations to research and produce original, public interest stories.A founding member and co-organiser of... Read More →
avatar for Max Harlow

Max Harlow

Software Developer, Ordnance Survey
Max Harlow is a software developer who has worked with journalists on investigations at the Guardian and at the Bureau of Investigative Journalism. He currently works with geographical data at Ordnance Survey and co-organises Journocoders, a meetup for journalists interested in c... Read More →


Sunday May 21, 2017 09:30 - 10:30
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

09:30

'Fake news' and fact-checking
Networking Round Table on Fact Checking - Let's come together and exchange our experiences from different European countries: The main topics of this networking round table on fact checking and "fake news" should be:
- which teams or organizations on fact checking are working in Europe?
- which tools and methods are evidently helpful for our job?
- what is already automatized or may be automatizable?
Of course, other topics are welcome.


Speakers
avatar for Marta Orosz

Marta Orosz

Reporter, CORRECTIV
Marta Orosz works as a reporter for the Berlin-based investigative newsroom Correctiv.org. She has been engaged in long-term investigations on TTIP and on the far-right group Pegida. As a Germany correspondent for Hungarian media, her other focus is politics and economy in Easter... Read More →
avatar for Albrecht Ude

Albrecht Ude

Journalist, Researcher, Recherche-Trainer
Albrecht Ude is based in Berlin (Germany) and Friesland, | works as freelancing journalist, researcher and research-trainer (online-researches, source checking, fact checking and security issues). | writes for several newspapers and magazines, print and online. | focusses on structured internet researches, privacy and security, censorship and civil rights in the digital world. | teaches at journalist’s academies, publishing companies and broadcasting stations inhouse, also at universities. | engages as editor in chief of the newsletter of the German investigative journalists association “netzwerk recherche”. | | Homepage at... Read More →


Sunday May 21, 2017 09:30 - 10:30
C2.25

09:30

SubsidyStories.eu: the European Structural Investment Funds uncovered I
Follow the money: Close to 500 billion of EU subsidies flow back into the member states through a complex system of subsidies, grants and regional funds. Information on who receives these funds is scattered over a web of regional and national data portals.Up to now, we could not compare projects and spending across member states and regions. Subsidystories has changed that. We brought the data from the regional and national EU funding portal together in one place. We standardize it so that it can be made comparable, visualized and analyzed. In this presentation, we will show how we have traced the EU funds and give the audience insights in the data and start the conversation on how to uncover stories in the data, and hear different local and national angles to the leads and stories that we have found so far. This project was started last year at the hackday of DataHarvest and in February of this year we finally had the data together and launched in March. We will also address with the audience how we - as an Open Data NGO - tried to cater to journalists and worked with freelancers and volunteers throughout the project. We struggled with open data vs. embargoed data and eventually decided to set up a group of hunch hunters to work with the data in the open, but try to find exclusive stories. In the session we will first demonstrate the platform, discuss the data, the process and our findings. We will ask the audience for their local or national angle on the stories and leads that we have found so far. In the second part, we will discuss how we can better cater to journalists in the future, if volunteers and hunch hunters work, and how to balance open data and exclusivity. NOTE: THIS PRESENTATION IS FOLLOWED BY A HANDS-ON WORKSHOP AND NETWORKING ROUND TABLE FOR THOSE WHO WANT TO DIG INTO THE DATA IMMEDIATELY AND MAYBE FORM TEAMS OF JOURNALISTS.

Speakers
avatar for Anna Alberts

Anna Alberts

Project Manager, OKFDE
OKFDE, Open Data, OpenBudgets.EU, Financial Transparency, subsidystories.eu, ESIF, EU Transparency
avatar for Christian Jørgensen

Christian Jørgensen

Photojournalist, EUP-Berlin GbR
Christian Jørgensen is a photo journalist from Denmark with base in Berlin, who with Follow the Subsidies www.followthesubsidies.eu has been working on collecting and publishing all EU-Subsidies since april 2016 and now together with the Hungarian programmer Balazs Kirch tries t... Read More →
avatar for Michael Peters

Michael Peters

Data Scientist, OKF Germany
Michael joined OKF Germany as Data Scientist for the projects: EU Subsidy Stories, OpenBudgets.eu and OffenerHaushalt.de. He studied Public Economics and advocates Transparency of Fiscal Data. His main tasks are Data Mining and Data Analysis.


Sunday May 21, 2017 09:30 - 10:30
C2.23 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

09:30

FOI / Wobbing Lightning examples
Bring your best (or worst) experiences with using freedom of information legislation and share a five minutes presentation. Pitch your presentation here https://docs.google.com/forms/d/e/1FAIpQLScD62ACBAsKLisubzlr__TKlDWjnhggV9u4U3QLeg_7-XZCHA/viewform?c=0&w=1

Speakers
avatar for Tania Röttger

Tania Röttger

Reporterin, Correctiv
Tania Röttger studierte Sozial-, Rechts- und Wirtschaftswissenschaften in London und Berlin und arbeitete danach in einem Londoner Recherchebüro, wo sie die Auskunftsrechte als Instrument investigativer Recherche kennenlernte.Tanja Röttger arbeitet als Journalistin des gemeinnützigen Recherche-Zentrums... Read More →


Sunday May 21, 2017 09:30 - 10:30
C2.30

10:30

Coffee
Sunday May 21, 2017 10:30 - 10:45
Cafeteria

10:45

Who lobbies the EU? Using the databases / Hands-on
Get your hands on the EU databases on lobbyism in the EU. The European Commission provides a transparency register https://ec.europa.eu/info/about-european-union/principles-and-values/transparency/transparency-register_en, the NGO Transparency International provides the Integrity Watch database http://www.integritywatch.eu/, and Brussels lobbywatcher NGOs offer the https://lobbyfacts.eu/ based upon the EUs own data. IF YOU'RE INTERESTED IN THIS TOPIC PLEASE NOTE THAT THE SPEAKERS ALSO WILL PROVIDE MORE GENERAL INFO ABOUT THE DATA BEFORE THIS WORKSHOP.

Speakers
avatar for Theresa Crysmann

Theresa Crysmann

Media Officer, Corporate Europe Observatory
Corporate Europe Observatory is a Brussels-based NGO which exposes and challenges the corporate capture of EU policy-making.
avatar for Raphaël Kergueno

Raphaël Kergueno

Policy officer, Transparency International EU


Sunday May 21, 2017 10:45 - 11:45
C2.21

10:45

Graph Databases II
Limited Capacity filling up

Graph Databases 2: Having built our database in part one, this session will focus on the querying the data. We will cover how to do basic and fuzzy searches, and how you can build up to more complicated queries to find stories. - Only 25 people allowed in, first come first serve.

Speakers
avatar for Adrian Blanco

Adrian Blanco

Data Journalist, El Confidencial
Adrian Blanco is a Spanish data journalist currently working at El Confidencial.Data stuff, visualizations, reporting and a bit of coding. He runs Journocoders Madrid. | | He was part of the project "The right to be forgotten", funded by Journalismfund.eu... Read More →
avatar for Leila Haddou

Leila Haddou

Data Journalist, Financial Times
Freelance investigative and data journalist currently working at the Financial Times. I have previously worked for the Guardian on the Datablog and data-led investigations covering offshore tax leaks, corporate land banking and issues surrounding social justice. Skilled in using advanced internet research, public records, data analysis and freedom of information regulations to research and produce original, public interest stories.A founding member and co-organiser of... Read More →
avatar for Max Harlow

Max Harlow

Software Developer, Ordnance Survey
Max Harlow is a software developer who has worked with journalists on investigations at the Guardian and at the Bureau of Investigative Journalism. He currently works with geographical data at Ordnance Survey and co-organises Journocoders, a meetup for journalists interested in c... Read More →


Sunday May 21, 2017 10:45 - 11:45
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

10:45

Python V
Limited Capacity filling up

Python 5 - Advanced workshop: Linking, normalising and de-duplicating large data in Python and SQL to generate leads. And CorpInt, a toolkit for building corporate network graphs from data in Python.

Speakers
avatar for Friedrich Lindenberg

Friedrich Lindenberg

Tech Coordinator, OCCRP
Friedrich Lindenberg is a coder and data journalist working on web technology for new narrative and investigative techniques. He was an 2014 ICFJ Knight International Journalism Fellow with Code for Africa, and a 2013 Knight-Mozilla OpenNews Fellow at Spiegel Online. Previously... Read More →


Sunday May 21, 2017 10:45 - 11:45
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

10:45

How we will make a living from our work. New kinds of watchdog media.
We've seen interest organisations using journalistic methods. We've even seen interest organisations declaring their research to be journalism. But what about credibility, when information is provided by one party in a case? What about editorial independence? Meet Mark Hunter – American/French former journalist turned scholar and author present the findings of his recently published a book about the subject.

Moderators
avatar for Ides Debruyne

Ides Debruyne

Managing Director, Journalismfund.eu vzw
Ides Debruyne is co-founder of Journalismfund.eu vzw (formerly known as the Belgian Pascal Decroos Fund for Investigative Journalism) and the Dutch-Flemish Association of Investigative Journalists (VVOJ). He is managing director of Journalismfund.eu. Debruyne is co-organizer of the... Read More →

Speakers
avatar for Mark Hunter

Mark Hunter

Founding member, Story-Based Inquiry Associates
Mark Lee Hunter is onderzoeksjournalist en docent. Samen met collega’s van business school Insead onderzocht hij de recente successen van zogenaamde ‘stakeholder media’. Hij is medeoprichter van The Stakeholder Media Project en co-auteur van “Power Is Everywhere: How stak... Read More →



Sunday May 21, 2017 10:45 - 11:45
Auditorium 1 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

10:45

How to validate stuff
Henk van Ess goes Fast and Furious with stuff that seems impossible to validate. In this anthology of his work with European media and Bellingcat, Henk will share the power of logical thinking. Who is behind the mysterious note of an IS-warrior? What is the full name of that completely anonymous Youtuber? That Egyptian missile launcher lying in the dump, is it real? What is the secret address of the CEO of Novartis? What is the telephone number of a guy that really doesn't want to be found? Experience some amazing Houdini-acts, inspired by harsh deadlines. When you're done with this Sunday morning session, you leave with 10 tips to validate stuff. Any stuff.

Speakers
avatar for Henk van Ess

Henk van Ess

Investigative Team, Bellingcat UK
Dutch born Henk van Ess is obsessed by finding news in data.  European media houses, like Axel Springer, Persgroep, European Broadcasting Union and Schibsted love his literal and lateral thinking and hire Henk on a regular basis to spill his secrets. He rarely appears in public conferences, so this is your chance to find out the best tricks in internet research... Read More →


Sunday May 21, 2017 10:45 - 11:45
Auditorium 2 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

10:45

Following EU Money Through Hungary
Hungarian journalists have a special knack for following EU money – hear about their tools and methods. Investigative center Átlátszó has built a data-based map of EU funds for tracking corruption, wrongdoings and misuse of European public money, while Direct36 followed EU money through data and on the road to disclose prime minister Orbán family's hidden involvement in public projects.

Speakers
avatar for Tamás Bodoky

Tamás Bodoky

Executive director, Atlatszo.hu
Tamás Bodoky is an investigative journalist and editor, and nonprofit executive based in Budapest, Hungary. Bodoky has been a journalist since 1996: before joining Index.hu, where he spent 9 years in different journalistic and editorial positions, he was science and technology j... Read More →
avatar for Attila Bátorfy

Attila Bátorfy

journalist/research fellow, Átlátszó.hu
Journalist at Átlátszó.hu, research fellow at CEU Center for Media, Data and Society.
avatar for Andras Petho

Andras Petho

co-founder / editor, Direkt36
Co-founder of @direkt36, an investigative center in Hungary. Previously @bbcworldservice and @washingtonpost... Read More →
avatar for Blanka Zöldi

Blanka Zöldi

journalist, Direkt36
Journalist at Direkt36 investigative journalism centre in Hungary.


Sunday May 21, 2017 10:45 - 11:45
C2.30

10:45

SubsidyStories.eu: the European Structural Investment Funds uncovered II
Follow the money - hands-on workshop – finding your way through the data. In the hands-on session we will use the subsidy-story dataset to show how to start finding stories from a dataset that is over 2 million lines big. Participants will learn about the dataset itself, as well as acquire skills to quickly get to know a dataset that is beyond the size of a normal spreadsheet program, running basic statistics and validation strategies that we used. We will first demonstrate the work we did on the hack day for inspiration. This will show what tools can be used to work through a 2 million-line datasets, such as jupiter notebooks, SQL, and the Open Spending toolbox. Starting with the OpenSpending toolbox, we provide a guided tour through the data, adding different filters and answering simple questions by trying different visualisations, and sorting options. In the second part, we already go into advanced mode and take the participants through the SQL-data-miner that is linked to the Open Spending repository and runs on our datasets. We will run basic statistics and some tailored queries together to show how to easily get to know a dataset of this size. Finally, we show how we validated our dataset, walking the participants through different validation strategies we used from comparing it to raw data, to making sure certain variables are always present etc.

Speakers
avatar for Anna Alberts

Anna Alberts

Project Manager, OKFDE
OKFDE, Open Data, OpenBudgets.EU, Financial Transparency, subsidystories.eu, ESIF, EU Transparency
avatar for Adrian Blanco

Adrian Blanco

Data Journalist, El Confidencial
Adrian Blanco is a Spanish data journalist currently working at El Confidencial.Data stuff, visualizations, reporting and a bit of coding. He runs Journocoders Madrid. | | He was part of the project "The right to be forgotten", funded by Journalismfund.eu... Read More →
avatar for Christian Jørgensen

Christian Jørgensen

Photojournalist, EUP-Berlin GbR
Christian Jørgensen is a photo journalist from Denmark with base in Berlin, who with Follow the Subsidies www.followthesubsidies.eu has been working on collecting and publishing all EU-Subsidies since april 2016 and now together with the Hungarian programmer Balazs Kirch tries t... Read More →
avatar for Michael Peters

Michael Peters

Data Scientist, OKF Germany
Michael joined OKF Germany as Data Scientist for the projects: EU Subsidy Stories, OpenBudgets.eu and OffenerHaushalt.de. He studied Public Economics and advocates Transparency of Fiscal Data. His main tasks are Data Mining and Data Analysis.
avatar for Marta Rey

Marta Rey

Freelance journalist
I am a freelance journalist and Digital Marketing specialist. Currently, I am a distance student of Data Driven Journalism Postgraduate at the University of Vic. I am a data analyst volunteer for the Open Knowledge Foundation Germany for the Subsidy Stories project.


Sunday May 21, 2017 10:45 - 11:45
C2.23 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

12:00

Lobbying round table
Lobbying in Europe happens in Brussels and in national capitals. Meet some of the people monitoring the data and find potential colleagues to work with.

Speakers
avatar for Theresa Crysmann

Theresa Crysmann

Media Officer, Corporate Europe Observatory
Corporate Europe Observatory is a Brussels-based NGO which exposes and challenges the corporate capture of EU policy-making.
avatar for Raphaël Kergueno

Raphaël Kergueno

Policy officer, Transparency International EU
avatar for Magdalena Wnuk

Magdalena Wnuk

Senior Analyst, Art 61


Sunday May 21, 2017 12:00 - 13:00
C2.21

12:00

How to pitch a story and get a grant
Do you want to apply for a cross-border grant? Get tips and tricks from Journalismfun.eu's Marjorie Blomme and Trine Smistrup.

Speakers
avatar for Marjorie Blomme

Marjorie Blomme

Editorial Co-ordinator, Journalismfund.eu
Marjorie Blomme is Journalismfund.eu's editorial co-ordinator for the Connecting Continents grant programme. She answers questions regarding the grants and is in charge of preparing the applications for the jury and following up on the ongoing investigations. | | Marjorie is bas... Read More →
avatar for Trine Smistrup

Trine Smistrup

Journalist, editorial coordinator, Journalismfund.eu
Editorial coordinator for Journalismfund.eu, grant programs and planning committee for EIJC/Dataharvest. Webmaster for SCOOP International and volunteer in SCOOP Russia. Danish freelance journalist, editor and trainer.


Sunday May 21, 2017 12:00 - 13:00
Auditorium 2 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

12:45

Building virtual reality charts
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Building VR charts: An introduction to how 3D graphics and virtual reality can be used to tell stories. We will be learning how to build a virtual reality chart similar to the 3D Nasdaq rollercoaster experience produced by the Wall Street Journal in 2015, but the underlying technology is the same as what was used to create completely different interactives, such as the Guardian’s solitary confinement simulation 6x9. (Original tutorial: http://www.storybench.org/how-to-make-a-simple-virtual-reality-data-visualization/) - Leila Haddou, Max Harlow, Adrian Blanco -Only 25 people allowed in, first come first serve.

Speakers
avatar for Adrian Blanco

Adrian Blanco

Data Journalist, El Confidencial
Adrian Blanco is a Spanish data journalist currently working at El Confidencial.Data stuff, visualizations, reporting and a bit of coding. He runs Journocoders Madrid. | | He was part of the project "The right to be forgotten", funded by Journalismfund.eu... Read More →
avatar for Leila Haddou

Leila Haddou

Data Journalist, Financial Times
Freelance investigative and data journalist currently working at the Financial Times. I have previously worked for the Guardian on the Datablog and data-led investigations covering offshore tax leaks, corporate land banking and issues surrounding social justice. Skilled in using advanced internet research, public records, data analysis and freedom of information regulations to research and produce original, public interest stories.A founding member and co-organiser of... Read More →
avatar for Max Harlow

Max Harlow

Software Developer, Ordnance Survey
Max Harlow is a software developer who has worked with journalists on investigations at the Guardian and at the Bureau of Investigative Journalism. He currently works with geographical data at Ordnance Survey and co-organises Journocoders, a meetup for journalists interested in c... Read More →


Sunday May 21, 2017 12:45 - 13:45
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM