Finished 28 / 12 / 2014
Funded!
Received
€ 8.530
Minimum
€ 7.900
Optimum
€ 11.850
250 Backers
Contributing € 10
Web recognition
You will be acknowledged on the website
> 47 Backers
Contributing € 20
Beta access before the project launch
Beta access before the project launch + web recognition
> 85 Backers
Contributing € 40
Stickers of Who cashes in the deal?
Stickers of Who cashes in the deal? + Beta access before the project launch + Web recognition
> 28 Backers
Contributing € 60
T-shirt with project logo
T-shirt with project logo + Stickers of Who cashes in the deal? + Beta access before the project launch + Web recognition
> 17 Backers
Contributing € 80
Construction worker’s helmet with project logo
Construction worker’s helmet with project logo + T-shirt with project logo + Stickers of Who cashes in the deal? + Beta access before the project launch + Web recognition
> 01 Backers
Contributing € 100
Book, with personal dedication
We are working on a book that, among other things, will analyse in-depth the most important cases related to public contracting. Book + Construction worker’s helmet with project logo + T-shirt with project logo + Stickers of Who cashes in the deal? + Beta access before the project launch + Web recognition
> 15 Backers
Contributing € 200
Who cashes in the deal: How did we do it?
We are at your disposal to make a presentation (in person or by video conference, depending on your location) about our project development process + Book + Construction worker’s helmet with project logo + T-shirt with project logo + Stickers of Who cashes in the deal? + Beta access before the project launch + Web recognition
> 01 Backers
Contributing € 400
Sponsor an article.
Your name will be shown as sponsoring one research article related to public contracting awards + Presentation + Book + Construction worker’s helmet with project logo + T-shirt with project logo + Stickers of Who cashes in the deal? + Beta access before the project launch + Web recognition
> 01 Backers

About this project

An in-depth analysis of the public construction award winning companies. Do you want to know who are behind them and which are their connections with the public sphere?
Task Minimum Optimum
Awards database
Scraping the Official Gazette and building an open database
€ 2.400
Website development
Building an open source website that shows the data obtained, the visualizations and the journalistic content.
€ 1.500
Web design
Crear la imagen del proyecto y el diseño de la página web
€ 1.000
Journalistic/investigative research articles
Research about the final beneficiaries of companies and publication of three in-depth analysis articles
€ 2.500
Hosting
Hosting of the website during a year
€ 500
Public contracting guide
Publication of downloadable manuals explaining how public contracting works is Spain
€ 750
Journalistic/investigative research articles
Publication of an extra three research articles, with in-depth analysis of specific cases as well as general trends
€ 2.000
API
API development to make the whole database available
€ 1.200
Total € 7.900 € 11.850
Necessary
Supplemental

General information

Over the last few years corruption scandals are a daily feature in Spanish news. Many of these cases share the use of public construction awards to foster illicit gains, from illegal commissions to multimillion projects that double their budgets without due justification. In Spain, we all have seen airports without plains, roads that go nowhere and monumental public projects abandoned halfway.

In Civio we want to launch a new project in which any citizen will be able to discover who are the companies receiving awards, for what amounts, who are behind these companies and if they have any connections with the public sphere - quite unbelievably, in Spain this information is not available in a consolidated and structured way.

We will do so using digital technology applied to investigative journalism, with research articles, visualizations and an open database available for downloading and reuse. As in every Civio’s project, all content, data and code will be open and free.


Description of the project. Main features, strengths and differentials.

Information about awarded contracts and who are the final beneficiaries of companies is published partially, in not re-usable formats (PDF), and is difficult to find and analyse. To know which company received a particular award -and who is behind it- is a difficult task, forcing journalists, activists or any interested individual to dive among countless documents and, sometimes, to use pre-pay websites. The main sources to work with are the Official Gazette (BOE) and the Business Registry (BORME), the latest digitized only from 2009 onwards. With your help, we will work with these sources to extract a database of public construction awards: price, execution date, public administration financing the award, contracting method (tender, negotiated, etc.), and company awarded.

This information will be shared through visualizations -that will show which are the companies that have received more public awards, the contracts not publicly tendered, the amounts spent by each administration- together with journalistic stories that will deepen into the most relevant cases -linking the companies with their final beneficiaries, and these with their relations and connections with public officials.

To complete the project and to promote a better understanding of how public contracting works, we will include educational resources for every citizen interested in deepening into the current rules and regulations. Our aim is to start reducing opacity in public contracting, and this project is just a first step.

In the coming year we will use the experience and technology developed with Who cashes in the deal? to broaden the project and, combining it with the use of other sources, create a complete map of public awards in Spain, including not only construction contracts but health services, security services, the acquisition of software licenses and many other critical pubñic expenditure areas. We want to follow the money and bring light to a traditionally opaque area, and we need you to kick off this long endeavour.

Why this is important

In Civio we are missing a key project to be able to understand and scrutinise the global map of power in Spain. In our previous projects we have dealt with governmental pardons, public private relationships and the implications of particular laws and appointments, but we have a huge gap before we can close the loop: public contracting. Our next objective to analyse and scrutinise it and we want to start doing it with your support.

Our final objective is that public contracting becomes a more transparent process, so we will advocate to introduce the necessary reforms to increase access to information and accountability in this particularly opaque area.

That is why Who cashes in the deal? is a project for everyone. From citizens concerned about corruption and overspending who want to know more about how the public awarding system works, to journalists, researchers and social organizations, who will have new information available to find relevant stories or to complement their own data with a rigorous new structured source.

Goals of the crowdfunding campaign

With this campaign we aim to extract the data, build the platform and write research articles.

If we achieve the minimum resources sought, we will:
- Create a downloadable database of public construction awards
- Show the data in an open website with a CC license
- Publish at least three research articles, with in-depth analysis of specific cases as well as general trends

If we achieve the optimal volume of resources, we will:
- Publish downloadable manuals explaining how public contracting works in Spain.
- Publish an extra three research articles, with in-depth analysis of specific cases as well as general trends
- Develop an API to make the whole database available

Team and experience

We are Fundación Ciudadana Civio (“Civio”), a Spanish non-profit founded in 2011. We are a civil society organization that fights for a better democracy. We work to bring about a political culture based on the values of transparency and accountability, with free access to public data for every citizen and organization. We believe in a society made up of active citizens who have a strong sense of democratic responsibility and institutions committed to serve the public interest.

In our day-to-day activities we investigate and generate relevant information about public governance to empower citizens and improve the accountability of public institutions. We use open technology and data journalism to create online projects that allow citizens to monitor and audit governmental actions dealing with issues such as public spending (www.dondevanmisimpuestos.es), governmental pardons (www.elindultometro.es), access to public information (www.tuderechoasaber.es), official gazette activity (www.elboenuestrodecadadia.com) or public-private relationships and conflict of interests (www.quienmanda.es).

Our team is multidisciplinary and consists of David Cabo, Director of Civio and computer engineer, responsible all the development of the portal and data extraction; Eva Belmonte, the lead journalist responsible for analysing the data and writing the stories; Javier de Vega, taking the whole issue of communication and Cristina Moreno supporting partnerships.

Social commitment