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

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

How do we make information on salaries and retirement pensions of ex-officers available?

Date of publication

23/4/2017

Link to article

https://www.lanacion.com.ar/2015545-las-pensiones-de-los-ex-presidentes-un-beneficio-con-algunas-disparidades

Other links related

https://www.lanacion.com.ar/2078653-zaffaroni-el-ex-ministro-de-la-corte-suprema-con-la-pension-mas-alta

Description of your project

LA NACION Data team explores every day about government databases and great volumes of public documents apparently “lost” on the Argentine legislation. This work allows to find not only new sources of information but also data which become important sources for news stories that have never been told.  Seguir leyendo

Sin comentarios

Life insurance of the crew members of the ARA San Juan

 

Date of publication

7/3/2018

>>> Live Link <<<

Description of the project

After the disappearance of the ARA San Juan, we began researching at LA NACION the purchases made by the Argentine Navy for the maintenance of the submarine. Without any specific hypothesis as a starting point, we cared about understanding the general context of the disappearance of the ARA San Juan. As we went deeper on this matter, we researched on the SAR (Search and Rescue) Operation and the help provided by other countries.

However, we asked ourselves what part of the whole system we were not aware of, what elements we did not consider. So, we decided to request access to information in order to know about the life insurance of the crew members. The request was made on December 6, 2017 to the Ministry of Defense. Said request included a large number of questions. The Ministry began providing the answers at longer intervals as the internal institutions provided the documents.  Seguir leyendo

Sin comentarios

LA NACION (Argentina): Open Data Journalism for change

Meet the team!

Open Data Journalism for Change

Since 2011 when LA NACION Data was launched as an open data journalism initiative, its strategy has been the same: to do data journalism AND to open data.

The vision we have is that each set of data that is published means that more knowledge is released.

The first step to make datasets famous is to become open data USERS. And if there is no open data, no problem, we need to become PRODUCERS and transform from closed formats to open data. We have to find and convert public information, so we file FOIA requests, we use more than 8 OCR engines combined with processes that automatize the feed from that closed PDF to a database adding rows in a database per month or daily, and we even type from handwritten data files. 

We also host civic marathons for opening data. Beside publishing products and services, we attended every launch of a data portal hosted by government ministries or secretaries (Open Argentina ConfScience & Technology, Justice, Agroindustry, ACUMARPrisons, province of Buenos Aires, city of Bahía Blanca, city of Pilar), NGO (Education Project) or Universities Data Lab (Di Tellaand report about it in our blog.  Seguir leyendo

Sin comentarios

Ranking of absence in Congress: which are the political party factions with more absences

>>> LIVE LINK <<<

Description 

As part of the Legislative Elections in 2017, an analysis of absences was made among representatives from the last renewal of seats in December 2015 to September last year. The number of absences in the Lower House at the moment of voting was analyzed and it was further detailed according to each political party and the Province that elected them. Finally, it was made a list with the names of the representatives with more absences and those representatives who were never absent.

Many of the members wanted to be reelected so the purpose of this article was to show the percentage of representatives who are present to cast their vote.

 

What makes this project innovative?  Seguir leyendo

Sin comentarios

LA NACION DATA TEAM (ARGENTINA)

Project Description

Since 2011 LN Data has been a strategy, a content initiative and a team whose goals are to facilitate open data journalism in LA NACION and impact for change in Argentina.

Our team has been formed by the same initial three members, Ricardo, data engineer for investigative reporting in LN Data, Flor, research and training in digital media trends and open data and Momi Peralta. We grew from there year after year. Today we are 10, including  data miner Gaby, data producer Romina, two back and front end developers Nico and Cristian, a librarian and archivist Gabriela and two journalists with data and scripting skills Carolina and Bianca 2017.

But the truth is that  we are never just 10 because our strategy is not to be a special centralized investigative unit, but a platform for all our newsroom to facilitate data, innovation, technology and skills for data journalism crossing all platforms and sections including LA NACION in its Tv channel.

Seguir leyendo

Sin comentarios

Energy cutoffs II – ENRE (National Electricity Regulatory Entity) :: Technical Details

Energy cutoffs – ENRE (National Electricity Regulatory Entity)

Software is executed every hour and collects data from different sources, then it updates them on a file in an OneDrive folder which is shared by anyone who needs to access said information.

To guarantee its operation, at least during the experimental stage, the software is executed in several computers at the same time, running every 5 minutes; it verifies if the file takes more than 60 minutes without being updated and if the hour advanced on its first 15 minutes, to ensure that all pages updated the time information.

If any of the computers stops working, or, if there is any problem with data collection, another computer will go on operating. All operations, whether successful or unsuccessful, are entered on a DEBUG file for their analysis and software restructuring.

The data reviewed are:

1)      Temperature informed by the Servicio Meteorológico Nacional (National Meteorology Service) (SMN)

http://www.smn.gov.ar/

2)      SADI energy demand (Sistema Argentino de Interconexión – Argentine Interconnection Service) provided by CAMMESA.  Seguir leyendo

Sin comentarios

Letters to the Presidents

 How this project began

At La Nación Data we are always aware of those areas of government which produce public interest information and, however, are not well known.

If we look at the flow chart of the Government Administration, we found that there was an area named Dirección de Documentación Presidencial (Presidential Document Department). We searched for its creation regulation to see the responsibilities and we found that said department was in charge of receiving all the letters, mails and oral requests addressed to the President of the Nation.

Said department has not any website to show statistics or any information regarding their functions. That is why, we prepared a request for access to public information to access the material concerned: the letters to the President.

Request for access to information

This request took the teamwork of LA NACIÓN Data almost one week, since letters include personal data and we had to be careful enough to avoid the release of such type of information and focus, instead, on the content of the document sent to said department.  Seguir leyendo

Sin comentarios