Loading…
This event has ended. Visit the official site or create your own event on Sched.
Join us for four days of inspiration, learning and networking!
Thursday, June 1
 

09:30 CEST

Check-in and Coffee
Thursday June 1, 2023 09:30 - 10:00 CEST
Cafeteria

10:00 CEST

Hackday [Hackday ticket needed]
One Union, Diverse Realities: Mapping Work and Wage Inequalities across Europe

This hackday is your opportunity to explore a wealth of data from Eurostat, and combine it with the microdata from the latest Eurofound survey on working conditions in 37 countries across Europe.

At the hackday, we will try to uncover the stark disparities present within European countries through the data ranging from workplace violence and pay gaps, to severe work accidents. We'll also dive into the exercise of mapping and visualizing these inequalities. In this way, we hope to gain a more comprehensive understanding of the challenges faced by employees throughout Europe.

Do you want to access and work with microdata on working conditions across Europe, and discuss your findings with fellow journalists and techies? If so, join us for the Dataharvest 2023 Hackday! You can take a look at the data already, then all you need to bring is your laptop.

Thursday June 1, 2023 10:00 - 12:00 CEST
C3.19

10:00 CEST

Masterclass: Investigating corporate lobbying [Masterclass ticket needed]
For decades, companies that produce petrochemicals, pesticides, processed food, or alcohol, have been customising tactics from the so-called “Tobacco playbook” to keep their harmful products on the market, delay regulation and prevent major changes in our production systems. In this masterclass, you will learn the darkest secrets of what should now be called the “Corporate Disinformation Playbook” and how to explore and expose those tactics.

A separate ticket is required to attend a masterclass. If you would like to attend but haven't yet purchased a ticket, please contact us at media@journalismarena.eu

Speakers
avatar for Stéphane Horel

Stéphane Horel

Journalist, Le Monde
Stéphane Horel works as an investigative journalist for Le Monde. She specializes in corporate lobbying and harm, toxic industries, conflict of interest and scientific disinformation. In early 2023, she supervised the European map of PFAS contamination of the "Forever Pollution Project... Read More →


Thursday June 1, 2023 10:00 - 12:00 CEST
C3.03

10:00 CEST

Masterclass: Planning and coordinating cross-border investigations [Masterclass ticket needed]
Today, reporting on the most important topics – from the pandemic to finance and almost everything else – requires data skills and cross-border collaboration. Launching a cross-border investigation can be daunting: setting up the appropriate team, dealing with media outlets in different countries, deciding on methodologies, getting the funding, coordinating the project… Not to mention getting or building the required datasets, and working on the data analysis and visualisations. But it can be done, and this master class will help you get started.

In this masterclass, we'll use as an example a topic that could realistically lead to a cross-border project. We'll use a potential investigation into labour issues to walk the required practical steps to plan, launch and coordinate such a cross-border project, including the data work that would need to be done. The masterclass aims to be practical and similar to a series of editorial meetings in which teams of journalists are planning an actual investigation.
 
The masterclass will start with two more general sessions:
  • General considerations when planning a cross-border investigation
  • General considerations when planning cross-border data work
And then it will continue with four practical sessions, in which we'll use a potential investigation into labour issues as an example. During these sessions, participants in the masterclass will also work in small groups to start designing their own potential cross-border investigation:
  • From preliminary research to investigative hypotheses and questions.
  • Designing and managing a cross-border investigation
  • How to go about the data and visualisation
  • Going beyond the data to report human stories
Participants will be able to download and keep the materials used during the masterclass, which may function as guides and checklists when planning an investigation, and which include a bibliography to find additional content about planning and managing cross-border investigations.

A separate ticket is required to attend a masterclass. If you would like to attend but haven't yet purchased a ticket, please contact us at media@journalismarena.eu

Speakers
avatar for Jose Miguel Calatayud

Jose Miguel Calatayud

Freelance journalist and writer
I am a freelance journalist and writer based in Berlin since January 2020, currently focusing on feature writing and investigative journalism, mainly about Europe. I am the co-initiator and the coordinator of the cross-border project Cities for Rent: Investigating Corporate Landl... Read More →
avatar for Sotiris Sideris

Sotiris Sideris

Data Editor, Reporters United, CCIJ
Sotiris Sideris is a data journalist, trainer, and project manager with extensive cross-border and collaborative experience.He is the data editor of Reporters United and the Center for Collaborative Investigative Journalism (CCIJ), and co-founder of AthensLive. He also serves as a... Read More →


Thursday June 1, 2023 10:00 - 12:00 CEST
C2.07

10:00 CEST

Masterclass: Researching the EU [Masterclass ticket needed]
How do you find out how your country's politicians act in Brussels, and hold them accountable for what they do? How did your MEPs vote? How did your government act in the Council? And how do you follow a national story that leads to the EU? In this masterclass, you will learn how the EU system works and how to research EU institutions.

A separate ticket is required to attend a masterclass. If you would like to attend but haven't yet purchased a ticket, please contact us at media@journalismarena.eu

Speakers
avatar for Sigrid Melchior

Sigrid Melchior

freelance journalist
Swedish journalist based in Brussels since forever it feels like. Reports on EU and European affairs, teaches EU journalism, does investigations with the European network http://investigate-europe.eu and has a gossipy bi-weekly podcast: https://brysselbubblan.libsyn.com... Read More →


Thursday June 1, 2023 10:00 - 12:00 CEST
C3.05

12:00 CEST

Lunch
Thursday June 1, 2023 12:00 - 13:00 CEST
Cafeteria

13:00 CEST

Hackday [Hackday ticket needed]
"One Union, Diverse Realities: Mapping Work and Wage Inequalities across Europe"

This hackday is your opportunity to explore a wealth of data from Eurostat, and combine it with the microdata from the latest Eurofound survey on working conditions in 37 countries across Europe.

At the hackday, we will try to uncover the stark disparities present within European countries through the data ranging from workplace violence and pay gaps, to severe work accidents. We'll also dive into the exercise of mapping and visualizing these inequalities. In this way, we hope to gain a more comprehensive understanding of the challenges faced by employees throughout Europe.

Do you want to access and work with microdata on working conditions across Europe, and discuss your findings with fellow journalists and techies? If so, join us for the Dataharvest 2023 Hackday! All you need to do is to bring is your laptop.

Thursday June 1, 2023 13:00 - 17:00 CEST
C3.19

13:00 CEST

Masterclass: Investigating corporate lobbying [Masterclass ticket needed]
For decades, companies that produce petrochemicals, pesticides, processed food, or alcohol have been customising tactics from the so-called “Tobacco playbook” to keep their harmful products on the market, delay regulation and prevent major changes in our production systems. In this masterclass, you will learn the darkest secrets of what should now be called the “Corporate Disinformation Playbook” and how to explore and expose those tactics.

A separate ticket is required to attend a masterclass. If you would like to attend but haven't yet purchased a ticket, please contact us at media@journalismarena.eu

Speakers
avatar for Stéphane Horel

Stéphane Horel

Journalist, Le Monde
Stéphane Horel works as an investigative journalist for Le Monde. She specializes in corporate lobbying and harm, toxic industries, conflict of interest and scientific disinformation. In early 2023, she supervised the European map of PFAS contamination of the "Forever Pollution Project... Read More →


Thursday June 1, 2023 13:00 - 17:00 CEST
C3.03

13:00 CEST

Masterclass: Planning and coordinating cross-border investigations [Masterclass ticket needed]
Today, reporting on the most important topics – from the pandemic to finance and almost everything else – requires data skills and cross-border collaboration. Launching a cross-border investigation can be daunting: setting up the appropriate team, dealing with media outlets in different countries, deciding on methodologies, getting the funding, coordinating the project… Not to mention getting or building the required datasets, and working on the data analysis and visualisations. But it can be done, and this master class will help you get started.

In this masterclass, we'll use as an example a topic that could realistically lead to a cross-border project. We'll use a potential investigation into labour issues to walk the required practical steps to plan, launch and coordinate such a cross-border project, including the data work that would need to be done. The masterclass aims to be practical and similar to a series of editorial meetings in which teams of journalists are planning an actual investigation.
 
The masterclass will start with two more general sessions:
  • General considerations when planning a cross-border investigation
  • General considerations when planning cross-border data work
And then it will continue with four practical sessions, in which we'll use a potential investigation into labour issues as an example. During these sessions, participants in the masterclass will also work in small groups to start designing their own potential cross-border investigation:
  • From preliminary research to investigative hypotheses and questions.
  • Designing and managing a cross-border investigation
  • How to go about the data and visualisation
  • Going beyond the data to report human stories
Participants will be able to download and keep the materials used during the masterclass, which may function as guides and checklists when planning an investigation, and which include a bibliography to find additional content about planning and managing cross-border investigations.

A separate ticket is required to attend a masterclass. If you would like to attend but haven't yet purchased a ticket, please contact us at media@journalismarena.eu

Speakers
avatar for Jose Miguel Calatayud

Jose Miguel Calatayud

Freelance journalist and writer
I am a freelance journalist and writer based in Berlin since January 2020, currently focusing on feature writing and investigative journalism, mainly about Europe. I am the co-initiator and the coordinator of the cross-border project Cities for Rent: Investigating Corporate Landl... Read More →
avatar for Sotiris Sideris

Sotiris Sideris

Data Editor, Reporters United, CCIJ
Sotiris Sideris is a data journalist, trainer, and project manager with extensive cross-border and collaborative experience.He is the data editor of Reporters United and the Center for Collaborative Investigative Journalism (CCIJ), and co-founder of AthensLive. He also serves as a... Read More →


Thursday June 1, 2023 13:00 - 17:00 CEST
C2.07

13:00 CEST

Masterclass: Researching the EU [Masterclass ticket needed]
How do you find out how your country's politicians act in Brussels, and hold them accountable for what they do? How did your MEPs vote? How did your government act in the Council? And how do you follow a national story that leads to the EU? In this masterclass, you will learn how the EU system works and how to research EU institutions.

A separate ticket is required to attend a masterclass. If you would like to attend but haven't yet purchased a ticket, please contact us at media@journalismarena.eu

Speakers
avatar for Sigrid Melchior

Sigrid Melchior

freelance journalist
Swedish journalist based in Brussels since forever it feels like. Reports on EU and European affairs, teaches EU journalism, does investigations with the European network http://investigate-europe.eu and has a gossipy bi-weekly podcast: https://brysselbubblan.libsyn.com... Read More →


Thursday June 1, 2023 13:00 - 17:00 CEST
C3.05
 
Friday, June 2
 

09:00 CEST

Check-in and Coffee
Friday June 2, 2023 09:00 - 10:00 CEST
Cafeteria

10:00 CEST

Opening of the conference (transmitted from Aula 2)
Friday June 2, 2023 10:00 - 10:30 CEST
Aula 1

10:00 CEST

Opening of the conference
Welcome to Mechelen and the 13th Dataharvest conference!
The opening and the keynote speech will be transmitted to Aula 1.

Speakers
avatar for Trine Smistrup

Trine Smistrup

Deputy director, Dataharvest director, Arena for Journalism in Europe
Trine Smistrup is a co-founder of Arena for Journalism in Europe and functions as deputy director and director of Dataharvest - the European Investigative Journalism Conference. She has worked with journalism and training for journalists in Denmark, the Nordic countries, and Russia... Read More →
avatar for Jelena Prtoric

Jelena Prtoric

Journalist, Arena for Journalism in Europe
avatar for Brigitte Alfter

Brigitte Alfter

Director, Arena for Journalism in Europe
Brigitte Alfter ist eine deutsch-dänische Journalistin, Geschäftsführerin für Redaktionelles bei Arena for Journalism in Europe und Dozentin Journalismus an der Universität Göteborg. Nach Jahren als Journalistin auf fallen Niveaus vom Lokaljournalismus bis zur EU-Korrespondentin... Read More →


Friday June 2, 2023 10:00 - 10:30 CEST
Aula 2

10:30 CEST

Networking welcome
Friday June 2, 2023 10:30 - 11:15 CEST
Announced from aula

11:30 CEST

11:30 CEST

Keynote: Why we need to investigate the EU
EU regulations affect all citizens in the EU, often beyond a day-to-day level. There is big money to follow in the EU. So why are we not better at covering the EU, put focus on the power structures, and making them relevant to our users? What are the obstacles? Should we consider new ways of collaborating, reporting or storytelling? How can we as journalists best facilitate the connection between citizens and those working on our regulations? Meet Lise Witteman, initiator of the Brussels office of Follow The Money, and hear why and how she moved to Brussels to report about European affairs.

Will also be transmitted to Aula 1

Speakers
avatar for Brigitte Alfter

Brigitte Alfter

Director, Arena for Journalism in Europe
Brigitte Alfter ist eine deutsch-dänische Journalistin, Geschäftsführerin für Redaktionelles bei Arena for Journalism in Europe und Dozentin Journalismus an der Universität Göteborg. Nach Jahren als Journalistin auf fallen Niveaus vom Lokaljournalismus bis zur EU-Korrespondentin... Read More →
avatar for Lise Witteman

Lise Witteman

investigative journalist EU-topics, Follow the Money
Team lead of the EU desk of investigative journalism platform Follow the Money (ftm.nl/ftm.eu).Our Brussels based team specialises in (data driven) investigations into EU affairs, such as the Recovery Files investigation.In the run up to the European elections of 2024 we have some... Read More →


Friday June 2, 2023 11:30 - 12:00 CEST
Aula 2

12:00 CEST

Lunch
Friday June 2, 2023 12:00 - 13:00 CEST
Cafeteria

13:00 CEST

Farm subsidies - dive into the data, learn who gets the money
The EU hands out more than €50 bn of public funds to the agricultural sector every year. The data on subsidies are publicly available via the EU member states, according to EU law. However, the information is often difficult to access, analyze and compare across borders. The Farmsubsidy.org website contains fresh and searchable data on farm subsidies, obtained from national government agencies. In this session, you will learn:
- how to analyze 16 million recipients of farm subsidies;
- how to crossmatch with other data to find story leaks;
- how to classify types of recipients (person/company/etc.) via trained machine learning models.

Speakers
avatar for Adriana Homolová

Adriana Homolová

ARENA / Follow The Money, Netherlands / Slovakia
Adriana is a freelance data journalist, trainer and public spending nerd. She coordinates the data skills training track on the Dataharvest conference and investigates the European Union for Follow The Money Bureau Brussel.
avatar for Simon Wörpel

Simon Wörpel

Investigative Data Journalist, ||)·|()
Simon Wörpel is an independent investigative data journalist, researcher and leak librarian. He specializes in documents processing, data engineering anddata analysis for journalistic investigations. Simon works for differentnon-profit organizations, newspapers and media outlets... Read More →


Friday June 2, 2023 13:00 - 14:15 CEST
C3.10

13:00 CEST

Working with flexible funding
What do we mean by flexible funding? What does it look like in practice? Flexible funding can come in the form of general support and/or grants at organisational level. We will present both funders' and grantees' perspectives. Moreover, we want to help people think about their fundraising strategy with some practical tips based on our experience.

Moderators
avatar for Peter Matjašič

Peter Matjašič

Executive Director, Investigate Europe
I'm originally from Slovenia and live in Barcelona. I have a background in Political Science/International Relations and have dedicated most of my adult life to activism and civil society engagement. After 12 years of youth work and youth representation (President of the European... Read More →

Speakers
avatar for Timothy Large

Timothy Large

Director of Independent Media Programmes, International Press Institute
Timothy Large is head of independent media programmes at the International Press Institute (IPI) in Vienna. He is an award-winning journalist, editor and media development specialist who runs the Investigative Journalism for Europe (IJ4EU) programme. Every year, IJ4EU provides more... Read More →
avatar for Ebru Akgun

Ebru Akgun

Public Interest Programme Manager, Adessium Foundation
Ebru, currently in the role of Public Interest Programe Manager, joined Adessium Foundation in November 2021. Adessium Foundation is a private and independent grant making foundation, based in the Netherlands. It aspires to a society that encourages people to live in harmony with... Read More →
avatar for Rozina Breen

Rozina Breen

CEO and Editor-in-Chief, The Bureau of Investigative Journalism
My name is RozIna Breen, I’m the CEO and Editor in Chief of The Bureau of Investigative Journalism.Based in the UK, TBIJ’s journalism spans local to global across topics including corruption, climate, democracy and misinformation, plus environment more widely [food, climate finance... Read More →


Friday June 2, 2023 13:00 - 14:15 CEST
C2.25

13:00 CEST

Lessons from difficult FOI processes
Some times filing your FOI requests doesn’t work as it should. Dina Djordjevic (CINS) learnt the hard way in Serbia and wrote a story about the problems. Luisa Izuzquisa (OKnF) filed requests with all countries participating in Frontex. The differences between countries are huge. What can we learn from their experiences?

Speakers
avatar for Tarjei Leer-Salvesen

Tarjei Leer-Salvesen

Freelancer, Freelance
Tarjei Leer-Salvesen spent this year six months at Reuters Institute in Oxford to learn more about the differences between 136 RTI laws in the world, and how journalists can use cross-border filing for information in their investigations.As he also is a well know international working... Read More →
avatar for Luisa Izuzquiza

Luisa Izuzquiza

FragDenStaat
Luisa Izuzquiza is a freedom of information activist based in Brussels, Belgium. Luisa works at FragDenStaat, where she leads the organisation's EU work. Luisa's FOI work has a special focus on EU migration, asylum and border control policies.
avatar for Dina Đorđević

Dina Đorđević

journalist/deputy editor, Center for Investigative Journalism of Serbia (CINS)
Member of Center for Investigative Journalism of Serbia – CINS since 2017. Dina mostly covers topics related to ecology and contributes to multimedia production of CINS with the production of short videos and infographics. In 2019 she won two special prizes for the contribution... Read More →


Friday June 2, 2023 13:00 - 14:15 CEST
C3.05

13:00 CEST

Don't be numbed by numbers
When you work with data, you're going to end up with numbers, totals, percentages and things like that. It's all too easy to numb yourself and your audience. Jonathan Stoneman's session is a light-hearted interactive quiz with some serious lessons. He will explore some of the worst uses of numbers, and how to avoid them. And he invites you to bring your own pet peeves!

Speakers
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)


Friday June 2, 2023 13:00 - 14:15 CEST
Aula 1

13:00 CEST

LobbyFacts - investigating EU lobbying
In the light of the recent Qatargate scandal, transparency in lobbying has never been more important. This session will be a practical introduction to LobbyFacts - the EU lobbying data website. LobbyFacts empowers journalists, activists, and researchers to analyse data from the official EU Transparency Register, tracking lobbyists, their networks, the topics they lobby about, and their influence at the EU level over time. Join lobby watchdog Corporate Europe Observatory for a look at the Brussels Bubble lobby scene and how the available lobby data can help you to nail your stories. This is just one kind of story that this session will help you to develop: https://corporateeurope.org/en/big-toxics-firepower

Speakers
avatar for Vicky Cann

Vicky Cann

Researcher and campaigner, Corporate Europe Observatory
Corporate Europe Observatory (CEO) is a research and campaign group working to expose and challenge the privileged access and influence enjoyed by corporations and their lobby groups in EU policy making. Vicky Cann is a researcher and campaigner and her work includes a specific focus on corporate capture and... Read More →



Friday June 2, 2023 13:00 - 14:15 CEST
C2.07

13:00 CEST

Tech tools and infrastructures for collaborations
Which tech tools do we need to make our cross-border collaborations work as smoothly as possible? Where are the hitches, and what has been tried to solve them? The members of the panel have years of experience in these questions and will discuss their approach towards supporting technically journalistic collaborations. The starting point will be focusing on current capabilities from the various points of views based on diverse network configurations and needs. The contributors will discuss hands-on about approaches and pain points, but will also focus on the wider socio-tech trends that are impacting collaborative work, now and in the future.

Moderators
avatar for Stefan Candea

Stefan Candea

co-founder, coordinator, European Investigative Collaborations
Currently I am the coordinator of the EIC network.My work started with covering organized crime across borders in România at the end of the 90’s. Mid 2015 I co-founded EIC as a network_by_agreement between media organisations and currently I coordinate the editorial and technological projects between @derspiegel @destandaard... Read More →

Speakers
avatar for Stephan Heffner

Stephan Heffner

IT Specialist Investigative Journalism, DER SPIEGEL
Coordination of IT-related topics in the editorial environment - investigative journalism, data journalism, information security, IT development and operations. Cross-border cooperations and networking.@salevajo@mastodon.social
avatar for Jan Strozyk

Jan Strozyk

Investigative Reporter / Data Journalist, OCCRP
Based in Germany, Jan Strozyk joined OCCRP in 2021 as data editor before becoming chief data editor in 2022. Jan co-leads OCCRP’s research and data team alongside Head of Research Karina Shedrofsky. He works closely with our editorial and the data teams, coordinating data analysis... Read More →
avatar for Alex Ștefănescu

Alex Ștefănescu

Aleph Developer, OCCRP
I'm a Python developer, working on Aleph for the OCCRP.I'm also an activist and digital rights advocate in Romania, working with Asociația pentru Tehnologie și Internet.
avatar for Caroline Desprat

Caroline Desprat

Software developer, ICIJ
Caroline Desprat, France, is a software developer at ICIJ since 2019 where she contributes to the development of journalist-friendly products and tools such as Datashare.



Friday June 2, 2023 13:00 - 14:15 CEST
C3.01

13:00 CEST

Using isotope analysis to investigate a supply chain
Are your clothes products of slave labour? From Burmese teak to Zimbabwean ivory: the exact origin of certain commodities is always of interest. Employing a chemical process called isotope analysis, we managed to prove that Adidas, Hugo Boss and other major German clothing brands source cotton from Xinjiang, China, where Uyghurs are being subjected to forced labour – despite the authorities' claims to the contrary. In this presentation, we will share what we've learned about both the potential and the limitations of this approach, and how it might benefit your own supply chain investigation.

Speakers
avatar for Manuel Daubenberger

Manuel Daubenberger

Freelance Reporter, NDR
Manuel Daubenberger is an investigative reporter and filmmaker. Since 2014 he is working on a freelance basis for multiple media outlets, mainly the German public television ARD. He coordinated the international media cooperation Cum-Ex-Files researching widescale tax fraud. His documentaries... Read More →


Friday June 2, 2023 13:00 - 14:15 CEST
C2.23

13:00 CEST

Working for our food: Modern slavery in Europe
Slavery has been abolished in Europe, but the race for food at low prices often leads to slavery-like working conditions in our food production sector. The tomatoes in our pasta and the olives in our cocktails hide the stories of hard work. Many other sectors of our food production rely on cheap or extremely cheap labour, leading to the exploitation that often goes hand in hand with human suffering. From pig farms to fields and greenhouses across Europe, people in search for job opportunities find themselves being exploited, treated like prisoners or even slaves, unprotected by European governments. Workers come from Europe and beyond and include particularly vulnerable groups like refugees from Ukraine and elsewhere. In this session, journalists will tell us how they investigated the modern slavery across Europe, and what they have found.



Speakers
avatar for Emiliano Mellino

Emiliano Mellino

The Bureau of Investigative Journalism
avatar for Geesje van Haren

Geesje van Haren

Founder, Lost in Europe
Geesje van Haren established Verspers.nl in 2005. VersPers is a training and publication platform for investigative journalists, with a large network of publication partners and extensive experience in training creative investigative journalism skills. Geesje van Haren initiated and... Read More →


Friday June 2, 2023 13:00 - 14:15 CEST
C2.05

13:00 CEST

Digital hygiene – password managers, social media settings, 2FA (introductory session)
It’s time to clean up your digital security hygiene! In this practical session, we’ll talk aboutsome of the most common points of vulnerabilities (e.g. weak passwords, social media settings, mobile devices settings) and walk you through some actionable changes you can make to strengthen your personal digital security posture. In this session you will learn some of the core tools and principles for keeping yourself, your work and your sources safe.


Speakers
avatar for Harlo Holmes

Harlo Holmes

Director of Digital Security, Freedom of the Press Foundation
Harlo Holmes is the Director of Digital Security at Freedom of the Press Foundation. She strives to help individual journalists in various media organisations become confident and effective in securing their communications within their newsrooms, with their sources, and with the public... Read More →
OM

Olivia Martin

Deputy Director of Digital Security, Freedom of the Press Foundation
Olivia Martin is a Digital Security Fellow at Freedom of the Press Foundation. At FPF, she focuses on researching and delivering digital security trainings to journalists, activists, and human rights defenders. She has spent years in newsrooms as a designer and editor with new media... Read More →
avatar for Jake Charles Rees

Jake Charles Rees

Programme Manager; Manager, Source Protection Programme, Centre for Investigative Journalism (TCIJ)
Jake Charles Rees is a curator, producer and programme manager for The Centre for Investigative Journalism in London, UK. For the CIJ he produces the biannual Logan Symposium, Closed Circuit webTV series, Logan Talks public lecture programme, and is currently focusing on leading the... Read More →


Friday June 2, 2023 13:00 - 14:15 CEST
C3.03

13:00 CEST

Reconstructing the Melilla massacre - how to present a well known story
How to be innovative when presenting a story that has been told by other media in various forms? This session is a behind-the-scenes tour of one of the most ambitious European cross-border reconstructions to date in which Lighthouse Reports along with partners with El Pais, Le Monde, Der Spiegel, and Enass established Spain and Morocco's responsibilities in the deaths of 23 people at a border post in June 2022. The session will explain how the story was done, but it will focus on innovative methods used in researching and presenting the story, such as video archiving and chronolocation methodology (using 145 video clips filmed on the day), the construction of a 3D model with Lidar and the placement of media inside that model, which was used during the interviews and storyboarding with a 3D model to make a compelling video product.

Speakers
JS

Jack Sapoch

Lighthouse Reports
avatar for Bashar Deeb

Bashar Deeb

OSINT investigator, Lighthouse Reports
Bashar is an investigative journalist with a specialization in digital investigations. He has participated in different teams that have produced groundbreaking reports on various issues such as the violation of human rights of asylum seekers at EU’s borders, Europe’s secretive... Read More →


Friday June 2, 2023 13:00 - 14:15 CEST
C3.19

13:00 CEST

The art of sonification: How to make your data sound
Data visualization has become omnipresent in digital journalism. However, when it comes to audio, such as podcasts, the presentation of data is often limited to numbers being read out. In this session, we'd like to introduce you to the growing world of data sonification: It's immersive, innovative, and full of possibilities that allow people to access data in a new way! Our project Soni Friday experiments with sonification techniques and tries to find connections between storytelling and data sonification in short videos on Instagram and Twitter, exploring the world of sounding data. 
 
In this hands-on workshop, you will learn how to make your data sound. We will give a short overview of sonification techniques, of what we've learned so far with Soni Friday and discuss the powers and limitations and listen to data together. After that, we will teach you the basics of a common sonification tool: Sonic Pi. At the end of the session, everyone will be able to make a dataset of choice sound! No previous experience is necessary! 

Please make sure to bring some headphones (Bluetooth headphones won't work unfortunately) and your laptops with an installation of Sonic Pi (it's free - you can download it here: https://sonic-pi.net/).

Speakers
BK

Berit Kruse

data journalist, Süddeutsche Zeitung
avatar for Christian Basl

Christian Basl

data journalist & editor at WDR / sonifications with soni friday


Friday June 2, 2023 13:00 - 14:15 CEST
C3.18

13:00 CEST

Clean data like a pro with OpenRefine
In this workshop, we will go through the basic functionalities of OpenRefine, a data cleaning tool used in various projects: the Panama papers, the Danske Bank money laundering story, to name but two! You will learn to match data against authority sources such as OpenCorporates or Wikidata, cluster values in a column, and many other useful tricks. After attending this session, the participants will be able to automate otherwise tedious data cleaning tasks. To attend this session, no prior knowledge is required. All the software necessary will be pre-installed on the school computers. Participants using their laptop will need to install OpenRefine before the session.

Speakers
avatar for Anuška Delić

Anuška Delić

founder, Oštro
Based in Slovenia, Anuška Delić is an investigative reporter and founder of Oštro, a non-profit center for investigative journalism in the Adriatic region. In 2021, Oštro established a sister center in Zagreb, Croatia, effectively creating a unique two-headed micro-regional entity... Read More →
avatar for Hervé Letoqueux

Hervé Letoqueux

OpenFacto
Co-Founder of OpenFacto with Lou (@CapteursOuverts) and Aliaume (@yaolri), a french NGO dedicated to online investigation for journalists and activists, I love OpenSource researches, Python, Gephi, R and OpenRefine. I used to deal with money laundering, financial frauds and terrorism... Read More →


Friday June 2, 2023 13:00 - 14:15 CEST
C3.15

13:00 CEST

Extract patterns from messy data
Extract and clean up messy data with the wonderful and powerful Regex language. We will introduce you to a powerful syntax library that can help you clean up your data, or turn text into something tabular that you can drop into a spreadsheet or database program. This session is for journalists who already know the basics but want to venture more into programming, and for advanced data journalists looking for new tools in their struggles with dirty data.

Speakers
avatar for Lasse Edfast

Lasse Edfast

Documentary producer and data researcher, Freelance
Documentary producer, researcher and data journalist. I'm be happy to help you with your Python project.
avatar for Robert Gebeloff

Robert Gebeloff

Reporter, New York Times
Robert Gebeloff has worked as a data projects reporter for The New York Times since 2008 and has taught data journalism for many years in newsrooms and at conferences. He was co-winner of the George Polk Award in 2015 and was a Pulitzer Prize finalist in both 2015 and 2016 for projects... Read More →


Friday June 2, 2023 13:00 - 14:15 CEST
C3.11

13:00 CEST

Web basics: how the web works, and how to scrape it
You have probably used a web browser to navigate a webpage already. But how does the web really work? Have you ever wondered how exactly your stories reach your readers? Ever wanted to know how to build a simple webpage? Or how to scrape information out of the web and onto your computer? In this session we will cover the basics: the principles of how web pages get onto your screen, and then go hands-on to learn the basics of the two key web technologies: HTML and CSS. As well as these first steps we'll cover how to apply what you've learned to start scraping information from the web. Participants will leave with the necessary foundations to learn web development or web scraping. To attend this session, no prior knowledge is required. All the software necessary will be pre-installed on the school computers. Participants joining with their own laptops need only a web browser such as Google Chrome, Firefox, Safari or Microsoft Edge.

Speakers
avatar for Max Harlow

Max Harlow

Financial Times
Max Harlow works on the visual and data journalism team at the Financial Times, focusing on investigations. He also runs Journocoders, a group for journalists to develop technical skills for use in their reporting.
avatar for Rui Barros

Rui Barros

data journalist, Público
Portuguese data journalist currently working at Público. In a relationship with R, loves to build things on the web. The solo coder in his newsroom, dreaming about the day where he’ll be just one more on a data team, so he doesn't have to debug his code alone.


Friday June 2, 2023 13:00 - 14:15 CEST
C3.04

14:15 CEST

Coffee break
Friday June 2, 2023 14:15 - 14:45 CEST
Cafeteria

14:30 CEST

Individual safety consultations
Do you have problems or considerations about digital security for you or your team? Would you like security advice on your personal software, hardware or on precautions when travelling?
Bring your team and your security questions for a one to one session with our trainers.

Book a time slot by writing to media@journalismarena.eu
We will connect you with the digital security trainers, who may contact you before the conference to learn more about your concerns.

Speakers
avatar for Jake Charles Rees

Jake Charles Rees

Programme Manager; Manager, Source Protection Programme, Centre for Investigative Journalism (TCIJ)
Jake Charles Rees is a curator, producer and programme manager for The Centre for Investigative Journalism in London, UK. For the CIJ he produces the biannual Logan Symposium, Closed Circuit webTV series, Logan Talks public lecture programme, and is currently focusing on leading the... Read More →
avatar for Harlo Holmes

Harlo Holmes

Director of Digital Security, Freedom of the Press Foundation
Harlo Holmes is the Director of Digital Security at Freedom of the Press Foundation. She strives to help individual journalists in various media organisations become confident and effective in securing their communications within their newsrooms, with their sources, and with the public... Read More →
OM

Olivia Martin

Deputy Director of Digital Security, Freedom of the Press Foundation
Olivia Martin is a Digital Security Fellow at Freedom of the Press Foundation. At FPF, she focuses on researching and delivering digital security trainings to journalists, activists, and human rights defenders. She has spent years in newsrooms as a designer and editor with new media... Read More →


Friday June 2, 2023 14:30 - 16:30 CEST
TBA

14:45 CEST

Why wait for leaks? Find breaking news EU stories with FOI
Whether journalists try to expose corruption in public procurement, get the inside story on a new EU law or look into lobbying by multi-national corporations - Freedom of Information (FOI) can be a powerful tool to get access to documents from public administrations across Europe. This session is meant to bring together experienced practitioners to show how the European Union's access to documents regulation and national FOI laws can be used in the most effective way to obtain insights. Speakers will showcase examples of insightful stories based on FOI'd documents and give insight into how the documents were procured, as well as discuss possible strategies and pitfalls for future investigations.

Speakers
avatar for Vicky Cann

Vicky Cann

Researcher and campaigner, Corporate Europe Observatory
Corporate Europe Observatory (CEO) is a research and campaign group working to expose and challenge the privileged access and influence enjoyed by corporations and their lobby groups in EU policy making. Vicky Cann is a researcher and campaigner and her work includes a specific focus on corporate capture and... Read More →
avatar for Peter Teffer

Peter Teffer

Investigative journalist, Follow the Money
avatar for Helen Darbishire

Helen Darbishire

Executive Director, Access Info
avatar for Alexander Fanta

Alexander Fanta

netzpolitik.org
Alexander berichtet als EU-Korrespondent von netzpolitik.org über die Digitalpolitik der Europäischen Union. Er schreibt über neue Gesetze und recherchiert investigativ über große Technologiekonzerne und ihr Lobbying. Er ist Ko-Autor der Studie "Medienmäzen Google" über Journalismusförderungen... Read More →


Friday June 2, 2023 14:45 - 15:30 CEST
C3.05

14:45 CEST

How to think about collaborative science journalism
Science communication based merely on inspiring wonder and celebrating scientific outcomes communicates the idea that science constantly progresses from result to result. This can prove limiting and counterproductive, leading to disillusionment and even distrust. In reality, scientific research proceeds by trial and error, through advances and throwbacks. Science is a fully human enterprise animated by controversy, power systems, economic interests, and even outright fraud.  That's why we need to make science journalism stronger also through an investigative, analytical, inquiring, and irreverent approach. This session will build on a series of experiences, looking at lessons learned and real case studies where journalists had to collaborate with scientists to go in-depth, and explain and sometimes uncover issues of high public interest and impact. We are going to reflect on the ways in which one can foster such collaborations, and reflect on the possibilities they bring and limitations they have.

Moderators
avatar for Brigitte Alfter

Brigitte Alfter

Director, Arena for Journalism in Europe
Brigitte Alfter ist eine deutsch-dänische Journalistin, Geschäftsführerin für Redaktionelles bei Arena for Journalism in Europe und Dozentin Journalismus an der Universität Göteborg. Nach Jahren als Journalistin auf fallen Niveaus vom Lokaljournalismus bis zur EU-Korrespondentin... Read More →

Speakers
avatar for Manuel Daubenberger

Manuel Daubenberger

Freelance Reporter, NDR
Manuel Daubenberger is an investigative reporter and filmmaker. Since 2014 he is working on a freelance basis for multiple media outlets, mainly the German public television ARD. He coordinated the international media cooperation Cum-Ex-Files researching widescale tax fraud. His documentaries... Read More →
avatar for Elisabetta Tola

Elisabetta Tola

founder - science&data journalist, Facta
Science and data journalist, Ph.D in Microbiology.Tow-Knight fellow 2019 Graduate School of Journalism, CUNY. Chief editor at Il BO Live and presenter of Radio3Scienza at RAI Radio3.Co-founder and CEO of the science communication agency formicablu and the independent non-profi... Read More →
avatar for Stéphane Horel

Stéphane Horel

Journalist, Le Monde
Stéphane Horel works as an investigative journalist for Le Monde. She specializes in corporate lobbying and harm, toxic industries, conflict of interest and scientific disinformation. In early 2023, she supervised the European map of PFAS contamination of the "Forever Pollution Project... Read More →


Friday June 2, 2023 14:45 - 16:00 CEST
C3.10

14:45 CEST

Lightning talks
This is a session made up of 5- minute standalone talks on subjects, tips or tools which need only 5 minutes of presentation or explanation. They could also be 5-minute versions of your Dataharvest presentation, or, for presenters who are looking for collaborators, a perfect moment to call for volunteers. Write to the moderator of the session, Jonathan Stoneman, and your idea will be considered!

Moderators
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)

Friday June 2, 2023 14:45 - 16:00 CEST
Aula 1

14:45 CEST

Working with NGOs and activists - no problem or no-go?
Can you work with NGOs and activists and maintain your journalistic independence? Can you be a journalist and an activist at the same time? When must you take different paths? Journalists often collaborate with specialists and NGOs with a particular insight. And that may lead to important and complicated discussions with editors or indeed colleagues in other journalism cultures within the same team. How can we go about this? What are the main thoughts to consider when we decide whether to collaborate? In this session, three experienced journalists will discuss their experiences regarding collaborating with NGOs and share their thoughts on the pros and cons.

Moderators
avatar for Ingeborg Eliassen

Ingeborg Eliassen

Managing editor, Investigate Europe
Ingeborg is part of Investigate Europe, a cross-border group of journalists in 12 countries. Previously, as a reporter with Stavanger Aftenblad, she specialized in labour issues, military conflicts, forced migration and asylum policies. Three books have resulted from her work: One... Read More →

Speakers
avatar for Rudi Bressa

Rudi Bressa

Freelance journalist
Rudi Bressa is an environmental and scientific freelance journalist, who collaborates with many Italian and international media outlets, focused on climate change, energy transition, circular economy and biodiversity conservation. He is a member of Swim (Science Writers in Italy... Read More →
avatar for Stefan Candea

Stefan Candea

co-founder, coordinator, European Investigative Collaborations
Currently I am the coordinator of the EIC network.My work started with covering organized crime across borders in România at the end of the 90’s. Mid 2015 I co-founded EIC as a network_by_agreement between media organisations and currently I coordinate the editorial and technological projects between @derspiegel @destandaard... Read More →
avatar for Romina Colman

Romina Colman

Latin America Data Editor, Organized Crime and Corruption Reporting Project (OCCRP)


Friday June 2, 2023 14:45 - 16:00 CEST
C3.01

14:45 CEST

Design thinking for solidarity 1
A topic that concerns the whole European public-interest media sector: solidarity amongst our audiences. Or in other words: how can we stimulate our audiences to support not just one outlet, but also other public-interest ‘friends’? In this 2-part session we will focus on design thinking – but rather than talking about it, we will apply it. The sessions are designed as a sprint/hackathon, where three or four teams will dive into the main question and work on designing concrete solutions. The end result will probably not be completely finished, but it will be something we can produce in the weeks following the conference. And something we could probably actually implement as well. The session is mainly intended for members of the Reference Circle and grantees from Civitates, but others are welcome to join us.

Speakers
avatar for Will Franklin

Will Franklin

Lead Developer, beabee
avatar for Mick ter Reehorst

Mick ter Reehorst

Director / Founder, Are We Europe


Friday June 2, 2023 14:45 - 16:00 CEST
C2.25

14:45 CEST

MEP Index - how do your country's MEPs fare in the integrity test?
After Qatargate, trust in European politicians has hit a new low; the question of trust is more pressing than ever. In the Netherlands, 10 years ago, journalist Bart de Koning worked together with academics from the Vrije Universiteit in Amsterdam to develop a standard to collect and assess the integrity of Dutch politicians. This internationally recognised method is now being tried in other countries: together with Bart de Koning, we want to use it to develop an integrity index for MEPs. This requires us to work together with journalists and media from various countries. We will scrape and fact-check relevant local and national articles on their MEPs, and dig up other relevant information. In this session, we will present the Index and our idea for a pan-European investigation. We would also like to learn from journalists from other EU member states, discuss best practices, and grow the network of reporters we can collaborate with on this topic.

Speakers
avatar for Adriana Homolová

Adriana Homolová

ARENA / Follow The Money, Netherlands / Slovakia
Adriana is a freelance data journalist, trainer and public spending nerd. She coordinates the data skills training track on the Dataharvest conference and investigates the European Union for Follow The Money Bureau Brussel.
avatar for Lise Witteman

Lise Witteman

investigative journalist EU-topics, Follow the Money
Team lead of the EU desk of investigative journalism platform Follow the Money (ftm.nl/ftm.eu).Our Brussels based team specialises in (data driven) investigations into EU affairs, such as the Recovery Files investigation.In the run up to the European elections of 2024 we have some... Read More →


Friday June 2, 2023 14:45 - 16:00 CEST
C3.03

14:45 CEST

Finding Faces
You need to do reverse image searches YouTube videos to find the true identity of crypto fraudsters? You want to track down Russian oligarchs’ yachts and jets from FaceBook photos? Or you need to work out whether a dead body is the Serbian drug smuggler you think it is? Find out how how OCCRP’s data and research team finds faces and assets using image recognition tools and machine learning. Which tool is best for which job? The team will explain which off-the-shelf and in-house tools they use when trying to figure out if two faces are the same or trying to find someone in a large dump of images.

Speakers
avatar for Karina Shedrofsky

Karina Shedrofsky

Head of Research, OCCRP
Based in Amsterdam, Karina Shedrofsky joined OCCRP in 2017 as a daily news reporter and became head of research in 2019. She now co-leads OCCRP’s research and data team alongside Chief Data Editor Jan Strozyk, and helps journalists in our global network track down people, companies... Read More →
avatar for Eric Barrett

Eric Barrett

Data Desk Manager, OCCRP
Based in Tbilisi, Georgia, Eric Barrett joined OCCRP in 2019 and is the data desk manager. He works with OCCRP journalists and member centers leveraging data to support investigations that shine a light on corruption. Previously, he directed Georgia’s first data non-profit, JumpStart... Read More →


Friday June 2, 2023 14:45 - 16:00 CEST
C2.07

14:45 CEST

Tracking the Wagner group from Africa to Europe
The Russian Wagner group is plundering the natural resources of the Central African Republic, and European countries help fund their operations. The CAR government needed mercenaries, which the Wagner group could provide – in exchange they received access to various resources such as tropical timber and diamonds. Undisturbed by the international sanctions, Wagner can export their products to Europe and import tools and machineries to exploit these resources.
European Investigative Collaborations partnered in the research with the NGO AllEyesOnWagner. The investigation led to the companies involved now being on the EU sanction list – and the Belgian research partner Standaard being nominated for the prestigious Belfius Award.

Speakers

Friday June 2, 2023 14:45 - 16:00 CEST
C3.19

14:45 CEST

Working on labour rights? How to research closed groups
Countless breaches of trust have left exploited workers disillusioned and suspicious. When journalists reach out to them in order to report on their suffering, these workers can be hard to reach, and their distrust has to be surmounted. Their jobs and their future, their safety or the safety of their families, and even their lives may depend on them laying low. How can we get in touch and build trust with these people or groups? How can we report on their situation without putting them in danger? How can we gain access to their closed groups or networks? We hear from three experienced journalists who used very different methods as they researched working conditions across Europe. They will share examples of how they managed to gain access to those closed groups, and their experiences on what should not be done under any circumstances.

Moderators
avatar for Hazel Sheffield

Hazel Sheffield

Arena Academy co-ordinator, Arena for Journalism
In 2020, Hazel co-ordinated the cross-border investigation Money to Burn, which revealed that Europe's renewable energy subsidies were inadvertently fuelling the destruction of ancient forests in Estonia. Today she is coordinating the education and training arm for Arena for Journalism... Read More →

Speakers
avatar for Emiliano Mellino

Emiliano Mellino

The Bureau of Investigative Journalism
avatar for Apolena Rychlíková

Apolena Rychlíková

Deník Alarm, z.ú.
Apolena Rychlíková is an award-winning Czech journalist and documentary filmmaker. Her work focuses on issues of social inequality, labour and the labour market, gender, the position of minorities, housing, and she is also a political commentator and analyst. Her investigative work... Read More →
avatar for Stavros Malichudis

Stavros Malichudis

Reporter, Solomon


Friday June 2, 2023 14:45 - 16:00 CEST
C2.05

14:45 CEST

Arena Climate Network: what should we research together?
The Arena Climate Network is an open-access network created by journalists for journalists. It functions as a meeting space for journalists and researchers who focus on all aspects of the climate crisis and who want to do in-depth, investigative work. Our network serves a community devoted to exposing financial greed, corruption, and government malaise that fuel the climate crisis. We offer journalists a hub for collaboration, discussion and learning from each other. As of 2023, we also organise a series of climate conferences for journalists, scientists and civic tech members, combined with training, a mentorship program, and guidance for the setting up of local networks. In this session, we would like to present the upcoming activities of the network, but also learn from our community of investigative journalists. What topics should be featured at our conference? What research areas should we encourage journalists in our network to dig deeper into? What’s your dream climate investigation? What is underreported -or, on the contrary, well-covered, in your country? Come and let’s talk climate.

Speakers
avatar for Lorenz Matzat

Lorenz Matzat

Network coordinator, Arena for Journalism in Europe
Lorenz is a coordinator of the Climate Network at Arena for Journalism in Europe. He also works for a non-profit journalism start-up in Switzerland and is a guest lecturer at the journalism faculty of the University of Leipzig.  Lorenz is co-founder of the NGO AlgorithmWatch and... Read More →
avatar for Zeynep Sentek

Zeynep Sentek

Project director, Climate Network, Arena for Journalism in Europe
Zeynep Sentek is a Turkish investigative journalist specialising in corruption, offshore structures, human rights, and the environment. She is now leading the climate network of Arena for Journalism in Europe. In this network, Arena facilitates journalists to do cross-border climate... Read More →


Friday June 2, 2023 14:45 - 16:00 CEST
C3.18

14:45 CEST

Prepare for online harassment 1: Self-doxing
Online harassment is a fact of life for investigative journalists. There is no silver bullet to beat hate and smear campaigns, especially if they are part of a coordinated campaign to create noise and discredit your work, but in this 2-part workshop, you will learn how to put your journalistic skills to work to combat harassment.
In the first part of the workshop, we will introduce some of the tactics used to intimidate and discredit the work of independent reporters and discuss the best strategies to address them. We will do this in a self-doxing exercise, where you will put yourself in the shoes of the attacker and learn the techniques and tools they use to gather personal information on a target.

Speakers
avatar for Javier Luque Martinez

Javier Luque Martinez

Head of Digital Communications, International Press Institute
Javier Luque is the Head of Digital Communications for the International Press Institute, where he coordinates advocacy and communication on IPI’s digital platforms. He has worked on online hate against journalists and media organisations since 2014. His research on this topic has... Read More →


Friday June 2, 2023 14:45 - 16:00 CEST
C2.23

14:45 CEST

Basic rules of good data design
"This is a chord… this is another… this is a third. NOW FORM A BAND". Simon Rogers, founder of The Guardian’s Datablog likened the principles of forming a punk band with the making of data visualisations. Data and visualisation tools are so abundant that anyone can, in principle, make their own charts with just a few clicks. One might argue that the job is done when you turn your data into a chart. But the next steps are equally important, if not more so! Not only do we have to show our data, but we have to make it look good, so our readers are also willing to read it - and may even find it memorable. In this session, we'll cover the basic rules of data design, and then apply this knowledge with the use of a free online tool, Flourish.studio. Participants will learn what makes a chart visually engaging and will be able to apply each aspect in a free-to-use online data visualisation tool.To attend this session, no prior knowledge is required, and no special tools are needed. Before the session sign up for a Flourish.studio account (free to register).

Speakers
avatar for Rui Barros

Rui Barros

data journalist, Público
Portuguese data journalist currently working at Público. In a relationship with R, loves to build things on the web. The solo coder in his newsroom, dreaming about the day where he’ll be just one more on a data team, so he doesn't have to debug his code alone.
avatar for Krisztián Szabó

Krisztián Szabó

data journalist, Átlátszó, ATLO
I'm a data journalist from Budapest, Hungary at atlatszo.hu, an online investigative news site. I am most experienced using Flourish.studio as I use it on a day to day basis for my work. I also use Google Sheets for making databases/creating databases for live charts and maps. More... Read More →


Friday June 2, 2023 14:45 - 16:00 CEST
C3.04

14:45 CEST

Cozying up to your computer: an introduction to the command line
What is the command line? And how can it help me? How can I use it to search documents and find something specific within a messy collection of data? How can it help me interact with large CSV tables? In this hands-on session Oksana and Alexandra, two OCCRP data developers, will walk you through examples of how to use the command line to make your professional life easier. Participants will learn the basics of working with files and browsing the file system from the command line. This workshop is interactive, and the objective of the exercises is to allow participants to solve real scenarios using only the command line. Knowledge of working with the command line is not necessary, but it would be helpful if participants have seen, and interacted with the command line before- just in terms of being familiar with the design and how the command line application is started. If you are working on your own laptop, you will need to be running either Linux or MacOS, or have Windows Subsystem for Linux (WSL 2) running on a Windows 10/11 laptop.

Speakers
avatar for Oksana Stavniichuk

Oksana Stavniichuk

Investigative Data Developer, OCCRP
avatar for Alex Ștefănescu

Alex Ștefănescu

Aleph Developer, OCCRP
I'm a Python developer, working on Aleph for the OCCRP.I'm also an activist and digital rights advocate in Romania, working with Asociația pentru Tehnologie și Internet.


Friday June 2, 2023 14:45 - 16:00 CEST
C3.11

14:45 CEST

Tracking changes with GitHub Actions
Have you ever come across something online that later gets changed? Sometimes these changes can be more interesting than the data itself. For example, Wikipedia lets you see how a page has been edited - adding or cutting out certain bits of information. What if we could do something similar for any webpage? Using GitHub Actions, we can. GitHub is a site for sharing and collaborating on code, as well as keeping track of how it is being revised or replaced. A few years ago GitHub launched Actions, which lets you run code on their servers on a regular schedule. It is remarkably simple to set up, and if you're happy for your work to be visible to other users, it's free. GitHub Actions is especially powerful for tracking changes - we can store different versions of the data and use Github's tools to identify any changes. Participants will leave with an understanding of how to set up GitHub Actions to regularly run a simple scraper, and then do some basic analysis on the output, including how to identify changes over time. We will also learn about other ways Actions is being used by newsrooms to find stories. No prior knowledge is required, however you will need to have a GitHub account. Sign up before the session if you don't already have one.(https://github.com/signup)

Speakers
avatar for Phil McMahon

Phil McMahon

Software Developer, The Guardian
Phil McMahon is an engineer at The Guardian. Recently his work has focussed on data journalism projects, whistleblowing systems, searching document dumps and working with UK Parliament/Company/Land Registry data.
avatar for Max Harlow

Max Harlow

Financial Times
Max Harlow works on the visual and data journalism team at the Financial Times, focusing on investigations. He also runs Journocoders, a group for journalists to develop technical skills for use in their reporting.


Friday June 2, 2023 14:45 - 16:00 CEST
C3.15

16:00 CEST

Break (cold drinks only)
Friday June 2, 2023 16:00 - 16:30 CEST
Cafeteria

16:30 CEST

Lost in Europe: investigating child trafficking around asylum centers
The cross-border investigative project Lost in Europe has shown that thousands of children go missing after registering in Europe, and that - in the case of Vietnamese minors - criminal networks are literally waiting for them in front of the asylum shelters in cars with flashing headlights. Is this systematic? With journalists from regional media in the Netherlands, Lost in Europe set up an investigation into trafficking at the hotels (which serve as emergency shelters in the Netherlands) and other shelters for minors. Do the arrangements for housing children lead to them going missing? Are criminals hanging around these shelters to lure vulnerable youngsters into their illegal businesses?

Moderators
avatar for Geesje van Haren

Geesje van Haren

Founder, Lost in Europe
Geesje van Haren established Verspers.nl in 2005. VersPers is a training and publication platform for investigative journalists, with a large network of publication partners and extensive experience in training creative investigative journalism skills. Geesje van Haren initiated and... Read More →

Speakers
avatar for Ismail Einashe

Ismail Einashe

Investigative Journalist
Ismail Einashe is an award-winning investigative journalist and writer who has written for The Guardian, BBC News, Foreign Policy, The Sunday Times, El Mundo, Internazionale and The Nation, among many others. He is a member of Lost in Europe, a cross-border journalism project investigating... Read More →
avatar for Sanne Terlingen

Sanne Terlingen

Founder, Lost in Europe
Sanne Terlingen is an award winning investigative journalist from The Netherlands, specialized in organized sexual violence, (early childhood) trauma, migration, people smuggling and trafficking. She currently works as head of investigations at Lost in Europe, a cross border investigative... Read More →


Friday June 2, 2023 16:30 - 16:45 CEST
C3.03

16:30 CEST

Biggest EU Subsidy Pot ever: Who gets billions from the EU recovery files?
With over 700 billion euros to disburse, the EU Recovery Fund is the biggest European subsidy program of all time. Working against frequent resistance from the European Commission and EU member states, a group of journalists from all over the EU has been working since 2021 to track down the beneficiaries and follow the decision-making processes for this fund. Now the journalists explain how they did it. Meanwhile they are still looking for media outlets in the EU that can help broaden the investigation.

Speakers
avatar for Staffan Dahllöf

Staffan Dahllöf

Reporter, Investigative Reporting Denmark
Eager to discuss any matter related to EU-reporting, especially FOI/Wobbing-issues. Have taken part in crossborder project Farmsubsidy.org, the Facebook arrests the MEP's Project, Chlorpyrifos (the most dangerous pesticide you've never heared of), Illegal pesticide + ongoing Covid... Read More →
avatar for Adriana Homolová

Adriana Homolová

ARENA / Follow The Money, Netherlands / Slovakia
Adriana is a freelance data journalist, trainer and public spending nerd. She coordinates the data skills training track on the Dataharvest conference and investigates the European Union for Follow The Money Bureau Brussel.
avatar for Hans-Martin Tillack

Hans-Martin Tillack

Investigative reporter, Welt
Hans-Martin Tillack works as an investigative reporter for the newspapers "Welt", "Welt am Sonntag" and the TV magazine "Report München" (public broadcaster ARD). Until 2021 he was an investigative reporter for the weekly magazine "Stern". From 1999 to 2004 he was the EU correspondent... Read More →
avatar for Peter Teffer

Peter Teffer

Investigative journalist, Follow the Money


Friday June 2, 2023 16:30 - 17:45 CEST
C3.05

16:30 CEST

Fueling war - how a local story turned into major international research
It began as a national story in Greece: Greek shipowners transported almost half the Russian oil exports to the global market. But the oil ended up in many European ports, and Reporters United in Greece began a collaboration with Investigate Europe. The project turned into an international story, published in 10 languages (including Russian) and involving methods from data scraping, sailing out to sea, finding anonymous business sources to building a database that had to contain as diverse data as national flags and scraped tweets. Hear how the reporters documented that Europe fuels Russia's war.

Speakers
avatar for Chris Matthews

Chris Matthews

Website Editor, Investigate Europe
Chris Matthews is the website editor of Investigate Europe, a cross-border investigative journalism consortium. Previously, he worked on climate investigations for an environmental nonprofit, with a particular focus on commodity-driven deforestation and global supply chains. He reported... Read More →
avatar for Sotiris Sideris

Sotiris Sideris

Data Editor, Reporters United, CCIJ
Sotiris Sideris is a data journalist, trainer, and project manager with extensive cross-border and collaborative experience.He is the data editor of Reporters United and the Center for Collaborative Investigative Journalism (CCIJ), and co-founder of AthensLive. He also serves as a... Read More →


Friday June 2, 2023 16:30 - 17:45 CEST
C3.10

16:30 CEST

How to use the user-unfriendly EU ETS database to track CO2 emissions
The EU ETS database tracking CO2 emissions is public, but hard to master. In this session, we will explain how we used the database to investigate Europe’s leading steelmaker ArcelorMittal. Through scraping, filtering and exploration of this database, we identified the group’s installations and estimated their total emissions across 9 European countries. The results show that ArcelorMittal has not decreased its carbon emissions since the implementation of the EU carbon quota system 20 years ago. We will share our methodology, give participants the opportunity to investigate other groups' emissions, and demonstrate our dataset on ArcelorMittal - opening the possibility of developing the story further. Finally, we will share our leads and insights about obtaining information and data on public subsidies, from the EU and individual member states. Our investigation showed that ArcelorMittal, France’s top CO2 emitter, benefitted from hundred of millions of Euros in EU & member state funds.

Speakers
avatar for Ariane Lavrilleux

Ariane Lavrilleux

Journalist, Disclose/Freelance
Investigative freelance journalist formerly based in Egypt, i am currently settled in France. I have worked with Disclose on French arms deals to dictatorships and environmental crimes. In 2022, we unveiled carcinogenic illegal pollution by steel world leader ArcelorMittal in cross-border... Read More →
avatar for Rémi Labed

Rémi Labed

Journalist, Disclose


Friday June 2, 2023 16:30 - 17:45 CEST
C3.01

16:30 CEST

Making research data from text
Part of publishing a good story is the art of selecting the most salient facts from a body of research. But what happens to all that information we collected along the way? And how do we build up a base of knowledge from multiple stories published over years or decades? How can that collected knowledge help to drive collaboration in reporting? In this panel we will explore how structured journalism and structured investigations can create something greater than the sum of their parts. We will talk about some of the examples of where this can work well, and some of the challenges we encounter when trying to do this work. As an example structured data project, we will additionally talk about OpenSanctions.org and how it is processing it's data and making it available for journalistic research.

Speakers
avatar for Simon Wörpel

Simon Wörpel

Investigative Data Journalist, ||)·|()
Simon Wörpel is an independent investigative data journalist, researcher and leak librarian. He specializes in documents processing, data engineering anddata analysis for journalistic investigations. Simon works for differentnon-profit organizations, newspapers and media outlets... Read More →


Friday June 2, 2023 16:30 - 17:45 CEST
C3.19

16:30 CEST

Design thinking for solidarity 2
A topic that concerns the whole European public-interest media sector: solidarity amongst our audiences. Or in other words: how can we stimulate our audiences to support not just one outlet, but also other public-interest ‘friends’? In this 2-part session we will focus on design thinking – but rather than talking about it, we will apply it. The sessions are designed as a sprint/hackathon, where three or four teams will dive into the main question and work on designing concrete solutions. The end result will probably not be completely finished, but it will be something we can produce in the weeks following the conference. And something we could probably actually implement as well. The session is mainly intended for members of the Reference Circle and grantees from Civitates, but others are welcome to join us.

Speakers
avatar for Will Franklin

Will Franklin

Lead Developer, beabee
avatar for Mick ter Reehorst

Mick ter Reehorst

Director / Founder, Are We Europe


Friday June 2, 2023 16:30 - 17:45 CEST
C2.25

16:30 CEST

Sue the bastards?
When your FOI process gets really stuck, it is tempting to take the issue to court. In this sessions we share experiences on litigation. Bring your own stories and questions.

Speakers
avatar for Tarjei Leer-Salvesen

Tarjei Leer-Salvesen

Freelancer, Freelance
Tarjei Leer-Salvesen spent this year six months at Reuters Institute in Oxford to learn more about the differences between 136 RTI laws in the world, and how journalists can use cross-border filing for information in their investigations.As he also is a well know international working... Read More →
avatar for Helen Darbishire

Helen Darbishire

Executive Director, Access Info
avatar for Arne Semsrott

Arne Semsrott

Projektleiter FragDenStaat, Open Knowledge Foundation
Arne Semsrott ist Projektleiter von FragDenStaat und beschäftigt sich mit Informationsfreiheit. Er ist Politikwissenschaftler, arbeitet als freier Journalist und engagiert sich in weiteren NGOs zu Themen wie Transparenz und Lobbyismus, unter anderem als ehrenamtlicher Vorstand von... Read More →


Friday June 2, 2023 16:30 - 17:45 CEST
C3.18

16:30 CEST

How to investigate Russian gas lobby - or any other network
Correctiv recently investigated the network of people who made Germany dependent on gas (https://correctiv.org/en/latest-stories/2022/10/07/gazprom-lobby-germany/). For the first time, we presented a comprehensive picture of the Russian Gazprom Lobby that included networks of German politicians, energy executives, and lawyers who led Germany down the dangerous path of Russian gas dependence. To this end, and over many years, they were systematically setting up inconspicuous organizations that targeted German politicians – from both the center-left and the conservative bloc – to support increased gas supplies from Russia. In a recent publication (https://correctiv.org/en/latest-stories/2023/04/19/vodka-scholz-and-gazprom/) we were also able to show how young lobbyists celebrated good business with Russia – and therefore, again, fueled gas dependency. This story showed us the necessity to dig into networks and lobbyism. There are plenty of examples of networks to investigate - Chinese networks, nuclear energy networks, Saudi-Arabian networks...In this presentation, we will share how we learned to investigate networks and make them transparent in an easily understandable way (e.g. with graphs we used), and how to dig into lobbyism data (like invitation lists for conferences or connecting points in CVs among politicians and lobbyists). We will also discuss what networks we could investigate together and where to look for the next lobbying stories.

Moderators
avatar for Jelena Prtoric

Jelena Prtoric

Journalist, Arena for Journalism in Europe

Speakers
avatar for Annika Joeres

Annika Joeres

Correctiv
Annika Joeres arbeitet in Frankreich für die Investigativredaktion correctiv.org und Zeitonline und als Kommentatorin für Arte. 2020 erschien ihr Buch die "Klimaschmutzlobby" (zusammen mit Susanne Götze), 2022 "Klima außer Kontrolle - wie sich Deutschland schützen muss".Zuvor... Read More →


Friday June 2, 2023 16:30 - 17:45 CEST
C2.05

16:30 CEST

Finding facts about people
We all have to find people and investigate them. What is their email address? Who are their friends and connections? This session will present a systematic approach on how to proceed and how to go from one data point to the next. How do you get the name behind an e-mail-address – and vice versa? How can you use nicknames, domains and social media profiles? Which tools do you need to get you from one point to the next?

Speakers
avatar for Marcus Lindemann

Marcus Lindemann

managing editor, autoren(werk) GmbH & Co.KG
Marcus Lindemann is the managing author of autoren(werk) and has been producing magazine pieces and documentaries for ARD and ZDF with his own company since 2000, mainly on consumer topics, often with hidden cameras. After the series "WISO ermittelt" and "oma trick", autoren(werk... Read More →


Friday June 2, 2023 16:30 - 17:45 CEST
Aula 1

16:30 CEST

Prepare for online harassment 2: Analyse and plan!
Online harassment is a fact of life for investigative journalists. There is no silver bullet to beat hate and smear campaigns, especially if they are part of a coordinated campaign to create noise and discredit your work, but in this 2-part workshop, you will learn how to put your journalistic skills to work to combat harassment.
In the second part of the workshop, you will learn how to analyze the type of online violence directed at you, which will give you the power to decide what’s the best course of action. We will explore the most effective measures to minimize the professional and emotional toll that smear campaigns and online hate take on you. And you will build a step-by-step guide for yourself to react to online hate.

Speakers
avatar for Javier Luque Martinez

Javier Luque Martinez

Head of Digital Communications, International Press Institute
Javier Luque is the Head of Digital Communications for the International Press Institute, where he coordinates advocacy and communication on IPI’s digital platforms. He has worked on online hate against journalists and media organisations since 2014. His research on this topic has... Read More →


Friday June 2, 2023 16:30 - 17:45 CEST
C2.23

16:30 CEST

Investigative journalists and artists - a dream team?
Can you present your investigation in a 2-minute animation? Can visual artists communicate your story better than words? And do investigative journalists and artists understand each other at all? Investigative journalism tends to have thousands of words and facts. Investigate Europe and Reporters United have tried to turn the communication upside down and introduce big, complicated stories with a 2-minute video. And Center for Artistic Inquiry and Reporting works to unite the storytelling efforts of investigative reporters and visual artists. Hear about the challenges and advantages of the collaboration from a journalist, a visual artist and a person with a foot on each side.

Speakers
avatar for Janine Louloudi

Janine Louloudi

Investigative journalist, MIIR & Reporters United
An investigative journalist and producer based in Athens, with experience in the field of documentary and news-production.  With the Mediterranean Institute for Investigative Reporting (MIIR) since 2019, and most recently with the Reporters United network, I have been experimenting... Read More →
avatar for Alexia Barakou

Alexia Barakou

Art Director, Illustrator, Animator, Freelance
I am an Art Director, Illustrator, and Animator based in Athens. I make explainer videos (direction, animation, illustration) for independent productions, documentaries, and advertising. For the last 5 years, I have been working with Investigate Europe and Reporters United, creat... Read More →
avatar for Jake Charles Rees

Jake Charles Rees

Programme Manager; Manager, Source Protection Programme, Centre for Investigative Journalism (TCIJ)
Jake Charles Rees is a curator, producer and programme manager for The Centre for Investigative Journalism in London, UK. For the CIJ he produces the biannual Logan Symposium, Closed Circuit webTV series, Logan Talks public lecture programme, and is currently focusing on leading the... Read More →


Friday June 2, 2023 16:30 - 17:45 CEST
C2.07

16:30 CEST

Python for beginners
In this session, you will get acquainted with the basic concepts of the Python programming language. Participants will be able to improve the skills needed to obtain and analyse data. To attend this session, no prior knowledge is required. Tools needed, if bringing your own laptop, are Python and Anaconda.

Speakers
avatar for Karrie Kehoe

Karrie Kehoe

Data Journalist, ICIJ
Karrie Kehoe is a data journalist at ICIJ. Previously she investigated health care, human rights, environmental pollution and public expenditure at The Times & Sunday Times newspapers, the Thomson Reuters Foundation, and the RTÉ Investigations unit.
avatar for Alesya Marokhovskaya

Alesya Marokhovskaya

The Head of the Data Department, Investigative and Data Reporter, IStories
Investigative and data reports at Important Stories (www.istories.media). You can contact Alesya by mail alesya.marohovskaya@istories.media.Awards:The Sigma Awards 2022 (Important Stories)Winner of the European Press Prize 2021 in the investigation category (Important Stories)The... Read More →


Friday June 2, 2023 16:30 - 17:45 CEST
C3.15

16:30 CEST

Scraping without code: using third-party tools to scrape websites
Do you love copy-pasting endlessly? If you do, this session is not for you! We often need to get information from websites. But why copy-paste if the computer can do that for us? After attending this session you can add a couple of simple scraping tools into your toolkit. Participants who want to join with own laptops will need Google Chrome with the webscraper extension installed, and build the 'ImportJSON' function in your Google Sheets Although no prior knowledge is required, participants will find some familiarity with HTML/CSS valuable.

Speakers
avatar for Sandra Foresti

Sandra Foresti

Lecturer, University of Gothenburg
Lecturer, Department of Journalism and Communication at University of Göteborg, Sweden. I teach data journalism and investigative journalism at bachelor and master level. Background as researcher, investigative journalist and data journalism at different Swedish media organisati... Read More →
avatar for Carmen Aguilar Garcia

Carmen Aguilar Garcia

Data Journalist, The Guardian
Data journalist at The Guardian Data Project team. I work on a variety of subjects - always finding the data angle in every story. Scraping, cleaning, data analysis, but above all JOURNALISM!


Friday June 2, 2023 16:30 - 17:45 CEST
C3.04

16:30 CEST

When Excel explodes: techniques for handling large datasets
Journalists frequently need to work with datasets that just too big for Google Sheets or Excel to handle comfortably. For instance, the UK Land Registry’s dataset on corporately owned property spans more than 130 files totalling more than 100GB. In this workshop, we’ll learn some simple command-line techniques for quickly searching such data when this is unfeasibly slow in Sheets or Excel. We’ll then learn how to use Google BigQuery, a powerful and user-friendly tool which is well integrated with Google Sheets. We’ll see how to use it to do SQL queries for aggregate analysis - for instance, counting companies that own the most land titles - and how fast this can be done, even when the datasets are huge. Participants will learn techniques for searching, analysing, and filtering CSV files that are too big to work with directly in spreadsheet applications. The participants should be comfortable using a terminal to run simple commands. Knowledge of SQL is advantageous but not essential. If bringng your own laptop, you should have the following command-line tools installed: ripgrep, xsv

Speakers
avatar for Joseph Smith

Joseph Smith

Staff Software Engineer, The Guardian
Joseph Smith is a software engineer who has spent the last four years working on investigative and data journalism projects at the Guardian. These include the Pandora Papers, the "UK For Sale" series on offshore-owned property, investigations into PPE procurement during the pandemic... Read More →
avatar for Phil McMahon

Phil McMahon

Software Developer, The Guardian
Phil McMahon is an engineer at The Guardian. Recently his work has focussed on data journalism projects, whistleblowing systems, searching document dumps and working with UK Parliament/Company/Land Registry data.



Friday June 2, 2023 16:30 - 17:45 CEST
C3.11

18:15 CEST

FOI Party and Art Auction
FOI and access to information is a challenge and a hardship - and sometimes it is better to laugh at ridiculously redacted documents instead of being frustrated. Norwegian FOI expert Tarjei Leer-Salvesen has invented the concept of FOI Art, some of his works will be shown during Friday at the conference at auctioned off , while we have a drink (Tarjei has kindly donated all income to Dataharvest!)

How much is your editor willing to spend on one of these unique pieces? Who wants to bring one home for the co-working space? Bring your cell phone and make your bid!

To make a bid at the auction either follow this link or go to Menti.com and use the code 4871 3757.

Read more about the #officialsecretsart project.

Speakers
avatar for Tarjei Leer-Salvesen

Tarjei Leer-Salvesen

Freelancer, Freelance
Tarjei Leer-Salvesen spent this year six months at Reuters Institute in Oxford to learn more about the differences between 136 RTI laws in the world, and how journalists can use cross-border filing for information in their investigations.As he also is a well know international working... Read More →
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)
avatar for Stéphane Horel

Stéphane Horel

Journalist, Le Monde
Stéphane Horel works as an investigative journalist for Le Monde. She specializes in corporate lobbying and harm, toxic industries, conflict of interest and scientific disinformation. In early 2023, she supervised the European map of PFAS contamination of the "Forever Pollution Project... Read More →


Friday June 2, 2023 18:15 - 19:30 CEST
Cafeteria
 
Saturday, June 3
 

09:00 CEST

Coffee
Saturday June 3, 2023 09:00 - 09:30 CEST
Cafeteria

09:30 CEST

Mapping Q-Anon in Europe, on Telegram and beyond
Since the start of the coronavirus pandemic an increasing number people across the world believe that the world is ruled by a dangerous 'Deep State'. Supporters of the QAnon conspiracy theory congregate on various social media platforms - namely Telegram - to follow and discuss Q-related theories and activities. Lighthouse Reports and Bellingcat developed a database of channels and posts to map this viral conspiracy theory in different countries. They also build a dashboard that allows users to query posts based on keywords, date ranges, countries, and channels. In this session, we will take a deep look into their investigation and the methodology behind it. They will as well present their dashboard and how one can use it.

Speakers
RC

Riccardo Coluccini

Freelance journalist
Freelance journalist based in Italy, working with various media outlets, including Vice Italia and IrpiMedia, and collaborating with the investigative nonprofit Lighthouse Reports. Writing about hacking, surveillance, digital rights and internet anthropology. FOIA requests lover... Read More →
avatar for Justin-Casimir Braun

Justin-Casimir Braun

Data Reporter, Lighthouse Reports, Germany
Justin is a data journalist focused on the societal impact of automated systems and artificial intelligence. In the past, Justin has worked with AlgorithmWatch e.V., a German digital rights organization, and various grassroots NGOs, documenting human rights violations against migrants... Read More →


Saturday June 3, 2023 09:30 - 10:45 CEST
C2.07

09:30 CEST

Tracking wildlife crime in your country
In 2018, Oxpeckers Investigative Environmental Journalism and Internews' Earth Journalism Network created #WildEye, a tool that maps illegal wildlife trafficking across the continent, allowing users to track seizures, arrests, court cases and convictions. At present, it has close to 500 incidents mapped, and it has been part of many journalistic investigations. The project has resulted in extending wildlife trafficking investigations to Asia; training webinars in Europe and South Asia; partnerships with organisations in Europe, Asia and Africa. In this session, we will present the tool and how you can use it to jump-start an investigation on wildlife trafficking in your country.

Speakers
avatar for Zeynep Sentek

Zeynep Sentek

Project director, Climate Network, Arena for Journalism in Europe
Zeynep Sentek is a Turkish investigative journalist specialising in corruption, offshore structures, human rights, and the environment. She is now leading the climate network of Arena for Journalism in Europe. In this network, Arena facilitates journalists to do cross-border climate... Read More →
avatar for Rudi Bressa

Rudi Bressa

Freelance journalist
Rudi Bressa is an environmental and scientific freelance journalist, who collaborates with many Italian and international media outlets, focused on climate change, energy transition, circular economy and biodiversity conservation. He is a member of Swim (Science Writers in Italy... Read More →


Saturday June 3, 2023 09:30 - 10:45 CEST
C2.23

09:30 CEST

How to fact-check your data work for an investigative piece?
Join us for a panel discussion featuring data journalists and developers from the International Consortium of Investigative Journalists (ICIJ) as they share their expertise. Drawing from their experiences in groundbreaking investigations like the Uber Files, Pandora Papers, and Deforestation Inc., the panelists will delve into methodologies, challenges, and best practices for ensuring the accuracy and integrity of investigative reporting. Topics covered include data collection and cleaning, source verification, cross-referencing, leveraging technology, and maintaining transparency and accountability. Don't miss this opportunity to learn from leading experts in data-driven investigative journalism and enhance your own reporting skills.

Speakers
avatar for Karrie Kehoe

Karrie Kehoe

Data Journalist, ICIJ
Karrie Kehoe is a data journalist at ICIJ. Previously she investigated health care, human rights, environmental pollution and public expenditure at The Times & Sunday Times newspapers, the Thomson Reuters Foundation, and the RTÉ Investigations unit.
avatar for Jelena Cosic

Jelena Cosic

Training Manager and Eastern European partnership coordinator, ICIJ
Jelena Cosic is ICIJ's training manager and Eastern European partnership coordinator.She prepares and implements training programs on ICIJ platforms, new materials, and documentation, both internally and across the organization’s global reporting network.Prior to joining ICIJ, she... Read More →
avatar for Caroline Desprat

Caroline Desprat

Software developer, ICIJ
Caroline Desprat, France, is a software developer at ICIJ since 2019 where she contributes to the development of journalist-friendly products and tools such as Datashare.


Saturday June 3, 2023 09:30 - 10:45 CEST
C2.25

09:30 CEST

Building a (business) case on data
There is a sharp increase in the number of newly founded public interest or nonprofit journalism organisations. At the same time, they exist in a precarious environment. In order to build a valid business case for these organisations and examine their position, it’s time to move away from anecdotal evidence and scale up research into how independent media organisations fund themselves and what stops them from thriving (legal obstacles to charitable status, for example). Two initiatives have been diving into this type of research, and have gathered data on this new sector. The information they collected can bring greater visibility to this growing market and ultimately help innovative news organisations grow, develop, and better inform their communities in ways that should strengthen their democracies for years to come.

Moderators
avatar for Sanne Schim van der Loeff

Sanne Schim van der Loeff

Managing Director, Arena for Journalism in Europe

Speakers
avatar for Sanne Breimer

Sanne Breimer

Journalism Trainer and Consultant, Sembra Media
Sanne Breimer is a freelance project manager, consultant and journalism trainer for international media organizations, including Sembra Media, Thomson Reuters Foundation (TRF), European Journalism Centre, and the Asia-Pacific Broadcasting Union (ABU). Sanne works remotely and divides... Read More →
avatar for Malte Werner

Malte Werner

Project Manager, Netzwerk Recherche
Former freelance reporter. Now working at Germany's association for investigative journalists, Netzwerk Recherche. We support nonprofit journalism in Germany and Europe with grants, research and knowledge transfer. Building the first peep-to-peer support hotline for journalists suffering from psychosocial problems (only German).Photo: Daniel van Moll... Read More →


Saturday June 3, 2023 09:30 - 10:45 CEST
C2.21

09:30 CEST

The human aspect of FOI
Remember the people in the archives - be nice! Combine FOI work with how you work with and nurture sources. Use SAR and think of GDPR as a tool, not just an obstacle.

Speakers
avatar for Tarjei Leer-Salvesen

Tarjei Leer-Salvesen

Freelancer, Freelance
Tarjei Leer-Salvesen spent this year six months at Reuters Institute in Oxford to learn more about the differences between 136 RTI laws in the world, and how journalists can use cross-border filing for information in their investigations.As he also is a well know international working... Read More →


Saturday June 3, 2023 09:30 - 10:45 CEST
C2.15

09:30 CEST

Follow the Money of European political parties
In 2019, Follow the Money did a thorough investigation into money flows of parties with seats in the European Parliament. This led to some very interesting stories about big tech financing the liberals, American Christian movements feeding into Euroscepticism, etc. For the upcoming elections, we want to repeat this investigation on a bigger scale. Not only do we want to track the money flows from the European parties, but we also want to add to the mix the finances of national parties and politicians linked to the European parliamentary parties. Does the big tech lobby also penetrate politics at the national level? Do religious sponsors find other venues to support pan-European conservative movements? In order to answer these, and other questions, we need to work with journalists from all over Europe. We need to dig into the available national party finance databases, and to investigate the most interesting sponsors. Come to this session to discuss how we can investigate European money flows together!

Speakers
avatar for Adriana Homolová

Adriana Homolová

ARENA / Follow The Money, Netherlands / Slovakia
Adriana is a freelance data journalist, trainer and public spending nerd. She coordinates the data skills training track on the Dataharvest conference and investigates the European Union for Follow The Money Bureau Brussel.
avatar for Lise Witteman

Lise Witteman

investigative journalist EU-topics, Follow the Money
Team lead of the EU desk of investigative journalism platform Follow the Money (ftm.nl/ftm.eu).Our Brussels based team specialises in (data driven) investigations into EU affairs, such as the Recovery Files investigation.In the run up to the European elections of 2024 we have some... Read More →


Saturday June 3, 2023 09:30 - 10:45 CEST
Aula 1

09:30 CEST

Forever Pollution Project: how to practice “peer-reviewed” journalism
They're ingredients of Teflon or Scotchgard: per- and polyfluoroalkyl substances (PFAS), aka “forever chemicals”. They don’t degrade in the environment and can be found in every drop of rain, tap water… or blood. The Forever Pollution Project looked into the magnitude of PFAS contamination in Europe with innovative “peer-reviewed” journalism. As well as collecting dozens of studies monitoring data in water and soil, the team created an original dataset containing tens of thousands of presumptive contamination sites across Europe such as military sites, airports, paper mills or textile factories. To build the first ever Map of Forever pollution in Europe, they adapted methodology developed by a team of scientists to locate PFAS contamination in the United States (with their support). The initial five-country team gathered so much knowledge that they shared it with colleagues from other countries with the clear goal to widen the reach of their work, and to impact continuing European public debate. The final product is a work of journalism that led to major national investigations in several European countries. It also provided regional media companies, impacted community members, citizens, researchers and regulators with a transparent tool to work with and deepen the discussions around one of the biggest environmental problems we currently face.

Speakers
avatar for Catharina Felke

Catharina Felke

Investigative Reporter, German Public Broadcasting
Catharina Felke works as an investigative reporter at German Public Broadcasting NDR/ARD. She uses open source research, data and freedom of information requests to report on social injustice and technology's effect on society. For NDR/ARD, she has also been involved in various cross-border... Read More →
avatar for Eurydice Bersi

Eurydice Bersi

Reporters United / Investigate Europe
I love investigating unaccountable power structures and their impact on people and the environment. Most recently, I took part in the #ForeverPollution project and the #Wasteland, #Untaxed, #SilentDeath, #Derailed investigations. In my previous life, I was a staff writer at the foreign... Read More →
avatar for Stéphane Horel

Stéphane Horel

Journalist, Le Monde
Stéphane Horel works as an investigative journalist for Le Monde. She specializes in corporate lobbying and harm, toxic industries, conflict of interest and scientific disinformation. In early 2023, she supervised the European map of PFAS contamination of the "Forever Pollution Project... Read More →
avatar for Raphaëlle Aubert

Raphaëlle Aubert

Data journalist, Le Monde
I'm a Data Journalist at Le Monde, always keen on learning more about data-driven stories, data analysis, and data-visualization techniques.Bonus point if they're in any way related to maps/GIS or help cover climate change.I've recently worked for the Forever Pollution Project, mostly... Read More →


Saturday June 3, 2023 09:30 - 10:45 CEST
C2.01

09:30 CEST

Save safely! Secure documentation of your web findings
Documenting research, saving findings on the web - a screenshot is not enough! This will become apparent when the opposing lawyer accuses you in court of having forged something with Photoshop (if not before). But even if it doesn't come to that: you should get into the habit of saving research findings, and doing so in a way that will stand up in court. It will also work for you many years later. This workshop will explain what to do and what to look out for

Speakers
avatar for Ude Albrecht

Ude Albrecht

Journalist and researcher, Freelancer
Ude Albrecht is based in Berlin (Germany) and Friesland, works as a freelance journalist, researcher and research-trainer (online-researches, source checking, fact checking and security issues).He writes for several newspapers and magazines, print and online. focusses on structured... Read More →


Saturday June 3, 2023 09:30 - 10:45 CEST
C2.05

09:30 CEST

Working for us: Human trafficking and exploitation in Europe
Healthy, fresh, and tasty food, or culinary creations from around the world can be delivered to our homes or to chic eateries in European cities at the click of a mouse. From classy sushi joints to hip poke bowl start-ups, the European food lifestyle is based on the cheap labor of migrants. The migrant workers in the food industry are unprotected due to inadequate or circumvented labor laws, and the cases of their trafficking and exploitation are rampant in the EU. It doesn´t happen just on farms, but in every corner of our food system - from fishing vessels in the Irish Sea to the restaurant kitchens in Italy. In this session, we'll talk to two journalists who have investigated how European labour markets exploit the desperation of people from third countries. Maria Delaney has followed the journey of Filipino workers to Ireland in hopes of obtaining better working conditions and wages, only to end up at the mercy of a work permission scheme that has been turned upside down. Ismail Einashe has taken a behind-the-scenes look at the modern food industry in Italy, where Bangladeshis - without labor protections and minimum wages - end up in criminal networks and in the hands of human traffickers.

Moderators
avatar for Geesje van Haren

Geesje van Haren

Founder, Lost in Europe
Geesje van Haren established Verspers.nl in 2005. VersPers is a training and publication platform for investigative journalists, with a large network of publication partners and extensive experience in training creative investigative journalism skills. Geesje van Haren initiated and... Read More →

Speakers
avatar for Ismail Einashe

Ismail Einashe

Investigative Journalist
Ismail Einashe is an award-winning investigative journalist and writer who has written for The Guardian, BBC News, Foreign Policy, The Sunday Times, El Mundo, Internazionale and The Nation, among many others. He is a member of Lost in Europe, a cross-border journalism project investigating... Read More →
avatar for Maria Delaney

Maria Delaney

Editor, Noteworthy (Ireland)
Editor of Noteworthy, an Irish crowdfunded investigative journalism platform. Noteworthy supports independent and impactful public interest journalism, allowing in-depth analysis of underreported issues. It is part of The Journal, Ireland's largest native online news outlet, and a member of the European Data... Read More →


Saturday June 3, 2023 09:30 - 10:45 CEST
C2.17

09:30 CEST

We have been SLAPPed!
When the rich and powerful use a lawsuit to bully their critics - rather than to correct an actual wrong - it's called SLAPPs – Strategic Lawsuit Against Public Participation. Journalists, newspapers, activists, whistle-blowers and others are increasingly being targeted with SLAPPs, that try to silence them (and other would-be critics) by burdening them with extra work and the cost of lawyers. Some journalists or media organisations are fighting dozens of SLAPPs at the same time, leaving few resources for journalism.
Meet four colleagues that have been fighting SLAPP cases in Greece, Belgium, Poland and Slovenia: What were the complaints, how did they handle the cases, what lessons can they share, and how did it end?

Speakers
avatar for Anuška Delić

Anuška Delić

founder, Oštro
Based in Slovenia, Anuška Delić is an investigative reporter and founder of Oštro, a non-profit center for investigative journalism in the Adriatic region. In 2021, Oštro established a sister center in Zagreb, Croatia, effectively creating a unique two-headed micro-regional entity... Read More →
avatar for Daniel Simons

Daniel Simons

Senior Legal Counsel Strategic Defence, Greenpeace International Legal Unit
 I serve as treasurer on the board of Arena for Journalism in Europe (the organiser of Dataharvest / EIJC).In my day job, I'm a senior legal counsel at Greenpeace International, responsible for risks arising from campaigns (publications, investigations and protests).In practice... Read More →
avatar for Danuta Pawłowska

Danuta Pawłowska

Gazeta Wyborcza
avatar for Steven Vanden Bussche

Steven Vanden Bussche

journalist, Apache
journalist Apache/ECIJA/European Press Prize 2022/ Public Land | Agriculture & Environment | Local Affairs | FOI & Transparency


Saturday June 3, 2023 09:30 - 10:45 CEST
C2.28

09:30 CEST

How to communicate data so people understand you
Living in an age informed by data means looking at the world through the lens of numbers, science, and statistics. But data doesn’t speak for itself and, as data journalists, our commitment is to convey information to the audience in an effective, trustworthy, and engaging way. So how can we deal with the complexity of the world around us when the ability to read numbers and graphs is not taught at school? In this session, we’ll analyse – with real-life examples – what works and what doesn’t in communicating data, in data visualization and in general. Do bring your own examples, thoughts and ideas to this open session.

Moderators
avatar for Federico Caruso

Federico Caruso

Comms officer and journalist, European Data Journalism Network - OBC Transeuropa

Speakers
avatar for Elisabetta Tola

Elisabetta Tola

founder - science&data journalist, Facta
Science and data journalist, Ph.D in Microbiology.Tow-Knight fellow 2019 Graduate School of Journalism, CUNY. Chief editor at Il BO Live and presenter of Radio3Scienza at RAI Radio3.Co-founder and CEO of the science communication agency formicablu and the independent non-profi... Read More →
avatar for Gianna-Carina Grün

Gianna-Carina Grün

Head of Data-driven Journalism, Deutsche Welle (DW)
Data journalist and Head of Data-driven Journalism at Deutsche Welle (DW), Germany's international media company. Research Fellow & PhD candidate TU Dortmund University. DDJ trainer and coding enthusiast (team Python).With more than ten years of experience and stages in local-, science- and online-journalism, Gianna is particularly f... Read More →
avatar for Catherine André

Catherine André

Deputy-Editor in Chief, Alternatives Economiques
Focus on economic, social and environmental related issues ; strong interest in Europe, democracy and freedom of the press ; infographics and data are great tools to counteract fake news, and help make complex stories more accessible to everyone ; also cofounder and Editorial director... Read More →


Saturday June 3, 2023 09:30 - 10:45 CEST
C2.02

09:30 CEST

Building your first scrollytelling data visualization
Have you ever seen a scrollytelling article and thought you'd like to do something like that? But in the end it all seemed too complicated? If you answered affirmatively to both these questions, this session is for you. We will learn the basics of Svelte, and how it can be combined with no-code tools like Flourish. The aim is to produce interactive long-form articles that use scrollytelling techniques to tell a compelling story. Bring along a dataset, your creativity, and ideas, and you will leave this session with a template to be used whenever you want to publish something that uses the power of scrolling to tell a story. Participants will be able to understand basic ideas of programming for the web and how to use a library to build an interactive scrollytelling experience. To attend this session, prior experience in web development and with Flourish is recommended. Participants should not be strangers to web development technologies, or should at least be interested in starting their path as web developers. All the necessary software will be pre-installed on the school computers. Participants bringing their own laptop will need to install Node.js (https://nodejs.org/en/download), a web browser, and a code editor of their choice.

Speakers
avatar for Krisztián Szabó

Krisztián Szabó

data journalist, Átlátszó, ATLO
I'm a data journalist from Budapest, Hungary at atlatszo.hu, an online investigative news site. I am most experienced using Flourish.studio as I use it on a day to day basis for my work. I also use Google Sheets for making databases/creating databases for live charts and maps. More... Read More →
avatar for Rui Barros

Rui Barros

data journalist, Público
Portuguese data journalist currently working at Público. In a relationship with R, loves to build things on the web. The solo coder in his newsroom, dreaming about the day where he’ll be just one more on a data team, so he doesn't have to debug his code alone.


Saturday June 3, 2023 09:30 - 10:45 CEST
C3.15

09:30 CEST

How to bring structure to unstructured documents without coding
Much of the data we work with as journalists comes in an unstructured or semi-structured format: court judgments, reports, meeting minutes. In this session, we will share strategies and tips for introducing structure from unstructured documents. We will create our own structured dataset from a set of documents. Participants should be comfortable with the spreadsheet operations usch as sorting and filtering. Those using their own laptop will need spreadsheet software (Excel or Google Sheets)

Speakers
avatar for Helena Bengtsson

Helena Bengtsson

Data Journalism Editor, Gota Media
Helena Bengtsson is Data Journalism Editor at Gota Media, a regional publishing company in the south of Sweden with 14 local titles. She previously worked as Editor for Data Journalism at Sveriges Television, Sweden’s national television broadcaster for 27 years and she also served... Read More →
VG

Victoria Gaunitz

Investigative journalist, Sveriges Radio


Saturday June 3, 2023 09:30 - 10:45 CEST
C3.04

09:30 CEST

Personalising the story: how to generate a 100-page website from one dataset using R
The BBC Shared Data Unit is increasingly using R scripts to automatically build 100-page-plus websites to help partners and audiences see what an issue is like in their own area, making it easier to write stories about the data (including custom charts). In this session, you will learn how to generate customised websites in R using ‘parameterisation’, including useful techniques for speeding up the process and generating personalised text, tables and charts. Participants will learn what parameterisation is and where it can be useful journalistically. They will also learn to identify projects where parameterisation can help make data more accessible, and turn a dataset into a website. Participants should have some basic knowledge of R and be comfortable using RStudio. Some knowledge of HTML will be useful, but not essential. You will need a laptop with R and RStudio installed, as well as a web browser.

Speakers
avatar for Paul Bradshaw

Paul Bradshaw

Journalist and Academic, BBC/Birmingham City University
Paul Bradshaw runs the MA in Data Journalism at Birmingham City University and also works as a consulting data journalist with the BBC Shared Data Unit. A journalist, writer and trainer, he has worked with news organisations including The Guardian, Telegraph, Mirror, Der Tagesspi... Read More →


Saturday June 3, 2023 09:30 - 10:45 CEST
C3.11

10:30 CEST

Journalism fair - meet the organisations that support and promote journalism
Join us in the cafeteria to learn about and get inspired by several organisations that, in different ways, help our profession move forward. The organisations are:

  • GIJC - the Global Investigative Journalism Conference
  • GRID-Arendal - a non-profit environmental data communications centre
  • EDJNet - the European Data Journalism Network
  • ECPMF - The European Center for Press and Media Freedom
  • Source Protection Programme - project of the Freedom of the Press Foundation


Saturday June 3, 2023 10:30 - 15:15 CEST

10:45 CEST

Coffee break
Saturday June 3, 2023 10:45 - 11:15 CEST
Cafeteria

11:15 CEST

Töpfer Stiftung (closed meeting)
Saturday June 3, 2023 11:15 - 12:30 CEST
C2.25

11:15 CEST

Suspicion machines: welfare surveillance algorithms revealed
Obscure government algorithms are making life-changing decisions about millions of people around the world - without anyone really knowing how they work. An international team of journalists, coordinated by Lighthouse Reports, gained unprecedented access to one of these "suspicion machines" and revealed the extent of bias encoded within. They obtained Rotterdam’s welfare fraud algorithm and the data used to train it, and found that it discriminates based on ethnicity and gender. Its flaws made the system inaccurate and unfair. In this session, they will reveal the methodology behind their investigation and explain what skills and methods are needed in order to report on such algorithms and their hidden biases.

Moderators
avatar for Gabriel Geiger

Gabriel Geiger

Investigative Journalist, Lighthouse Reports
Gabriel is an investigative journalist with Lighthouse Reports. He specializes in surveillance and algorithmic accountability reporting and most recently was the lead reporter on Lighthouse Reports' Suspicion Machines investigation. His work often combines traditional reporting methodologies... Read More →

Speakers
avatar for Romy van Dijk

Romy van Dijk

Investigative journalist
Romy is a Dutch investigative journalist. She has worked with Vers Beton, Platform Investico and De Groene Amsterdammer on various subjects, ranging from temporary housing contracts to drought and watermanagement in the Netherlands. She has a special interest in data, tech and AI... Read More →
avatar for Justin-Casimir Braun

Justin-Casimir Braun

Data Reporter, Lighthouse Reports, Germany
Justin is a data journalist focused on the societal impact of automated systems and artificial intelligence. In the past, Justin has worked with AlgorithmWatch e.V., a German digital rights organization, and various grassroots NGOs, documenting human rights violations against migrants... Read More →
avatar for Evaline Schot

Evaline Schot

Evaline Schot is a Netherlands-based investigative journalist specialised in social affairs reporting and the use of data in the public sector. Over the past two years, she has collaborated with Lighthouse Reports to investigate the use of algorithms within welfare systems and their... Read More →


Saturday June 3, 2023 11:15 - 12:30 CEST
Aula 1

11:15 CEST

Futureproof your investigation with the whole team
When we start a big data driven investigation we don't always know how it will develop - but we can have a good guess. And so can key members of our team, whether editorial or technical. Semir Mujkic from BIRN Bosnia & Herzegovina talks about two big live investigations, on tracking government spending on luxury cars, and on mapping hate, where it paid to think where things would go - and where the techies' input was as vital as the journalists’.

Moderators
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)

Speakers
avatar for Semir Mujkić

Semir Mujkić

Managing editor, BIRN Bosnia and Herzegovina
Semir Mujkic is managing editor for BIRN Bosnia and Herzegovina. He joined BIRN in April 2017 and has worked as a journalist and deputy editor for BIRN BiH website Detektor.ba where he is managing editor as of October 2019. Semir led a newsroom when it won the 2020 European Press... Read More →


Saturday June 3, 2023 11:15 - 12:30 CEST
C2.23

11:15 CEST

Missing data: An updated map of femicides in Europe
The high rate of murder of women at the hands of men is a well-known issue. But current data are missing, making it difficult to report the phenomenon or to adopt policies to mitigate it effectively. The Mediterranean Institute for Investigative Reporting (MIIR) and partners of the European Data Journalism Network (EDJNet) from various countries investigated the state of femicide and violence against women in Europe. The goal was to create an updated map of Europe, documenting where an violence (physical, psychological, sexual, economic) against women increased during the pandemic, and examining the effectiveness of prevention mechanisms and sentencing policies. Come and hear how the team tackled the complexity of the story, the challenges of comparing different national statistics on crime, and the problem of missing data.

Speakers
avatar for Maria Álvarez del Vayo

Maria Álvarez del Vayo

Data journalist, Civio
avatar for Thanasis Troboukis

Thanasis Troboukis

Journalist & Project Manager, IMEDD Lab
Thanasis Troboukis is a journalist and Project Manager at iMEdD Lab. He has worked as a reporter and editor in Chief for some of the most successful Greek media. He set up the office of VICE Media in Greece, where he served as the Head of Content. His investigation about child trafficking... Read More →
avatar for Janine Louloudi

Janine Louloudi

Investigative journalist, MIIR & Reporters United
An investigative journalist and producer based in Athens, with experience in the field of documentary and news-production.  With the Mediterranean Institute for Investigative Reporting (MIIR) since 2019, and most recently with the Reporters United network, I have been experimenting... Read More →


Saturday June 3, 2023 11:15 - 12:30 CEST
C2.07

11:15 CEST

How to balance costs and (digital) safety
It’s becoming increasingly important to make sure your (investigative) newsroom is safe from digital attacks by state actors, pressure groups and individuals. You need to focus on the human aspect of safety, rather than the technical measures. Creating an open and safe working space, where people dare to admit they made a mistake, is much more effective than any technical solution. In this session you will get tips and advice on how to make it work.

Speakers

Saturday June 3, 2023 11:15 - 12:30 CEST
C2.21

11:15 CEST

Three years of European housing investigation: A guide
How many square meters do you live in? Was it difficult to find? If so, you're not alone. Housing has become one of the biggest issues for many in Europe's capitals. This is not only due to urbanisation and migration to urban areas; real estate has become one of the most attractive investment opportunities – and it's becoming increasingly global. We started to investigate housing and its economic actors in 2018. By 2019, our investigation went Europe-wide. Now we have published hundreds of articles with the media partners in our network of urban journalists. The network is a continuation of the investigation "Cities for Rent", a collaborative project investigating corporate landlords in Europe. It was prompted by the Arena Housing Project, and created following the Dataharvest conference in 2019. Today, we are still pushing the housing investigation forward. We can show where to start. In this hands-on session we focus on what we have learned and on the mistakes we have made. We will also present you with the data on housing, and explain which data are hard to find.

Speakers
avatar for Sotiris Sideris

Sotiris Sideris

Data Editor, Reporters United, CCIJ
Sotiris Sideris is a data journalist, trainer, and project manager with extensive cross-border and collaborative experience.He is the data editor of Reporters United and the Center for Collaborative Investigative Journalism (CCIJ), and co-founder of AthensLive. He also serves as a... Read More →
avatar for Hendrik Lehmann

Hendrik Lehmann

Head, Tagesspiegel Innovation Lab
Hendrik Lehmann is Head of Tagesspiegel Innovation Lab and coordinating a European network for urban journalism. Him and the Lab work with investigative data analysis, dataviz and interactive web applications. They also try hard to make use of AI for investigative research and editorial... Read More →
avatar for Gaby Khazalová

Gaby Khazalová

reporter, Deník Referendum
reporter working for the Czech online daily Deník Referendum.


Saturday June 3, 2023 11:15 - 12:30 CEST
C2.01

11:15 CEST

Scrutinising EU funds in your country: how to find the data you need
When people speak of "EU money", they often mean decentralized EU funds in their country. The funding landscape is complex, and journalists reporting on those funds walk a tightrope between precision and jargon. In this two-part session, Daiva and Zoltán will introduce you to the complex world of decentralized EU funds. Firstly, using their experience, they will present tools and mechanisms for investigating what has been funded with the funds in your country. Secondly, they will discuss storytelling aspects and caveats when it comes to translating EU jargon into compelling narratives. You can find their joint project here:  https://www.journalismfund.eu/supported-projects/cinderella-cyclists, Daiva's reporting on biodiversity funding here: https://www.daivarepeckaite.com/en/media-portfolio/chainsaw-landscaping-collaborative-project-on-biodiversity-funding-used-to-cut-trees-in-trakai/
and Zoltán's reporting on Interreg funds here: https://atlatszo.ro/kozpenzek/eu-penzek/sikersztori-szovatan-vegyesboltbol-luxuspanziot-fejleszt-peter-ferenc-csaladi-cege/ and here https://atlatszo.ro/kozpenzek/eu-penzek/novak-levente-rmdsz-ugyvezeto-alelnok-panzioja-nyaradszereda/




Speakers
avatar for Zoltán Sipos

Zoltán Sipos

Editor-in-Chief, Átlátszó Erdély
Zoltán SIPOS is the manager and editor-in-chief of Átlátszó Erdély (atlatszo.ro), an investigative journalism outlet focusing on issues regarding the 1,2 million Hungarian community living in Transylvania, Romania... Read More →
avatar for Daiva Repečkaitė

Daiva Repečkaitė

Freelance
Investigative journalist from Lithuania, based in Malta. Covering environment, health and inequalities. Published in Financial Times, Foreign Policy, Politico, the Guardian, Deutsche Welle. Prix Europa 2022 co-nominee. Policy Leader Fellow 2023 at the European University Institu... Read More →


Saturday June 3, 2023 11:15 - 12:30 CEST
C2.05

11:15 CEST

Labour in Europe - research on the ground and in the EU institutions
Labour laws all over Europe follow the European legislation decided in Brussels, but national laws and regulations are also important. Adina Florea is a journalist and has covered migration from Asia into Romania, as well migration of Romanians toward Western Europe. She has met many workers and researched the labour conditions they work in. Alina Lippegaus is a lawyer with the German workers' support organisation, Fair Labour, which offers advice to migrants coming into Germany, and deals with legal issues they face. Paula Soler follows the developments in the labour market from the EU angle, and the topics discussed among the EU lawmakers. The three panelists will share their expertise, and together they will paint a broader picture. How is the European labour market regulated, and labour regulation implemented? What are the current gaps and shortcomings of labour legislation? And how can we investigate them? Together we will unravel the European jargon, and look into structural issues in order to better understand the underlying labour issues across Europe.

Moderators
avatar for Eurydice Bersi

Eurydice Bersi

Reporters United / Investigate Europe
I love investigating unaccountable power structures and their impact on people and the environment. Most recently, I took part in the #ForeverPollution project and the #Wasteland, #Untaxed, #SilentDeath, #Derailed investigations. In my previous life, I was a staff writer at the foreign... Read More →

Speakers
avatar for Alina Lippegaus

Alina Lippegaus

Legal Advisor, Faire Mobilität
Fair MobilityAims to support mobile workers from Central and Eastern EU Member States in enforcing their rights to fair wages and working conditions on the German labour market.Means are advisory services and support for mobile employees in their native languages. Production and... Read More →
avatar for Adina Florea

Adina Florea

Freelance Journalist
I have been working as a journalist since 2015, with a focus on labour and migration, breaking stories on abusive working conditions faced by Romanian workers in the Netherlands, as well as by those who come to replace them back in Romania. Currently, I'm a freelancer moving from... Read More →


Saturday June 3, 2023 11:15 - 12:30 CEST
C2.17

11:15 CEST

Arena Food & Water meeting: Let’s talk about future investigations!
It has been a year since the Arena Food & Water Network met for the first time at Dataharvest 2022. Since then, network members have come together and organized various meetings to discuss their investigations and research methods and to find colleagues across Europe for future projects.

The Arena Food & Water Network is an open network by journalists for journalists with the aim of bringing together journalists as well as researchers and civil society representatives interested in reporting on our waters and food systems.

Shared efforts of the network over the past year included updating the farm subsidies database and revealing who benefits from the billions spent on the EU’s Common Agricultural Policy. As well as the Forever Pollution Project, a cross-border investigation into ‘Forever Chemicals’ mapping the extent of the PFAS pollution in Europe.
Now we want to take the opportunity to meet again in person to discuss what urgently needs to be put on the European agenda, unexplored and underreported research areas around food and water, and ideas for collaborations across Europe.

Everyone interested – old and new to Arena’s Food & Water Network – is warmly invited to join the round!

Speakers
avatar for Sarah Pilz

Sarah Pilz

Project coordinator, Arena for Journalism in Europe
Sarah is a freelance journalist based in Germany working in cross-border teams and coordinating the Arena Food & Water Network.
avatar for Brigitte Alfter

Brigitte Alfter

Director, Arena for Journalism in Europe
Brigitte Alfter ist eine deutsch-dänische Journalistin, Geschäftsführerin für Redaktionelles bei Arena for Journalism in Europe und Dozentin Journalismus an der Universität Göteborg. Nach Jahren als Journalistin auf fallen Niveaus vom Lokaljournalismus bis zur EU-Korrespondentin... Read More →
avatar for Zeynep Sentek

Zeynep Sentek

Project director, Climate Network, Arena for Journalism in Europe
Zeynep Sentek is a Turkish investigative journalist specialising in corruption, offshore structures, human rights, and the environment. She is now leading the climate network of Arena for Journalism in Europe. In this network, Arena facilitates journalists to do cross-border climate... Read More →


Saturday June 3, 2023 11:15 - 12:30 CEST
C2.15

11:15 CEST

How to avoid SLAPP lawsuits – and what to do if you get them anyway
Powerful individuals, companies or authorities increasingly try to stop critical coverage with SLAPPs – Strategic Lawsuits Against Public Participation. How big is the problem, how can you avoid being targeted – and what can you do if you get SLAPPed? The session will discuss steps you can take during research to make yourself less vulnerable. We will hear how journalism organisations and other NGOs are fighting back through the Coalition Against SLAPPs in Europe (CASE), and about the new initiative Reporters Shield, set up by the OCCRP and Cyrus R. Vance Center, to provide legal and financial support for journalists who are at risk of or facing SLAPPs.

Speakers
avatar for Daniel Simons

Daniel Simons

Senior Legal Counsel Strategic Defence, Greenpeace International Legal Unit
 I serve as treasurer on the board of Arena for Journalism in Europe (the organiser of Dataharvest / EIJC).In my day job, I'm a senior legal counsel at Greenpeace International, responsible for risks arising from campaigns (publications, investigations and protests).In practice... Read More →
avatar for Emma Prest

Emma Prest

Chief Product Officer, OCCRP
Emma Prest is the chief product officer at OCCRP. She is responsible for the strategy and execution of OCCRP’s digital products, including its website, and tools for journalists, such as its investigative data platform OCCRP Aleph. She focuses on improving reader engagement and... Read More →
avatar for Rebecca Bonello Ghio

Rebecca Bonello Ghio

Projects & Comms Assistant, European Federation of Journalists (EFJ)
Rebecca Bonello Ghio works at the European Federation of Journalists (EFJ), which is the largest representative of the profession in Europe with around 250,000 journalists from 73 journalists' organisations from across 45 countries. She has experience coordinating large civil society... Read More →


Saturday June 3, 2023 11:15 - 12:30 CEST
C2.28

11:15 CEST

A simple scraper using Python
Step by step, the participants will write their own scraper. With the help of such simple scrapers, journalists can collect a lot of data on their own and use it in their stories. Participants will learn how to write their own scrapers using Python. To attend this session, no prior knowledge is required. Tools needed, if bringing your own laptop, are Python and Anaconda.

Speakers
avatar for Karrie Kehoe

Karrie Kehoe

Data Journalist, ICIJ
Karrie Kehoe is a data journalist at ICIJ. Previously she investigated health care, human rights, environmental pollution and public expenditure at The Times & Sunday Times newspapers, the Thomson Reuters Foundation, and the RTÉ Investigations unit.
avatar for Alesya Marokhovskaya

Alesya Marokhovskaya

The Head of the Data Department, Investigative and Data Reporter, IStories
Investigative and data reports at Important Stories (www.istories.media). You can contact Alesya by mail alesya.marohovskaya@istories.media.Awards:The Sigma Awards 2022 (Important Stories)Winner of the European Press Prize 2021 in the investigation category (Important Stories)The... Read More →


Saturday June 3, 2023 11:15 - 12:30 CEST
C3.15

11:15 CEST

Introduction to R and RStudio
Working in a spreadsheet can get messy and confusing, especially if you have a very large dataset and need to perform many operations. You have to document each step to be able to repeat the same analyses later on. R solves that problem. With a few simple lines of code you can import, clean, sort, filter, group-by and ask your data questions in a clear workflow that can easily be changed, repeated and shared. The learning curve for R is quite steep, so this session aims to get you familar with R and RStudio (the most frequently used interface with the R language) and the key concepts you need to get started. No software installation is required for this session - but it will be useful for participants to create a free RStudio Cloud account (https://posit.cloud/) whether they intend to use a school computer or their own laptop.

Speakers
avatar for Robert Gebeloff

Robert Gebeloff

Reporter, New York Times
Robert Gebeloff has worked as a data projects reporter for The New York Times since 2008 and has taught data journalism for many years in newsrooms and at conferences. He was co-winner of the George Polk Award in 2015 and was a Pulitzer Prize finalist in both 2015 and 2016 for projects... Read More →
avatar for Luuk Sengers

Luuk Sengers

Journalist & trainer, Story-Based Inquiry Associates / De Groene Amsterdammer
Luuk is an independent investigative journalist, lecturer, trainer and mentor. For the leading Dutch magazine De Groene Amsterdammer he writes about the effects of corporate power on our environment and climate, based on data-analysis. He also teaches research skills, data journalism and interview techniques to professionals and students and helps media and NGOs organise and carry out investigative projects. He... Read More →


Saturday June 3, 2023 11:15 - 12:30 CEST
C3.11

11:15 CEST

Spreadsheets: the basics
This introductory course is not about software, heavy number crunching or coding. It's about developing what we call a "data state of mind." You will see how working with data is similar to any other form of reporting, and we will cover basic concepts that will help you identify opportunities for incorporating data work into your reporting. You will come away with a solid understanding of basic data journalism concepts and will be prepared to learn more. Following this section participants will be able to import data from a csv/xls/xlsx file, add/delete rows, filter, sort, calculate percentages, percentage change and use basic formulas to sum, count items (numbers and non-numbers) and find the average, as well as other spreadsheet essentials. No prior knowledge is required. This is a hands-on session, so participants should bring their laptop. The lesson is taught through Google Sheets but translates to Excel: participants will therefore need access to a Google account (or should set up a temporary account before class).

Speakers
avatar for Pamela Duncan

Pamela Duncan

Data journalist, The Guardian
Pamela Duncan is acting editor of the Guardian’s Data Projects team, leading a small (but utterly amazing) team of data journalists/nerds, mining data for news stories, investigations and interactive features. She admits to having a (perhaps unhealthy) love for discovering new formulas... Read More →
avatar for Carmen Aguilar Garcia

Carmen Aguilar Garcia

Data Journalist, The Guardian
Data journalist at The Guardian Data Project team. I work on a variety of subjects - always finding the data angle in every story. Scraping, cleaning, data analysis, but above all JOURNALISM!


Saturday June 3, 2023 11:15 - 12:30 CEST
C3.04

12:30 CEST

Lunch
Saturday June 3, 2023 12:30 - 13:30 CEST
Cafeteria

13:30 CEST

Scraping with R
Although R was designed as a statistical analysis tool it has grown to include many other solutions - including scraping. We will look at loading data from static and dynamic websites into R for further analysis, in a session designed to demystify scraping. No software installation is required for this session - but it will be useful for participants to create a free RStudio Cloud account before the session (https://posit.cloud/) whether they intend to use a school computer or their own laptop.

Speakers
avatar for Robert Gebeloff

Robert Gebeloff

Reporter, New York Times
Robert Gebeloff has worked as a data projects reporter for The New York Times since 2008 and has taught data journalism for many years in newsrooms and at conferences. He was co-winner of the George Polk Award in 2015 and was a Pulitzer Prize finalist in both 2015 and 2016 for projects... Read More →
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)
avatar for Luuk Sengers

Luuk Sengers

Journalist & trainer, Story-Based Inquiry Associates / De Groene Amsterdammer
Luuk is an independent investigative journalist, lecturer, trainer and mentor. For the leading Dutch magazine De Groene Amsterdammer he writes about the effects of corporate power on our environment and climate, based on data-analysis. He also teaches research skills, data journalism and interview techniques to professionals and students and helps media and NGOs organise and carry out investigative projects. He... Read More →


Saturday June 3, 2023 13:30 - 13:45 CEST
C3.11

13:30 CEST

How to fund journalism better
Investigative journalism in Europe depends a lot on grants and financial support from foundations. But do grants support the right things and in the right way? What are the trends in the funding landscape? Are funders steered towards hype and the so-called ‘donor darlings'? The Journalism Funders Forum invites you to an open discussion about their activities, and how they may better serve independent journalism. Some questions to address: are funders accessible and clear about the criteria they use in choosing whom to support? Should funders identify under-covered topics and provide special grants – or just put fewer restrictions in place? In short - how can funders better support independent investigative journalism in Europe?

Speakers
avatar for Daniela White

Daniela White

Program Manager, OSF
avatar for Ebru Akgun

Ebru Akgun

Public Interest Programme Manager, Adessium Foundation
Ebru, currently in the role of Public Interest Programe Manager, joined Adessium Foundation in November 2021. Adessium Foundation is a private and independent grant making foundation, based in the Netherlands. It aspires to a society that encourages people to live in harmony with... Read More →
avatar for Abhijit Das

Abhijit Das

As programme director at Stichting Democratie en Media, Abhijit is responsible for the foundation’s grant-making and partner support programmes. The Amsterdam-based foundation is fully independent and has a history tracing back to the illegal Dutch resistance newspaper Het Parool. Stichting... Read More →
avatar for Willem Lenders

Willem Lenders

Program Manager, Limelight Foundation
Limelight Foundation is an independent philanthropic foundation, based in the Netherlands. We support journalism and civil society organizations that are committed to a strong and free information ecosystem in the digital age. As a program manager my role is to build our portfolio... Read More →


Saturday June 3, 2023 13:30 - 14:45 CEST
C2.01

13:30 CEST

Managing chaos: Huge leaks, huge headaches
10 months, a dozen countries, 50 journalists, terabytes of data, hundreds of companies and thousands of documents. Collaborative cross border investigations can be BIG. This session will unpack how we do it. We will look at the processes of how we coordinate these unruly projects.
We will touch on how we go about handling and sharing multi-terabyte data sets, the types of information security challenges we face, and how we keep track of all the leads and findings. We will be frank about our missteps, and share the tips and tricks we’ve learnt for taming the chaos and the reporters.

Moderators
avatar for Emma Prest

Emma Prest

Chief Product Officer, OCCRP
Emma Prest is the chief product officer at OCCRP. She is responsible for the strategy and execution of OCCRP’s digital products, including its website, and tools for journalists, such as its investigative data platform OCCRP Aleph. She focuses on improving reader engagement and... Read More →

Speakers
avatar for Jelena Cosic

Jelena Cosic

Training Manager and Eastern European partnership coordinator, ICIJ
Jelena Cosic is ICIJ's training manager and Eastern European partnership coordinator.She prepares and implements training programs on ICIJ platforms, new materials, and documentation, both internally and across the organization’s global reporting network.Prior to joining ICIJ, she... Read More →
avatar for Jan Strozyk

Jan Strozyk

Investigative Reporter / Data Journalist, OCCRP
Based in Germany, Jan Strozyk joined OCCRP in 2021 as data editor before becoming chief data editor in 2022. Jan co-leads OCCRP’s research and data team alongside Head of Research Karina Shedrofsky. He works closely with our editorial and the data teams, coordinating data analysis... Read More →
avatar for Paulo Pena

Paulo Pena

Journalist, Investigate Europe
Based in Lisbon, a member of Investigate Europe since 2016, I worked in several newsrooms since 1998 (Visão, Público, Diário de Notícias) and wrote 3 non-fiction books.


Saturday June 3, 2023 13:30 - 14:45 CEST
C2.25

13:30 CEST

Hackday findings: The inequalities of work and wage
Data wizards and wranglers will present what they found on the pre-conference Hackday in the extensive collection of Eurostat surveys on occupational health and safety, on the structure of earnings or in the latest Eurofound survey on working conditions with over 70.000 respondents.
But not all will be about numbers and spreadsheets, but also about patterns. We want to bring to this session compelling visualisations that show in pretty shapes and colours what is not so pretty at all – the inequalities in work and wage in Europe.
Finally, we would like to brainstorm with all of you based on the results and analysis of the different data sources: Which European stories need to be told and how can we do it?


Saturday June 3, 2023 13:30 - 14:45 CEST
C2.05

13:30 CEST

Rural Observatory: let´s look into the EU data on rural areas (and find stories)
In 2019, the European Commission committed to improving rural life and closing the rural-urban divide. To this end, it has launched the EU Rural Observatory: a rural database with data & indicators to monitor rural trends at the EU level and with a greater level of detail. In this session, we will explain you what data can be found in the EU Rural Observatory and on related platforms (e.g., the GRANULAR platform). We will also discuss how you can use this data to find new unreported stories, so be ready to bring your own ideas and find potential collaborators! 

Speakers
avatar for Jose Miguel Calatayud

Jose Miguel Calatayud

Freelance journalist and writer
I am a freelance journalist and writer based in Berlin since January 2020, currently focusing on feature writing and investigative journalism, mainly about Europe. I am the co-initiator and the coordinator of the cross-border project Cities for Rent: Investigating Corporate Landl... Read More →
avatar for Carla Lostrangio

Carla Lostrangio

Rural and Territorial Development Expert, AEIDL - European Association for Innovation in Local Development
Carla Lostrangio works as Rural and Territorial Development Expert at AEIDL- the European Association for Innovation in Local Development. She is a passionate observer of rural development models, strategies and narratives. She collaborates in several European funded projects on rural... Read More →


Saturday June 3, 2023 13:30 - 14:45 CEST
C2.23

13:30 CEST

Doing it all - combining skills in (small) teams
When working on investigative stories you need expert knowledge on various topics. Your newsroom needs to be both ‘nerd’ and expert on the topic at hand, while at the same time it needs to act like a pitbull when it comes to journalistic perseverance. But what is the best way to combine these very different requirements: working together in a team where multiple skills are present, or making sure that everyone in the team has multiple skill sets? Different organisations opt for different models.

Moderators
avatar for Sanne Schim van der Loeff

Sanne Schim van der Loeff

Managing Director, Arena for Journalism in Europe

Speakers
avatar for Steffen Kühne

Steffen Kühne

Tech Lead, Bayerischer Rundfunk
Tech Lead AI + Automation Lab and BR Recherche / BR Data at Bayerischer Rundfunk. Data journalist and interactive developer, specialized in data analysis, visualization and storytelling.
avatar for Dan Kåre Engebretsen

Dan Kåre Engebretsen

Editorial leader, NRK
Dan Kåre is an award winning datajournalist and editorial leader formerly at VG, now at NRK. Enjoys a great dataset, and getting digital journalism into the newsrooms together with great digital storytelling.
avatar for Thomas Muntz

Thomas Muntz

Thomas Muntz is editor-in-chief of Investico, an independent platform for investigative reporting in the Netherlands. Investico is a non-profit that focuses on investigative journalism in collaboration with Dutch and international media. As a investigative journalist Thomas has reported... Read More →


Saturday June 3, 2023 13:30 - 14:45 CEST
C2.21

13:30 CEST

Europe's Missing Emails
Governments from Germany to Finland, along with the European Commission delete emails en masse, sometimes removing complete e-mail accounts - after a minister leaves their role, for example. This can infringe on the right of citizens - including journalists - to get access to documents. A group of journalists from across Europe are now documenting this. And they are looking for more participants.

Speakers
avatar for Staffan Dahllöf

Staffan Dahllöf

Reporter, Investigative Reporting Denmark
Eager to discuss any matter related to EU-reporting, especially FOI/Wobbing-issues. Have taken part in crossborder project Farmsubsidy.org, the Facebook arrests the MEP's Project, Chlorpyrifos (the most dangerous pesticide you've never heared of), Illegal pesticide + ongoing Covid... Read More →
avatar for Hans-Martin Tillack

Hans-Martin Tillack

Investigative reporter, Welt
Hans-Martin Tillack works as an investigative reporter for the newspapers "Welt", "Welt am Sonntag" and the TV magazine "Report München" (public broadcaster ARD). Until 2021 he was an investigative reporter for the weekly magazine "Stern". From 1999 to 2004 he was the EU correspondent... Read More →
avatar for Peter Teffer

Peter Teffer

Investigative journalist, Follow the Money


Saturday June 3, 2023 13:30 - 14:45 CEST
C2.02

13:30 CEST

Friend or foe: using AI as an investigative tool
Artificial intelligence is transforming the way we approach journalism. While there are concerns that AI might "steal" journalists´ jobs, many newsrooms are experimenting with the use of AI to improve their work. From fact-checking political claims to automatically identifying gender online or analyzing political speeches...there are various ways in which journalists can use artificial intelligence. In this panel, we will look into how AI can help find the story and make journalistic work easier. We´ll also examine how chatGPT is already being used by some newsrooms, and touch on the questions around the limitations of AI and the risk of the big tech. 

Moderators
avatar for Carmen Aguilar Garcia

Carmen Aguilar Garcia

Data Journalist, The Guardian
Data journalist at The Guardian Data Project team. I work on a variety of subjects - always finding the data angle in every story. Scraping, cleaning, data analysis, but above all JOURNALISM!

Speakers
avatar for Joseph Smith

Joseph Smith

Staff Software Engineer, The Guardian
Joseph Smith is a software engineer who has spent the last four years working on investigative and data journalism projects at the Guardian. These include the Pandora Papers, the "UK For Sale" series on offshore-owned property, investigations into PPE procurement during the pandemic... Read More →
avatar for Ude Albrecht

Ude Albrecht

Journalist and researcher, Freelancer
Ude Albrecht is based in Berlin (Germany) and Friesland, works as a freelance journalist, researcher and research-trainer (online-researches, source checking, fact checking and security issues).He writes for several newspapers and magazines, print and online. focusses on structured... Read More →
avatar for Alexander Fanta

Alexander Fanta

netzpolitik.org
Alexander berichtet als EU-Korrespondent von netzpolitik.org über die Digitalpolitik der Europäischen Union. Er schreibt über neue Gesetze und recherchiert investigativ über große Technologiekonzerne und ihr Lobbying. Er ist Ko-Autor der Studie "Medienmäzen Google" über Journalismusförderungen... Read More →
avatar for Paul Bradshaw

Paul Bradshaw

Journalist and Academic, BBC/Birmingham City University
Paul Bradshaw runs the MA in Data Journalism at Birmingham City University and also works as a consulting data journalist with the BBC Shared Data Unit. A journalist, writer and trainer, he has worked with news organisations including The Guardian, Telegraph, Mirror, Der Tagesspi... Read More →
avatar for Irene Larraz

Irene Larraz

Fact-checking and Data teams coordinator, Newtral
I coordinate the Fact-checking and Data teams at Newtral, where I also lead Newtral Educación, the media literacy branch. We are focused on innovative journalism through fact-checking and data visualization. I have worked on the team for three years, and previously I worked for ten... Read More →


Saturday June 3, 2023 13:30 - 14:45 CEST
Aula 2

13:30 CEST

How to find sources, offline and online
What if you know there is a story out there, but you are struggling to find sources to talk to? Have you worked on a sensitive story where your sources were elusive and it was hard to persuade them to confide in you? In this session, we are going to look at some of the approaches journalists use to find sources and connect with them, and discuss their benefits and limitations. Geesje van Haren (Lost in Europe) will highlight the importance of spending enough time in the field and finding creative ways of connecting with the sources she and her team have used in their investigations on underaged refugee communities in Europe. We will also explore different approaches to finding sources online and talk about the advantages and disadvantages of working with "intermediaries" (e.g. NGOs, official sources...).

Moderators
avatar for Zeynep Sentek

Zeynep Sentek

Project director, Climate Network, Arena for Journalism in Europe
Zeynep Sentek is a Turkish investigative journalist specialising in corruption, offshore structures, human rights, and the environment. She is now leading the climate network of Arena for Journalism in Europe. In this network, Arena facilitates journalists to do cross-border climate... Read More →

Speakers
avatar for Nicola Naber

Nicola Naber

Investigative Reporter, DER SPIEGEL
Works for DER SPIEGEL in Hamburg since 2006. Focused on white collar crime. Board member of European Investigative Collaborations.
avatar for Tatev Hovhannisyan

Tatev Hovhannisyan

Europe and Eurasia Editor, openDemocracy
Based in Armenia, Tatev Hovhannisyan is openDemocracy’s Europe and Eurasia editor on our Tracking the Backlash project. She is an investigative journalist with a particular interest in tracking attacks on universal human rights and investigating the funding of anti-gender movements... Read More →
avatar for Geesje van Haren

Geesje van Haren

Founder, Lost in Europe
Geesje van Haren established Verspers.nl in 2005. VersPers is a training and publication platform for investigative journalists, with a large network of publication partners and extensive experience in training creative investigative journalism skills. Geesje van Haren initiated and... Read More →


Saturday June 3, 2023 13:30 - 14:45 CEST
C2.15

13:30 CEST

How to work with traumatized sources
How do you work with vulnerable sources - people traumatised by war, by having to flee, or by sexual violence? Few journalistic tasks are as important and as ethically challenging as the coverage of migration, modern slavery, and (sexual) exploitation. Too often, survivors are seen only as victims, when they are actually the key witnesses to major events that are not properly documented in the paper trails that journalists are accustomed to working with. In this joint session with the Dart Center for Journalism and Trauma and the investigative platform Lost in Europe, Gavin Rees, Ismail Einashe & Sanne Terlingen will talk about creating a safe environment, building trust and minimizing re-traumatization. They will also look at how to verify the stories you hear, and how to remain sane yourself.

Moderators
avatar for Gavin Rees

Gavin Rees

Senior Advisor for Training and Innovation, Dart Center for Journalism and Trauma
Gavin Rees is Senior Advisor for Training and Innovation at the Dart Center for Journalism and Trauma. Since 2008 he has been working as a trauma awareness consultant and trainer for newsrooms, media-support organisations, and journalism schools across Europe as well as internati... Read More →

Speakers
avatar for Sanne Terlingen

Sanne Terlingen

Founder, Lost in Europe
Sanne Terlingen is an award winning investigative journalist from The Netherlands, specialized in organized sexual violence, (early childhood) trauma, migration, people smuggling and trafficking. She currently works as head of investigations at Lost in Europe, a cross border investigative... Read More →
avatar for Ismail Einashe

Ismail Einashe

Investigative Journalist
Ismail Einashe is an award-winning investigative journalist and writer who has written for The Guardian, BBC News, Foreign Policy, The Sunday Times, El Mundo, Internazionale and The Nation, among many others. He is a member of Lost in Europe, a cross-border journalism project investigating... Read More →


Saturday June 3, 2023 13:30 - 14:45 CEST
C2.07

13:30 CEST

Researching the arms lobby
In the last couple of years, the EU has become increasingly active as a military actor, for the first time spending billions of euros on defence programmes. With the war in Ukraine, the EU is set become even more active in this area. Researchers and journalists have highlighted the role of the arms lobby in this process and warned about the ever closer connections between the industry and EU institutions. At the same time, information is hard to get by for reasons of “national security”. In this workshop we will highlight some tips and tricks on how to research the arms lobby.

Speakers
avatar for Bram Vranken

Bram Vranken

Researcher and campaigner, Corporate Europe Observatory


Saturday June 3, 2023 13:30 - 14:45 CEST
C2.28

13:30 CEST

On the ground – learning from a workers’ aid group in Germany
Journalists are not the only ones in touch with exploited workers. In Germany, trade unions offer support via the Fair Mobility Project, through which they reach out to workers on the ground. Fair Mobility has decided on a number of top priority sectors they focus on. This session will be presented by Alina Lippegaus from Berlin, a lawyer who works on the ground in Germany, one of the major destination countries for intra-European labour migration. Alina will talk about the problems they observe in the field, and will explain us how they reach out to the workers and what journalists can learn from their work. We will also hear about the legal challenges and opportunities such workers face.

Moderators
avatar for Brigitte Alfter

Brigitte Alfter

Director, Arena for Journalism in Europe
Brigitte Alfter ist eine deutsch-dänische Journalistin, Geschäftsführerin für Redaktionelles bei Arena for Journalism in Europe und Dozentin Journalismus an der Universität Göteborg. Nach Jahren als Journalistin auf fallen Niveaus vom Lokaljournalismus bis zur EU-Korrespondentin... Read More →

Speakers
avatar for Alina Lippegaus

Alina Lippegaus

Legal Advisor, Faire Mobilität
Fair MobilityAims to support mobile workers from Central and Eastern EU Member States in enforcing their rights to fair wages and working conditions on the German labour market.Means are advisory services and support for mobile employees in their native languages. Production and... Read More →


Saturday June 3, 2023 13:30 - 14:45 CEST
C2.17

13:30 CEST

Network analysis: make sense of all that data you have
Learn how to make sense of big datasets where people, companies or other entities have some sort of a relationship with each other. Think about mapping followers and interactions in online communities, cryptocurrency transactions or contract awards between governments and companies.
With the help of network analysis tools you can make a mysterious web of "friends of friends of friends" into colorised groups describing the social and professional context of your subject. In this hands-on session, we will be using Gephi and it's built-in algorithms with real-world data. By the end of the session, the participants will be familiar with the basics of network analysis as a concept and with Gephi as a tool.


To attend this session, no prior knowledge is required.

If working on your own computer, you need to have Gephi installed, see instructions and a tutorial if you are interested!

Speakers
avatar for Oksana Stavniichuk

Oksana Stavniichuk

Investigative Data Developer, OCCRP
avatar for Lasse Edfast

Lasse Edfast

Documentary producer and data researcher, Freelance
Documentary producer, researcher and data journalist. I'm be happy to help you with your Python project.


Saturday June 3, 2023 13:30 - 14:45 CEST
C3.15

13:30 CEST

Spreadsheets: Advanced formulas
This session is all about formulas. If you’ve ever needed to split a name, find out if a certain word appears in a cell or merge data from one dataset into another, this is the session for you! We’ll take you on a journey all the way from basic formulas to slightly more complex ones. You'll learn how to manipulate and clean your data so that it's ready for your analysis. In this session, participants will learn to use various formulas for the purposes of data analysis. No prior knowledge is required if the participants attend the Basics session. Otherwise, they should be comfortable with the basics of either Excel or Google Sheets, and should be comfortable with sorting and filtering.This is a hands-on session so participants should bring their own laptop. The lesson is taught through Google Sheets but translates also into Excel. Participants will therefore need access to a Google account (or should set up a temporary account before class).

Speakers
avatar for Helena Bengtsson

Helena Bengtsson

Data Journalism Editor, Gota Media
Helena Bengtsson is Data Journalism Editor at Gota Media, a regional publishing company in the south of Sweden with 14 local titles. She previously worked as Editor for Data Journalism at Sveriges Television, Sweden’s national television broadcaster for 27 years and she also served... Read More →
avatar for Pamela Duncan

Pamela Duncan

Data journalist, The Guardian
Pamela Duncan is acting editor of the Guardian’s Data Projects team, leading a small (but utterly amazing) team of data journalists/nerds, mining data for news stories, investigations and interactive features. She admits to having a (perhaps unhealthy) love for discovering new formulas... Read More →


Saturday June 3, 2023 13:30 - 14:45 CEST
C3.04

14:00 CEST

Individual safety consultations 2
Do you have problems or considerations about digital security for you or your team? Would you like security advice on your personal software, hardware or on precautions when travelling?
Bring your team and your security questions for a one to one session with our trainers.

Book a time slot by writing to media@journalismarena.eu
We will connect you with the digital security trainers, who may contact you before the conference to learn more about your concerns.

Speakers
avatar for Jake Charles Rees

Jake Charles Rees

Programme Manager; Manager, Source Protection Programme, Centre for Investigative Journalism (TCIJ)
Jake Charles Rees is a curator, producer and programme manager for The Centre for Investigative Journalism in London, UK. For the CIJ he produces the biannual Logan Symposium, Closed Circuit webTV series, Logan Talks public lecture programme, and is currently focusing on leading the... Read More →
avatar for Harlo Holmes

Harlo Holmes

Director of Digital Security, Freedom of the Press Foundation
Harlo Holmes is the Director of Digital Security at Freedom of the Press Foundation. She strives to help individual journalists in various media organisations become confident and effective in securing their communications within their newsrooms, with their sources, and with the public... Read More →
OM

Olivia Martin

Deputy Director of Digital Security, Freedom of the Press Foundation
Olivia Martin is a Digital Security Fellow at Freedom of the Press Foundation. At FPF, she focuses on researching and delivering digital security trainings to journalists, activists, and human rights defenders. She has spent years in newsrooms as a designer and editor with new media... Read More →


Saturday June 3, 2023 14:00 - 15:00 CEST
TBA

14:45 CEST

Coffee break
Saturday June 3, 2023 14:45 - 15:15 CEST
Cafeteria

15:15 CEST

Breaking out of the silos – can we?
If you have worked in a cross-border collaborative investigation, you have probably felt this challenge: How to tackle internationally systemic issues when all participating media have audiences that are used to understanding issues at a local or national level.
Addressing issues at the international level and demanding accountability in the right places is especially difficult in Europe, where audiences are fragmented by language and culture – even if most countries are tied closely together in economic and regulatory structures. In addition, many media outlets (rightly or wrongly) believe their audiences are less interested in European or global issues than they are in the political debates raging at a national level.
How can we break out of these national silos? When is it important? Which methods have been considered or tried? In this session some of Europe’s most experienced cross-border reporters will discuss the challenges.

Moderators
avatar for Simon Bowers

Simon Bowers

Investigations Editor, Finance Uncovered

Speakers
avatar for Jelena Cosic

Jelena Cosic

Training Manager and Eastern European partnership coordinator, ICIJ
Jelena Cosic is ICIJ's training manager and Eastern European partnership coordinator.She prepares and implements training programs on ICIJ platforms, new materials, and documentation, both internally and across the organization’s global reporting network.Prior to joining ICIJ, she... Read More →
avatar for Stefan Candea

Stefan Candea

co-founder, coordinator, European Investigative Collaborations
Currently I am the coordinator of the EIC network.My work started with covering organized crime across borders in România at the end of the 90’s. Mid 2015 I co-founded EIC as a network_by_agreement between media organisations and currently I coordinate the editorial and technological projects between @derspiegel @destandaard... Read More →
avatar for Harald Schumann

Harald Schumann

Journalist, Investigate Europe
Journalist since 1983 with- „tageszeitung“ (2 years),- „Der Spiegel“ (18 years) -- "Tagesspiegel" (since 2004) and Investigate Europe (since 2016)My main interest is to help to overcome the narrow minded national perspective in reporting about European affairs and issues... Read More →
avatar for Jan Strozyk

Jan Strozyk

Investigative Reporter / Data Journalist, OCCRP
Based in Germany, Jan Strozyk joined OCCRP in 2021 as data editor before becoming chief data editor in 2022. Jan co-leads OCCRP’s research and data team alongside Head of Research Karina Shedrofsky. He works closely with our editorial and the data teams, coordinating data analysis... Read More →


Saturday June 3, 2023 15:15 - 16:30 CEST
C2.28

15:15 CEST

The coordinator - the unsung hero of cross-border collaborations
If there's an unsung hero in cross-border collaborative investigations that must be the coordinator. Keeping the overview, managing communications, making sure everyone is on the same page and does their thing on time, lending a hand here and there, documenting the investigation, and acting as a fixer and even as a diplomat to prevent conflict and make things work...
If you've been part of a collaborative investigation, you know how many different tasks coordinators may have to juggle at the same time. And if you've coordinated a collaborative investigation yourself, you know how exhausting, exhilarating and in the end fulfilling the role can be. In this roundtable, journalists with expertise in coordinating cross-border collaborations share their different experiences and lessons learnt in the job.
Come to get a peek behind the scene of coordinating an investigation, share your own experiences and join the conversation, so that we all can learn from each other.

Moderators
avatar for Jose Miguel Calatayud

Jose Miguel Calatayud

Freelance journalist and writer
I am a freelance journalist and writer based in Berlin since January 2020, currently focusing on feature writing and investigative journalism, mainly about Europe. I am the co-initiator and the coordinator of the cross-border project Cities for Rent: Investigating Corporate Landl... Read More →

Speakers
avatar for Hazel Sheffield

Hazel Sheffield

Arena Academy co-ordinator, Arena for Journalism
In 2020, Hazel co-ordinated the cross-border investigation Money to Burn, which revealed that Europe's renewable energy subsidies were inadvertently fuelling the destruction of ancient forests in Estonia. Today she is coordinating the education and training arm for Arena for Journalism... Read More →
avatar for Elena Ledda

Elena Ledda

Freelance journalist
I am a Sardinian feminist journalist based in Barcelona, Spain, and practicing in-depth social, investigative, and narrative journalism. I am the coordinator of the cross-border investigation The bankers of irregular migration, carried out together with colleagues Andrés Mourenza... Read More →
avatar for Zeynep Sentek

Zeynep Sentek

Project director, Climate Network, Arena for Journalism in Europe
Zeynep Sentek is a Turkish investigative journalist specialising in corruption, offshore structures, human rights, and the environment. She is now leading the climate network of Arena for Journalism in Europe. In this network, Arena facilitates journalists to do cross-border climate... Read More →


Saturday June 3, 2023 15:15 - 16:30 CEST
C2.07

15:15 CEST

The Devil in the Data - researching sports's data and betting industry
This investigation examined the relationship between illegal/criminal sports gambling operators and elite football clubs and organisations. Philippe Auclair will explain how data analysis was used to support more traditional investigative methods to prove that sports data collection companies, which are supposed to guarantee of the integrity of sports are enabling illegal/criminal gambling operators to conduct their business. The investigation demonstrates how individual investigators with complementary skills are more than the sum of their parts when they get together.

Speakers
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)
avatar for Philippe Auclair

Philippe Auclair

Investigative Reporter, Josimar
Philippe Auclair is a French London-based investigative print and broadcast journalist who writes for a variety of media, including the BBC World Service, The Guardian, Josimar, Eurosport, 11 Freunde and others. His France Football dossier on the corruption surrounding the 2022 Qatar... Read More →


Saturday June 3, 2023 15:15 - 16:30 CEST
C2.15

15:15 CEST

The non-voter time bomb: mapping voter abstention in Europe
What would European democracies look like if habitual non-voters decided to cast their ballot in the next elections? This is the starting question of “The non-voter time bomb”, a project run by the Portuguese media Divergente, involving data collection from the 27 EU countries. It is based on the contribution of 12 media partners and 15 freelancers. The session will focus on: Divergente’s approach to data journalism: the faces and thinking behind the numbers; how to build a human map of voter abstention in Europe with quantitative and “hyper-qualitative” methods, and their findings up until Dataharvest begins. Part of the session will be dedicated to explaining how Divergente, helped by Dataninja, engaged volunteers in data checking and cleaning through a training course on data journalism.

Speakers
avatar for Luciana Maruta

Luciana Maruta

Journalist, Divergente
I’m a journalist with fourteen years’ experience in radio and television, assuming in recent years also the position of producer and editor. I reported on health, migration and sports for national TV and radio stations and, in recent years, joined documentary projects about environment... Read More →


Saturday June 3, 2023 15:15 - 16:30 CEST
C2.01

15:15 CEST

Engaging with hard-to-reach communities
Some communities that our journalism serves are hard to reach. Some audiences exist outside our own bubbles. Underrepresented groups may have a deep distrust of the media. So how do you build trust amongst these communities? How do you increase the impact of your investigations? A lot boils down to using the right language and cultural references, working with advocates, bridging ideological divides and building connections with communities. We hear from three organisations that have experience in doing just that.

Moderators
avatar for Lucas Batt

Lucas Batt

Coordinator, Reference, Arena for Journalism in Europe
I'm part of a small team coordinating Reference, an exciting new network for European independent media. My role focuses in particular on community building and facilitating knowledge exchange, with the aim of strengthening network connections and accelerating collective learning... Read More →

Speakers
avatar for Zoltán Sipos

Zoltán Sipos

Editor-in-Chief, Átlátszó Erdély
Zoltán SIPOS is the manager and editor-in-chief of Átlátszó Erdély (atlatszo.ro), an investigative journalism outlet focusing on issues regarding the 1,2 million Hungarian community living in Transylvania, Romania... Read More →
avatar for Sofia da Palma Rodrigues

Sofia da Palma Rodrigues

Journalist and editor-in-chief, Divergente
I am a journalist, with experience as investigative reporter in different countries in Europe, Africa and America. I like to straddle the worlds of journalism, documentary and academia. In 2014, I co-founded Divergente, a digital magazine of narrative journalism focus on investigative... Read More →
avatar for Maria Delaney

Maria Delaney

Editor, Noteworthy (Ireland)
Editor of Noteworthy, an Irish crowdfunded investigative journalism platform. Noteworthy supports independent and impactful public interest journalism, allowing in-depth analysis of underreported issues. It is part of The Journal, Ireland's largest native online news outlet, and a member of the European Data... Read More →


Saturday June 3, 2023 15:15 - 16:30 CEST
C2.21

15:15 CEST

Researching alt-right and conservative groups online: blueprints for an investigation
How does one investigate radical movements and track extremists online? Anna Gielewska will share lessons learned from the cross-border investigative project “Firehose of Falsehood”. From following the money and connections, to mapping influence, to understanding the infrastructure of organized disinformation through technical data and social media analysis - these are key elements for complex journalistic projects focused on alt-right propaganda and disinformation campaigns spreading a radical message.

Moderators
avatar for Daiva Repečkaitė

Daiva Repečkaitė

Freelance
Investigative journalist from Lithuania, based in Malta. Covering environment, health and inequalities. Published in Financial Times, Foreign Policy, Politico, the Guardian, Deutsche Welle. Prix Europa 2022 co-nominee. Policy Leader Fellow 2023 at the European University Institu... Read More →

Speakers
avatar for Anna Gielewska

Anna Gielewska

Vice-chairman, Reporters Foundation
Anna is a vice-chairman of the Reporters Foundation (the first Polish investigative nonprofit). Co-founder of frontstory.pl and vsquare.org (a regional cross-border outlet in Central Europe). She specializes in investigating disinformation operations and influence campaigns. As a John S. Knight Fellow at Stanford University (2019/20), she developed a project focused on investigating organized disinformation and strengthening cross-functional collaborat... Read More →


Saturday June 3, 2023 15:15 - 16:30 CEST
C2.23

15:15 CEST

Googling for nerds
Round table-talk for heavy-Google-users – come with your own tips and problems! Marcus Lindemann will start the session by talking about undocumented Google features (i.e. operators, combos and supported file types) and show some more complicated searches that are feasible with Google. Have you seen face recognition in videos? And how do you to find relevant videos on Youtube? We will also look at things Google does badly and discuss how we can get around its shortcomings. For example, there is a Google filter that will keep more than 60% of all pages relevant to your search terms out of the SER. If you are not careful you will lose important information. Google image search is getting worse all the time - let us try to understand what they are doing. See examples where Google is not at all behaving logically.

Speakers
avatar for Marcus Lindemann

Marcus Lindemann

managing editor, autoren(werk) GmbH & Co.KG
Marcus Lindemann is the managing author of autoren(werk) and has been producing magazine pieces and documentaries for ARD and ZDF with his own company since 2000, mainly on consumer topics, often with hidden cameras. After the series "WISO ermittelt" and "oma trick", autoren(werk... Read More →


Saturday June 3, 2023 15:15 - 16:30 CEST
C2.05

15:15 CEST

The future of work in the digital age: Dark sci-fi utopia on its way to become reality?
The promise of the digital age: anything, anytime, anywhere; fast, easy, and cheap. And all of this is to be made possible by robots or algorithms (partially), but even more by the workers themselves. Each of them is a small part of a larger machine set up to achieve radical efficiency. Every task is planned down to the last minute, every worker is monitored and tracked. Labor laws, employment rights, and protections are often circumvented and ignored by employers and governments, and union representation of workers is often missing. In this session, three journalists will talk about the investigative methods used to research platform work and the inner workings of online commerce giants like Amazon. We will also discuss what working for and with automated systems and processes looks like today, and what it might look like in the future. How will our day-to-day work change and look? In which way will labor rights and unions need to adapt to the developments? And what should journalists pay attention to next in this field?

Speakers
avatar for Charles Boutaud

Charles Boutaud

Developer-Journalist, The Bureau of Investigative Journalism
Charles is a developer-journalist who has experience investigating digital information (data) for stories using computational methods.
avatar for Matea Grgurinović

Matea Grgurinović

Journalist, Faktograf.hr/Freelance
I am a Zagreb-based journalist writing mostly about social issues with a strong interest in Southeast Europe, China, and the post-Soviet space and a growing interest in data journalism. I cover topics such as poverty, inequlity, labour/workers' rights, trauma and climate change.
avatar for Miriam Lenz

Miriam Lenz

Reporter, Correctiv
Miriam has been a reporter in the Berlin investigative editorial team at CORRECTIV.Lokal since March 2022. While studying social sciences at Berlin's Humboldt University, she discovered her enthusiasm for urban research and student journalism. In 2018, she received a scholarship from... Read More →


Saturday June 3, 2023 15:15 - 16:30 CEST
C2.17

15:15 CEST

From reporter to subject of surveillance
In the past two years, Greek media realized that they were not only reporting about the Greek wiretapping scandal but also had become subjects of surveillance. Not only was spyware found on the smartphones of multiple journalists, but they were also followed on the streets. Surveillance has a dramatic impact on the work and lives of the journalists concerned.

In this talk, we will discuss how surveillance and threats affect your work and personal habits, and how affected journalists have dealt with it and found ways to continue their work without being overwhelmed by surveillance.

Speakers
avatar for Gavin Rees

Gavin Rees

Senior Advisor for Training and Innovation, Dart Center for Journalism and Trauma
Gavin Rees is Senior Advisor for Training and Innovation at the Dart Center for Journalism and Trauma. Since 2008 he has been working as a trauma awareness consultant and trainer for newsrooms, media-support organisations, and journalism schools across Europe as well as internati... Read More →


Saturday June 3, 2023 15:15 - 16:30 CEST
C2.25

15:15 CEST

Phishing 101 (introductory session)
Phishing is a digital attempt by a bad actor (e.g. hackers, data-mining companies) to persuade you to reveal your personal information (e.g. passwords, credit card numbers) often received via email or text message. Phishing messages have become more advanced and harder to identify. In this activity-based session, we will give you some tips and tricks you can use daily to determine if a message is authentic and safe or suspicious and dangerous




Speakers
avatar for Harlo Holmes

Harlo Holmes

Director of Digital Security, Freedom of the Press Foundation
Harlo Holmes is the Director of Digital Security at Freedom of the Press Foundation. She strives to help individual journalists in various media organisations become confident and effective in securing their communications within their newsrooms, with their sources, and with the public... Read More →
OM

Olivia Martin

Deputy Director of Digital Security, Freedom of the Press Foundation
Olivia Martin is a Digital Security Fellow at Freedom of the Press Foundation. At FPF, she focuses on researching and delivering digital security trainings to journalists, activists, and human rights defenders. She has spent years in newsrooms as a designer and editor with new media... Read More →
avatar for Jake Charles Rees

Jake Charles Rees

Programme Manager; Manager, Source Protection Programme, Centre for Investigative Journalism (TCIJ)
Jake Charles Rees is a curator, producer and programme manager for The Centre for Investigative Journalism in London, UK. For the CIJ he produces the biannual Logan Symposium, Closed Circuit webTV series, Logan Talks public lecture programme, and is currently focusing on leading the... Read More →


Saturday June 3, 2023 15:15 - 16:30 CEST
C2.02

15:15 CEST

War and muscles on TikTok: Investigating the most popular app in the world
More than 220 million Europeans have TikTok accounts, many of them children. But the Chinese-owned company isn't very willing to share how the algorithms decide what children see. Henrik Bøe and Christian Nicolai Bjørke from Norwegian Broadcaster NRK started to investigate how and how quickly a 13-year-old TikTok user, interested in building muscle, was drawn into a world of extreme training.
While they were investigated this, Russia attacked Ukraine, and TikTok suddenly became an important channel for news from the war. But did TikTok show the war to everyone? This project recently won The Sigma Award.
In this session we will look into their methodology involving innovative programming, artificial intelligence, local proxies, young sources, storytelling and a good dose of creativity.

Speakers
avatar for Henrik Bøe

Henrik Bøe

Data Journalist, NRK
avatar for Christian Nicolai Bjørke

Christian Nicolai Bjørke

Journalist, NRK
Investigative/data journalist at Norwegian Broadcasting Corporation. Sigma Awards Winner 2023 for the project «World’s apart».


Saturday June 3, 2023 15:15 - 16:30 CEST
Aula 1

15:15 CEST

Stats with R
Find stories in data with R. Continuing to get to grips with the basics, we will go looking for scale, rankings, trends, ratios, samples, outliers and correlations. Basic knowledge of R (e.g. through the first, introductory, workshop) is necessary. We will also step into the world of data visualization with ggplot. No software installation is required for this session - but it will be useful for participants to create a free RStudio Cloud account in advance (https://posit.cloud/) whether they intend to use a school computer or their own laptop.

Speakers
avatar for Robert Gebeloff

Robert Gebeloff

Reporter, New York Times
Robert Gebeloff has worked as a data projects reporter for The New York Times since 2008 and has taught data journalism for many years in newsrooms and at conferences. He was co-winner of the George Polk Award in 2015 and was a Pulitzer Prize finalist in both 2015 and 2016 for projects... Read More →
avatar for Luuk Sengers

Luuk Sengers

Journalist & trainer, Story-Based Inquiry Associates / De Groene Amsterdammer
Luuk is an independent investigative journalist, lecturer, trainer and mentor. For the leading Dutch magazine De Groene Amsterdammer he writes about the effects of corporate power on our environment and climate, based on data-analysis. He also teaches research skills, data journalism and interview techniques to professionals and students and helps media and NGOs organise and carry out investigative projects. He... Read More →


Saturday June 3, 2023 15:15 - 16:30 CEST
C3.11

15:15 CEST

Summarising complex data with Pivot tables and merges
Want to take your spreadsheet skills to the next level? We’re here to teach you how (you lucky things!). Have you ever opened a spreadsheet and been overwhelmed by the sheer size of the dataset in front of you? Well, in these three sessions we give you the answer: pivot tables are a dream come true for those seeking to summarise and organise data in just a few clicks. Plus we will teach you how to merge two or more datasets together using a magic trick 🪄 🎩 🐇 (ok, ok, it's not magic…but we’ll teach you a wonderful formula called an XLooKUp!!). Following this section participants will be able to summarise datasets into smaller chunks for the purposes of journalistic analysis. No prior knowledge is required -if participants attend the first two sessions. Otherwise, they should be comfortable with Excel or Google Sheets to the level of sorting and filtering and using formulas. This is a hands-on session so participants should bring their.own laptop.The lesson is taught through Google Sheets, but also translates to Excel: participants will therefore need a Google account, or should set up a temporary account before class.

Speakers
avatar for Helena Bengtsson

Helena Bengtsson

Data Journalism Editor, Gota Media
Helena Bengtsson is Data Journalism Editor at Gota Media, a regional publishing company in the south of Sweden with 14 local titles. She previously worked as Editor for Data Journalism at Sveriges Television, Sweden’s national television broadcaster for 27 years and she also served... Read More →
avatar for Pamela Duncan

Pamela Duncan

Data journalist, The Guardian
Pamela Duncan is acting editor of the Guardian’s Data Projects team, leading a small (but utterly amazing) team of data journalists/nerds, mining data for news stories, investigations and interactive features. She admits to having a (perhaps unhealthy) love for discovering new formulas... Read More →


Saturday June 3, 2023 15:15 - 16:30 CEST
C3.04

15:15 CEST

Text Analysis in Python
Natural Language Processing (NLP) is a powerful tool that can help investigative journalists extract valuable information from large volumes of text data. By using NLP techniques, journalists can clean and structure text, explore the themes covered in the data, and extract important information about people, places, and events.

This creates a deeper understanding of the data, allowing journalists to uncover hidden patterns and gain new insights that can drive their investigations forward. In this hands-on session, participants will learn the basics of NLP for investigative journalism, using Python to analyze and explore text data.

To get the most out of this session, participants are encouraged to bring their laptops and ensure they have basic Python programming skills.


Speakers
avatar for Rémi Labed

Rémi Labed

Journalist, Disclose
avatar for Natalie Widmann

Natalie Widmann

Data Scientist, Freelance / ida
I'm a Data Scientist supporting journalist and human rights activists with data, tools and automation.I'm happy to talk about scraping data, extracting the most relevant information from it, understanding algorithms and using them for investigations.


Saturday June 3, 2023 15:15 - 16:30 CEST
C3.15

16:30 CEST

Break (cold drinks only)
Saturday June 3, 2023 16:30 - 17:00 CEST
Cafeteria

17:00 CEST

Big Plastic in Europe – a story of power abuse and green-washing
Investigate Europe’s latest cross-border research laid bare Europe's problem with plastics. The investigation detailed how unchecked production and use is creating a plastic waste crisis across the continent. It also unmasked how the plastics industry, one of the most powerful lobbies in Europe, has free rein to put more and more plastic packaging on the market, without any serious disincentive.
In this session, four of the reporters will explain how they accessed and analysed the data which illuminates Europe’s plastic waste crisis, discuss case studies and share lessons learned from the investigation.


Speakers
avatar for Maria Maggiore

Maria Maggiore

Journalist, Investigate Europe
I grew up in Europe. There is no solution without Europe, but Europe has to change, a lot, more democracy and transparency are needed. less space for lobby.I follow many items, but all around gas and green transition, are my favorite investigation targets, in recent years.
avatar for Lorenzo Buzzoni

Lorenzo Buzzoni

Investigative Journalist, Investigate Europe
I'm an enthusiastic investigative journalist and an independent documentary filmmaker based in Italy.
avatar for Manuel Rico

Manuel Rico

Journalist since 1990. Worked among other media in El Mundo, Interviu, Tiempo and Público. Co-founder of infoLibre, where I was editor-in-chief and head of the investigative team. I collaborated in projects led by EIC, OCCRP and Investigate Europe.I am also a lawyer since 2017, interested... Read More →


Saturday June 3, 2023 17:00 - 18:15 CEST
Aula 1

17:00 CEST

What to do when you don't have the perfect dataset for an investigation?
Discover insightful strategies for tackling the challenges of working with imperfect datasets in investigative journalism. Renowned data journalists and developers from the International Consortium of Investigative Journalists (ICIJ), will share their experiences and expertise. Gain valuable insights on identifying and addressing data gaps, leveraging alternative sources to supplement incomplete information, and extrapolating meaningful insights. This engaging session is a must-attend for journalists and researchers seeking practical advice on overcoming the limitations posed by imperfect data.

Speakers
avatar for Karrie Kehoe

Karrie Kehoe

Data Journalist, ICIJ
Karrie Kehoe is a data journalist at ICIJ. Previously she investigated health care, human rights, environmental pollution and public expenditure at The Times & Sunday Times newspapers, the Thomson Reuters Foundation, and the RTÉ Investigations unit.
avatar for Pierre Romera

Pierre Romera

Chief Technology Officer, ICIJ, France
Pierre Romera has been Chief Technology Officer at the International Consortium of Investigative Journalists (ICIJ) since 2017. He manages a team working on the platforms that enabled more than hundreds journalists to collaborate on the Pandora Papers, the Uber Files, the FinCEN Files... Read More →
avatar for Jelena Cosic

Jelena Cosic

Training Manager and Eastern European partnership coordinator, ICIJ
Jelena Cosic is ICIJ's training manager and Eastern European partnership coordinator.She prepares and implements training programs on ICIJ platforms, new materials, and documentation, both internally and across the organization’s global reporting network.Prior to joining ICIJ, she... Read More →


Saturday June 3, 2023 17:00 - 18:15 CEST
C2.17

17:00 CEST

You want impact? Let's work on it!
Journalism outlets (and their funders) are increasingly interested in impact: not just publishing a story, but actually making a difference. This means you need to work on getting your stories out to the right people in the right places, tracking your work and working with social listening. Most tools for this are commercial, expensive and not suitable for non-profits. But recently, there has been a rise in Impact Producers. Who are they and what do they do? And how do various outlets regard their position when it comes to creating impact? Is this part of your journalistic mission, or does it cross the line into activism?

Speakers
avatar for Emma Prest

Emma Prest

Chief Product Officer, OCCRP
Emma Prest is the chief product officer at OCCRP. She is responsible for the strategy and execution of OCCRP’s digital products, including its website, and tools for journalists, such as its investigative data platform OCCRP Aleph. She focuses on improving reader engagement and... Read More →
avatar for Eva Belmonte

Eva Belmonte

Director, Civio
Eva Belmonte (Spain, 1982) is a journalist specialised in public data treatment and analysis. She gained journalistic experience writing and editing for major Spanish media organisations like El Mundo, where she worked from 2005 to 2012. She is currently Director at Fundación Civio... Read More →
avatar for Abhijit Das

Abhijit Das

As programme director at Stichting Democratie en Media, Abhijit is responsible for the foundation’s grant-making and partner support programmes. The Amsterdam-based foundation is fully independent and has a history tracing back to the illegal Dutch resistance newspaper Het Parool. Stichting... Read More →


Saturday June 3, 2023 17:00 - 18:15 CEST
C2.21

17:00 CEST

Child trafficking: inspiration for an investigation
This week openDemocracy and irpiMedia published a year-long investigation into alleged illegal adoptions of dozens of Armenian newborns to Italy. The alleged gang, including Armenia’s top obstetrician, a key government official responsible for international adoptions, and child welfare workers, procured babies by manipulating patients in a maternity hospital into putting their children into orphanages, from where they were sold to overseas couples wanting to adopt. In this session, Tatev will offer investigative methods and techniques that can be replicated by journalists in other countries (France, the United States, Russia, and Switzerland) where allegedly 437 Armenian kids have been sold at the price of €25,000 each. She will also tell us about the challenges of doing this kind of complex investigation and reflect on the lessons learned.



Speakers
avatar for Tatev Hovhannisyan

Tatev Hovhannisyan

Europe and Eurasia Editor, openDemocracy
Based in Armenia, Tatev Hovhannisyan is openDemocracy’s Europe and Eurasia editor on our Tracking the Backlash project. She is an investigative journalist with a particular interest in tracking attacks on universal human rights and investigating the funding of anti-gender movements... Read More →


Saturday June 3, 2023 17:00 - 18:15 CEST
C2.07

17:00 CEST

Find more through structured Internet Research
Everyone searches the internet, day after day, but mostly quite inefficiently. This is because few of us fully understand the different "areas" of the internet, each of which has specific tools and methods for research. Once you understand how this works, you will get better results - and faster! Good research starts in your head, not with a search engine. This session shows how research on the internet can be improved by structuring your searches well.

Speakers
avatar for Ude Albrecht

Ude Albrecht

Journalist and researcher, Freelancer
Ude Albrecht is based in Berlin (Germany) and Friesland, works as a freelance journalist, researcher and research-trainer (online-researches, source checking, fact checking and security issues).He writes for several newspapers and magazines, print and online. focusses on structured... Read More →


Saturday June 3, 2023 17:00 - 18:15 CEST
C2.05

17:00 CEST

Getting Started with Satellite Imagery
Within the last decade, a large amount of geospatial data has become freely available, and satellite images evolved into powerful tools for journalistic discovery and analysis. In this hands-on session, the award-winning Berlin-based initiative Vertical52 will showcase some examples of how one can use geospatial in journalistic investigations. They will show us where to get which data and what to use it for. The session is for beginners, but advanced users of satellite imagery are welcome to join and share their own stories. Real cases and challenges will be discussed and answered during the session.

Moderators
avatar for Natalie Widmann

Natalie Widmann

Data Scientist, Freelance / ida
I'm a Data Scientist supporting journalist and human rights activists with data, tools and automation.I'm happy to talk about scraping data, extracting the most relevant information from it, understanding algorithms and using them for investigations.

Speakers
avatar for Marcus Pfeil

Marcus Pfeil

Co-Founder, Vertical52 GmbH
Marcus hat sich seit 2012 auf komplexe Storytelling-Projekte in Digitalmedien spezialisiert. Nach dem BWL-Studium arbeitete er für die Deutsche Bundesbank und die Bundesanstalt für Finanzdienstleistungsaufsicht. 2002 volontierte er an der Georg von Holtzbrinck-Schule für Wirtschaftsjournalisten... Read More →
avatar for Michael Anthony

Michael Anthony

Co-Founder, Vertical52


Saturday June 3, 2023 17:00 - 18:15 CEST
C2.02

17:00 CEST

How to follow the money and unpick offshore transactions
Would you like to learn how to unpick offshore transactions and get beyond corporate secrecy to show who really controls the company you are investigating? Using real case studies this session will look at how to unravel corporate trails, uncover bribes and tax dodging which are hiding in plain sight. Audience participation encouraged!

Speakers
avatar for Leigh Baldwin

Leigh Baldwin

Editor-in-Chief, SourceMaterial
Leigh Baldwin is the editor of SourceMaterial
avatar for Marcus Leroux

Marcus Leroux

reporter, SourceMaterial
Marcus Leroux is a reporter at SourceMaterial, a not-for-profit investigative journalism organisation focusing on climate, corruption and democracy.


Saturday June 3, 2023 17:00 - 18:15 CEST
C3.05

17:00 CEST

Labour roundtable: Let’s talk about work!
What are the most important aspects of covering work in Europe these days? What are the most pressuring topics, and what are the most vulnerable groups and sectors? Are there any trends we should look into? In which sectors are exploitation most widespread? In this roundtable, the participants will be able to share an overview of the labour topics they have researched and get in touch with other journalists in the field. The round table will be opened by Jose Miguel Calatayud (along with Adriana Homolova and Brigitte Alfter), who will introduce the key findings of an Arena stocktaking report on how we cover (or do not cover) labour and how the labour reporting is organised (or neglected) in newsrooms across the continent.  Bring your story ideas and let’s develop the research on the labour market together!

Moderators
avatar for Brigitte Alfter

Brigitte Alfter

Director, Arena for Journalism in Europe
Brigitte Alfter ist eine deutsch-dänische Journalistin, Geschäftsführerin für Redaktionelles bei Arena for Journalism in Europe und Dozentin Journalismus an der Universität Göteborg. Nach Jahren als Journalistin auf fallen Niveaus vom Lokaljournalismus bis zur EU-Korrespondentin... Read More →

Speakers
avatar for Adriana Homolová

Adriana Homolová

ARENA / Follow The Money, Netherlands / Slovakia
Adriana is a freelance data journalist, trainer and public spending nerd. She coordinates the data skills training track on the Dataharvest conference and investigates the European Union for Follow The Money Bureau Brussel.
avatar for Matea Grgurinović

Matea Grgurinović

Journalist, Faktograf.hr/Freelance
I am a Zagreb-based journalist writing mostly about social issues with a strong interest in Southeast Europe, China, and the post-Soviet space and a growing interest in data journalism. I cover topics such as poverty, inequlity, labour/workers' rights, trauma and climate change.
avatar for Ana Tudela

Ana Tudela

Project leader / Cofounder, DATADISTA
Financial and investigative journalist with more than twenty years of experience working for national newspapers as El Economista, Público and El Español and former content editor in chief for the spanish edition of Forbes. I pivoted my professional life since 2016 founding my own... Read More →
avatar for Alina Lippegaus

Alina Lippegaus

Legal Advisor, Faire Mobilität
Fair MobilityAims to support mobile workers from Central and Eastern EU Member States in enforcing their rights to fair wages and working conditions on the German labour market.Means are advisory services and support for mobile employees in their native languages. Production and... Read More →


Saturday June 3, 2023 17:00 - 18:15 CEST
C2.28

17:00 CEST

Collaborating across borders (advanced session)
This session will cover a practical mix of data security tips and models for workflows that journalists can use when collaborating across borders.

This session will be most useful for participants who already have some of their own digital security practices in place or have basic knowledge of digital security fundamentals (like those covered in our Digital Hygiene session)

Speakers
avatar for Harlo Holmes

Harlo Holmes

Director of Digital Security, Freedom of the Press Foundation
Harlo Holmes is the Director of Digital Security at Freedom of the Press Foundation. She strives to help individual journalists in various media organisations become confident and effective in securing their communications within their newsrooms, with their sources, and with the public... Read More →
OM

Olivia Martin

Deputy Director of Digital Security, Freedom of the Press Foundation
Olivia Martin is a Digital Security Fellow at Freedom of the Press Foundation. At FPF, she focuses on researching and delivering digital security trainings to journalists, activists, and human rights defenders. She has spent years in newsrooms as a designer and editor with new media... Read More →
avatar for Jake Charles Rees

Jake Charles Rees

Programme Manager; Manager, Source Protection Programme, Centre for Investigative Journalism (TCIJ)
Jake Charles Rees is a curator, producer and programme manager for The Centre for Investigative Journalism in London, UK. For the CIJ he produces the biannual Logan Symposium, Closed Circuit webTV series, Logan Talks public lecture programme, and is currently focusing on leading the... Read More →


Saturday June 3, 2023 17:00 - 18:15 CEST
C2.15

17:00 CEST

Toxic data: working with graphic imagery and other nasties
Sometimes data sets contain far more than just letters and digits. This workshop will explore safer, more effective ways of working with emotionally charged content, be it traumatic imagery from war zones, disturbing environmental data or harrowing witness testimony. We'll be looking at strategies for making optimal workflow decisions and discussing what every journalist needs to know about self-care when working with material that can impact their mental health.  

Speakers
avatar for Gavin Rees

Gavin Rees

Senior Advisor for Training and Innovation, Dart Center for Journalism and Trauma
Gavin Rees is Senior Advisor for Training and Innovation at the Dart Center for Journalism and Trauma. Since 2008 he has been working as a trauma awareness consultant and trainer for newsrooms, media-support organisations, and journalism schools across Europe as well as internati... Read More →


Saturday June 3, 2023 17:00 - 18:15 CEST
C2.25

17:00 CEST

Investigative journalism in audio: podcasting beyond true crime
Investigative journalism is investigative journalism, regardless of the publication format. But researching a story while knowing you'll tell it in the audio format opens up numerous possibilities for crafting your narrative. Do you bring listeners with you as you find new information? Do you explain, step by step, how you got to each conclusion? Do you create a serialized podcast with Netflix-like endings of episodes, so-called cliffhangers? In this presentation, Ricardo Esteves Ribeiro, journalist, and co-founder of Fumaça, a Portuguese investigative journalism podcast, will share their method of doing investigative journalism in audio. He will take us on a journey from the beginning of an investigation and deciding whom to talk to first, to the moment when you turn your recorder off.

Speakers
avatar for Ricardo Esteves Ribeiro

Ricardo Esteves Ribeiro

Fumaca
I'm a co-founder and journalist at Fumaça, an investigative journalism podcast focused on injustices and inequalities. We mainly create serialized audio-documentaries. In the past, through sometimes years-long investigations, we have covered the private security sector, European... Read More →


Saturday June 3, 2023 17:00 - 18:15 CEST
C2.01

17:00 CEST

GeekSpeak: Our favourite digital tools
Tell us all about the free digital tools that you wouldn't want to live without! The ones that make your work easier or better-looking: those that help you out when nothing else will! Come and share them with others.

In this session, we will start out with some of the participants sharing their free favourites -- but we also need your input. If you are willing to take the floor for 5 minutes to tell us about your favourite tool get in touch with Ana Lutzky (analutzky@gmail.com) to be added to the list of presenters.

Olaya Argüeso Pérez is Editor-in-chief at Correctiv, she will talk about Keybase, a tool for team communication that they have very successfully used at different cross-border investigations. It works basically like Slack, but it is encrypted, and allows you to share larger files. A very good addition to the basic cross-border coordinator's toolkit !


Alex Pyrgiotis is a software developer who's helping build Dangerzone, an open-source tool for sanitizing untrusted documents and making them safe to open and share. It was originally created by Micah Lee (Intercept) and now it's being primarily developed by Freedom of the Press Foundation. Come see what threats are out there and how you can potentially protect yourself !

Moderators
avatar for Ana Lutzky

Ana Lutzky

Journalist, AEF Info
Datajournalist at AEF Info news agency in Paris, leading "Data Sup-Recherche", a weekly data-driven newsletter about universities and research. Also coordinating a network of  data ambassadors journalists working in each of AEF newsrooms to apply data skills on various topics : education... Read More →

Speakers
avatar for Marcus Lindemann

Marcus Lindemann

managing editor, autoren(werk) GmbH & Co.KG
Marcus Lindemann is the managing author of autoren(werk) and has been producing magazine pieces and documentaries for ARD and ZDF with his own company since 2000, mainly on consumer topics, often with hidden cameras. After the series "WISO ermittelt" and "oma trick", autoren(werk... Read More →
AP

Alex Pyrgiotis

Software Engineer, Freedom of the Press Foundation
I'm a software engineer working at Freedom of the Press Foundaton. I'm helping build Dangerzone, an open-source tool for sanitizing untrusted documents and making them safe to open and share. I have previously worked at software companies doing all sorts of wonky stuff with storage... Read More →
avatar for Olaya Argüeso Pérez

Olaya Argüeso Pérez

Editor in chief, CORRECTIV
Olaya Argüeso Pérez is editor-in-chief at CORRECTIV, where she leads the international investigations since 2019. After more than a decade reporting about economy, business and finance at the most important radio network in Spain (Cadena SER), Olaya decided to expand her expertise... Read More →


Saturday June 3, 2023 17:00 - 18:15 CEST
C3.15

17:00 CEST

Joining tables in SQL
Take the next step after dealing with spreadsheets, and learn how to handle large datasets with SQL. Using SQL makes it possible to handle large amounts of data, to safely share data with others, and most important, to combine tables together by joining. In this session you will understand how relational databases work, especially how to join tables to find data that exists in both tables or use joining to add information into a table. By attending this session the participants will be able to understand when to take the step from Excel to databases and SQL, and how to use SQL to join datasets together in order to find new information. To attend this session the participants should have basic knowledge of working with spreadsheets. All the software necessary will be pre-installed on the school computers. Participants who want to bring their own laptop will need: DB Browser SQLite which can be downloaded from https://sqlitebrowser.org/ for PCs and Macs.

Speakers
avatar for Helena Bengtsson

Helena Bengtsson

Data Journalism Editor, Gota Media
Helena Bengtsson is Data Journalism Editor at Gota Media, a regional publishing company in the south of Sweden with 14 local titles. She previously worked as Editor for Data Journalism at Sveriges Television, Sweden’s national television broadcaster for 27 years and she also served... Read More →
avatar for Oksana Stavniichuk

Oksana Stavniichuk

Investigative Data Developer, OCCRP


Saturday June 3, 2023 17:00 - 18:15 CEST
C3.04

17:00 CEST

OpenRefine for OSINT: how to automate your open source searches
A common question when doing an OSINT investigation is "How do you automate the process?". For a beginner, coding can be time-consuming and frustrating. In between doing things manually and programmatically the intermediate solution is to use a tools such as OpenRefine. This workshop will introduce you to the use of OpenRefine for OSINT purposes, using concrete examples. Participants will learn how to import some OSINT-obtained json data and map them, use APIs to collect data, scrape websites using external tools and TOR. Participants will be able to automate an OSINT task, replicate scenarios, and protect their privacy. Participants should be comfortable using OpenRefine, and have a basic understanding of what command-line and Osint Python tools are. Participants bringing their own laptop should preinstall the mandatory tools set out in this github repository : https://github.com/openfacto/DataHarvest23-OpenRefine-for-Osint

Speakers
avatar for Anuška Delić

Anuška Delić

founder, Oštro
Based in Slovenia, Anuška Delić is an investigative reporter and founder of Oštro, a non-profit center for investigative journalism in the Adriatic region. In 2021, Oštro established a sister center in Zagreb, Croatia, effectively creating a unique two-headed micro-regional entity... Read More →
avatar for Hervé Letoqueux

Hervé Letoqueux

OpenFacto
Co-Founder of OpenFacto with Lou (@CapteursOuverts) and Aliaume (@yaolri), a french NGO dedicated to online investigation for journalists and activists, I love OpenSource researches, Python, Gephi, R and OpenRefine. I used to deal with money laundering, financial frauds and terrorism... Read More →


Saturday June 3, 2023 17:00 - 18:15 CEST
C3.11
 
Sunday, June 4
 

09:00 CEST

Coffee
Sunday June 4, 2023 09:00 - 09:30 CEST
Cafeteria

09:30 CEST

Step by step: Digging into a multinational arms company
Hensoldt is a multinational company in the defense and security industry, a spin off from Airbus. Der Spiegel obtained a data set and shared it with the research network European Investigative Collaborations. But like any cross-border investigation the project came with some challenges.
In this case study, two of the reporters will walk you step-by-step through each cross-border collaboration. How to share data? How to structure and divide the work between the different newsrooms? Which communication tools to use? What to do if a data set doesn’t look promising at first sight? How to avoid legal risks?
They will also share some of their learnings, for example a specific clause that they nowadays insert in any collaboration agreement with media partners from abroad. Another subject will be the perfect time to send out “right to reply” letters. Bring your questions, ideas and favorite tools and share your experiences.

Moderators
avatar for Stefan Candea

Stefan Candea

co-founder, coordinator, European Investigative Collaborations
Currently I am the coordinator of the EIC network.My work started with covering organized crime across borders in România at the end of the 90’s. Mid 2015 I co-founded EIC as a network_by_agreement between media organisations and currently I coordinate the editorial and technological projects between @derspiegel @destandaard... Read More →

Speakers
avatar for Rafael Buschmann

Rafael Buschmann

Investigative reporter, Der Spiegel
Born in 1982 in Zabrze, Poland, studied German, psychology, sports and education at the University in Münster. Has worked for SPIEGEL since 2010, initially in the sports department, now as an investigative reporter. Was part of the Football Leaks research team and wrote two books... Read More →
avatar for Nicola Naber

Nicola Naber

Investigative Reporter, DER SPIEGEL
Works for DER SPIEGEL in Hamburg since 2006. Focused on white collar crime. Board member of European Investigative Collaborations.


Sunday June 4, 2023 09:30 - 10:45 CEST
C2.28

09:30 CEST

Mapping street names: What do they tell us?
The naming of streets after people is far from a neutral activity; each city map tells its own story about how societies translate their views and values into space. There is clearly a gender gap, but there are other issues too: do street names celebrate people from minorities, social movements, disadvantaged social classes, non-Europeans, or people associated with controversial military campaigns? When did these people live, and where did they come from? Whose names are missing from our cities’ streets? A collaborative project led by OBC Transeuropa, within the European Data Journalism Network, has examined 30 major cities in 17 European countries. In this session, we'll see how the project progressed from initial idea, to deciding how to present the data. And we will see how collaborative working led to the reuse of data for different formats and story angles.

Speakers
avatar for Yuliia Dukach

Yuliia Dukach

Texty.org.ua
Have PhD in sociology and work as head of the disinformation research project at Ukrainian independent media Texty.org.ua. As a full-stack data journalist, I specialize in computer processing, data analysis and visualization in Python and R programming languages. There are various... Read More →
avatar for Lorenzo Ferrari

Lorenzo Ferrari

Network coordinator, European Data Journalism Network
avatar for Kelly Kiki

Kelly Kiki

Data Journalist | Project Manager, iMEdD


Sunday June 4, 2023 09:30 - 10:45 CEST
C2.15

09:30 CEST

How to investigate public tenders?
Every year, across Europe and beyond, the public sector grants contracts worth hundreds of billions of euros to private companies. And while public procurement represents a significant chunk of a country´s economy, the tendering process is more often than not non-transparent. In this panel, we will showcase different examples of journalists who have investigated public procurement. Newtral (Spain) uses data journalism to trace public spending and expose a lack of transparency in some topics. They are also experimenting with the use of AI to establish an alert system for tenders and public contracts, which would automatically detect potential red flags in contracts. BIRN (Bosnia) has developed an extensive database showcasing the public spending on politicians on luxurious cars, while saving money on ambulance vehicles and firetrucks. If you are a public procurement nerd - or an aspiring one - join us for this presentation, and stay for a discussion on how we can better investigate public tenders together.

Moderators
avatar for Adriana Homolová

Adriana Homolová

ARENA / Follow The Money, Netherlands / Slovakia
Adriana is a freelance data journalist, trainer and public spending nerd. She coordinates the data skills training track on the Dataharvest conference and investigates the European Union for Follow The Money Bureau Brussel.

Speakers
avatar for Semir Mujkić

Semir Mujkić

Managing editor, BIRN Bosnia and Herzegovina
Semir Mujkic is managing editor for BIRN Bosnia and Herzegovina. He joined BIRN in April 2017 and has worked as a journalist and deputy editor for BIRN BiH website Detektor.ba where he is managing editor as of October 2019. Semir led a newsroom when it won the 2020 European Press... Read More →
avatar for Irene Larraz

Irene Larraz

Fact-checking and Data teams coordinator, Newtral
I coordinate the Fact-checking and Data teams at Newtral, where I also lead Newtral Educación, the media literacy branch. We are focused on innovative journalism through fact-checking and data visualization. I have worked on the team for three years, and previously I worked for ten... Read More →


Sunday June 4, 2023 09:30 - 10:45 CEST
C2.05

09:30 CEST

Company ownership registries, an endangered species
Earlier this year Direkt36 in Budapest published a ground-breaking investigation showing that pro-government businessmen in Hungary owned a number of private equity funds and were using them to hide vast fortunes. The key to unlocking this information lay in plain sight.

Until recently European governments have been required to maintain publicly available registries showing who owned companies, otherwise known as the ultimate beneficial owners (UBOs). The Hungarian UBO registry played a pivotal role in helping Direkt36 connect the dots. More generally, UBO registries across Europe have been essential for follow-the-money investigations. However, a recent ruling by the Court of Justice of the European Union has effectively given European governments an excuse to close down these registries. And many have. Only a few hours after the ruling, countries started to switch off public access to the data.

This session will explore which registries are still available, and where else journalists can access this data. We will talk through different examples of how this data can be used and what this ruling means for journalists moving forward.

Speakers
avatar for Karina Shedrofsky

Karina Shedrofsky

Head of Research, OCCRP
Based in Amsterdam, Karina Shedrofsky joined OCCRP in 2017 as a daily news reporter and became head of research in 2019. She now co-leads OCCRP’s research and data team alongside Chief Data Editor Jan Strozyk, and helps journalists in our global network track down people, companies... Read More →
avatar for Eric Barrett

Eric Barrett

Data Desk Manager, OCCRP
Based in Tbilisi, Georgia, Eric Barrett joined OCCRP in 2019 and is the data desk manager. He works with OCCRP journalists and member centers leveraging data to support investigations that shine a light on corruption. Previously, he directed Georgia’s first data non-profit, JumpStart... Read More →
avatar for Zsuzsanna Wirth

Zsuzsanna Wirth

journalist, editor, Direkt36


Sunday June 4, 2023 09:30 - 10:45 CEST
C2.07

09:30 CEST

Urban journalism is the future! Connect with journalists from other cities to improve your research
Housing, transport, tourism, climate change, and energy prices: with the increased number of challenges shared by European cities, urban journalism is on the rise. In this session, presented by the members of the European Cities Investigative Journalism Accelerator, data journalists and investigative reporters interested in exploring urban issues will have a chance to brainstorm and network around the issues of urban journalism. We'll present our most fascinating research, and support you with tips on how to get started in this field. This session is also an opportunity to join our network. 

Speakers
avatar for Hendrik Lehmann

Hendrik Lehmann

Head, Tagesspiegel Innovation Lab
Hendrik Lehmann is Head of Tagesspiegel Innovation Lab and coordinating a European network for urban journalism. Him and the Lab work with investigative data analysis, dataviz and interactive web applications. They also try hard to make use of AI for investigative research and editorial... Read More →
avatar for Gaby Khazalová

Gaby Khazalová

reporter, Deník Referendum
reporter working for the Czech online daily Deník Referendum.


Sunday June 4, 2023 09:30 - 10:45 CEST
C2.01

09:30 CEST

Scraping at the speed of thought with TypeScript and Deno
Need to scrape in a hurry? Instead of being lured by the pied Python, try TypeScript! Based on our experience of writing dozens of scrapers for journalistic projects at the Guardian, we'll explain the advantages of TypeScript over Python for writing scripts that scrape data from the web. In particular, we'll talk about how JSON and HTML parsing are native to the TypeScript language and ecosystem. We'll also explain how the Deno runtime gives you the improved development experience of coding in a typed language but with zero setup and no need for a compilation step. We’ll then use Deno+TypeScript to build and run a journalistically interesting scraper together. In this session, participants will learn why running TypeScript with Deno is a great choice for scraping data from the web, and how to write a simple scraper.
Participants should be comfortable using a terminal to run simple commands. Some familiarity with at least one programming language (not necessarily TypeScript) is not essential but would be an advantage. You will need VSCode installed, or another TypeScript-enabled IDE or code editor.
In order to maximise our time, participants are asked to install Deno on their laptops before the workshop and to set up their code editors for editing Deno scripts.

Speakers
ZH

Zeke Hunter-Green

Software Developer, Guardian
SG

Samantha Gottlieb

Associate Software Engineer, The Guardian


Sunday June 4, 2023 09:30 - 10:45 CEST
C3.11

10:45 CEST

Coffee break
Sunday June 4, 2023 10:45 - 11:15 CEST
Cafeteria

11:15 CEST

How to write the perfect grant application
For many investigative journalists, raising funds for projects is a necessary evil. But what makes the difference between a successful grant application and rejection?

Speakers
avatar for Timothy Large

Timothy Large

Director of Independent Media Programmes, International Press Institute
Timothy Large is head of independent media programmes at the International Press Institute (IPI) in Vienna. He is an award-winning journalist, editor and media development specialist who runs the Investigative Journalism for Europe (IJ4EU) programme. Every year, IJ4EU provides more... Read More →


Sunday June 4, 2023 11:15 - 12:30 CEST
Aula 1

11:15 CEST

FOI'ing Europe's suspicion machines
Machine learning algorithms make more and more decisions about people’s lives, including what schools their children attend, who gets interviewed for jobs, and who gets a loan. The spread of risk-scoring models is presented as progress, promising mathematical objectivity and fairness. Yet citizens have no real way to understand or question the decisions such systems make. WIRED and Lighthouse Reports used FOI to learn how these practices work and if they are fair.

Speakers
avatar for Justin-Casimir Braun

Justin-Casimir Braun

Data Reporter, Lighthouse Reports, Germany
Justin is a data journalist focused on the societal impact of automated systems and artificial intelligence. In the past, Justin has worked with AlgorithmWatch e.V., a German digital rights organization, and various grassroots NGOs, documenting human rights violations against migrants... Read More →
avatar for Tarjei Leer-Salvesen

Tarjei Leer-Salvesen

Freelancer, Freelance
Tarjei Leer-Salvesen spent this year six months at Reuters Institute in Oxford to learn more about the differences between 136 RTI laws in the world, and how journalists can use cross-border filing for information in their investigations.As he also is a well know international working... Read More →
avatar for Gabriel Geiger

Gabriel Geiger

Investigative Journalist, Lighthouse Reports
Gabriel is an investigative journalist with Lighthouse Reports. He specializes in surveillance and algorithmic accountability reporting and most recently was the lead reporter on Lighthouse Reports' Suspicion Machines investigation. His work often combines traditional reporting methodologies... Read More →


Sunday June 4, 2023 11:15 - 12:30 CEST
C2.07

11:15 CEST

Working your entire life, struggling as a pensioner
Pensioners with the lowest pensions are hit particularly hard by inflation and rising prices. These are vulnerable groups; some have struggled their entire lives in precarious jobs or taking care of children without savings for their retirement. With the prices of food and electricity escalating, in economies already tightly controlling spending, inflation has thrown the retirement budgets out of balance. In Spain, Datadista has analyzed the data on the impact that inflation has had on pensioners region by region. In Portugal, Divergente has interviewed pensioners and other workers facing harsh economic realities. This session will look into different ways in which one can report on poverty and pension funds.

Speakers
avatar for Diogo Cardoso

Diogo Cardoso

Co-founder and Reporter, DIVERGENTE
Diogo Cardoso is a senior media producer and reporter, based in Lisbon. In the past 15 years he has directed and produced high end imagery for TV and cinematic productions, traveling and working in Europe, Africa, Asia and the Americas. Since 2014 he has been mainly focused on the... Read More →
avatar for Matea Grgurinović

Matea Grgurinović

Journalist, Faktograf.hr/Freelance
I am a Zagreb-based journalist writing mostly about social issues with a strong interest in Southeast Europe, China, and the post-Soviet space and a growing interest in data journalism. I cover topics such as poverty, inequlity, labour/workers' rights, trauma and climate change.
avatar for Ana Tudela

Ana Tudela

Project leader / Cofounder, DATADISTA
Financial and investigative journalist with more than twenty years of experience working for national newspapers as El Economista, Público and El Español and former content editor in chief for the spanish edition of Forbes. I pivoted my professional life since 2016 founding my own... Read More →


Sunday June 4, 2023 11:15 - 12:30 CEST
C2.05

11:15 CEST

Signal for beginners (introductory session)
Signal is an open-source, end-to-end encrypted text messaging application used worldwide by journalists to protect their communications from prying eyes. In this session, we will give an overview of Signal and how to use it (including a demo) as a digital security tool to protect you and your sources.

Speakers
avatar for Harlo Holmes

Harlo Holmes

Director of Digital Security, Freedom of the Press Foundation
Harlo Holmes is the Director of Digital Security at Freedom of the Press Foundation. She strives to help individual journalists in various media organisations become confident and effective in securing their communications within their newsrooms, with their sources, and with the public... Read More →
OM

Olivia Martin

Deputy Director of Digital Security, Freedom of the Press Foundation
Olivia Martin is a Digital Security Fellow at Freedom of the Press Foundation. At FPF, she focuses on researching and delivering digital security trainings to journalists, activists, and human rights defenders. She has spent years in newsrooms as a designer and editor with new media... Read More →
avatar for Jake Charles Rees

Jake Charles Rees

Programme Manager; Manager, Source Protection Programme, Centre for Investigative Journalism (TCIJ)
Jake Charles Rees is a curator, producer and programme manager for The Centre for Investigative Journalism in London, UK. For the CIJ he produces the biannual Logan Symposium, Closed Circuit webTV series, Logan Talks public lecture programme, and is currently focusing on leading the... Read More →


Sunday June 4, 2023 11:15 - 12:30 CEST
C2.01

11:15 CEST

Create a simple data web app in Python with Streamlit
Streamlit is a Python library which allows to quickly and easily build data web applications.It is a useful tool for Python data journalists to share their work with their team in a clear, efficient and timely fashion, despite limitations we will address. In this session, we will create a small application with the Streamlit framework, using a real-world dataset from a past Disclose investigation. We will make a simple dashboard to display relevant insights through tables, graphs and maps. We will also see how to deploy our app online to share it with colleagues and partners. After attending this session, the participants will be able to create simple Streamlit apps and share them online.

Participants should have basic knowledge of the Python language and the pandas library.

Participants who want to join with own laptops will need Python, a code editor and a web browser

 



Speakers
avatar for Natalie Widmann

Natalie Widmann

Data Scientist, Freelance / ida
I'm a Data Scientist supporting journalist and human rights activists with data, tools and automation.I'm happy to talk about scraping data, extracting the most relevant information from it, understanding algorithms and using them for investigations.
avatar for Rémi Labed

Rémi Labed

Journalist, Disclose


Sunday June 4, 2023 11:15 - 12:30 CEST
C3.15

11:15 CEST

How to analyse millions of tweets (or other text) using Python notebooks (and why you might not)
In this hands-on workshop you will be given access to pre-written Python notebooks that contain ‘recipes’ for performing a range of text analysis which can be run within Google Drive. These include recipes that extract adjectives or nouns, tweeters or mentions, and count their frequencies; recipes that classify tweets on a range of measures of hostility, or positive/negative sentiment; and a recipe that groups documents into topic clusters for further analysis. We will also discuss some of the debates around techniques such as AI, machine learning, NLP, and sentiment analysis, and the editorial challenges of using these in stories. You will learn how Google Drive’s Colab notebooks can be used to create ‘recipes’ that fellow journalists can use to perform analyses. Participants will learn what Colab notebooks are, and how they can be useful journalistically. They will learn to identify projects where text can be treated as data, including ranking of word frequencies; adjective and noun extraction; sentiment and toxicity analysis; ngrams; and topic modelling. To attend this session no prior knowledge is required. We will be using Python Colab notebooks, but no knowledge of Python is necessary to run these.You will need a laptop and a Google Drive account.

Speakers
avatar for Paul Bradshaw

Paul Bradshaw

Journalist and Academic, BBC/Birmingham City University
Paul Bradshaw runs the MA in Data Journalism at Birmingham City University and also works as a consulting data journalist with the BBC Shared Data Unit. A journalist, writer and trainer, he has worked with news organisations including The Guardian, Telegraph, Mirror, Der Tagesspi... Read More →


Sunday June 4, 2023 11:15 - 12:30 CEST
C3.11

12:45 CEST

Goodbye - see you next year!
Sunday June 4, 2023 12:45 - 13:15 CEST
Aula 2
 
Filter sessions
Apply filters to sessions.