Data investigations

During my time at correctiv.org (2014-2017) I created database news apps, scraped and collected data, analyzed it for investigations, worked on the CMS and was responsible for digital security in the newsroom.

Here are some of the publications:

• German Animal Farming and Farm Subsidies – this investigation found that many intensive animal farms also receive farm subsidies despite their bad impact on the environment. My data analysis matched companies of two separate databases (E-PRTR and farm subsidies) and included nitrate ground water measurements in further reporting.
• Euros for Doctors – a database of payments from pharma companies to doctors for Germany, Austria and Switzerland. This included scraping, cleaning, deduplicating and analysing the dataset and building the web app with URLs for every doctor (Code on GitHub)
• Nursing Homes Database – a journalistic view on the nursing home score cards in a searchable database including a call to action for readers to requests non-public reports via fragdenstaat.de. Code on GitHub)
• Court Donations – Money collected by the judicial system is distributed without much oversight. Data was collected via FOI, cleaned and consolidated and then put into a searchable database. (Code on GitHub)