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!
'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.
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 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:
You can view a report on the data quality here.
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.)
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.
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
Starting with the basics of data, we will show you where to find data and how to ask questions to datasets using simple spreadsheets.
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.
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.
Guest Speaker: Verena Pflieger
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
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
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)
14:00 Team work
16:00 Short project presentations
17:00 Team Presentation (status quo)
19:30 Team work (as needed)
10:15 Good Morning Game
10:30 Team Work / further collaboration
11:15 Visualisation Gallery
11:35 Analogue Visualisation