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

WiDS Buenos Aires

 

As a way to reach the community and focus our strategy vision we partnered with Stanford University, as a local host for Women in Data Science (WiDS) Conference.

The Global Women in Data Science (WiDS) Conference aims to inspire and educate data scientists worldwide, regardless of gender, and support women in the field.

LA NACION & the Engineering Faculty at Universidad de Buenos Aires hosted the 2nd edition in Argentina.

https://www.widsbuenosaires.org 

>>> Videos and Presentations <<<

The event presented more than 20 female speakers and + 300 participants throughout the day.

 

 

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

Where and Why energy cuts off in Buenos Aires

Date of publication

12/3/2018

>>> Live Link <<<

https://www.lanacion.com.ar/2115529-donde-y-por-que-se-corta-la-luz

Other links

https://www.lanacion.com.ar/2116113-por-cortes-en-2017-edenor-y-edesur-devuelven-a-los-usuarios-casi-200-millones

Description of the project

Argentina has an energy crisis mainly related to a frozen fee scheme maintained for about 10 years of the Kirchner administration and an electricity generation and distribution lack of investment.

This project was based on data collection with time schedule on a daily basis, from 4 websites with the purpose of determining if it is correct the perception of any relationship between energy cutoffs of electricity distribution companies (Edenor and Edesur) and extreme temperatures.

Said Project also determines which ones are the districts more affected by the cutoffs, if said cutoffs are worse or better and it also arrives at any other conclusions related to electrical energy, including the sources of generation.

The production for the article about energy cutoffs on the metropolitan area of Buenos Aires consisted of two articles published at the same time: one of them was printed and published on the front page as regards a discount given by service providers (Edenor and Edesur) to people affected by the energy cutoff from March to August 2017 and another article published on the homepage of the website about districts in Buenos Aires and greater Buenos Aires that were more affected between January 2017 and January 2018, said articles focused on the causes for this problem.

The database compiled with daily scraping 4 websites was published as a table with open data to download

Seguir leyendo

Sin comentarios

Chronology of a violent day: the most dramatic hours

Date of publication

18-12-2017

>>> Live  Link <<<

Description of the project

It was a minute-by-minute coverage of the events occurred the day of the legislative debate of the pension system reform at the House of Representatives at the City of Buenos Aires. Several social organizations made protestation in different areas of the city to show disagreement about the bill submitted by the Executive Power.

A few minutes before constituting quorum for the transaction of business, it began a violent confrontation between demonstrators and the police which resulted in a historical day of violence: there was commotion in the streets of Buenos Aires with wounded people, persons under arrest and damages.

What makes this project innovative?

Although many news articles have been written on this regard, the order of information established for this article was useful for people to have a better comprehension of events and an order of the events in the middle of an information chaos. The use of infographies, photographs and videos were useful to show the audience a more correct dimension of the most important event of the last few weeks of the year.  Seguir leyendo

Sin comentarios

Malvinas

Project Description

In 1982, the civilian military regime that ruled Argentina at that time sent conscripted soldiers who were not even 20 years old to fight in Malvinas against the British Army. Many of them died at the island and other 121 soldiers were buried in unnamed tombs and with heartbreaking words on it: Argentine soldier only known by God. Thanks to an ex combatant and to scientific work done in 2017, the Argentine state began to compensate said debt by identifying the tombs and notifying the families who finally knew where the soldier rested in peace.

Our production team wanted to pay tribute to those forgotten soldiers: we designed a big interactive infography that places the image of each soldier on his respective tomb, then we made contact with their families to know how their soldier was and how they, as family, lived all this time. By going through the structure of the interactive infography of the cemetery, the information of each soldier is displayed allowing thus each user to navigate the information structure.   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

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

2017 Elections: who enters and who is left out of the new Congress?

This interactive display shows the conformation of the Chambers of Deputies and Senators in real time during the night of the legislative elections of 2017.

Not only allows to see how the chamber of the cameras will be composed, readers can find which candidates enter and which do not for each province.

LA NACION was the only news website that had the candidates lists from all over the country, obtained after opening all the pdfs published by the National Electoral Chamber.

We wanted this project to be really federal, so we included the photo of all the candidates all over the country, so our readers could identify their local people.

Another important fact is that we were the only ones to show live, during the night of the Elections, the name and surname of the candidates who obtained a seat. 

>>> Live link 

Several news channels published our production that night and the day after.

The visualization was inserted in a note that got almost 700,000 pageviews and an average stay in note of more than almost 3 minutes.

We also replicate all the information in our print edition with a wide display in two complete sheets.

 

How we did it? 

The first was to build a large database with the candidates for deputies and senators for each province and each party. We did this by opening hundreds of pdf files published by the National Electoral Chamber.

Then we designed a visualization where the banks imitate the positions within the Congress, for print and online edition.

The interactive one includes several features such as:
- Compare with the current Congress
- Compare with the primary elections
- Filter by province to know the candidates who obtained a bank

We used: D3, jquery, python.

 

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