Loading…
Dataharvest-EIJC21 has ended
The European Investigative Journalism Conference - arranged by Arena for Journalism in Europe.

Buy your ticket here!

Log in to bookmark your favorites and sync them to your phone or calendar.

Data journalism [clear filter]
Tuesday, May 18
 

14:00 CEST

Scraping from scratch
You may have come across acronyms like HTTP and HTML, but what does it all mean, and what does it matter? The principals that underpin the web are likely simpler than you think. Understanding these ideas can help you scrape information you need from the web, as well as comprehend how, exactly, your stories reach your readers. No technical knowledge required.
Moderators
avatar for Adriana Homolová

Adriana Homolová

Proud coordinator of the data skills training 📊, ARENA, Follow The Money, Lost in Europe
Adriana is a freelance data journalist, trainer and public spending nerd. At Dataharvest, she coordinates the data skills training. At other times, she writes scrapers and investigates European Union for Follow The Money's Bureau Brussel and collects data on missing children in migration... Read More →

Speakers
avatar for Max Harlow

Max Harlow

Financial Times
Max Harlow works on the visual and data journalism team at the Financial Times in London, where he focuses on using data to find and tell investigative stories. @maxharlow

Tuesday May 18, 2021 14:00 - 15:15 CEST
Online
  Data journalism, Presentation
 
Wednesday, May 19
 

14:00 CEST

No database, no problem
When and How to Create Your Own Dataset: Even if you're lucky enough to work somewhere with a strong open records law, sometimes the best data stories star with no database at all. In this class, we'll discuss when it's appropriate to build your own database out of documents or other records, and everything you'll need to consider to do the job correctly.
Moderators
avatar for Adriana Homolová

Adriana Homolová

Proud coordinator of the data skills training 📊, ARENA, Follow The Money, Lost in Europe
Adriana is a freelance data journalist, trainer and public spending nerd. At Dataharvest, she coordinates the data skills training. At other times, she writes scrapers and investigates European Union for Follow The Money's Bureau Brussel and collects data on missing children in migration... Read More →

Speakers
avatar for Robert Gebeloff

Robert Gebeloff

Robert Gebeloff is a New Yorks Times reporter specializing in data analysis. He works on in-depth stories where numbers help augment traditional reporting.

Wednesday May 19, 2021 14:00 - 15:00 CEST
Online
  Data journalism, Presentation
 
Thursday, May 20
 

14:00 CEST

Scraping without programming
Do you love the endless copy pasting? If you do, this session is not for you. We will show you how to scrape from Google Docs and how to use the chrome extension tool "Scraper".

If you would like to follow along, please download the extension Scraper and Web scraper for your Google Chrome before the session (they only work in Chrome).You can also build the 'ImportJSON' function in your Google Sheets Here or here. 
Speakers
avatar for Adriana Homolová

Adriana Homolová

Proud coordinator of the data skills training 📊, ARENA, Follow The Money, Lost in Europe
Adriana is a freelance data journalist, trainer and public spending nerd. At Dataharvest, she coordinates the data skills training. At other times, she writes scrapers and investigates European Union for Follow The Money's Bureau Brussel and collects data on missing children in migration... Read More →
avatar for Carmen Aguilar García

Carmen Aguilar García

Senior Data Journalist, Sky News
Data journalist at Sky News. Scraping, cleaning, data analysis, visual storytelling but above all JOURNALISM!

Thursday May 20, 2021 14:00 - 15:15 CEST
Online
  Data journalism, Presentation
 
Friday, May 21
 

16:00 CEST

Tracking industrial emissions - from ETS data to companies' registries
The UK has pledged that by 2050, the amount of carbon dioxide emitted by all the cars, homes and industry in the country will be net-zero. Manufacturing and industry - that are the drivers of the country’s economy and important job providers- often escape public scrutiny. Data-led investigation from Sky News found out that 15 firms are responsible for around a sixth of all the UK's annual greenhouse gas emissions.
In order to crunch the numbers and understand who the big companies behind specific installations are, data journalist Carmen Aguilar Garcia had to analyse the European Emission Trade system data and cross-check it with the companies’ registries. In this session, she will take us through her investigation process, and share with us tips on how to deal with the ETS data.

Read Sky News investigation HERE.
Moderators
avatar for Jelena Prtoric

Jelena Prtoric

Journalist / Arena Climate Network Coordinator, Arena for Journalism in Europe

Speakers
avatar for Carmen Aguilar García

Carmen Aguilar García

Senior Data Journalist, Sky News
Data journalist at Sky News. Scraping, cleaning, data analysis, visual storytelling but above all JOURNALISM!

Friday May 21, 2021 16:00 - 17:15 CEST
Online
  Data journalism, Presentation
 
Tuesday, May 25
 

11:00 CEST

The data state of mind: Where to get it
When looking for the data you need, it helps to have a method: Jonathan Stoneman shares his in this interactive session.
Moderators
avatar for Adriana Homolová

Adriana Homolová

Proud coordinator of the data skills training 📊, ARENA, Follow The Money, Lost in Europe
Adriana is a freelance data journalist, trainer and public spending nerd. At Dataharvest, she coordinates the data skills training. At other times, she writes scrapers and investigates European Union for Follow The Money's Bureau Brussel and collects data on missing children in migration... Read More →

Speakers
avatar for Jonathan_Stoneman

Jonathan_Stoneman

Data journalism trainer, Freelance (UK)

Tuesday May 25, 2021 11:00 - 12:15 CEST
Online
  Data journalism, Presentation

14:00 CEST

How to think about data: get organised and avoid mistakes with better working practices
This session will explain concepts as well as cover tips, tricks, and traps to avoid which will make your work with spreadsheets easier and more effective. This will include wide versus tall data, separating semantics from presentation, how to name things, and data validation techniques. In short: everybody who regularly works with spreadsheets should listen in.
Moderators
avatar for Adriana Homolová

Adriana Homolová

Proud coordinator of the data skills training 📊, ARENA, Follow The Money, Lost in Europe
Adriana is a freelance data journalist, trainer and public spending nerd. At Dataharvest, she coordinates the data skills training. At other times, she writes scrapers and investigates European Union for Follow The Money's Bureau Brussel and collects data on missing children in migration... Read More →

Speakers
avatar for Max Harlow

Max Harlow

Financial Times
Max Harlow works on the visual and data journalism team at the Financial Times in London, where he focuses on using data to find and tell investigative stories. @maxharlow

Tuesday May 25, 2021 14:00 - 15:15 CEST
Online
  Data journalism, Presentation
 
Wednesday, May 26
 

11:00 CEST

Automating collaboration with many partners
Russian reporters in istories.media (short for Important stories) automated some of the tasks of investigative journalism and created apps that share findings with dozens of newsrooms all across the country.
Moderators
avatar for Adriana Homolová

Adriana Homolová

Proud coordinator of the data skills training 📊, ARENA, Follow The Money, Lost in Europe
Adriana is a freelance data journalist, trainer and public spending nerd. At Dataharvest, she coordinates the data skills training. At other times, she writes scrapers and investigates European Union for Follow The Money's Bureau Brussel and collects data on missing children in migration... Read More →

Speakers
avatar for Roman Anin

Roman Anin


Wednesday May 26, 2021 11:00 - 12:30 CEST
Online
  Data journalism, Presentation

14:00 CEST

Data collaboration in local media
10 local newsrooms across northern and mid-Norway shared large datasets, analyzed 500.000 state payments to farmers, and exposed which farmers and areas got the most state subsidies. They also used it to expose covid19-funding, the wages to public workers, and other stories.This was done with new tools in Excel 2016, that allowed the newsrooms to do data journalism without coding. Reporter Rune Ytreberg shows how they worked and how you can do the same, no matter which platform you use.
Moderators
avatar for Adriana Homolová

Adriana Homolová

Proud coordinator of the data skills training 📊, ARENA, Follow The Money, Lost in Europe
Adriana is a freelance data journalist, trainer and public spending nerd. At Dataharvest, she coordinates the data skills training. At other times, she writes scrapers and investigates European Union for Follow The Money's Bureau Brussel and collects data on missing children in migration... Read More →

Speakers
avatar for Rune Ytreberg

Rune Ytreberg

Journalist, Itromsø
Rune Ytreberg är redaktör för tidningen iTromsø:s datadesk och utvecklar datastödd journalistik om ekonomi för Polariskoncernen. Han jobbade 15 år med NRK:s undersökande program Brennpunkt, har vunnit Skup-priset och har deltagit i flera större internationella grävproje... Read More →

Wednesday May 26, 2021 14:00 - 15:15 CEST
Online
  Data journalism, Presentation
 
Thursday, May 27
 

11:00 CEST

Seven ways to tell the data story
Some people struggle to find story angles in data - and some people miss fresher angles because they rely on the same approach each time. In this session Paul Bradshaw will outline the 7 most angles used when finding stories in data - and an 8th approach to using data to generate story leads - as a methodical approach to use those in ideas generation.
Moderators
avatar for Adriana Homolová

Adriana Homolová

Proud coordinator of the data skills training 📊, ARENA, Follow The Money, Lost in Europe
Adriana is a freelance data journalist, trainer and public spending nerd. At Dataharvest, she coordinates the data skills training. At other times, she writes scrapers and investigates European Union for Follow The Money's Bureau Brussel and collects data on missing children in migration... Read More →

Speakers
avatar for Paul Bradshaw

Paul Bradshaw

Journalist and Academic, Birmingham City University
Paul Bradshaw runs the MA in Data Journalism and MA in Multiplatform and Mobile Journalism at Birmingham City University and also works as a consulting data journalist with the BBC England Data Unit. A journalist, writer and trainer, he has worked with news organisations includin... Read More →

Thursday May 27, 2021 11:00 - 12:15 CEST
Online
  Data journalism, Presentation

14:00 CEST

Joining tables in SQL
SQL is a powerful tool to join information contained in multiple datasets. When you’ve done all you can with spreadsheets but either your data are too big or you need to join tables (files), SQL (Structured Query Language) is for you.

To attend this class you need to have a basic knowledge of spreadsheets and you also need to download DB Browser, https://sqlitebrowser.org/
Moderators
avatar for Adriana Homolová

Adriana Homolová

Proud coordinator of the data skills training 📊, ARENA, Follow The Money, Lost in Europe
Adriana is a freelance data journalist, trainer and public spending nerd. At Dataharvest, she coordinates the data skills training. At other times, she writes scrapers and investigates European Union for Follow The Money's Bureau Brussel and collects data on missing children in migration... Read More →

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 →

Thursday May 27, 2021 14:00 - 15:15 CEST
Online
  Data journalism, Presentation
 
Friday, May 28
 

10:00 CEST

Data Buffet: Heavy industry's Emissions Trading System (ETS) and pollution
Join us for a rich data buffet with two data scientists from the European Environmental Agency. We'll first dive into the Emission Trading System to better understand how it works, then explore the data related to industrial pollution. You will learn what sort of data related (heavy) industry EEA has in store, how it's collected and how to make the best use of it.
Speakers
avatar for Jelena Prtoric

Jelena Prtoric

Journalist / Arena Climate Network Coordinator, Arena for Journalism in Europe
avatar for Javier Esparrago

Javier Esparrago

Expert - Energy and Environment at the European Environment Agency, European Environment Agency
Javier works as an expert in energy and environment at the European Environment Agency (EEA). He works on the interface of science and environmental policy and his aim is to inform EU climate and energy policies with accurate and updated data and information. He contributes to various... Read More →
avatar for Juan Calero

Juan Calero

Expert - Industry and Environment at European Environment Agency, European Environment Agency
As part of my current role, I lead assessments and policy support activities on the interface between industry and environment, and coordinate the monitoring and reporting of industrial emission data.Previously, I was a principal consultant and project manager at Wood. I have seven... Read More →

Friday May 28, 2021 10:00 - 11:00 CEST
Online
  Data journalism, Presentation

11:30 CEST

Zoom into aviation - offset schemes, state aids and science behind the emissions
How to analyse aviation’s climate ambitions? Is the UN’s aviation offsetting scheme (Corsia) in any way compatible with the EU Green Deal? Join us for a session with Jo Dardenne for Transport&Environment to learn about aviation offsetting, the economic side of the aviation industry (taxation state aids) and the role of synthetic fuels and hydrogen-based fuels in the aviation industry.




Moderators
avatar for Jelena Prtoric

Jelena Prtoric

Journalist / Arena Climate Network Coordinator, Arena for Journalism in Europe

Speakers
JD

Jo Dardenne

Aviation Manager, Transport&Environment

Friday May 28, 2021 11:30 - 12:30 CEST
Online
  Data journalism, Presentation
 
Tuesday, June 1
 

14:00 CEST

JavaScript basic in Observable
How JavaScript and its multiple libraries such as D3, Turf or lodash help us to do visual, explanatory and investigative journalism every day. With real-life examples, Adrián Blanco, Martín González and Yaryna Serkez will describe how they learned and integrated JavaScript in their day to day workflows and how anyone can learn it. Let's be clear, JavaScript is hard – so the session is going to be a very practical one where you will see and learn how to get started no matter what you want to do: data wrangling, data analysis or data visualization. We'll use Observable notebooks, so participants can follow and learn the basics to gather data, ask questions to their data and visiualize it.
Moderators
avatar for Adriana Homolová

Adriana Homolová

Proud coordinator of the data skills training 📊, ARENA, Follow The Money, Lost in Europe
Adriana is a freelance data journalist, trainer and public spending nerd. At Dataharvest, she coordinates the data skills training. At other times, she writes scrapers and investigates European Union for Follow The Money's Bureau Brussel and collects data on missing children in migration... Read More →

Speakers
MG

Martin Gonzales

The Economist
avatar for Adrian Blanco

Adrian Blanco

Visual reporter, The Washington Post
Adrian Blanco is a Spanish data journalist currently working at The Washington Post. Data stuff, visualizations, reporting and a bit of coding.

Tuesday June 1, 2021 14:00 - 15:00 CEST
Online
  Data journalism, Presentation
 
Wednesday, June 2
 

14:00 CEST

How to parse anything using String Expressions and Regex
Let's face it. Not everything in the data world comes in a clean, ready-to-use CSV file. In this class,Rob Gebeloff will show you how to extract the good stuff from the big mess of a file you're working with.
Moderators
avatar for Adriana Homolová

Adriana Homolová

Proud coordinator of the data skills training 📊, ARENA, Follow The Money, Lost in Europe
Adriana is a freelance data journalist, trainer and public spending nerd. At Dataharvest, she coordinates the data skills training. At other times, she writes scrapers and investigates European Union for Follow The Money's Bureau Brussel and collects data on missing children in migration... Read More →

Speakers
avatar for Robert Gebeloff

Robert Gebeloff

Robert Gebeloff is a New Yorks Times reporter specializing in data analysis. He works on in-depth stories where numbers help augment traditional reporting.

Wednesday June 2, 2021 14:00 - 15:00 CEST
Online
  Data journalism, Presentation
 

Twitter Feed