LA NACION DATA Website

Meet the team!

>>> lanacion.com.ar/data <<<

Project Description

LA NACION DATA website is not just a website, it´s a strategy, a project and a team. The strategy has to do with the commitment of using data to tell stories and expand the use of data, preferably open data, to activate demand of public information, in a country that just passed a FOIA law.

The internal strategy is to work in teams with journalists, tv producers and infographers so we just facilitate the data and help in the investigation or analysis, but they are the ones who domain the topic and know how to tell the stories.  Seguir leyendo

Sin comentarios

Where did the main political forces win and loose votes

In 2017 were the legislative elections in Argentina. Not only the new representatives of the Congress are elected, it is an opportunity for the political forces to measure their power in each province.

The map shows the 2017 Elections results for each political force, and the user can compare them with the primary elections and with the 2015 presidential elections of 2015.

This tool not only displays the votes results in absolute values, also the percentage of votes that each political force won or lost. The user can click on each province and see the result for each location in in a pop-up

The innovative thing is the design, the way of presenting the information. We chose to represent the provinces of our country through squares, and give each one a simple graph of arrows that reflect that percentage of votes each politcal force won or lost.

 

How we did it?

We looked for the official data results of: the presidential elections of 2015, the primary elections 2017 and the general elections 2017.

With all the information, we categorized the political forces according to three major groups: the party Cambiemos, the party that responds to the Kirchnerismo and the peronismo no kirchnersita.

The political groups that do not identify with these three forces were not taken into account.

We used: d3js, underscore.js, jquery, css3, sass, node, gulp.

Sin comentarios

Mortgage loans simulator

In Argentina, for more than ten years, only those with good salaries have access to mortgage loans. There were no flexible offers and the rates were very high.

With the new government, this changed. A new type of credit was created, called a mortgage loan adjusted for inflation. And it boosted the housing loan market.

What’s new? This loan begins with a low initial quota, which increases over time according to the national inflation index.

When analyzing the convenience of a housing loan it is necessary to understand that the amount to be requested is conditioned by salary and age, among other variables. People wasn’t used to this new credit and how to calculate it. That’s why LA NACIÓN developed a mortgage loan simulator that allows the user to know their financing possibilities in a practical way.

This is the first time that we made a tool based on open data working together with the commercial area of the newspaper. 

How we did it?

We used the data on mortgage loans published by the Central Bank and we generate a calculator that allows the user to find their best option.

At the same time, we allow interested banks to place their corporate logos through a commercial campaign that included a contact button, so that the user can send their personal data so that the bank can contact him.

Watch the next video and look how it works! 

 

All the banks in our country are obliged to inform the Central Bank of the Argentine Republic of all their products and services, with the detailed information of each one. This information is open to the public on its website and we use the dataset on mortgage loans.

First, we made a survey and chose the main banks that operate in the entire country. Then, we tried hard to understand the formula to calculate the first installment of a loan, and the last installment of the first 3 years of that loan (in Argentina we are interested in knowing how inflation will affect our credit obligations).

With the formula in our hands, we translated the calculation into Javascript language, creating a tool that allows the user to choose their own filters (type of house, type of credit) and enter the necessary data (such as salary and age) to be able to offer the result that each bank has for its situation.

After that, we dedicated to the design of the tool. There was a lot of information to show, and it must be understandable.

Impact

The note where the tool is embedded was published on September 17 and since then has accumulated almost one million page views (999,559 to be more specific). 30% of the entries to the note were generated from Google, thanks to the excellent indexation that allowed La Nación to become the first reference of consultation in mortgage loans.
The tool was also embedded in all the articles about mortgage loans in LA NACIÓN, and in other media websites. This allowed to overcome the amount of pageviews reaching a million and a half visits and an average of seven minutes in the tool.
Regarding the commercial aspect of the project, the first banks that participated were three: Supervielle, Santander Río and HSBC. After month and a half of publication the Macro and the ICBC were added.

Sin comentarios

Candichat, an interview to the candidates through WhatsApp

Date of publication

17-10-2017

>>> Live Link <<<

 

Description of the project

This project was conceived to join citizens and candidates to legislator in view of the crucial legislative elections in Argentina in 2017. To achieve an attractive experience for any user, it was designed a platform which simulated a conversation with politicians through WhatsApp -the communication means most widespread among Argentine people. Answers were real and questions had been already made to candidates who privately answered through WhatsApp to a LA NACION journalist. All candidates were made the same questions, and then each user may choose any question to “chat” with his/her candidate. When LA NACION interviewed candidates through WhatsApp, they were specially asked to use all available resources of the communication application: audio, emojis, videos, etc.  Seguir leyendo

Sin comentarios

Legislative Elections 2017: map with live results province by province

A unique and valuable service for the the users to know the legislative election results of each district and province in real time.

In addition to the map with the percentage of votes for each province, the tool offers:

- The option to see the results not only by province, but also by the districts that comonen each of them.

- The name, photograph and political orientation of each of the 4.216 senator and deputies candidates,

- The results they obtained with the absolute value and the percentage of votes.

- The number of votes counted at a given time

- A switcher which allows the user to compare the actual results with the primary ones and a color palette for each political orientation with gradual transparency that allows the user to see the distribution of votes between them.

-  Another switcher to know the results by deputies or senators.

The update of the results in real time was automated and the users could see the date and time of the last modification.

 Live link  

 

Impact

The map was replicated in several news outlets, even our main media group competitor published the app on their TV programs.

The election coverage was trending topic on Twitter, and many of the politicians of the different districts shared the web app on their social media.

It even obtained 1.170.000 pageviews and 40% of the traffic came from Google.

 

How we did it? 

We divided the process in multiple steps.

Firstly, we downloaded and validated the election data given by the government.

Then, we saved it into a database to later process it and created different JSON’s depending on app needs.

We tried to write small process so it is easier to parallelize the work and the runtime process.

In addition, to show the seats that each candidate won, we calculated and programmed the formula taking into account the D’Hont system for the deputies chamber and in the case of the senators it was easy because it is one representing the majority and the other representing the minority.

We used Python and PostgresSQL as the database for processing and saving the official data provided by the government. Also, Javascript and D3.js for rendering the map, and the Amazon services for hosting the backend and frontend.

Sin comentarios

Using DevExtreme, HTML5 and Javascript to connect reusable data visualizations with updated data

Since 2012 Lanacion.com keeps an open data catalog, with updated datasets. Besides, we report stories with open data published in Google Spreadsheets .

Most of these datasets are manually updated and we use Tableau Public to illustrate most of our stories with interactives as we cannot afford to have developers, we have only one.

Since 2013 our dataviz designer learned D3.js and javascript to develop our own visualizations and we detected many reusable ones that could serve as useful context information for many stories.

He selected DeveXtreme: a crossplatform HTML5 / Javascript tool to create responsive web applications for touch enabled devices and traditional desktops.

Examples 1)  Dollar: official and “blue” prices of dollar conversion to pesos, daily updated

 

Example 2) Central Bank stock of dollar reserves (Reservas del Banco Central) , weekly updated  Seguir leyendo

Sin comentarios

Open Data Catalog using Junar Open Data Platform

 

[UPDATED April, 2016] In  March 2012 we launched our “Data Dashboard” or Data Store and we keep updating the  database.

This site hosts the datasets Lanacion.com is opening and is powered by “Junar” an open data platform. We integrated this platform that helps our readers download data, embed datastreams or share them in social media.

The platform has an API so than any user can download all data in a single action.

As a way to ease navigation and serve our users we are offering special catalogs for inflation in Argentina from different sources as this is a very controversial and sensitive information in Argentina.

 

 

We programmed the data flows and procesess to keep this information updated.

Read more here:  Seguir leyendo

Sin comentarios

DATA as context integrated in content TAGS

As a way to enrich stories, Lanacion.com adapted it´s CMS to integrate data as context in our content topical tags. Every news application or data platform we develop must be structured with this in mind so data as context can be distributed in topical or persons tags.

To do this, we first normalize names and then cross them with our TAGS database, and those that are in both datasets are automatically augmented by data or direct urls to our news applications.

For example: in a Legislator´s tag: her Statement of Asset, her path in politics, and even her profile can be presented, together with all the reporting.

Example 1) Person´s TAG: this is Elisa Carrio´s TAG – home page in Lanacion.com

 

This is the link to our Statements of Assets news application – Elisa Carrió statements of assets page

 

 

Elisa Carrio´s Political path from another of our news application “Laberinto Político”  Seguir leyendo

Sin comentarios