how to use complex data
download this tactic card (pdf 792kb)
Plan your action
Do it yourselfAsk
Different ways you can do this
FEATURED TOOL Visualise data over time Google Motion Chart can use your data to make an animated graph showing how different sets of information relate to one another over time. Motion Chart can display data from any Google Spreadsheet that you link to the chart. The chart can then be shared on your website as a Flash animation. As Google Motion Chart relies on data saved in Google Spreadsheet, this means that you must be connected to the internet to update data, and that your data will be stored on servers maintained by Google. For very sensitive data, this may not be an ideal tool. This video guides you through how to install and use the chart. |
TIPS ZUZANA WIENK FROM FAIR PLAY ALLIANCE, ON LOCALISATION: "Be sensitive to what tools are best in your country or region. In Poland, we couldn’t create an online database as we had done in Slovakia because they didn’t have access to this kind of data – for example, we could not create a database to show both donations to political parties and public procurement. Also, FOIA laws will be different in each region."
JACK FROM FARMSUBSIDY.ORG, ON GETTING ACCESS: "It's really important to know exactly what you’re asking for. You’ve got to know that government holds this data, and that requires a bit of research on what the government holds – you may also develop relationships with friendly civil servants who can tell you, or you can look at the laws to find out what they are required to hold."
ZUZANA WIENK FROM FAIR PLAY ALLIANCE, ON CROWD-SOURCING: "My feeling is society is really changing towards more informal collaboration and ad-hoc activism. People are skilled and open to interact and contribute, but we have to create spaces for that, and that space has to be attractive and give people some kind of public recognition or their work. A web space is great for that." |
how to use complex data
download this tactic card (pdf 792kb)
Case Study
TITLE: WHO: WHERE: WEBSITE: |
Fair Play Fair Play Alliance Bratislava, Slovakia Fair Play Alliance |
DESCRIPTION
Using Freedom of Information (FOI) requests, Fair Play gathers invoices and other documents that show how the Slovakian government spends its money, adds this material to a database connected to its website, and invites people to use this information to influence political change. Zuzana Wienk from Fair Play says, "We started to experiment with this during a huge scandal we had in Slovakia recently concerning European Union (EU) funding. The media learnt that contracts were given to companies that are closely connected to the government’s leaders. Using FOI laws we started to request more and more data about contracts between these companies and Ministers, also requesting invoices and other accounting data. We produced graphs from this information and put them online, and we also scanned all the invoices and made them available." Soon after doing this, NGOs, journalists, concerned citizens and academics started to analyse the data themselves and write about it. "There were very active forums based on these articles", says Zuzana. "This made us feel it was important to include the public in these investigations – that people have the interest, skills and expertise". By making the information easy to access, a debate was created around public spending and pressure for change became so great that one Slovak construction minister had to resign.
TOOLS USED: | Custom-built database, using open source tools (mySQL, Apache server, and PHP). Data imported from Freedom of Information (FOIA) requests, in Excel spreadsheets, but sometimes they needed to be scanned or retyped. Web-scrapers are used to bring in data from online sources. |
REACH: | The project tracks public spending in the Slovakian government. It is now expanding to track assets of Slovak members of European Parliament. During the EU funding scandal, the Fair Play website was one of the top three most visited in Slovakia. |
RESOURCES: | Student volunteers assist in updating the database. Volunteer developers and programmers attended a BarCamp organised by Fair Play to plan the project. |
TIME: | Nine months to get the first database up in 2003. Updated continuously, every three to 12 months, with data from new FOIA requests. |
LEVEL Of DIFFICULTY: 4.5
COST:USD$4000 in 2003 for the first programming and technical phase. One coordinator was employed in 2004 to update the database, costing USD$12,000.
LINKS TO LEARN MORE:
Fair Play database (slovak language)