Friday 14:00–14:45 in Hall 5

Visualizing FragDenStaat.de

Andrej Warkentin

Audience level:
Novice

Description

FragDenStaat.de is a website that helps people to make freedom of information requests in Germany. Starting in 2011, they collected over 12000 of these requests. Using pandas and matplotlib, I tried to bring life into this interesting data set.

Abstract

Motivation

FragDenStaat.de offers an API with which you can scrape more than 12000 public freedom of information requests. Each request contains information about: when it was sent, to which public body and to which jurisdiction it was sent, how long it took the public body to complete the request, whether the request was successful and if not, why so. Visualizing all these aspects of the data set might lead to new insights about this transparacy process.

Data preparation

How I scraped the data set and organized it using pandas.

Data visualization

How I visualized the data set using pandas and matplotlib.

Visualizations

The results of my work so far.