Ara Data

Ara Data

Organisation: Ara.cat (Spain)

Publication Date: 04/05/2017

Size of team/newsroom:large

Description

On May 19, 2016 Ara.cat launched Ara Data (http://www.ara.cat/data/). During all these months, this team has now entered deeper into the data journalism. Last November, Ara Data published the tax collection of all traffic radars with their location based on access request to public information as envisaged in the law of transparency. So far, the governments of Catalonia and Barcelona had refused to publish its complete information. Other access requests brought to light all the delays of the suburban train network (Rodalies Renfe), line by line, and the cost of the trips of the government president and councillors between 2010 and 2015. Last July, the interactive map with 2,886 wildfires in Catalonia allowed to state how some fires are responsible for three quarters of the total forest burned area in Catalonia (http://interactius.ara.cat/incendis/). Ara Data has also been working with open data, such as the interactive map with the 3,566 bike accidents in Barcelona between 2010 and 2015 (http://interactius.ara.cat/accidents/bicis). The most viewed story of Ara Data is the one based on baby names; Catalonia in the 21st century told through onomastics (http://interactius.ara.cat/noms-nen-nena-catalans/). The award-winning interactive 'All Messi’s goals' (http://interactius.ara.cat/messi/en) shows how the argentinian football player scored all their goals in the Spanish league. And a story of Michael Bernis analyzes all the match results of the five major European football leagues since 1970 and found that the filed factor is affecting fewer every day (http://www.ara.cat/esports/Jugar-casa-ja-lavantatge-que_0_1415858435.html) (english version: http://miquelbernis.com/en/playing-at-home-is-no-longer-the-advantage-it-used-to-be/). Among the most viewed interactive projects of Ara Data the special ones dedicated to elections (http://eleccions.ara.cat/). In these you can find, for example, results in the city of Barcelona, street by street. Journalists, programmers and designers have worked together in the development of many other maps, such as the evolution of municipal public debt, town to town. ARA is a newspaper created by a group of entrepreneurs from the fields of journalism, publishing and business in Catalonia who are committed to the society. They are active people who have shown initiative and know how to carry it out, inspired by critical spirit but not installed in criticism. The newspaper is published in Barcelona with a circulation of about 20,000 copies in tabloid format and more than 2 million unique visitors per year on our website. ARA was born on 2010, which means already in the digital era, with an integrated editorial team who has fostered innovation from its very beginning, with storytelling projects. Examples: http://interactius.ara.cat/9n/en, http://3anys.ara.cat/, http://interactius.ara.cat/brasil2014/, http://interactius.ara.cat/idomeni, http://interactius.ara.cat/grecia/en, http://interactius.ara.cat/testdialectal/.

What makes this project innovative? What was its impact?

The news published on Ara Data are among the most read on our newspaper. Since May 2016, this section has accumulated 2,124,209 pageviews. Some of the reports have been awarded. The report 'Why Catalonia is burning' has been selected among the best in science reports in Spain by PerCientEx project. It has also won a silver medal in the ÑH newspaper design awards, organized by the Society for News Design. 'All Messi’s goals' has won the gold medal in the category of infographics. 'Baby names for undecided parents' won the bronze medal.

Technologies used for this project:

'Why Catalonia is burning': We have a database that contains the hectares, the perimeter, and the victims of each fire as well as a file with KML coordinates in order to draw the fires’ polygons. We have crossed two databases and introduced them into Google Fusion Tables. With the Google Maps API, we painted the polygons on the map. To make the guided tour or let users filter out fires, we call on the fusion tables database by filtering the data based on our needs. 'Barcelona, Bike Revolution': We are working on a database of all accidents and all the victims involved in the city of Barcelona categorized by vehicle type. We use Google Fusion Tables as a database to manage accidents’ data and Google Maps API for painting the dots on the map and making calls to fusion tables with the necessary filters. These filters show only accidents that apply in each step of the guided tour or depending on the options chosen by the user. Elections special content: We have a database with all data from scrutiny of elections separated by municipalities, counties, districts, regions and generals. All these data were collected in real time during the election night at each election day. The data was updated every 3 minutes and received in CSV format. During the election night the website updated in real time and displayed modules and different data as the scrutiny advanced. For small stories we usually use self-editing tools like DataWrapper or CARTO.
Follow this project
Wait
Comment

Comments (0)

You have to be connected to contribute

You have to be connected to follow

Leave this project and no longer be informed about this project

By joining this project, you will be informed by email when an update or a new contribution is posted on the website.

Thank you for your active participation !
Best,

The GEN Community Team