La Nación Data on live TV

This year we embraced the new tv channel of La Nación to expand our audience reach. We pushed the limits by making cross-platform reporting: print, digital (desktop, tablet and mobile) and broadcast tv coverages.

Members of La Nación’s Data team exposed the data driven stories on La Nación Más, a cable and satellite tv channel that was launched in november of 2016. Our tv segments included visualizations and infographics that were presented on a full HD display with touch control.

Some of our best results:

-Nisman app: After two years of listening, analysing and classifying, and the participation of more than 120 volunteers, we created an app that contains detailed information about the people involved in the former prosecutor Nisman’s accusation including their biographies, topics of conversation and timestamps of the most important parts inside the conversations.

 

-The use of data for simulation. Interactive government credit, PROCEAR simulator

 

-Keys for understanding Trump’s immigrant ban. Figures explaining the number of refugees living in United Stated, their nationalities, religious beliefs, and the countries affected by the policy.  Seguir leyendo

Sin comentarios

The nationalization of gasoline in Argentina, reported from 3.8 million rows of data

>> Please, first take a look at the published version in Spanish. <<

How was the story of the nationalization of gasoline is the result of a research project of La Nación Data together with the Forum of Argentine Journalism (FOPEA) and the Association for Civil Rights (ADC). With a scrollytelling format we tried to explain how the suppliers were nationalized and what happened to the price when Argentina decoupled from the international price of oil. We reviewed which are the great players of this market and the difference that has the fuel according to where it is bought.

<We made a video to explain the composition of the price with test tubes>

The project is based mainly on the analysis of the prices and sales volumes of gasoline for the entire national territory, as reported by service stations in accordance with Resolution 1104. The database is located on the website of the Ministry of Energy and exceeds the 3,800,000 registered data. Only the data for liquid, gasoline and diesel fuels were worked on for a period of time starting in December 2004 and ending, in this edition, in September 2016.

Thanks to the support of the United States Embassy and the Austral University, and the integrated work between journalists, data miners and designers, we achieved a high level of analytical work with attractive visual resources.  Seguir leyendo

Sin comentarios

Calculators and simulators

Technology allows us to present information in more attractive formats, which give the audience the possibility to experienced how news impact on their own reality. The information can become palpable. Face to changes in public services rates, or new state subsidy programs, readers can estimate how current events can affect their lives. For example, the increase of the cost of electric energy can not only be read, but also estimated at the scale of the reader’s own economy.   CALCULATOR FOR ELECTRICITY PRICE

The 2017 edition is the tool that LA NACION has developed to allow neighbors of Autonomous City of Buenos Aires and the metropolitan area to estimate the monthly amount of their consumption. 

Since the beginning of 2016 the updating of rates has been a topic of political and media agenda in Argentina. Why? Because after 10 years of price freeze, the new rates surprised everyone. And knowing how to calculate the new invoice is not easy for everyone. For this we create the calculator.

Fuente: Diario La Veloz

In Argentina there are two different rates for energy. The general and the social rate, whose beneficiaries are retirees, holders of social plans, disabled, unemployed, among others.

In addition with the new government policy of rewarding those who save energy, we offer in our calculator the three possibilities of amounts according to savings achieved by comparing the consumption with the one of the same month of the 2015.

It is a very easy tool to use. With entering the kilowatt hours usually consumed by the user, and pointing out the resident place and the type of rate, the calculator does the rest by applying the prices published in the Official Gazette by the Ministry of Energy. Behind the tool there is a big dataset with the amounts of each category of consumer and type of rate.

Technologies used: HTML5, CSS3, JQUERY, HAMMER.JS

CREDIT SIMULATORS

With the new edition of mortgage credits subsidized by the State, the PROCREAR credits, we developed a simulator where readers can check if they meet the conditions to win the loan, and can simulate the amount of a first fee.   Seguir leyendo

Sin comentarios

Argentina in the world, the ranking platform

The platform “Argentina in the world” is an application that allows monitoring the behavior of our country with respect to the others. Rankings are ranked by subject and can be embedded in notes responsively.

The various topics can be easily filtered in: Economy, Sports, Education and Society. The platform is relatively new, new themes will open soon.

All rankigns include link to the source, a section with the methodology, the date of last update, and the possibility of downloading the data.

When navigating within each ranking, the user can select up to two countries to compare them through a visual color effect. The addedvalue of this interactive element is the ability to display historical data. 

HOW WE DO IT

This application was created to generate upgradeable and reusable rankings. And the storage of all information is done using google spreadsheets. Each ranking has its own dataset, and each one is part of a general index that also lives in a Google spreadsheet.

Sin comentarios

Data journalism for sports news

Besides the reports on economics, politics and society; data journalism can also provide interesting information for sports news.

To compare the goals of two great argentinian soccer players, throughout history, and to classify them by type of tournament and movement that provoked the goal; is something that takes time of production but that is not impossible. For that we are the journalists, to process information and to offer an added value when facing news.

Coverage of the America 2016 Cup

Here we share the special that we realized on the soccer career of Leonel Messi, compared to the trajectory of Gabriel Batistuta, Diego Maradona, Hernán Crespo and Sergio Aguero. 

 

After each match, football fans often comment on what each player’s performance looked like. But would not we draw more objective conclusions if we could analyze passes and movements between players more accurately? That’s where we needed data, and we went for it!

 

Rugby injuries

Rugby injuriesNot everything is football in Argentina, we are also fan of rugby. That’s why we developed an interactive special where you can learn more about the common injuries suffered by the players of this sport.

Sin comentarios

A special event for Open Data

In June 2016 we held the  Datafest 4th edition, an event of opening, mining and visualization of public data destined to journalists, communicators, data miners, designers, programmers and specialists from different areas.


The agenda of the meeting included exhibitions of international referents of data journalism, workshops, open seminars and panels on Open Government issues at national, provincial and citizen level.  Seguir leyendo

Sin comentarios

Free public bikes are used 4 times more on weekdays that weekends

Once again we discover stories in large datasets, in this case, the new public bike system implemented by the City of Buenos Aires since 2010 has produced and now opened a dataset that lets us know the citizens behaviour, the evolution of user´s demand and if this service is valuable, well dimensioned, and useful for them. 

Between 2010 and 2017, the day of the week with more demand  was wednesday, the month were october and november, and  the time range was between 17 and 18 hs. 

The Bikes special was made with open data  from the City of Buenos Aires portal:

Because of the great amount of data, more than 4MM rows, we had to upload them to a SQL database server , filter and group them there and export them in a simpler way to excel for further analysis.

Examples of some of our SQL instructions:

Seguir leyendo

Sin comentarios

Monitoring electricity in a country facing severe energy crisis

Background

Argentina faces an energy crisis, a result of the politics played in the last 10 or 12 years; the Government kept frozen prices for users, but those prices were subsidized by the State.

On this regard, distribution companies did not make the necessary investments to replace obsolete facilities or accompany urban changes: family residence neighborhoods turned into apartment building neighborhoods where 30 or more families reside, many of them replaced the use of natural gas by electricity. Also, there is a constant sale of cold/heat air conditioning equipment.

In the last few years there was an increase in the number and length of electricity cut offs in different cities, these cut offs lasted few hours to several days, even weeks, precisely in peak electricity demand periods which coincides with more severe moments of Summer and Winter.

The ENRE (Regulatory Energy Agency) uploads and updates every 30 minutes a detailed progress of those affected areas for EDENOR and EDESUR users.  Seguir leyendo

Sin comentarios

Tracking the monetary base in pesos 2003-2017, and how this speaks about inflation

Proving inflation when there are no official stats has been very hard during the last 6 years in Argentina. One of the problems we had was that as inflation increased but was not recognized in official stats, more and more pesos bills were printed, and the highest amount was the bill of 100 pesos. So the ATMs were stuffed with those bills and lots of them came out of service again and again. The argument of the former government was that as there was no inflation there was no need to increase the amount of the pesos bills.

There was another problem, the corruption case in which the former vice president Amado Boudou was suspected to influence the sell of the bill´s printing press Ciccone Calcográfica to a company run by his supposed figurehead.

 

So how could we measure and monitor this?

The Central Bank communicates the quantity of bills that conform the monetary base in Argentina in pesos. This communications are bi weekly and in PDF, so as we detected them , we scraped all these communications, called “circulars”, and built a dataset.

 

To build this dataset first we have to OCR the PDF and then add the new rows to the dataset in XLS.

 The dataset is based in quantity of bills in pesos per each amount with basic analysis  Seguir leyendo

Sin comentarios