Thank you for your interest.


For the first edition, 'The Story Hunt: Uncover the EU', signups are now closed. If you want to stay updated on the results and possible future editions of The Story Hunt, sign up below.

In the meantime, feel free to check out the materials created for the workshops!


Welcome to 'The Story Hunt'!


'The Story Hunt: Uncover the EU' is a programme hosted by the Open Knowledge Foundation Germany's teams of Datenschule, OpenBudgets, and SubsidyStories.eu. Together with journalists, analysts, non-profit organizations, developers and designers, we want to develop and apply the skills needed to hunt stories in financial data.

The Story Hunt is split into two separate parts: a series of Workshops and an Expedition Weekend in Berlin.

The workshops are tailored to aspiring data journalists and non-profit organizations that are interested in improving their data-literacy skills. They are run by our team and by trusted members of the civic tech community in Germany.

They will culminate in the weekend-expedition at end of June, where - together with proven experts - we are going to dive into a massive database of the European Union’s primary financial instrument, the ESIFunds.

During the weekend, we will form interdisciplinary teams that collaboratively work on finding stories, leads, and data analyses around the EU and its money flows. This will offer an ideal opportunity to practice the acquired skills in a supportive environment.

The Challenge


Our aim is to use the extensive EU subsidy data that we have collected to find interesting stories on how the EU spends the taxpayers money. But what exactly are we hunting for? The range of possible stories is vast, but using the data to follow the money and research what kind of projects were financed can yield astonishing results.

An illustrative example is Farmsubsidy, a similar project that collected all the EU’s agricultural data. An investigation led by Greenpeace analysing the top 100 recipients of the agricultural fund then uncovered that “Individuals or families featured in the Sunday Times’ Rich List own or control 16 businesses among the Top 100 beneficiaries, receiving a total of £10.6m last year in “single payment scheme” subsidies alone, and £13.4m in total farm subsidies.” This was a quite revealing result produced by data driven journalism. Thus, examining flows of financial data could be the cornerstone of your next story or campaign.

With The Story Hunt, we want to get together and venture into the data in order to find out whether it contains similar, exciting stories.

A first insight from the Czech dataset, for instance, was that 80% of their ESIFunds was received by public institutions. Therefore, one of the ideas includes focussing on recipients such as universities that are frequently financed through EU research grants.

Another approach might be looking into the EU’s funding priorities such as job creation and evaluating these by using the operational programmes.

However, we are very open to any suggestions and will develop new project ideas together on the first day of the weekend workshop.

The Data


The EU and its money flows are notoriously complex and intransparent. In an effort to change this, the team behind SubsidyStories.eu has gathered, cleaned, and concatenated data on the EU’s most important financial instrument: the European Structural Investment Funds (ESIF).

Together with representatives of different disciplines (journalists, non-profit organizations, developers, domain experts, and designers) we want to immerse ourselves in the data, hunting for stories.

While there are many existing transparency portals and data sources on the EU’s finances, the actual, local recipients of the ESIFunds have thus far often been difficult to access since they were published regionally. Now though, the data is available in one dataset telling you where the money goes. If you already want to look at the data, check out the following links:

Detailed documentation

Policy and data background

Data Description

You can view a report on the data quality here.

The data on OpenSpending

The dataset in one .csv file (879MB)

The quality (and thus the level of transparency) of the data varies greatly across the EU member states:

(Image taken from the ESIF data quality report.)

The Workshops


Learn essential data-skills such as finding, scraping, cleaning, analysing, and visualising data and apply you newly-developed skills in the Story Hunt!

We offer 5 weekly workshops, each 2 hours, starting on 23 May 2017.

1. Getting Started

23 May 2017

The first meeting will be an introduction on the upcoming topics and the Structure of the ESIF data. We will present inspiring data-driven stories to get your creativity flowing.

Guest Speaker: Simon Jockers

Workshop Materials Week 1

2. Asking questions and Finding Data

30 May 2017

Starting with the basics of data, we will show you where to find data and how to ask questions to datasets using simple spreadsheets.

Workshop Materials Week 2

3. Scraping & Cleaning Data

6 June 2017

In this workshop we explain the basics of scraping data from the web and show you how to clean these often messy datasets with tools such as OpenRefine or LibreOffice.

Workshop Materials Week 3

4. Analytics: Intro into Basic Statistics & Spreadsheets

13 June 2017

Statistics have a bad reputation of being difficult and manipulative. In this workshop we will show why you should use statistics and how they can help you validate your data. We will run basic functions for first analysis.

Workshop Materials Week 4

5. Visualising Data

20 June 2017

Data comes to life in visualisations. In this workshop we will discuss basic principles of design and data visualisations.

Guest Speaker: Lisa Rost

Workshop Materials Week 5

The Weekend-Expedition




The Story Hunt Expedition is a weekend-long event that will bring together the previously trained participants with experts from the field of programming, data analysis and design. The weekend will begin with a dive into the data on Friday. Together we will attempt to find first leads and develop research questions that guide us through the following two days of intense story hunting.




The Story Hunt will be a combination of group work, training, and mutual learning that teaches the whole investigative data pipeline process from asking questions to the dataset, hypothesising, cleaning and analysing it and turning the results into stories, presentations and visualisations.

It fosters teamwork and collaboration in all the necessary fields for working on a data-driven story, and allows us to attempt to produce concrete output in one weekend.

All costs for the weekend and travel within Europe (up to 250 E) are covered upon acceptance and participation in the expedition

Location: Impact Hub Berlin

Programme:

Friday 30 June

14:30 Arrival at Impact Hub Berlin

15:00 Welcome & Get to know each other

15:30 World-Café on Financial Data

16:15 Intro: The Data Pipeline

16:30 Coffee Break

16:40 Farmer's Market: Topics, Skills & finding a group

17:50 Brigitte Alfter: Data Journalism & Collaboration

18:00 Defining Challenges & Goals

18:30 Project Pitch

19:00 Dinner

Saturday 1 July

09:00 Coffee

09:15 Good Morning Game

09:30 Rethinking Challenges & Hypothesis

10:00 Team work

11:30 Data Pipeline Review

12:00 Coffee Break

12:15 Team work / Break out Sessions (tbd)

13:00 Lunch

14:00 Team work

16:00 Short project presentations

17:00 Team Presentation (status quo)

18:05 Dinner

19:30 Team work (as needed)

22:00 End

Sunday 2 July

10:00 Coffee

10:15 Good Morning Game

10:30 Team Work / further collaboration

11:15 Visualisation Gallery

11:35 Analogue Visualisation

13:00 Lunch

14:00 Departure

Timeline