EIJC17 & Dataharvest

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.

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.

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.

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.

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.

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

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.

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.

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.

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.