LA NACION, Buenos Aires, Argentina 2019

La Nación was founded in 1870 by former President Bartolomé Mitre. It is the most prestigious national newspaper in Argentina, well known for its quality journalism, investigative reporting and editorial integrity. It’s Brand has expanded and today it has the website with the mobile and social media versions, the Tv news channel, and several magazines including Hola!, and Argentine Rolling Stone.

LA NACION August 13, 2017

In 1995 we launched our website and became the first massive online newspaper in Argentina. Since then, the main premise of lanacion.com is to maintain journalistic excellence while taking advantage of new technologies as an indispensable tool for innovation.

lanacion.com has 32,500,000 unique browsers per month and this year became the first online media in Argentina to achieve 200,000 paid subscribers. We are part of the Group of Newspapers of America (11 main newspapers in Latin America Consortium) and we are known for being the most innovative digital media of Latin America and the most awarded as well. 

This year was special because our Driver’s Notebooks investigation, won the The International Prize King of Spain (Rey de España), and the National Investigative Journalism Prize of the Argentinean Journalism Forum (FOPEA). Also, this year we won the World’s Best Designed Newspaper award of the Society for News Design (SND) and our data unit, LA NACION DATA was finalist in 3 categories of the GEN Data Journalism Awards.

LA NACION’s Tv set 

INVESTIGATIVE REPORTING:Investigative journalism is the core of our newsroom. We work with editors and journalists of each section who are interested in public transparency and willing to innovate with new tools and storytelling techniques. We specialize in deep digging and research, following breadcrumbs which lead to rigorous and powerful stories.

A recent example of this is the The Driver’s Notebooks of Corruption investigation. This investigation formally began on January 8, 2018, when Diego Cabot, an investigative journalist from La Nación was given eight notebooks that exposed Argentina´s greatest corruption scandal ever. We built a structured dataset from this handwritten notebooks,  we transcribed all the information into an Excel database and began analyzing each one of the records. Then, we verified and checked the information by crossing it with other multiple sources such as official and company records, corporate information, public works contracts. This verification process was used to carry out a strict process of standardization and structuring of data in which currency and descriptions were unified and names and addresses were standardized.

So far, 73 individuals have been prosecuted in this case (40 have been imprisoned and several continue and another 90 businessmen are waiting for prosecution), including a former President, the entire office of the Ministry of Planning and the main public works contractors of the country. About 40 persons repented and confessed their crimes. US$ 600 million were seized.

READ MORE ABOUT THIS INVESTIGATION: CLICK HERE

DATA JOURNALISM AND OPEN DATA FOR CHANGE: We also have a special unit destined for this job called LA NACION DATA who was chosen the Best Data Journalism Team Portfolio in the GEN Data Journalism Awards 2019 and became finalist in two other categories: data visualization of the year and investigation of the year. The team promotes Open Data Journalism for change, in order to better serve our audiences using data to discover and tell stories. They encourage the use of open data and access to information in Argentina as evidence to keep governments accountable, enhance transparency and allow citizen’s collaboration in the process of journalism.

Much of their work and effort is invested in building datasets from scratch, cleaning, structuring and normalizing to make them accessible for our newsroom and our users in Argentina. But their objective is also to produce long-term investigations that encompass a multiplicity of topics of interest with the intention of producing a political and social impact.

They work by projects and in multi-skilled teams to provide data as service in the daily reporting and to build innovative tools and data platforms for open collaboration. They even partner with NGO’s to promote civil participation in the process of journalism and because they never get tired of learning something new, they love sharing knowledge through hackathons and hosting multiple events.


An example of this is the open Statement of Assets (Affidavits) website of the main officers of government. Every year LA NACION DATA access hundreds of affidavits through FOIA requests. The problem is that most of the data is handwritten on a sheet of paper, so they organized hackathons in alliance with NGOs: Poder Ciudadano, ACIJ and Directorio Legislativo to upload all the information into an open source administrator we created for such purpose.

These are meetings held for several days in the newsroom where students and volunteers participate to build this dataset together. In total, there are already more than 4,000 published affidavits typed in our unique web site, that are constantly reused to investigate cases of corruption or to provide information on each new Government officer. This data is presented in open formats as well.

Furthermore, keeping the team and our newsroom updated, we are now focused in learning how data science can help society and journalism for good, As this happens LA NACION DATA supports and co-organized the Global Women in Data Science (WIDS) Conference in Buenos Aires 2018 and 2019. In this event journalists, data scientists, engineers and programmers meet in order to promote the inclusion of women as speakers in Data Science in different areas, industries and services in Argentina in order to inspire more women in STEM and in technology.

READ MORE ABOUT LA NACION DATA: CLICK HERE

PUBLIC SERVICE: We produce journalism that makes a difference and motivates the audience to act and improve a community’s welfare and quality of life. We are devoted to highlight stories that raise awareness among political leaders and civil society. We want to achieve a better future for all and we understand that it is our responsibility to act and be involved in the global challenges we face: poverty, inequality, climate, justice, prosperity, and peace and justice.

We even have a special unit called Fundación La Nación that produces community service journalism and actions to raise society’s awareness of different social problems, providing new perspectives, knowledge and approaches to them. They even make visible and work together with different causes and initiatives promoted by social organizations, companies and Government that are destined to achieve a more just and inclusive society.

A recent example of our work is our Hambre de Futuro (“Hungry for the Future”) project which explores childhood poverty in the most vulnerable locations in Argentina.We hoped that the project would raise awareness among political leaders and civil society and put the structural problem of childhood poverty on local agendas. Our mission was to promote the protection of children’s rights by spreading their voice to help them meet their basic needs and secure their survival, protection and development

VISUAL DIGITAL STORYTELLING: We make innovative efforts in telling stories through original, creative and interactive visualizations and graphics. The idea is to create unique and quality storytelling products that clearly convey the story’s topic or event. We give special attention in bringing stories and data to life so we even created “format meetings” with one delegate of each section, developers and data team members.

An example of this is our FIFA World Cup Russia 2018 coverage. The objective was to inform and engage the audience in two different stages. The first stage consisted of a series of playful and social visualizations prior to the beginning of the World Cup. The articles were strategically conceived according to the schedule prior to the event: selection of the 23 players that were going to travel to Russia, the 11 players that were going to play on the first match,  a draw simulator of the different possible groups in which each country soccer team could be selected and their possible opposing team, and a result forecast for the people to play with and bet.

Instead, the second stage was focused on the real time results and matches: a fixture with the times, teams and matches, a calculator for the audience to estimate results and evaluate the possibility of passing to the next round, a game that allows the audience to score the players after each match, a live statistics visualisations of the amount of shoots and passes between players and their positions on the field throughout the game, the possibility to vote for the best goal of the world cup and a monitor of the speed and the distance runned by each player.

READ MORE ABOUT THE WORLD CUP COVERAGE: CLICK HERE

Another example of visual digital storytelling is the piece we created a year after the disappearance of the submarine ARA San Juan. To commemorate the first anniversary of the tragedy of the ARA San Juan Submarine, a scrollytelling was made to present all the details and data about the sinking of the submarine. It was one of the most tragic events of the past few years as it involved the death of 44 crewmen that were on board. The purpose was to develop a visual piece with new data from the year-long official investigation to shed light on some of the uncertainties and controversies of the case.

It included data from official naval reports, videos of the crewmen families-specially produced and created for the occasion-, audios of the official naval announcements, 3D animations of the submarine made with two programs called Carrara and Blender, and satellite geolocated data of the search operations collected with Marine Traffic vessel platform.

READ MORE ABOUT THE SUBMARINE: CLICK HERE AND HERE

AUTOMATED DATA-DRIVEN CONTENTThe project was born in the context of 2017 elections. With the purpose of creating news articles automatically from datasets using different templates, we put into practice the automated technology which allowed us to cover the real-time election results in the 530 districts of the Argentine territory. 

We knew that the technology developed for the occasion could mean an opportunity to help the newsroom in its usual work process. Specially, in repetitive news that are data driven and that could be supported with series and graphs. So, we began to produce daily and weekly articles, automated through a systematic collection of data from different sources and topics.

Three examples

All the automatically generated articles are accompanied with infographics, images and interactive visualizations that are created from the automatic loading of data in Google Spreadsheets.

The first subjects covered by this project were thought in terms of the interest of the Argentine citizens: dollar, inflation and Argentine football. Three central subjects in the everyday life of our country.

The importance of this project is that we found a way to work in teams with our editors that understood how technology and data can help them better serve audiences and reach larger audiences thanks to a broader coverage. We developed an in-house automatization platform customized to each data source and worked with our graphics area to have the data visualizations ready.

Work that was repetitive and tedious became, thanks to this process and technology, a successful and efficient task that preserves the touch of quality journalism. The choice of topics helped change the newsroom culture since several traditional journalists are experiencing the benefits of technology and data to support their stories.

READ MORE ABOUT OUR AUTOMATED CONTENT PROJECTS: CLICK HERE

USER EXPERIENCE: We pay special attention in user interface and interactive innovation and how each helped our users. We think that special content should be presented in creative and useable applications and platforms. 

A perfect example of this is LA NACION´s SHOPPING CART: monitoring 2600 supermarkets and 170 product prices.

In March 2018, Argentina was one of the five countries with highest inflation according to the International Monetary Fund. The index climbed up to 47.6% anually according to official numbers. The jump of the exchange rate, higher than 100% also had an impact on the rise of prices on the supermarkets every week. Given the country’s inflationary context, there are several sources of information about price variation, but these end-user reports are abstract numbers that do not reflect their daily reality and do not represent the real impact on their economy.


To understand how supermarket product prices evolve independently of the official measurements monthly informed, and to bring this measurement closer to the daily economy of the audience, we created “Changuito LA NACION“  (LA NACION Shopping Cart), a price monitor that allows a weekly and monthly monitoring of goods product by product such as noodles, soft drinks and liquors and toothpaste, among others. Its name refers to the colloquial way of naming the shopping cart.

El Changuito presents a group of 170 food, beverage, cleaning and toiletry products from leading brands that are marketed nationally in 2,561 points of sale and are representative of household consumption in Argentina. Each one of the goods has a “premium” option and a “standard”option, differentiated by price.

To make interaction easier, we created four pre-set baskets, based on our official statistics methodology. They are: for people living alone, for couples, for a four-member family, and for retired persons. Thus, if the user selects this option, he/she can access a pre-set basket of food, toiletries and cleaning items that are similar to the consumption of the type of household chosen. In addition, you may modify: add or remove products and decrease and increase quantities. Each of them has its nominal price (total price) and its variation (on a weekly and on monthly basis).

The user also has the option of assembling a “changuito a medida” (taylor-made shopping cart), that is to say, to make a virtual tour among the monitored products to personalize his/her own basket. To enable an individual tracking, each reader registered on the Web or through the mobile app of LA NACION may save his/her own selection.

In addition, by clicking on each product, the user may see its current price and the weekly and monthly price variation with a linear graph.

READ MORE ABOUT LA NACION’s SHOPPING CART: CLICK HERE

TECHNICAL INNOVATION IN THE SERVICE OF DIGITAL JOURNALISM: We build digitals tools and platforms from open source code to achieve a sustainable industry. We learn from the works and tools of international media and take advantage of the knowledge we gain to improve existing tools and adapt them to our needs and style.

For example, we built an entire platform with Autotune, a product of VOX MEDIA that concentrates different tools that journalist can use to generate visualizations without having to write a single code line. We offer different templates such as: data tables, timelines, zoom for images, before and after sliders, fade in/out, 360° images, trivias and phrases tool.

Other examples involve for example NPR Books open source code. A platform that was made for book reviews we transformed it into two new products: a museum catalogue and a holiday calculator.

Furthermore, we also used VOX MEDIA Meme Generator that was available in open source to make our own LA NACION MEME MAKER for our social media team to easily produce Memes and Phrases.

SOCIAL MEDIA: We have 3,76mm fans on Facebook and a daily reach of 3,3mm. On Twitter we gained 3,17 mm followers and recently we launched a new way of telling stories and breaking news on Instagram where we have 714K followers. We are constantly trying to find different and new ideas to have a powerful presence on social media. We understand that the content is the most important asset we have and social media is an opportunity to attract and engage with new users.

We adapt our digital storytelling to innovative ways of attracting the attention and engaging new young audiences. An example of this is an interview with María Kodama, widow of Argentine author Jorge Luis Borges. We decided to create a short video to tell the story of a conversation between Mick Jagger and Borges to share it on social media:

We create this type of video every week to promote a specific article that is usually published on sundays. Here is another example:

Brand expansion: La Nación also introduced in september 2016, its own paid TV channel called LN+. A network designed for a digital audience that broadcasts directly from La Nacion’s newsroom. It delivers cable and on-demand programming, focused on analysis and news. It offers more than 20 shows and its objective is to expand the reach of the digital newspaper quality content. This is why we even created our own Youtube channel where we adapt all the TV content to a more dynamic and entertaining format.

THIRD PARTY RECOGNITION AND AWARDS: 

Our website won the Editor and Publisher EPPY Awards five years in a row (2011, 2012, 2013, 2014, 2015) and also received in 2010, 2011, 2013 the Online Journalism Award for General Excellence in Online Journalism, Non-English, Large Site. Also, last year lanacion.com was named the best news website of Latin America by WAN-Ifra Digital Media Awards. On 2018 we also received the OJA award last year for Excellence in Audio Digital Storytelling, and the Data Journalism Award for Best use of data in breaking news story. These are just some of the overall prizes we received in the past few years.

READ MORE ABOUT OUR AWARDS: CLICK HERE

Sin comentarios

Open Data Journalism for Change

LA NACION Data was launched as an open data journalism initiative. Its strategy is to create impact and change in Argentina through the use and promotion of open data journalism. Our main focus is to develop and facilitate data platforms based in public information and open data to serve in investigative journalism as well as in daily reporting and automated content.

Every day we update our data series indicators that are linked to visualizations that we embed in the articles of the day. All of this interactive infographics have a download button for the user to reuse the information or simply to give access to the historical database in an open format. and source. We have aproximately more than 200 databases that we frequently update and open to the public.

In a difficult context in Argentina, we are coherent and consistent with enhancing openness and transparency. Since we launched in 2011, we base our success not only in products, but in helping our community use and demand more open data as well.

A classic example of this is our project Open Statements of Assets which was launched in 2013 and updated every year because its a tool that helps us and the citizens detect cases of corruption regarding public spending and companies owned by official’s relatives or friends. Its a collaboration project that produces open data from hand-written copies of Statements of Assets (Affidavits) that were requested using our FOIA law. We constantly request the information to the three powers: Executive, Legislative and Judicial. Each year we organize hackathons in alliance with NGOs: Poder Ciudadano, ACIJ and Directorio Legislativo to upload all the information into an open source administrator we created for such purpose.

We are heavy users of Open Data and access to public information (FOIA) in Argentina, in order to help citizen participation and open government because we believe this improves the quality of democracy. The first step to make datasets famous is to become open data USERS. And if there is no open data, we become PRODUCERS and transform closed formats to open data. We have to find and convert public information, so we file FOIA requests, we use more than 10 OCR engines combined with processes that automatize the feed from closed PDFs to a database adding rows in a database per month or daily, and we even type manually information from handwritten data files.

One new example in 2018 of this is The Driver’s Notebooks of Corruption. This investigation formally began on January 8, 2018, when Diego Cabot, an investigative journalist from La Nación was given eight notebooks that exposed Argentina´s greatest corruption scandal ever. We built a structured dataset from this handwritten notebooks,  we transcribed all the information into an Excel database and began analyzing each one of the records. Then, we verified and checked the information by crossing it with other multiple sources such as official gazettes and company records and public contracts. This verification process was used to carry out a strict process of standardization and structuring of data in which currency and descriptions were unified and names and addresses were standardized.


So far, 73 individuals have been prosecuted in this case (40 have been imprisoned and several continue and another 90 businessmen are waiting for prosecution), including a former President, the entire office of the Ministry of Planning and the main public contractors of the country. About 40 that were inprisoned already confessed their crimes and US$ 600 million were already seized.

Also, we are very proud of being a media initiative producing and evangelising about open data to key players of the knowledge ecosystem (Governments, Universities, NGOS, Academia, multilateral organizations, citizenship). We spread knowledge about the importance of building together structured machine readable data from reliable sources in which every player can benefit as User and Producer of new information combining datasets. We are active participants of the national, latin american and international open data community conferences, meetups and, EVEN, Whatsapp and Telegram Groups. In our blog, site and social networks we publish and promote open data projects from Argentina and worldwide as well as open government portals launched

 

A member of our team at Open Data Day


A recent example is a legislative training we delivered in alliance with an NGO called Nuevas Generaciones about the importance of creating an open legislative power. We travelled to four provinces: Salta, Mendoza, Corrientes and Córdoba and spoked with the province legislators about our experience as data users and producers with the province legislators to motivate them an generate a possitive change in the local governments.

A member of our team in the legislative power of Cordoba province

The vision we have is that each set of data that is digitalized and published means that more knowledge is released. Although it is true that we use data as input for journalism, our work goes far beyond including statistics in news articles.

 

A member of our team at the house of the City of Buenos Aires Government

An example of this is our project At What Price? (A que precio). Together with Chequeado, a Fact checker unit, and Acij, a transparency NGO, we researched, compiled and opened all public contracts and data from medicine purchase processes of the State. It is an observatory of health-related purchases depending on the National Government and the City of Buenos Aires. Particularly, HIV medicines, contraceptives and vaccines.

We developed a scraper to get all the documents from multiple State portals, contrast them with the data obtained through requests for access to information, structure the base and carry out an in-depth analysis. This led to two exclusive findings we published: a) only 25% of the investment for drug purchases corresponds to public tenders; b) the Government reduced the delivery of contraceptives.


Another example is the 2018 Youth Olympic Games in Buenos Aires investigation were we manually monitored all purchases, contracts and infrastructure of the event from open data portals and a FOIA request from the City of Buenos Aires. After analyzing this contracts we were able to reconstruct the total cost of the event that exceeded 8 billion pesos and explain specifically the purposes for such an expense. Until then, the government had repeatedly refused to inform this figure and did not have the systematized information open to citizens.

In search of innovation in data collection, analysis and presentation this year, in August, we began to develop and  produce automated content from scratch and in house. In other words, 1,300 automatic articles are monthly created on several topics like: sports, prices and inflation, currency exchange rates and more. The idea is to save work and make in-depth content creation more efficient to journalists and better serve with more topics on time based on data-to text stories, for our readers.

For example, as regards the monetary exchange rate, an automatic extraction of real-time data is made concerning the value of the Dollar and the Euro informed on Central Bank website and the subsequent publication of articles with more than 1000 combinations of journalistic articles. All these articles are accompanied by a visualization that is also updated through an automatic process.

Finally, keeping our team and newsroom updated, we are now focused in learning how data science can help society and journalism for good, As this happens we support or co-organized the Global Women in Data Science (WIDS) Conference in Buenos Aires 2018 and 2019. In this event journalists, data scientists, engineers and programmers meet in order to promote the inclusion of women as speakers in Data Science in different areas, industries and services in Argentina in order to inspire more women in STEM and in technology.

 

Sin comentarios

La Nacion Data’s team portfolio from Buenos Aires, Argentina 2019

La Nación Data is the data journalism unit from LA NACION in Argentina. We do Open Data Journalism for change, in order to better serve our audiences using data to discover and tell stories. We promote the use of open data and access to information in Argentina as evidence to keep governments accountable, enhance transparency and allow citizen´s collaboration in the process of journalism.

Much of our work and effort is invested in building datasets from scratch, cleaning, structuring and normalizing to make them accessible for our newsroom and our users in Argentina. But our objective is also to produce long-term investigations that encompass a multiplicity of topics of interest with the intention of producing a political and social impact. Here is a selection of this year´s work and strategy:

1.  The Driver’s Notebooks of Corruption. This investigation formally began on January 8, 2018, when Diego Cabot, an investigative journalist from La Nación was given eight notebooks that exposed Argentina´s greatest corruption scandal ever. We built a structured dataset from this handwritten notebooks,  we transcribed all the information into an Excel database and began analyzing each one of the records. Then, we verified and checked the information by crossing it with other multiple sources such as official and company records, corporate information, public works contracts. This verification process was used to carry out a strict process of standardization and structuring of data in which currency and descriptions were unified and names and addresses were standardized.

So far, 73 individuals have been prosecuted in this case (40 have been imprisoned and several continue and another 90 businessmen are waiting for prosecution), including a former President, the entire office of the Ministry of Planning and the main public works contractors of the country. About 40 persons repented and confessed their crimes. US$ 600 million were seized.

 

2. 2018 Youth Olympic Games in Buenos Aires investigation we manually monitor all purchases, contracts and infrastructure of the event. After analyzing the historical budget, the electronic purchase portal and requesting twice an access to public information, we were able to reconstruct the total cost of the event that exceeds 8 billion pesos and explain specifically the purposes for such an expense. Until then, the government had repeatedly refused to inform this figure and did not have the systematized information open to citizens.

 

All processed information and original sources are made available to the public for download and reuse.

3. Project At What Price?. Together with Chequeado, a Fact checker unit, and Acij, a transparency NGO, we researched, compiled and opened all public contracts and data from drug purchase processes in State. It is an observatory of health-related purchases depending on the National Government and the City of Buenos Aires. Particularly, HIV medicines, contraceptives and vaccines.

We developed a scraper to get all the documents from multiple State portals, contrast them with the data obtained through requests for access to information, depurate them and accurately structure the base and carry out an in-depth analysis. This led to two unpublished investigations: a) only 25% of the investment for drug purchases corresponds to public tenders; b) the Government reduced the delivery of contraceptives.

 


 

4. Congresoscopio : legislative transparency 2010-2019.  To promote government accountability and use data as part of citizen control and surveillance we monitor the use of public resources and institutions.

A clear example is the Congresoscopio application that we use every time a new bill is voted in Congress and where we download the forms from the official sites of the Senate and House of Representatives. Through an OCR process, we convert them to Excel format and upload them then to our admin. It is a platform developed in house where the citizens access all the legislation considered in Congress from 2010 to the present and delve into how each legislator voted. In addition, it allows the user to see how many bills each legislator submitted and the number of absences. Obviously, legislation is made available to the user.

 

On the other hand, we believe that all citizens should participate by activating the demand for public information as a democratic principle and human right. That is why we are dedicated to teach civil society and build community. We strengthen our relationship with NGOs and universities through hackathons, meetups and workshops.

5. Argentina’s Senate rejected the bill to legalize abortionCitizens followed the presentations of Senators as closely as if they were watching a suspense movie, to be on the spot was very important. La Nación reused code to build a visualization that could follow that rhythm of the vote; it was important to know the final result of the vote and the vote of each one of the Senators on real time as well. The first interactive shows the faces of those persons representing us at the Senate, some of them are unknown for the audience in general. Moreover, the interactive adds the possibility of crossing variables to understand whether his/her age, religious belief, politic orientation or university background were related to their vote.

The second interactive, published early in the morning the day after, followed the same logic as the first one, but this time it analyzed and compared the votes between both House of Representatives and the Senate (257 Representatives/72 Senators), trying to find a pattern that answered the questions that many of us asked ourselves: did senior legislators vote against the bill and the younger ones, in favor?; do the Catholic ones supported the 2 lives? Are lawyers against it? You can find the answers in the visualization

6. Open Collaboration with NGOs and Universities: the Open Statements of Assets

An example of this is the open Statement of Assets (Affidavits) website of the main officers of government. Every year we access hundreds of affidavits through FOIA requests. The problem is that most of the data is handwritten on a sheet of paper, so we organized hackathons in alliance with NGOs: Poder Ciudadano, ACIJ and Directorio Legislativo to upload all the information into an open source administrator we created for such purpose.

 

These are meetings held for several days where students and volunteers participate to build this dataset together. In total, there are already more than 4,000 published affidavits typed in our unique web site,  that are constantly reused to investigate cases of corruption or to provide information on each new Government officer. This data is presented in open formats as well.

 


7. Data Science and Journalism: keeping our team and newsroom updated, we are now focused in learning how data science can help society and journalism for good, As this happens we support or co-organized the Global Women in Data Science (WIDS) Conference in Buenos Aires 2018 and 2019. In this event journalists, data scientists, engineers and programmers meet in order to promote the inclusion of women as speakers in Data Science in different areas, industries and services in Argentina in oder to inspire more women in STEM and in technology.

 

8. Open Data and Open Government:  we actively participate in movements of open information and act as users of open data from open governmens, we share learnings and give talks in several universities: Universidad Austral, Universidad Católica Argentina, Universidad Don Torcuato Di Tella, Universidad de La Matanza, Universidad de Lomas de Zamora, and others in Latin America as well.

 

Open Data Day

Every year, we are speakers at Argentina Abierta (Open Argentina) , a federal meeting on openness and innovation to design better public services. It is attended by public officers, entrepreneurs, civil society organizations, students and journalists willing to share achievements and experiences throughout the country and beyond to continue promoting a more open and collaborative world.

Team member at La Sabana University in Bogotá Colombia

At the same time, we were media partners of the 5th International Open Data Conference (IODC) in the City of Buenos Aires. It is a meeting aimed at developing transversal thoughts on openness, transparency and citizen participation. Our team was moderator of the panel on journalism and open data and organized a media conference at the editorial office of LA NACIÓN.

 


9. Automated content, from scratch in LA NACION: in search of innovation in data collection, analysis and presentation this year, in August, we began to develop and  produce automated content from scratch and in house. In other words, 1,300 automatic articles are monthly created on several topics like: sports, prices and inflation, currency exchange rates and more. The idea is to save work and make in-depth content creation more efficient to journalists and better serve with more topics on time based on data-to text stories, for our readers.

 

For example, as regards the monetary exchange rate, an automatic extraction of real-time data is made concerning the value of the Dollar and the Euro informed on Central Bank website and the subsequent publication of articles with more than 1000 combinations of journalistic articles. All these articles are accompanied by a visualization that is also updated through an automatic process.

10. Playing with data: regarding the innovative and creative presentation of data, the aim of all our interactive pieces is to challenge the user to understand, interact and explore the topic to be covered.

 

A clear example is the coverage of the 2018 World Cup in Russia where a series of visualizations focused on the real time of the event were planned. More than 12 large productions were created related to penalties in the knockout round, a balance of the first round, live statistics, an interactive key to beat the knockout round, players’ scores, fixtures and many more. All of them were created for direct interaction with the user: draw simulator, select your players, make your World Cup forecast.

 

11. Data visualization in news stories:  the first anniversary of the disappearance of the Ara San Juan Submarine. A year of uncertainty had passed since contact with the 44 crew members was lost. Data was collected from the last messages sent by the crew members to their families and the last reports sent by ARA SAN JUAN were presented.

In addition, the route was visualized, and a 3D render was made to graph the ventilation system through which the water that damaged the batteries entered and that ended the lives of all the crew members. At the same time, special emphasis was placed on real time searching and tracking with the use of tools such as marinetraffic.com from which all the stories with data were told and all the rescue ships followed and simulated in our graphs.

Another year learning new tools, producing data journalism and enjoying every challenge with our data team.

TEAM MEMBERS:

Momi Peralta Ramos: Data Journalism Project Manager and Multimedia Development Manager

Ricardo Brom: Data engineer for investigative reporting – Data intelligence unit

Florencia Coelho: Research and training in digital media trends

Gabriela Bouret: Data analyst and data miner

Romina Colman: Data journalist and freedom of information specialist

Bianca Pallaro: Data journalist and data producer

Gabriela Miño: Librarian and Archivist

Florencia Rodríguez Altube: Data journalist and data producer

Nicolás Bases: Back and front end developer

Cristian Bertelegni: Back and front-end developer

Sin comentarios

LA NACION´s Shopping Cart. Monitoring 2600 supermarkets and 170 product prices

LA NACION´s SHOPPING CART: monitoring 2600 supermarkets in 170 product prices

CONTEXT

In March 2018, Argentina was one of the five countries with highest inflation according to the International Monetary Fund. The index climbed up to 47.6% anually according to official numbers. The jump of the exchange rate, higher than 100% also had an impact on the rise of prices on the supermarkets every week.

Given the country’s inflationary context, there are several sources of information about price variation, but these end-user reports are abstract numbers that do not reflect their daily reality and do not represent the real impact on their economy.

To understand how supermarket product prices evolve independently of the official measurements monthly informed, and to bring this measurement closer to the daily economy of the audience, we created “Changuito LA NACION“  (LA NACION Shopping Cart), a price monitor that allows a weekly and monthly monitoring of goods product by product such as noodles, soft drinks and liquors and toothpaste, among others. Its name refers to the colloquial way of naming the shopping cart.

The premise is to make price variation -an abstract subject that impacts on every household in an inflationary context- more contained in terms of everyday aspects and give control to end users . According to the study made in March of this year by D’Alessio IROL/Berensztein, inflation is the first concern of Argentine citizens, followed by uncertainty about economic situation and insecurity.

The audience of Changuito LA NACION is potentially massive: as price variation is an issue for every Argentine citizen, any person with devices may access the app for which links are often provided from our home page.

El Changuito presents a group of 170 food, beverage, cleaning and toiletry products from leading brands that are marketed nationally in 2,561 points of sale and are representative of household consumption in Argentina. Each one of the goods has a “premium” option and a “standard” option, differentiated by price.

To make interaction easier, we created four pre-set baskets, based on our official statistics methodology. They are: for people living alone, for couples, for a four-member family, and for retired persons. Thus, if the user selects this option, he/she can access a pre-set basket of food, toiletries and cleaning items that are similar to the consumption of the type of household chosen. In addition, you may modify: add or remove products and decrease and increase quantities. Each of them has its nominal price (total price) and its variation (on a weekly and on monthly basis).

The user also has the option of assembling a “changuito a medida” (taylor-made shopping cart), that is to say, to make a virtual tour among the monitored products to personalize his/her own basket. To enable an individual tracking, each reader registered on the Web or through the mobile app of LA NACION may save his/her own selection.

In addition, by clicking on each product, the user may see its current price and the weekly and monthly price variation with a linear graph.

 

INNOVATION

This is the first time in Argentina that a platform has been developed by a data journalism and the business editors team,  and it allows the user to compare price evolution every week in consumer centers in the most important areas of the country. This is particularly useful because the country is exposed to constant inflationary movements throughout its history, something that has worsened in the last six years. This is rare and valuable in a country where monthly price variations reached 6.5% in 2018.

It is different from any type of application that analyzes price variations because it has a personalized approach, because it invites dialogue with the user and because it “brings back” to reality and individualizes a product (initially, an abstract concept), but that affects the pocket of all Argentine citizens.

It is also innovative from its genesis. To begin with, we select key products to be included in an average consumer basket of supermarkets. We made a different selection and we were helped by experts, but also by potential users of the app: we consulted both consumer specialists and consumers.

In addition, we use an official database, “Precios Claros” (clear prices) that publishes daily thousands of prices in thousands of supermarkets in Argentina, but doesn´t open this historical prices in an API or replied with this data to our two FOI requests in order to obtain the complete dataset. So we decided to add value. Every day this database presents a picture of the current status of prices in different points of sale, but you can´t go back to the price of the day before, it´s lost. Instead of this still picture, we make a film: we collect data once a week and build a dataset, so we may analyze its evolution, we add frequency and systematization with data analysis over time as well.

In the process, for each of the functionalities we created (such as the generation of individual baskets or the possibility of ordering products according to higher or lower price) we held meetings to determine the user experience. To do this, we consulted different profiles, from consumer specialists, designers, economic journalists and programmers, among others.

IMPACT

The average time of the app is 4.51 minutes. The Changuito LA NACION was presented several times on TV, on news sections of LN+ and Lanacion.com. Since it is an atemporal platform, always useful , it may apply to any event that may alter prices or that may focus on them, such as strong devaluation or a monthly report on inflation made by the Instituto Nacional de Estadísticas y Censos (National Statistics and Census Institute – Indec).

Besides, its use is also highlighted on special occasions, such as Christmas Season. In December last year, we set a special Christmas basket of products that could be weekly checked to see when it was convenient to purchase each product.

SOURCE AND METHODOLOGY

The Changuito LA NACIÓN consists of a following-up of a group of 170 products (food, soft drinks and liquors, cleaning and toiletries items of leader brands locally commercialized in 2.561 points of sale.

The project began in the middle of 2018. After several requests for access to information to obtain a complete historical database we decided to scrap the products by ourselves from the official Precios Claros website. To do so, we left activated a software to be executed twice a week and record the information in a database.

To create the basket, consumer specialists were consulted and the final selection of the products was made. In all cases, prices are collected by LN Data from the information available in Precios Claros, the official system that is assembled from the data provided daily by stores and supermarkets to the Dirección Nacional de Defensa del Consumidor (National Board of Consumer Protection).

From the moment we began to save the data in the database, we checked the official website to verify and control the information. In addition, as we found inconsistencies in the prices published on the site, we decided to discard the outliers.

The survey excluded items on offer, specific promotions and products that make up the official program of Precios Cuidados (through which fixed prices are agreed with the Government for more than 500 products) to avoid distortions. Meat, fruit and vegetables were not taken into account either, as they tend to lose track and distort the sample.

The price of each product arises from averaging its price in the 2.561 points of sale and its sum gives the total price of the basket. LA NACION has been following this basket since August 3, on a weekly basis, and will continue to publish information with the same periodicity.

Another feature is that you can select from pre-determined baskets according to each user’s profile, or else, create individualized baskets. The basket may be saved for tracking over time. It is also possible to choose between premium or standard products, add or remove products, and, in each case, it graphs the variation of each product and that of the entire basket. 

Also, the user may order the basket by different attributes: higher or lower price, higher or lower price increase, premium or standard products. Another useful function is to be able to see the products with their photos or in a list.

For each of the functionalities we held different meetings to determine the user experience and to do so we consulted different profiles, from consumer specialists, designers, economic journalists and developers among others.

The opdating process is fully automatic, since data is automatically collected twice a week, saved in a database, and then an update impacts on the front end .

On the other hand, if it is necessary to add or remove products for users to see, we have an admin and back-end where the same journalists may modify the arrangement of a basket or create new ones to follow some other project, such as a school basket when school time begins, a Christmas basket or a set of products related to holidays.

Beside these special baskets we arranged a specific basket that we called “Canasta LN” (LN Basket), that we use for reporting in which we included a list of 43 products. Thus, every week another script runs automatically, and creates an article based on a template together with our visualization and it determines the products that increased the most or were reduced the most. In addition, it embeds a visualization on Tableau that is automatically updated for each publication.

 

TECHNOLOGIES

On its website “www.preciosclaros.gob.ar” the National Government publishes a price list of more than 70,000 products throughout the country. This list may be consulted to find the best price of a product in supermarkets and stores nearby, as it uses geolocation. It may be accessed through the web portal or through an API.

The government application offers for each product several descriptive data such as name, packaging presentation, minimum and maximum price that may be found for that product and branches of supermarkets where the user may get them with their corresponding list price. All retailers are required to report the price list on a daily basis so the site is updated every day.

Taking into account the inflationary problem of Argentina, LA NACION used these data to calculate the price variation for each family type. The initial question for this project -and its answer- is: “What was the price variation for me (or my family) this month?”

For doing so, first of all, we developed a scraper for some products on the website Precios Claros since 2018 to build our dataset. This database contains prices in supermarkets and stores in each city of Argentina. It was also necessary to set up common products between cities, since not all brands and packaging presentations cover all the territory. For this reason, there was a selection of 170 products that were representative and that may be found in almost all the stores.

This scraper updates data every week and the user may thus obtain the price variation of each product. First we developed one for the “LN Canasta” in SQL so we could prove the concept, Then for “LN Chanquito” we needed to automatize it and connect it with boths outputs,  so we developed another with Python and hosted in a Lambda with CloudWatch and PostgreSql , using in RDS for the database.

An ADMIN developed with Django/Python is used as a back-end to be able to control that all processes work correctly. Besides, journalists involved in the project may make decisions such as which products are included in each basket and which items need to be added, for example, according to the seasons of the year.

From the back-end, after updating the data weekly, a json file is created and hosted in S3 with the prices of the last four weeks for each product in each city. At the moment, the data of the City of Buenos Aires and the Greater Buenos Aires are being used, but in the future more cities will be added.

For the front-end an application developed with VUE.js, D3.js, CSS3 HTML5 was programmed. This one uses the json files published by the back-end in S3. Each user has different alternatives to know what is the price variation of the products he/she consumes through sets of goods that we call baskets.

A “basket” is the group of products that make up the monthly consumption of a person or family, as appropriate. There are five basket options: “family” (couple plus two children), “couple” (two adults), “retired persons” (elderly couple), “single” (adult person) and “taylor-made” (possibility of choosing which products make up the user’s monthly basket).

When selecting a basket or choosing the products that the user consumes, the user may see on the front-end the variation of their prices based on the selection made.

The application is connected to the login service of the LA NACION website and the user has the possibility of saving his selected basket for future visits. If the user is not registered, he is invited to register in order to save his basket.

Sin comentarios

FIFA World Cup Russia 2018

On the occasion of the 2018 FIFA World Cup in Russia, a complete coverage was planned. The production had to demonstrate the highest standards of journalism in an interactive and digital design. The objective was to inform and engage the audience in  two different stages:

The first stage consisted of a series of playful and social visualizations prior to the beginning of the World Cup. The articles were strategically conceived according to the schedule prior to the event: selection of the 23 players that were going to travel to Russia, the 11 players that were going to play on the first match,  a draw simulator of the different possible groups in which each country soccer team could be selected and their possible opposing team, and a result forecast for the people to play with and bet.

Instead, the second stage was focused on the real time results and matches: a fixture with the times, teams and matches, a calculator for the audience to estimate results and evaluate the possibility of passing to the next round, a game that allows the audience to score the players after each match, a live statistics visualisations of the amount of shoots and passes between players and their positions on the field throughout the game, the possibility to vote for the best goal of the world cup and a monitor of the speed and the distance runned by each player.

Russia 2018

Visualizations published before the Soccer World Cup

 - DRAW SIMULATOR

Days before the event and with the purpose of informing the methodology of the draw, an interactive was made that simulated the possible combinations that could result from the draw and thus allow the user to speculate with which teams could face the Argentine football team.

 

- CHOOSE YOUR 23 SOCCER PLAYERS

The day the coach of the Argentine football team informed the previous list of 35 players of which only 23 would be included in the final list, an interactive development allowed the reader to choose his/her 23 favorite players for the football team. With the data provided by the users, a ranking was formed in real time with the most and least chosen players. During the day the app was active, it obtained 113,340 unique users and an estimated time of 4.22 minutes.

 

- CHOOSE YOUR 11 FOOTBALL PLAYERS

After informing the list of 23 football players confirmed to play in the World Cup, users were asked to put together a team of 11 players to play the matches. With the data provided by users, a ranking was made in real time with the most and least chosen players. It was an interactive that also was monetized through a sponsor.

 

- ALL THE WORLD CUP FOOTBALL PLAYERS

Once the players of all the football teams that would play the World Cup were confirmed, a database was created with the nationality and the football club where they played. Through an interactive, user could explore data and get different views on the players on the list.

 

- FOOTBALL WORLD CUP DRAW

Three weeks before the beginning of the event, this app was released and the users could predict the results of all the football matches. With the data provided by the users and by means of a score system based on the hits obtained, a list of positions was created that, at the end of the World Cup, informed a winner.

In addition, the app offered the possibility of creating groups for users to set up tournaments with their friends. More than 30,000 forecasts were created, and the app had a high level of participation during the 45 days that the app was active. Total users 1,028,134. The average time was 08:33. It was an interactive that also was monetized through a sponsor.

 

Visualizations published during the Football World Cup

 FIXTURE

During the World Cup this app was released with the schedule, groups and real-time results of all World Cup matches. In addition, each group had a calculator to speculate the results of the matches and evaluate the chances of classification of the teams according to the speculation made. It was the most successful piece of all, with a user record of 3,376,065 and an average time of almost 10 minutes. It was a development that was also monetized through a sponsor. For the real time it was used the data service of the OPTA company which was processed and enriched to adjust to the needs of the proposed development.

 

GIVE A SCORE TO PLAYERS

An interactive that allowed users to give a score to players after Argentina’s matches during the World Cup in Russia. The data provided by the users allowed to give each player an average score. This resulted in a platform with a reusable collective score for each match of the Argentine football team.

 

INTERACTIVE KEY

To get excited about the elimination phase of the World Cup, this app was released so the user could speculate on the results of the groups and create the tournament key. In this way, the user was given the possibility of determining which selection the user thought would be the winner. For real time the data service of the OPTA company was used, which was processed and enriched to adjust to the needs of the proposed development.

 

LIVE STATISTICS

For the coverage of all the soccer matches of the World Cup, a series of visualizations were developed in real time with the statistics and incidences of each match. For real time, the data service of the OPTA company was used, from which the raw data were taken to obtain original and exclusive visualizations of LA NACIÓN: shots to goal, passes between players and movements on the field .

 

FIRST ROUND BALANCE

Based on the data provided by OPTA, a database was created to develop this visualization, which was released just after the first round of the World Cup, in which the performance of the Argentine soccer team players was evaluated: shots to goal, distance covered and speed for each match of the first phase.

 

PENALTIES IN KNOCKOUT ROUND

FIFA’s official data was analyzed for all the matches that were defined by penalties in the knockout round in the history of the World Cups. The result of the analysis was the conclusion that the teams that had most defined their matches by penalties were Argentina and France, both rivals in the following match of the World Cup. With the data, a visualization was developed that analyzed in detail these two teams in their definitions by penalties.

Sin comentarios

Driver’s notebooks exposed Argentina’s greatest corruption scandal ever: ten years and millions of cash bribes in bags

INVESTIGATION

ALL THE ARTICLES PUBLISHED IN LA NACION ABOUT THE SUBJECT

This investigation was published on august 2018 after 7 months of secrecy. So far, 73 individuals have been prosecuted including a former President, 40 have been imprisoned, other 40 already confessed their crimes and are waiting for oral judging and US$ 600 million had been seized.

More than 200 newspapers from the all over the world covered the news that broke in LA NACION, globally known as “The notebooks of bribes” (“Los cuadernos de las coimas”).

On january 2018, Diego Cabot, an investigative journalist from La Nación, was contacted by one of his sources. At the meeting, he was given eight notebooks that have been written by the driver of Roberto Baratta, the Secretary of Energy, an officer of the former Federal Planning Agency that included Energy, Transportation and Infrastructure. The Minister in charge was Julio De Vido, one of the most important officers during the 12 years of the Kirchner administration (from 2003 to 2015).

The notebooks contained a detailed record of each one of the routes the driver made for 10 years, taking Roberto Baratta and other officers to collect money in bags of cash representing bribes of several large companies of Argentina that have been awarded with public contracts.

From the beginning of the investigation, Diego Cabot, who has been a pioneer in data journalism since 2011, and a small team who accompanied him in the whole process, made two fundamental decisions. First, given the number of state officers and important businessmen involved, they decided not to publish anything until they could prove and verify most of the facts, No person, except for the team members and LA NACION´s Managing editor, knew anything about the investigation that was being carried out.

 

Second key decision: build a dataset from this handwritten notebooks. The 8 notebooks were transcribed to an Excel database. The team began working on each one of the records with all the objective elements that could be verified. The following columns were listed:

- Names and positions

- Adresses and destination of the routes

- Data from car plates

- Name of companies

- Places for the delivery

- Personal information of the individuals identified at the moment a bribe was paid.

- Amount of each one of the bribes

During the checking and verification process they consulted:

- Official gazette datasets and company records

- A large number of addresses using google maps

- The corporate information of the companies involved was gathered

- The amounts paid were compared to the Government accounting details

- The payment of bribes were cross checked with the information related to tenders and public contracts and the percentage of execution of each one to verify any relation to the amounts of money from bribes.

After checking and knowing that the whole matter was true, the team understood that they were working with the biggest corruption scheme ever revealed in Argentina. 

The content of this corruption scheme was formalized in a document and in March 2018, the journalist began a formal negotiation with a Federal Prosecutor (Carlos Stornelli). On April 10, a formal complaint was filed before justice.

There was a commitment between the Prosecutor’s office, the federal court and LA NACION: nobody could know anything about the cause and silence had to be absolute. “If the investigation was leaked, it would have been very dangerous and risky,” said the Prosecutor of the case some months later.

On the early morning of August 1st, seven months after Diego Cabot received the evidence, the case became known to the public and the Justice ordered 17 arrests and 36 search warrants.

 

The title of the case file had the name of the former President of the Nation: “Fernandez Cristina Elizabet and others for illicit association” (9608/2018). The Judge considered that the data provided proved the existence of a criminal organization made up of public officers who, using official means (including automobiles, employees, cell phone equipment, etc.) and commanded by the heads of the National Executive Branch (Néstor Carlos Kirchner and Cristina Elisabet Fernández) and the Federal Planning Ministry (Julio Miguel De Vido), between 2003 and 2015, obtained illegitimate amounts of money from several individuals, many of them businessmen who were contractors of public spending for infrastructure from the national government.

That same day, the Data team in LA NACION decided to compile all the spreadsheets that they had been previously worked on to deepen the analysis and processing of the notebook records. First, a check was made on the transcripts to verify that the amounts described, the individuals, the place of origin and destination that appeared handwritten in the notebooks were correct. This verification process was used to carry out a strict process of standardization and structuring of data in which currency and descriptions were unified and names and addresses were normalized. The exact date and time of the routes were also added.

On the other hand, a methodology was applied to classify each route, which was divided according to: a) if the bag of money was delivered to the head of the criminal bribery plan; b) whether it consisted of collecting the money given by the companies as a bribe. In addition, a series of tags were included to identify the relevance of each record.

 

Based on the classification, we created several dictionaries of equivalences because the notebooks contained various terms for the same concept. Example: “bag” = “suitcase” = “briefcase”. We did the same with personal names and addresses.

All the journalistic investigation work was accompanied by various applications and exclusive visualizations that allowed the user to browse in a digital and interactive way all the notebooks and current news on the subject. This included the full text searchable notebooks and the grouped by brives destiny visualizations . 

 

IMPACT

So far, 73 individuals have been prosecuted (40 have been imprisoned and several continue and another 90 businessmen are waiting for prosecution), including a former President, the entire office of the Ministry of Planning and the main public works contractors of the country. About 40 persons repented and confessed their crimes. US$ 600 million were seized.

Researchers from CONICET (a group of State scientists) calculated that the bribe money paid during those years of corruption was US$ 38,000 million.

More than 200 newspapers from the all over the world covered the news which was globally known as “The notebooks of bribes” (“Los cuadernos de las coimas”).

 The case file accumulated 35 bodies of proceedings in federal court in one month, in addition to voluminous documents and annexes. There were 70 search warrants, 36 in the City of Buenos Aires, 24 in the Province of Buenos Aires, 7 in Misiones, 2 in Santa Cruz and 1 in Mendoza. Moreover, the Senate considered the request of the Judge to search the private addresses of former President Cristina Kirchner, currently a Senator and holder of Parliamentary privileges and immunities. The vote in the legislative body ended 66 votes in favor and none against and the procedure was authorized.

More than two hundred and fifty (250) paintings were seized in possession of two accused for approximately thirty-seven million pesos ($37,000,000) and four million five hundred thousand pesos ($4,500,000). In addition, as a consequence of this, more than six million three hundred and fifty thousand pesos ($6,350,000), more than one million two hundred and forty-five thousand US Dollars (U$S 1,245,000), and two hundred and thirty-five thousand Euros (€ 235,000.00) were seized, as well as other currency: Chilean and Uruguayan Pesos and Brazilian Real, nine (9) firearms, mobile and electronic telephone equipment and finally, a large number of cars of different brands and models, many of them luxury cars.

 

Repercussion in the international press

- Bags of Cash in Argentina: Driver’s Notes Propel Corruption Inquiry – The New York Times

 Argentina notebook scandal: Driver details ‘decade of brives’ – BBC

Secret papers trigger argentine scandal: What you need to know – Bloomberg

Driver’s diaries of transporting bags of cash help Argentina score historic victory against corruption – Miami Herald

How a chauffeur could bring down Argentina’s political elite – Bloomberg

 

Diego Cabot and his team in LA NACION , thanks to their work in “The notebooks of brives” or “The notebooks of corruption” already won:

-The National Investigative Journalism Prize at the Argentinean Journalism Forum (FOPEA)

-The International Prize King of Spain (Rey de España)

-Society for News Design 

Sin comentarios

Automated data-driven content

The project was born in the context of 2017 elections, with the purpose of creating news articles automatically from datasets using templates and allowed us to cover much more detailed results for all Argentina´s territory, so we did it to cover 530 districts with their results and local maps.

Then we found this could create an opportunity to help the newsroom in its usual work process in repetitive news that are data driven and that can be supported with series and graphs. So we began to produce daily and weekly articles, automated through a systematic collection of data from different sources and topics.

All these automatically generated articles are accompanied with infographics, images and interactive visualizations that are created from the automatic loading of data in Google Spreadsheets.

The first subjects covered by this project were thought in terms of the interest of the Argentine citizens: dollar, inflation and Argentine football. Three central subjects in the everyday life of our country.

Examples of automated data-driven content in LA NACION:

Dollar: https://www.lanacion.com.ar/economia/dolar-hoy-asi-cotiza-el-3-de-abril-en-banco-nacion-y-otras-entidades-nid2234795

Inflation: https://www.lanacion.com.ar/economia/la-canasta-de-precios-de-la-nacion-tuvo-un-alza-de-187-en-las-ultimas-cuatro-s-nid2232905

Football: https://www.lanacion.com.ar/deportes/colon-san-martin-de-san-juan-el-mapa-de-los-remates-y-quien-dio-mas-pases-nid2234453


Dollar , daily currency exchange

In Argentina the price of the Dollar has an important place in the life of the population. Every Argentine citizen knows the daily exchange rate because the fluctuation and volatility of the value of the Peso makes it necessary its daily monitoring. Our economic history developed an eternal distrust in the national currency in the Argentine people. And since the threat of recession and devaluation is always latent, a large part of the population´s savings are in Dollars. In addition, there is also the factor of high rates of inflation that prevents saving in Pesos because it quickly loses value. In fact, people are so interested in this topic that it has a permanent place in the home of all media.

Before automatization,  every morning a journalist tracked the day’s exchange rate price and wrote several articles according to the variation of the Dollar throughout the day.

This was useful as a clear example to automate. That is to say, to ease work of economic journalists and to assure that each article is consistent with the bank rates informed and an infograph to visualize the variation over time.

The automatic article that is created in the morning informs the rate of the previous day, then it is updated with the rate of the day and in the afternoon a new article is created at the closing of the rate. This article also makes easier the work of the journalists since when there is a significant rise or fall, the journalist may use it as a basis to create more content in the article: explain reasons, consult experts and add them as a source.

 

Inflation is another central subject in the daily life of Argentine people. In fact, inflation in 2018 was the highest in 27 years: it reached 47.6% yearly. There are several sources of information about price variation, but these end-user reports end up being abstract numbers because they do not reflect their daily reality and do not represent the real impact on their economy.

For this reason, we decided to create a platform where the price of products sold in supermarkets can be automatically tracked and in real time. We created “Canasta LA NACIÓN” (LA NACION Basket), a price monitor that allows a weekly and monthly monitoring of the price of several products such as noodles, soft drinks and toothpaste, among others.

And, from that moment onwards, once a week we produce an automatic article with basic food basket information of 43 products for digital and paper versions with corresponding interactive display.

 

Soccer:

In order to give more context and cover all soccer games, we automate the articles of the different matches of the Argentine Soccer Association. The automatic articles are summarized in three:
a) An interactive visualization with the passes, shots and movements of the players of the two teams of each match that is played

b) 24hs before a match, an article is created with minimum information and already pre-loaded widgets so that the match updates and modifies during the match.

c) A summary of all the matches that are played throughout Argentina, that is to say that it includes automatic articles of the local matches that are played in the different provinces.

INNOVATION

It project is innovative because we found a way to work in teams with our editors that understood how technology and data can help them better serve audiences and reach larger audiences thanks to a broader coverage. We developed an in house automatization platform customized to each data source and work with our graphics area as well to have the data visualizations ready.

Work that was repetitive and tedious became, thanks to this process and technology, a successful and efficient task that preserves the touch of quality journalism.

The choice of topics helped change the newroom culture since several traditional journalists are experiencing the benefits of technology and the context data gives to support their stories,

IMPACT

The impact of the project was immediate. Particularly, with the increase of entries in all the topics considered . But besides helping with figures and traffic, it also developed a cooperation culture between traditional journalists , data producers and developers. Now, journalists are approaching LA NACIÓN DATA to request the automation of different articles in order to add value to their work and speed up those productions that need most of the human work.

People constantly comment, claim, question and give opinions on inflation, football and Dollar and to do so they share news articles of LA NACIÓN.

Source and Methodology

The beginning of the cycle for creating an automatic article flow has several origins. In some cases, the same editor realized that the same article was repeated frequently and asked us about the possibility of automating such articles to lighten work of the journalist in charge. In others, it came up from the lopportunity to cover more topics and sub topics like all the soccer games in the main and second main league in Argentina, every week.

Once we confirm the possibility and need for automation, we research the source and origin of data. The source may be:

- A database regularly and manually completed by the journalist
- an API
- Scrapping and building a dataset from scratch

The next step was to create multiple text possibilities according to the variation of data. These texts are conditional and are used to produce thousands of articles that will work as text templates based on the figure obtained.

The last step was to configure and collect data with the generation of articles and define a date and time (cron) for publication that is done automatically without the need to go through the hands of an editor.

Technology

The project has a serverless architecture using the AWS stack. Each automatic article has its Lambda written in Python. In cases where the data source is a dynamic site made in javascript Node.js is used with Headless Chrome to do the scraping. As a database we are using PostgreSQL.

We use Google Docs API and present updated graphs in the front end using Javascript and Tableau Public.

Sin comentarios

Argentina’s Senate rejected the bill to legalize abortion

ONE BY ONE, HOW DID EACH SENATOR VOTE FOR THE BILL ON VOLUNTARY INTERRUPTION OF PREGNANCY

ABORTION: THE VOTES BETWEEN BOTH HOUSE OF REPRESENTATIVES AND THE SENATE, ACCORDING TO PROFESSION, AGE AND GENDER

CONTEXT

On August 8, the Senate voted the Bill on voluntary interruption of pregnancy after a preliminary approval at the House of Representatives a few weeks before. The bill established the possibility of having an abortion during the first 14 weeks of pregnancy at public hospitals. The bill was not approved that day and Argentine legislation only allows abortion in case of rape or in a life risk situation of the mother.

The day the abortion bill was defeated in the Senate

That bill divided Argentine society and the debate moves to the media, politics and society and it involves deeper feelings of each individual, since it questions the origins of human life, the position of a woman and her capacity to decide on her own body, among other subjects. There appeared “green scarfs” as a symbol of the fight of those women who were in favor of the decriminalization of abortion and, as opposed, there also appeared “light blue scarfs” showing another position against this legislative proposal and in favor of saving both lives (mother and child).

The day the abortion bill was defeated in the Senate

Women of all ages stayed long hours at the surroundings of the Congress waiting for a resolution

As days went by, the city of Buenos Aires was painted in both colors and, on the day the bill was voted in detail at the Senate, women of all ages stayed long hours at the surroundings of the Congress waiting for the legislative session. It was a cold day of August and the session lasted ten long hours. It rained, but nothing stopped those persons. The mere fact of being debating a taboo subject like this one was a historical milestone in our country. One could be in favor or against it, but it was impossible to be on the sidelines.

The whole country observed and listened to each Senator as he/she presented the reasons for his/her vote. The country was divided: half was green, and the other half was light blue. That day we saw how audiences grew in their interest on this topic and we decided to react and present on real time two projects to the audience: the online following up of the debate and a comparison between the vote at the House of Representatives and the Senate.

The day the abortion bill was defeated in the Senate

Argentina’s Senate rejected the bill to legalize abortion 

INNOVATION

Citizens followed the presentations of Senators as closely as we were watching a suspense movie, to be on the spot was very important. That is why, La Nación reused code to build a visualization that could follow that rhythm; it was important to know the final result of the vote and the vote of each one of the Senators on real time as well. The first interactive shows the faces of those persons representing us at the Senate, some of them are unknown for the audience in general. Moreover, the interactive adds the possibility of crossing variables to understand whether his/her age, religious belief, politic orientation or university background were related to their vote.

ONE BY ONE, HOW DID EACH SENATOR VOTE FOR DE BILL ON VOLUNTARY INTERRUPTION OF PREGNANCY

The second interactive, published early in the morning the day after, followed the same logic as the first one, but this time it analyzed and compared the votes between both House of Representatives and the Senate (257 Representatives/72 Senators), trying to find a pattern that answered the questions that many of us asked ourselves: did senior legislators vote against the bill and the younger ones, in favor?; do the Catholic ones support the 2 lives? Are lawyers against it? These and many more questions find their answers in both visualizations.

ABORTION: THE VOTES BETWEEN BOTH HOUSE OF REPRESENTATIVES AND THE SENATE, ACCORDING TO PROFESSION, AGE AND GENDER

 

IMPACT

The project concerning how each Senator voted based on each Senator’s different demographic indicators became the most read article of the day. In social media, gender-filtered visualization was shared because it was clear that 60% of all male Senators voted against abortion, while the percentage among women is 50%. It was remarkable for the female audience since it was a fundamental public policy for women and they claimed that it had not been approved because it had been left in the hands of the men in the House (who are in the majority).

At the same time, the filter of age and political orientation was also shared repetitively. The only women under 40 years old voted in favor, while among the rest of the senior Senators, there was much disparity in the vote. And as regards the orientation and political parties, it was very clear that the pro-government party has the majority of its Senators against the bill.

The day the abortion bill was defeated in the Senate

Moreover, the visualization regarding the vote of the Senators compared to that of the members of the House of Representatives allowed to give a wider visibility to the subject, since it included the whole Congress as well as the possibility that the user understands in a visual way how each legislator voted, who were absent and whether the socio-demographic factors had any impact on each chamber.

SOURCE AND METHODOLOGY

Google Spreadsheet and Google Spreadsheet API was used to upload each one of the votes in real time. The session lasted until 3 o’clock in the morning and data were completed as each speaker gave his/her opinion and we verified it with the minutes published by each House.

As regards socio-demographic data: age, gender, political orientation, province, university degree and termination of office, a database made for the opening day of sessions at the Congress on March 1st was reused.

It was a comprehensive survey, a data journalist telephoned the 257 members of the House of Representatives and 72 Senators, a total of 329 individuals. This was manually performed for two months, since many had been elected a few months ago.

TECHNOLOGIES

The first interactive was made using HTML5 and CSS3. It was also used a JavaScript library named VUE which enables a faster uploading and its fragmentation. Thus, during the vote at the Senate, part of the interactive was highlighted on the home of La Nación website (bars and counting), and the complete interactive (filters and faces) could be seen inside the article. The second interactive was made on Tableau and both visualizations used the Google datasheet. One person uploaded the votes on real time and both visualizations were automatically updated (Google Spreadsheet and API).

The day the abortion bill was defeated in the Senate

 

Sin comentarios

A year after the disappearance of the submarine ARA San Juan

Unpublished details of the disappearance

CONTEXT

To commemorate the first anniversary of the tragedy of the ARA San Juan Submarine, a scrollytelling was made to present all the details and data about the sinking of the submarine. It was one of the most tragic events of the past few years as it involved the death of 44 crewmen that were on board.

The purpose was to develop a visual piece with new data from the year-long official investigation to shed light on some of the uncertainties and controversies of the case. The story-telling was concieved for a wide audience without segmentation as the subject emotionally involved the whole of society. 

INNOVATION

The intention was to bring together all in the same development, a multiplicity of multimedia resources and to make available exclusive data on the subject. Its a vertical story-telling that only requires the user a minimum effort of interaction: scrolling. It includes data from official naval reports, videos of the crewmen families-specially produced and created for the occasion-, audios of the official naval announcements, 3D animations of the sumbarine made with two programs called Carrara and Blender, and satellite geolocated data of the search operations collected with Marine Traffic vessel plataform.

Everything was designed in a way that the story-telling surprises the user with the succesive appearance of these elements as the story goes on.

Sources and methodology 

To create contents for the project, official reports of the investigation were searched and provided. This allowed us to create and inform what had happened as faithfully as possible (something that had not been done until now). On the other hand, the transcriptions of the communications between the submarine and the operation base were obtained. This enabled us to georeference key moments of the voyage and subsequent sinking of the submarine.

Moreover, the data service of marinetraffic.com was used to recreate the search of the submarine. The tool is a global pioneer in vessel tracking that we got to know in a data journalism course at the International Journalism Festival in Perugia, ItalyWe. Furthermore, we also contacted the families of the victims from whom we collected data as they provided testimonial evidence of the last Whatsapp messages delivered and recieved from their children before the fatal outcome.

Technology

The main purpose was to create and deliver different types of content through the scrolling. When a new section of the scrolling enters the scene, something should happen that draws the attention.

For such purpose, we used a Javascript library called “Scrollama.js” that helped us to detect which part of the interactive was on screen and trigger different events. The challenge was also to be able to control the videos with the scroll and to do so, we manage to preloaded them before the user gets to watch them on screen. For this last part we used our JS Player video hosting platform.

Another important part of the interactive was to be able to show a 3D sequence of the sinking of the submarine, given the need to visualize it in high quality, we divided the video in image sequences with Python software (so the user could download the image sequence by scrolling). In that way, we made sure that the image could be seen correctly and the sequence could be consistently controlled.

Another useful JavaScript library was Anime.js which helped us to do the animation using the scroll for the final part of the voyage of the submarine on a SVG line.

IMPACT

The development had a very good performance in metrics, the time spent on the page was 4.26 m rather above the average and a very good number of unique users: 76.762. It was also among the three most visited articles of the day.

 

Sin comentarios

Youth Olympic Games 2018 Investigation

THE CITY WILL SPEND MORE THAN 8 BILLION PESOS ON THE YOUTH OLYMPIC GAMES

The investigation lasted three months. In June we began to gather all the contracts related to the Youth Olympic Games that were registered in the electronic system of Government’s purchases named Buenos Aires Compras (BAC). This was complemented with three databases published on the City of Buenos Aires Open Data site: Framework Agreements, closed Purchase Orders and Open Purchase Orders.

However, the information had repeated records between the databases, the executing unit was poorly described, the information was incomplete and outdated, the monetary unit was not unified and there was no trace of those purchases that were held outside the Purchasing and Contracting Unit of the Youth Olympic Games (UPEJOL) and that were used for the event.

After a long normalization effort, we decided to contrast the total amounts with the sanctioned and executed budget of UPEJOL. We downloaded the Government Budget database from Buenos Aires Data site and filtered the information according to the executing unit until we obtained the figures from 2014 to 2018. There, we saw that the total amount of money declared for purchases and contracts was far below the budget which meant that the information that we had worked so hard to collect was incomplete.

That is why we decided to make a FOIA request under the Buenos Aires law 104. We requested all the purchases and contracts of the Youth Olympic Games Buenos Aires 2018, disaggregated by lines of recruitment and divided by type of process, file number, description, object, company name, CUIT of the supplier and total price.

Within the period of time stated in the FOIA law, the director of UPEJOL, Florence Grigera requested us a face to face appointment at the headquarters of the agency to explain to her what was exactly the information we wanted to gather. Two weeks after that meeting, they ask us to pick up the information in the headquarters  of the Government (despite our repeated requests to send it via email). Finally, they handed to us 9 sheets of A3 paper. The information was not only in closed format but also it did not comply with the provisions of the access request. Faced with the refusal to deliver the correct information in xls or csv, we contacted María Gracia Andía, who leads the Legal Organization of FOIA rights. She intervened and gave us access to the information in PDFs.

Once we managed to transform those PDFs to Excel, we saw that the information we had collected from the BAC was totally different from the one we received. The same file had different amounts and descriptions. That is, the same purchase that appeared in both archives cost differently according to the documents and had been awarded to different companies. That is why we contacted the Undersecretary of Strategic Management and Institutional Quality of the Government. They had no previous knowledge of these disparities and problems so they contacted UPEJOL to solve them.

Furthermore, they decided to hold a meeting in the Argentine Olympic Committee with the finance team of the Youth Olympic Games and us. There we were able to identify the inconsistencies and errors in the systematization of the information and, consequently, they undertook the challenge to find out more about the errors and to correct the mistakes.

Within three weeks of that meeting, we received an email from the General Director of Institutional Quality with the information updated and in an open format. But the file only contained the purchases and contracts of UPEJOL and the Government Budget Execution 2014-2018. We still had to corroborate the contracts linked to the infrastructure: Olympic Village and Park. To do so, we decided to download the information from the BA Infrastructure data portal of the City Government that includes data of the most important projects of the City and of the awarded companies, description of the work and amounts.

This is how we managed to manually reconstruct the total cost of the Youth Olympic  Games that exceeds 8 billion pesos and to explain in detail on what specifically the Government spent the money on. Until then, the Government had repeatedly refused to report the money they had spent and they didn’t have a site with systematized and open information about it.

In addition, with the information published in the budget, we showed what other stuff you can build with 8 billion pesos. In other words, we explained what that money represents. That is, we showed that the expenditure required for the event organization exceeds the total investment needed to build the most expensive and largest work in the city, the Paseo del Bajo, which costs 6 billion pesos. Furthermore, we showed that 8 billion pesos represents four times the annual budget of a hospital like Ricardo Gutierrez and almost ten times more than the budget of the Moyano hospital.

Parte del documento oficial de la postulación que el Gobierno de la Ciudad de Buenos Aires presentó ante el COI

Finally, we also gained access to an official document where the Government stated on their initial application as candidates to host the Games that they estimated an expenditure of only 231 million dollars at a price of 4.50 pesos and an annual inflation of 5.7% for 2018

Finally, we also gained access to an official document where the Government stated on their initial application as candidates to host the Games that they estimated an expenditure of only 231 million dollars at a price of 4.50 pesos and an annual inflation of 5.7% for 2018.

Regarding the impact of the investigation, the City Government informed us that, based on our request, they were able to resolve the errors that existed between agencies and were able to systematize and concentrate the information. That’s why they decided to create a legacy site for the Youth Olympic Games with the information gathered and then become the first city to open to transparency site about the Olympic event. We managed to negotiate that the publication of the site had to be subsequent to our investigation. Although the page does not report the total amounts and the information is disseminated in different bases, at least they opened the information so that the citizens can access by themselves.

The research was presented in digital format, paper and television programs.

 

 

 

Sin comentarios