Loading…
The European Investigative Journalism and Dataharvest Conference organised by Journalismfund.eu, is the most relevant networking event for investigative and data journalists in Europe. Dataharvest EIJC17 will take place on Friday 19, Saturday 20 and Sunday morning 21 May 2017, with a pre-conference Hack Day on Thursday 18 May.

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

Data [clear filter]
Thursday, May 18
 

09:58

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

Speakers
avatar for Georgiana Bere

Georgiana Bere

Data engineer, https://tenders.exposed
Data savvy programmer and open data supporter. I believe data contains wisdom and I help people get to it.
avatar for Adriana Homolova

Adriana Homolova

data journalist, KRO-NCRV
Data journalist @ Pointer / KRO-NCRV
avatar for Friedrich Lindenberg

Friedrich Lindenberg

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

Victor Nitu

Software Developer, Datopian
Victor Nițu is currently a software developer at Datopian, an open data solutions provider spun off from Open Knowledge.Victor is also one of the developers of Elvis, a public tenders visualisation platform that aims to visually expose patterns of corruption in the EU and beyond.In... Read More →
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

Open Knowledge Foundation
Stefan Wehrmeyer ist investigativer Softwareentwickler. Er startete 2011 das Informationsfreiheits-Portal FragDenStaat.de und arbeitete von 2014-2017 beim gemeinnützigen Recherchezentrum correctiv.org an datenjournalistischen Projekten. Momentan kämpft er für mehr Informationsfreiheit... Read More →


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

12:00

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

Speakers
CL

Christiaan Laevaert

Team Leader Internet, Eurostat
Chris Laevaert joined the Digital dissemination Unit of Eurostat in 2005 and is now team leader Internet, where he is responsible for the management of the Eurostat website including the associated visualisations. He is an active member of the Dissemination Working Group in the European... Read More →


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

12:00

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

Speakers
avatar for Maarten Lambrechts

Maarten Lambrechts

Data journalist & visualisation consultant, Self employed
Maarten Lambrechts is a freelance data journalist and datavisualisation expert. After working some years as a data journalist at Belgian newspaper De Tijd, he now works as a freelancer. He designs and develops data visualisations, builds tools to visualise data and gives trainings... Read More →


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

14:00

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

Speakers
avatar for Maarten Lambrechts

Maarten Lambrechts

Data journalist & visualisation consultant, Self employed
Maarten Lambrechts is a freelance data journalist and datavisualisation expert. After working some years as a data journalist at Belgian newspaper De Tijd, he now works as a freelancer. He designs and develops data visualisations, builds tools to visualise data and gives trainings... Read More →


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

14:00

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

Speakers

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

14:00

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

Speakers
avatar for Rob Gebeloff

Rob 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.


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

15:15

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

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

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

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

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

Speakers
avatar for Georgiana Bere

Georgiana Bere

Data engineer, https://tenders.exposed
Data savvy programmer and open data supporter. I believe data contains wisdom and I help people get to it.
avatar for Friedrich Lindenberg

Friedrich Lindenberg

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

Victor Nitu

Software Developer, Datopian
Victor Nițu is currently a software developer at Datopian, an open data solutions provider spun off from Open Knowledge.Victor is also one of the developers of Elvis, a public tenders visualisation platform that aims to visually expose patterns of corruption in the EU and beyond.In... Read More →
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

Open Knowledge Foundation
Stefan Wehrmeyer ist investigativer Softwareentwickler. Er startete 2011 das Informationsfreiheits-Portal FragDenStaat.de und arbeitete von 2014-2017 beim gemeinnützigen Recherchezentrum correctiv.org an datenjournalistischen Projekten. Momentan kämpft er für mehr Informationsfreiheit... Read More →


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

15:15

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

Speakers
avatar for Heleen Vollers

Heleen Vollers

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


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

15:15

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

Speakers
avatar for Theresa Crysmann

Theresa Crysmann

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

Raphaël Kergueno

Policy officer, TI EU


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

16:30

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

Speakers
avatar for Helena Bengtsson

Helena Bengtsson

Editor, Data Journalism, Sveriges Television
Helena Bengtsson is Editor for Data Journalism at Sveriges Television, Sweden’s national television broadcaster. She previously worked as Editor, Data Projects at the Guardian in London, UK between 2014-2017. In 2006 and 2007, she was database editor at the Center for Public Integrity... Read More →
avatar for Friedrich Lindenberg

Friedrich Lindenberg

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


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

16:30

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

Speakers
avatar for Håkon Høydal

Håkon Høydal

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


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

09:30

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

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

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

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

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

Speakers
avatar for Georgiana Bere

Georgiana Bere

Data engineer, https://tenders.exposed
Data savvy programmer and open data supporter. I believe data contains wisdom and I help people get to it.
avatar for Friedrich Lindenberg

Friedrich Lindenberg

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

Victor Nitu

Software Developer, Datopian
Victor Nițu is currently a software developer at Datopian, an open data solutions provider spun off from Open Knowledge.Victor is also one of the developers of Elvis, a public tenders visualisation platform that aims to visually expose patterns of corruption in the EU and beyond.In... Read More →
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

Open Knowledge Foundation
Stefan Wehrmeyer ist investigativer Softwareentwickler. Er startete 2011 das Informationsfreiheits-Portal FragDenStaat.de und arbeitete von 2014-2017 beim gemeinnützigen Recherchezentrum correctiv.org an datenjournalistischen Projekten. Momentan kämpft er für mehr Informationsfreiheit... Read More →


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

09:30

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

Speakers
avatar for Eva Belmonte

Eva Belmonte

Managing Editor, Civio
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 Managing Editor at Fundación... Read More →


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

09:30

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

Speakers
avatar for Georgiana Bere

Georgiana Bere

Data engineer, https://tenders.exposed
Data savvy programmer and open data supporter. I believe data contains wisdom and I help people get to it.
avatar for Ben Meghreblian

Ben Meghreblian

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

Victor Nitu

Software Developer, Datopian
Victor Nițu is currently a software developer at Datopian, an open data solutions provider spun off from Open Knowledge.Victor is also one of the developers of Elvis, a public tenders visualisation platform that aims to visually expose patterns of corruption in the EU and beyond.In... Read More →


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

10:45

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

Speakers
avatar for Eva Belmonte

Eva Belmonte

Managing Editor, 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 Managing Editor at Fundación... Read More →
avatar for Marta Orosz

Marta Orosz

Reporter, Correctiv
Marta Orosz leitete zuletzt das investigative Rechercheprojekt Grand Theft Europe zum Thema Umsatzsteuerbetrug und koordinierte 35 Redaktionen in 30 Ländern. Davor hat sie die Fälle von sexueller Belästigung beim WDR aufgedeckt. Sie recherchiert in erster Linie im Bereich der Steuer... Read More →


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

14:00

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

Speakers
avatar for Anders Pedersen

Anders Pedersen

Senior Open Data Officer, Natural Resource Governance Institute


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

14:00

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

Speakers
avatar for Eva Belmonte

Eva Belmonte

Managing Editor, Civio
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 Managing Editor at Fundación... Read More →
avatar for Hristio Boytchev

Hristio Boytchev

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

Patrick Stotz

Spiegel Online
Seit Juli 2015 Mitglied des Datenjournalismus-Teams von SPIEGEL ONLINE. Macht aus Daten Geschichten. Zuständig für die komplette Bandbreite von Datenbeschaffung, über -analyse und -visualisierung bis zur Berichterstattung.
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

Open Knowledge Foundation
Stefan Wehrmeyer ist investigativer Softwareentwickler. Er startete 2011 das Informationsfreiheits-Portal FragDenStaat.de und arbeitete von 2014-2017 beim gemeinnützigen Recherchezentrum correctiv.org an datenjournalistischen Projekten. Momentan kämpft er für mehr Informationsfreiheit... Read More →


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

14:00

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

Speakers
avatar for Ana Lutzky

Ana Lutzky

Journalist, AEF Info
Journalist living in Paris, responsible since January 2019 of implementing data journalism at AEF Info news agency in Paris. Writing weekly data driven articles about education and research at AEF Data Sup-Recherche. Helping other departments on an ad hoc basis including housing... Read More →



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

15:15

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


Speakers
avatar for Corina Buruiana

Corina Buruiana

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

Glen Campbell

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


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

15:15

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

Speakers
avatar for Anders Pedersen

Anders Pedersen

Senior Open Data Officer, Natural Resource Governance Institute


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

15:15

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

Speakers
avatar for Eva Belmonte

Eva Belmonte

Managing Editor, Civio
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 Managing Editor at Fundación... Read More →
avatar for Hristio Boytchev

Hristio Boytchev

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

Patrick Stotz

Spiegel Online
Seit Juli 2015 Mitglied des Datenjournalismus-Teams von SPIEGEL ONLINE. Macht aus Daten Geschichten. Zuständig für die komplette Bandbreite von Datenbeschaffung, über -analyse und -visualisierung bis zur Berichterstattung.
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

Open Knowledge Foundation
Stefan Wehrmeyer ist investigativer Softwareentwickler. Er startete 2011 das Informationsfreiheits-Portal FragDenStaat.de und arbeitete von 2014-2017 beim gemeinnützigen Recherchezentrum correctiv.org an datenjournalistischen Projekten. Momentan kämpft er für mehr Informationsfreiheit... Read More →


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

15:15

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

Speakers
avatar for Ana Lutzky

Ana Lutzky

Journalist, AEF Info
Journalist living in Paris, responsible since January 2019 of implementing data journalism at AEF Info news agency in Paris. Writing weekly data driven articles about education and research at AEF Data Sup-Recherche. Helping other departments on an ad hoc basis including housing... Read More →



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

16:30

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

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

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

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

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

Speakers
avatar for Georgiana Bere

Georgiana Bere

Data engineer, https://tenders.exposed
Data savvy programmer and open data supporter. I believe data contains wisdom and I help people get to it.
avatar for Friedrich Lindenberg

Friedrich Lindenberg

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

Victor Nitu

Software Developer, Datopian
Victor Nițu is currently a software developer at Datopian, an open data solutions provider spun off from Open Knowledge.Victor is also one of the developers of Elvis, a public tenders visualisation platform that aims to visually expose patterns of corruption in the EU and beyond.In... Read More →
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

Open Knowledge Foundation
Stefan Wehrmeyer ist investigativer Softwareentwickler. Er startete 2011 das Informationsfreiheits-Portal FragDenStaat.de und arbeitete von 2014-2017 beim gemeinnützigen Recherchezentrum correctiv.org an datenjournalistischen Projekten. Momentan kämpft er für mehr Informationsfreiheit... Read More →


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

16:30

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

Speakers
avatar for Caelainn Barr

Caelainn Barr

Data Projects Editor, The Guardian
Caelainn Barr is the data projects editor at the Guardian. When working for the Bureau of Investigative Journalism, she used data analysis to uncover the misuse of expenses by the European Commission and human rights abuses in Ethiopia. She has also worked at the Wall Street Journal... Read More →
avatar for Helena Bengtsson

Helena Bengtsson

Editor, Data Journalism, Sveriges Television
Helena Bengtsson is Editor for Data Journalism at Sveriges Television, Sweden’s national television broadcaster. She previously worked as Editor, Data Projects at the Guardian in London, UK between 2014-2017. In 2006 and 2007, she was database editor at the Center for Public Integrity... Read More →


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

09:30

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

Speakers
avatar for Alexandre Léchenet

Alexandre Léchenet

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


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

09:30

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

Speakers
avatar for Magdalena Wnuk

Magdalena Wnuk

Senior Analyst, Art 61


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

10:45

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

Speakers
avatar for Theresa Crysmann

Theresa Crysmann

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

Raphaël Kergueno

Policy officer, TI EU


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

12:00

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

Speakers
avatar for Theresa Crysmann

Theresa Crysmann

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

Raphaël Kergueno

Policy officer, TI EU
avatar for Magdalena Wnuk

Magdalena Wnuk

Senior Analyst, Art 61


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