The Government of the City of Buenos Aires has a catalog of data where it publishes information in open format to make different areas of its administration more open to the public eye.

We  began searching among the datasets available to work with those of high relevance considering public interest.

We decided to download the datasets related to the salaries of the cabinet officials and the chief of the Buenos Aires administration.

Working with the database

As a first task, we downloaded the two files with the salaries for 2012 and 2013, we merged them in one Excel spreadsheet  so we could calculate the monthly variations. The data was distributed in several columns to facilitate the analysis and to have the chance to get a global vision of the whole set.

Because the published databases were clean, with no important mistakes, there was no need to do a lot of work on the information published by the City administration.

For a first story (More than 40 percent pay rise for BA ministers) we decided to calculate the percentage variations between July 2012 and July 2013, since the information published reached that month.

In the second story (Another pay rise for BA ministers: 20% in the last semester) with the complete 2013 data, the percentage difference was calculated for the period July-December 2013.

To facilitate the journalistic work, in both cases rankings by official were created according to salaries for all of 2012 and changes in ranking were analyzed according to salaries perceived in 2013.

The visualizations

When the work on the database was done, the journalists and the multimedia design team met to create a visualization that would clearly show the conclusions they had arrived at.

For the first publication, the percentage salary rise between July 2012 and July 2013 was considered.

The second visualization worked with the information of the second semester of 2013.  Seguir leyendo →