blog

News Editors and Data Wranglers Hangout - Live

Written by
  • Teodora Beleaga
Outdated Content Warning: This content refers to an older version of OpenSpending. See here for information about the next version of OpenSpending and ways to contribute.

The News Editors’ and Data Wranglers’ Teams are catching up tonight in a joint Hangout. In the interest of transparency we are running this live-blog as an experiment.

Refresh at your convenience.

7.02pm (GMT) We are wrapping up, as our to-do lists are growing. Final points include allocation of more administrative tasks and an awesome project that Steve came up with which is to map all monies spent on energy management, specifically with regards to global warming and the funds budgeted there.

6.49pm (GMT) Berlin-based Michael is sharing his project of opening up budgets across German cities, including this one and this one. In partnership with Miriam Ruhenstroth they aim to get the data up on Open Spending.

6.42pm (GMT) Another insight from the call is that our guide, which aims to help communities get started and has been translated (by volunteers) in four languages, may yet again be in need of a refresh. Steve is going to go through it with a pair of fresh eyes and help update it. If you want to help too, please let us know. Getting communities started as seamlessly as possible with Open Spending is very important to us.

6.32pm (GMT) We’re talking data cleaning now. Big Data that is. Elain’s data is a 1GB file of over 1m lines. She is currently attempting the task with MySQL and OpenRefine. Do you have any other suggestions?

6.27pm (GMT) One of the data wranglers, Elaine Ayo is working cleaning the data on EU structural funds for Italy, which she claimed here. “It’s quite large and so I am still working on trying to figure out how to deal with it,” she told us. Can you help?

6.22pm (GMT) Turns out we have Berlin and Toronto represented in the call too.

6.17pm (GMT) We are taking rounds to reinforce who we are and what we’re in this game for. George Adcock (aka Steve) underlined the need for an infographic map showing the relationships between all the tools we use, especially here at OpenSpending, whether to produce our work, keep up with it or share it. Great insight!

6.10pm (GMT) Welcome! Hooking up on a call from across the world take a few minutes. We are joined from DC, London and Louisiana to name but a few places. In the call tonight we have Anders Pedersen, George Adcock, Elaine Ayo, Michael Horz, Neil Ashton and myself.