Categoría: General Excellence in Online Journalism

Playing with World Cup Data

Publicado el por

In a conjunction of efforts done to transform the newsroom into a data aware one, we worked hard  to make a special coverage of the World Cup using data. In most of the visualizations, the information was analyzed and checked on the FIFA webpage. In the case of goals data, the information was manually updated each day.

A team integrated by a journalist, a Data Miner and two visualizations experts were able to create 5 different articles that included data pieces. These were:

“Only 11 of the 736 football players play in Brazil”

The article provided information about the tendency there is of football players preferring to play in Europe (76% of them) rather than in other continents. The article included a Tableau that showed where each of the players actually played during the year.  Seguir leyendo →

Sin comentarios

The Political Maze 2015

Publicado el por

The candidates for president in Argentina are already immersed in the complex electoral race with focus on arriving to the Casa Rosada by the end of 2015. A good exercise for voters is to explore as a wayback machine and review the political past of each candidate, and get more background beyond their promises or public statements.

LA NACION launched by the end of 2014 “The Political Maze 2015”, an interactive tool for visualizing the political path made by the major candidates and crosses between them in different political parties during previous elections.  Seguir leyendo →

Sin comentarios

LA NACION DATA: Open Data Journalism for Change

Publicado el por

LA NACION continued in 2014-2015 with its effort to use data as new raw material for journalism and to contribute to open data in Argentina while reporting or as a way to activate demand of more public information, in a country still without a FOI Law.

After another year of training and consistency in the data project of LA NACION, opportunities of new projects appeared. We continued reporting from datasets built from scratch and then transformed, opened and shared by our team in print, online and social media.

Seguir leyendo →

Sin comentarios

Vozdata II: crowdsourcing online collaborative platform for investigative reporting

Publicado el por

VozData is a collaborative tool to convert public documents trapped in closed formats into a structured database. Information proccessed is suitable for general audience understanding and for journalists to analyse and report.  The application was inspired by The Guardian “MP´s Expenses” and  Propublica´s “Free the files”.

VozData´s first initiative was Senate Expenses (Argentina), divided in 3 different periods. Over the course of a couple of months, LA NACION digitized more than 10000 PDF.  Team work was fulfilled by 1000 volunteers. Data obtained was published online in real time in the form of rankings of recipients and type of expense. The platform also includes ranking of users that review and classify documents.

At the end of each data project, LA NACION´s data team reviewed representative samples and published the dataset in open data formats for download (CSV, XLS, etc). The Code driving Vozdata was open sourced by OpenNews Fellows and named Crowdata.

Aggregated LA NACION’s reporting on Senate Expenses, including findings in Vozdata projects.

Vozdata VIDEO Demo in english

CIVIC OPEN COLLABORATION: Partnering with NGO’s and Universities, and general audience!

Students of Universidad Torcuato di Tella – Masters in Journalism during a civic marathon al LA NACION

During May 2014 we started a campaign to try to finish “the stack of PDFs” of the first set of Senate Expenses during #SemanadeMayo that is a patriotic week and culminates May 25th. This historical day of 1810 is well known with a phrase “El Pueblo Quiere Saber” “People wants to know”. So we decided to organize what we named “Civic Marathons” for opening data using Vozdata.

 

We made  banners for social media and got shared via LA NACION & LNdata twitter and Facebook accounts.  Seguir leyendo →

Sin comentarios

CONGRESOSCOPIO, a news application to follow the legislative work of our congressmen.

Publicado el por

To follow the behavior of legislators in Congress at Argentina is not a simple task, so an interdisciplinary team of journalists, designers and developers at LA NACION, created a news app called Congresoscopio that allows all citizens to explore in detail the parliamentary performance of individual MPs.

Until now, this information was inaccessible or published in no particular order and/or closed formats, so, from now on, citizens may use this application as a new source to learn more about the behaviour of those that represent us.

For topical reporting on Congress, we have an aggregated tag to monitor parlamentary action and when each law is passed (often during the night), we report about the particularities regarding the new legislation and make a process to convert a PDF with each vote to an interactive data visualisation that will be embeded in the reporting. An example of how this work can be seen in this example of a law passed recently regarding trains in Argentina.

 

 .

 

1. “START” page

With an interactive graph that simulates a chamber with the current layout in Congress, you can browse position to position in order to access information from each of the MP’s.

2. “LAWS” page  Seguir leyendo →

Sin comentarios

Why this entry merits consideration

Publicado el por

LA NACION has an integral strategy. More than 17,000,000 UBs in it´s news website, 2,230,555 followers between it´s Twitter channels,  1,070.487 followers between all the newsroom staff Twitter accounts and 2,667,683  fans in total between all of it´s Facebook pages.

Argentina, still has no FOIA and needs to open data and help citizens deal  with this so as to empower them. That´s why the past year we continued to grow our commitment with open and data journalism, introducing open collaboration.

Open data journalism, collaboration and data storytelling using free or reusable tools were our way, not only to lead in quality journalism  but to envision a long term strategy that can help sustain or reinvent journalism and media even in a hostile political context.

We increased our data storytelling by using free reusable tools like Timeline.js, Storymap.js , Tableau,  Tabula, DocumentCloud,  CartoDB, Open Refine and Google collaboration tools and by setting our reusable graphs in javascript and special interactive visualizations for the Elections.

Our data driven investigations are being  presented in judicial cases or amplified by national TV or radios; and our news applications have become a new bridge to integrate NGOs and academia using collaboration as a new form of intelligence.

We continued activating the data community via hacktivism, participating in hackathons, sharing open source code in Github, and organizing our own DATAFEST event.

We learn and train, and in may 2014 we gave our fourth Data Journalism internal training. Even though we are a small team,  we trained on Ruby, D3, CartoDB, Tableau, ArcGis, Open Refine and Excel for DATA.

We algo give workshops on Social and Mobile journalism and keep a pool of smartphones to lend as mobile equipment for journalists who do real time multimedia reporting.

In terms of internal communications we keep track of our newsroom´s  reporting initiatives in a special blog and share them internally, and we have our own “LA NACION Multimedia and Data journalism Awards”.

We believe in openness to serve our audience using Social, Mobile and Data Journalism, mixing social with BI with journalism, engaging hacktivism with industry experts and NGOs, and leading a movement that collaborates and opens data, which together with journalism will leverage digital media as a new tool to empower citizens towards innovation, participation and knowledge discovery.

Three examples of user interface and innovative interactivity:

–  Data as context integrated  as content TAGs: to enrich stories, lanacion.com adapted it´s CMS to integrate data. Every news application or data platform we develop must be structured with this in mind so data can be distributed in topical or persons tags. This helps users understand and dig deeper into stories and backgrounds.

– Open statements of assets from Argentina´s public officials: together with three transparency NGO´s, we developed the first site concerning the heritage of public servants.  This news application allows users to visualize a large volume of information, to search and do comparisons, and it also has an easy visual interface, which includes the possibility to explore every original PDF document in detail, using DocumentCloud. It has helped users because before this they had to go to the Anticorruption office for information. Now data is downloadable in open data formats.

– Junar Open Data Platform: In our “Data Dashboard , LA NACION hosts the datasets that we open and share. We integrated this platform that helps our readers download data, embed datastreams or share them in social media.The platform has an API so any user can download this data in a single action.

On creative use of online technology last months we started using:

–  DevExtreme an HTML5 and Javascript tool  that connects reusable data visualizations with updated data and creates responsive web applications.

Examples provided are updated from datastreams manually by our  journalists. Users can download them in open data formats like XML, CSV  and JSON.

– CartoDB: we developed an exclusive interactive map that allowed visualization of the results of the 2013 parliamentary election  in the different voting centers Buenos Aires. The  map combined three layers of data: the geo-localization of voting centers, the number of votes and the distribution of those votes by party in each center.  

– Vozdata:  our open collaborative platform to transform public PDF documents into structured data. Using Documentcloud,and reusing an idea of Guardian and Propublica with help of our Opennews fellows we developed a platform that served  to activate a community of more than 500 volunteers for our first 6,700 Senate Expenses project fulfilled in two months after organizing two “civic marathons” in LA NACION.

This platform was open sourced.

Social tools strategy: La Nacion has an active focus on the use of social tools for reaching and including the audience in their work . More than 35 branded official channels with more than 2MM followers, 130 journalists on Twitter, a 35 blog network, which has thriving communities that daily participate in the content of each blog by posting their comments (for example, in Movies, Amateur Cooking and Gay Friendly blogs). Many of these also have a very active  Facebook Fan page participation (Cooking and Gardening for instance).We work with our audience on Facebook, generating specific content on the various pages of lanacioncom (with more than 913 995 fans), canchallenacom (our sports site),sections Fashion/Beauty and Culture, and fanpages of some of our blogs.

We’ve also started with Instagram initiatives for different channels and magazines.

Third parties support include awards, special funding and/or praise from Tow Center at Columbia University,  ONA International, Tableau Software Inc., The Knight Foundation, The Knight-Mozilla OpenNews program, GEN, International Journalism Festival, Open Government Partnership, ICFJ, EJC, Journalism.co.uk, Regional Conference on Open Data for Latinamerica,  US Embassy in Argentina
Original reporting:

– Statements of assets

– Senate expenses

– Legislative Elections in Argentina

– 30 years of democracy in Argentina

Sin comentarios

Public officials salaries and assets for reporting and accountability

Publicado el por

“Click to access to Statements of Assets integrated Tag”

LA NACION decided to fight for transparency in public officials salaries and declaration of assets as we feel that even in a country without FOIA, journalism and citizens must know and share what they know about how politicians earn their money, and how they compare with others or with other periods. This is a tool that is also helping detect cases of corruption, regarding public spending and companies owned by official´s relatives or friends.

To aggregate stories, we integrated the news application with the open dataset and Lanacion.com´s CMS using a TAG that gathers all the stories that are coming out about these Declarations of Assets or salaries of the president and ministers we also requested and opened .

Main stories and data:  Seguir leyendo →

Sin comentarios

Argentina´s Senate Expenses 2004-2013

Publicado el por

Extracting stories from public DATA formerly unstructured and in PDFs.

After finding out that Senate have published expenses since 2004 in raw PDFs, some of them as images and completely unstructured, LA NACION data team managed to scrape, transform, normalize and structure three datasets into one and began an interrogation process that included front page stories, replies from actual and former Argentina´s vice presidents (Senate presidents), and provoked a judicial investigation over vicepresident Amado Boudou regarding these expenses. This series of front page stories lead to more stories and different approaches to keep Senate accountable.

As we converted these PDFs into OCR txt files, we realized that we have lots of information lost as a consecuence of very noisy PDF´s. Besides, we realized that there would be more stories if more eyes helped us classify and enter this data. So we decided to ask for help: inspired in The Guardian MP´s Expenses and Propublica´s Free the Files, we asked our Knight-Mozilla Opennews Fellow 2013 Manuel Aristaran to help us develop “Vozdata” a platform for Crowdsourcing data in a structured way .

He developed “Crowdata” working together with Gabriela Rodriguez our Opennews Fellow 2014. We launched our first “Senate Expenses Vozdata project with a dataset of more than 6700 PDFs that took two months to be processed.

To fulfill that, again we asked for collaboration and activated our community organizing  two “Civic Marathons” with NGO´s , Universities and users. See all the details here.

At the same time, one of our journalists heard that in Senate there had been a big growth of the amount of employees and as our data team has been scraping during 30 months (since november 2011),  the lists of Senate permanent, temporary and contracted employees, we could release a unique and original analysis that became a new finding sustained with data and visualizations. In this period , senate employees and contracted went from 3.700 to 5.700 which meant a 55% of growth. Again, our vice president Amado Boudou replied to these articles using the official channel in national TV , but he could not deny any of the numbers on the reporting.

Here are the details, data collection and data analysis process and the articles and visualizations.

Regarding all the Senate Expenses stories, as they were many and some of them are still in judicial investigations, we decided to put them all together in a Tag home page

http://www.lanacion.com.ar/gastos-en-el-senado-t49163

So here is the process and how we did this , together with new stories:

Play it in HD!

Thanks to building this dataset from scratch and analysing dates, we also found out that some expenses of official trips were presented with dates that were overlapped and even included some trips that were not made.  Seguir leyendo →

Sin comentarios

2013 Legislative Elections in Argentina

Publicado el por

 

Introduction

LA NACIÓN produced a multimedia and multiplatform coverage of the 2013 parliamentary elections with a focus on innovation through database journalism as the fundamental tool to show the contents in a new way and to present the information transparently for the electorate and citizens in general.

To add value to the press coverage and not repeat classical approaches, the 2013 Elections project included the development of different interactive and research pieces using data as the primary source.

These contents were included/ grouped in a specific item of the coverage called The electoral magnifying glass (La lupa electoral). Journalists from both platforms (online/paper) worked on the productions of this category. In fact, many of the works published in this space were generated by editors that were in the Data Journalism Program, a LA NACIÓN special training program for its journalists. The project lasted 6 months. 15 people participated. It was an internal challenge for the company, since it implied the integration and the joint work of the paper and online staff, the LNData team, and the Product and Marketing areas.

Real Time Data Generating and Analysis

 

Election 2013 case summary projects:  Seguir leyendo →

Sin comentarios

The 30 years of Democracy in Argentina´s Anniversary

Publicado el por

Recent history of Argentina changed completely on sunday 30th, 1983. Raúl Alfonsin won the elections and became president which meant, returning to democracy and ending the period of military dictatorship.

To cover this anniversary LA NACION developed a transmedia experience that allowed users simulate a real time elections coverage with digital platforms but using the 1983 original content.

They could experience in real time, 30 years later, this historical elections. This implied an intense research work into our archives, together with multimedia and other materials so as to offer context information like social movements during the weeks previous to the elections, the TV and radio spots and caimpaign ads from Raul Alfonsin , and the newspaper´s front pages.

For us it was a different way to live again this special moment, using present technologies but not in a traditional digital coverage that would be a secuential one way production. This simulated coverage was live from October 19th to November 1st, 2013, based in a narrative that was spread by social media.

Revive history, in real time  

Through the Twitter account @LNvoto83 https://twitter.com/LNvoto83 the coverage published exclusive documents that were crucial to simulate those days in real time and transport users throuth time. All this tuits were published with the hashtag #Voto83.

Seguir leyendo →

Sin comentarios