Museums of Buenos Aires

Project description

In a context of growing visibility for the latin american art, we decided to create a web app that allows the users to navigate through the permanent collections of the most recognized museums of Buenos Aires. It includes contextual information about the author and the piece of art itself, and a map with the multiple locations of the museums.

It’s an innovative initiative that was launched on the week of the annual “Museum Night” that celebrates the city’s vibrant visual arts scene. It is a night where more than 200 museums open their doors, with free entry and special events for the public. So, we thought that concentrating the most relevant and powerful artworks of Buenos Aires on a single web page, would provide a perfect service for the public to enjoy a more organized and pleasant visit. Also, we offer a map that gives the user the opportunity to create a personalized and viable route to visit the paintings and sculptures they find most interesting.

Innovation

It is not just an art catalogue or a guide, it is a valuable and unique tool that can be fully adapted to the users art interests. All of the artwork included in the app has been chosen and curated by a journalist that specializes in the subject. While the photographs and the information of each of the art pieces and authors were provided by the museums itself. Even though we created the app in the context of the “Museum Night”, it is an enduring service for people to appreciate the artwork of Buenos Aires and to choose which Museum they would like to visit. It is the only art’s app available of Buenos Aires that reunites the permanent collection of more than ten museums. We manage to consolidate various museums in one place. The value of the product for tourist or people who want to visit the museums is huge. In addition, the innovation of this product is also the capability of monetization it has. The Ministry of Culture of Buenos Aires payed us just to insert their logo in the web app because they considered it was a way to promote the art life of our country.

The app had a great impact because various museums called us to include them in the platform, and the ones that were already participating promoted our work on their own social media accounts. All of the magazines of our newsroom group asked us to make a banner of the app for them to include on their pages. Even the Buenos Aires government congratulated and thanked us for the app and told us they would provide the url to the tourists.

Creation

The making process was long and difficult because we had to convince each of the museums to provide us with information and photographs of their permanent collection for free. They would have to share space in the app with other museums for art promotion purposes only. We manage to send them multiple Google Form’s for them to complete. They had to fill one form for each of the art pieces. Also, all of the museums signed an electronic legal document to give us all image copyrights for us to publish and use the photographs with no problem. In total we had 90 responses we had to work with from 10 different museums: MALBA, Colección de Arte Amalia Lacroze Fortabat, Museo de Arte Español Enrique Larreta, Museo de Arte Moderno de Buenos Aires, Museo Isaac Fernández Blanco, Museo Mitre, Museo Nacional de Arte Decorativo, Museo Nacional de Bellas Artes, Museo Sívori.

We worked with the NPR’S Book Concierge open source code and adapt it to La Nacion’s color design and to our project best interests and objectives. Most of the code was written in Python and we used a Google Spreadsheet that worked as a data base. We also added plenty of other utilities that we thought were essential for this type of app. Furthermore, we included a search engine and used MapBox to locate all the museums to create a route for the visitors.

Sin comentarios

One-third of the Congress members don’t have a College Degree

Project description

104 members of the Congress don’t have a college degree. That’s about 31% of all the 329 representatives of the legislative power. There are 17 undergraduate senators and 87 deputies. In other words, at least 2 members of each political orientations found in the Congress have no superior studies after secondary school. Cambiemos, the coalition in power has the highest number of graduates from university, 76% of their congressmen own a degree. On the other end, the left-handed parties and the Sergio Massa alliance, constituited by some of the strongest adversary parties of Mauricio Macri, have the lowest percentage of graduates.

Even though the Constitution does not establish a college degree as a legal requirement to become elected, we decided to state a controversial debate topic regarding the higher education and training of the elected politicians.

Moreover, we also found that 70% of the 130 congresswomen have completed a higher education program which means that they are more qualified than men. In the Senate, these figures are accentuated because the amount of women with a degree is 20 percentage points higher than men. This information had a great impact in Argentina because just two months before The Gender Parity Law was approved and any ballot list for elected office in 2019 must contain equal percentages of male and female candidates. In addition, we investigated the careers chosen by the ones who have a degree and saw that of them are lawyers and 80% studied in public universities.

Our project is different because of the process of translating the gathered and close information of the 329 legislators into a good, open and useful web app service that adds value to the role of civil society in holding government accountable. The platform created allows the user to click on any of the quadrants that symbolize each of the seats of the Senate and the Chamber of Deputies. Each click unfoldes the picture, name, college degree, party, province and social media profile of a Congress member. If you want to have a quick overview of the amounts and percentage of members with a college degree it is possible to filter by chamber, party and public or private institution

Impact

The investigation was replicated in multiple news outlets and TV programs. Also, some of the few congressmen that didn’t answer our phonecalls reached out and asked us to include them in the app. It was the most read article of the day in La Nación. It had 72.732 page views and an average time on page of 6 minutes.

Technology

The web app was developed wih JavaScript and D3JS to generate a graphic with quadrants that represent the amount of seats of the bicameral Congress. Complementary libaries were also used such as Underscore.js and Select2.js. In addition, for the uploading and synchronization of the information we used Google Spreadsheet as a data base. This gave us the chance to do the journalistic production and the programming simultaneously. The tools we used were Node.js with Gulp which allowed us to build automated tasks for the deployment of the app.

Sin comentarios

Mapping Jacarandas

[Under Construction]

 

We used data from the city of Buenos Aires, regarding trees.

In November the city turns into lightblue due to the precious trees named Jacarandas.

We made a data visualisation with Tableau Publlic, mapping each piece.

 

Sin comentarios

2017 Elections map: results in real time

A unique and valuable service for the the users to know the legislative election results of each district and province in real time. It includes the name, photograph and political orientation of each of the 4.216 senator and deputies candidates, and the results they obtained with the absolute value and the percentage of votes. It also shows the amount of polls counted at a certain time and the percentage of participation. It even has 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. The update of the results in real time was automated and the users could see the date and time of the last modification. 

 

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

The search operation of the submarine Ara San Juan

Should we consider this project in Breaking News category? 

This was not a planned news event for which we prepared months/weeks in advance to serve our audience with quick analysis and rich visualizations after an expected major data dump (e.g. elections, olympics, soccer World Cup) or when a periodic nature disaster happens (e.g. California wildfires).

In Argentina, the disappearance of a submarine in time of peace and the occurrence of an hydroacoustic anomaly are unexpected events by definition.

How do we count 36 hs. after a breaking news event happened? Which event is the breaking news?

Different situations happened since the disappearance. 

November 17th, the Navy informed the press about the disappearance of the submarine and the start of a rescue operationSome optimistic hypothesis included communications problems.

November 22nd – 7 pmthe first official indication was unveiled: a “hydroacoustic anomaly”, recorded hours after losing contact with the ship, almost 60 km from the place where the last communication took place on Wednesday the 15th at 7.30 am. The Navy began to map a specific search area and ordered the transfer of vessels and aircraft to that area.

And that is the  day were we start counting the breaking news data. Optimistic hypothesis vanished and the tragedy option gained credibility.

That day, the entire fleet of the argentine Navy and the international ships organized under the same operation.

From very early that November 22, LA NACION DATA started following the route of those vessels and their search without specific direction. Until 7 pm.

What happened? When the Navy announced the hydroacoustic anomaly, we were ready to inform about the first boats that approached the new search area. From 7 pm until midnight we were able to show the raking that each ship made, within the search polygon marked by the Navy.

The result: we provided videos with the route of the boats to embed in all the notes that informed about the search a couple of hours after the navy Press conference; and a map we published on November 23rd print edition.

So, LA NACION DATA had the exact location of each search vessel in real time. 

ONLINE ARTICLE published November 23rd, 12.17 am (midnight after Nov. 22nd): 

>> Submarine ARA San Juan: a video of the route of the boats that are looking for in the area (includes exclusive video capture embeded below)

 

The search for the submarine was in a terrain unknown to all: the sea. That’s why we needed precise data about the location of the boats and the route each one made to rake as much as possible. And let what happened at sea, not just be there but on the screen of each reader.

The relatives of the crew joined in the hope of more news about the submarine ARA San Juan

 

In LA NACION DATA we accessed the data to geolocate the ships that approached the search point with satellite update, and managed to visualize the route of the vassels and tankers arriving from Chile, Brazil, Africa, Antarctica and the coast of Argentina.

This same day we made captures on the position of the ships to deliver visual and context material for the extensive coverage that took place this day. We also worked with the infographic team on a huge visualization that was going to be published next day.

 

PRINT EDITION published during midnight Nov. 22nd and delivered to general public on November 23rd morning, within hours after the hydroacoustic anomaly was announced.

 


How we did it? 

At the moment in which the navy informed the participating vessels of the search operation, one of our team members reacted suggesting Marine Traffic as a real time data tool. This is for breaking news using data!

She has assisted to the School of Data workshop “Investigating crime and corruption” in the International Journalism Festival in Perugia 2014 and remembered it. The workshop’s video is in this link

We used the Marine Traffic database and set up a fleet with the vessels we knew (by official information from the Navy) that were approaching the search site.

 

We could have worked through an API, but the breaking news hurried us and we decided to use other resources: video captures and static infographics.

 

Impact

We were the only ones who accessed the route of each ship during the search.

With the satellite update in real time we were able to report on the status of ships, such as the Sophie Siem (who had a rescue mini-submarine), that had to return to land to stock up. They were times of great uncertainty and every movement that made a boat was relevant.

 

 

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

District election results: news automatization

In this opportunity we will explain one of the projects that has most prided us this year: the automation of news. In this case applied to more than 500 notes so that each province and district, all over the country, could access to the results of the legislative elections 2017 on a map especially for their region.

We created a template that was reproduced in the 500 notes including map and personalized text. We show an example.

**

 

All the notes were placed a tag called: “Result by district”.
In the next video you will see all the notes accumulated under this tag, and so you will see what this project was about

Sin comentarios

2017 Legislative Elections Package

The event of the year was the Legislative Elections. Two years after the presidential elections and two years before the next ones. A key time to take the political temperature, measure the strength that each party has in every corner of the country.

That is why we think of a wide visual production to cover all the details of this event.

For the previous months we made:

- Candidates for legislators: what aspects they have in common

Live link

 

This interactive visualization allows to know in a different way the candidates of the two most important districts of the country: City of Buenos Aires and Province of Buenos Aires.
Through the filters placed to the left of the visualization, the user can choose the criteria to order and see how the candidates are similar to each other.

The filters are:

- Those with less than 35 years of age
- Those who seek to reach the Congress for the first time
- Those who have a university degree
- Those who got K officials
- Those with profile outside politics
- Those who were prosecuted by Justice

 

- 2017 Elections: met the confirmed ones to compete in the primary

Live link

This development showed day by day how the board of candidatures of the first places in the lists was completed.

Only applied for candidates from the City of Buenos Aires and the Province of Buenos Aires

The visualization is crossed by a main line. Below the possible candidates and above confirmed. As they accepted the candidacy we placed the faces on top.

 

- Primary: 44% of candidates are women, but only 30% tops the lists

Live link

 

LA NACION was the only news site to have a complete list of all the candidates. We took this opportunity to talk about gender parity.
In Argentina we have a law that says  the lists must have at least 30% of women on the list.
It was interesting to see the place that women are given in each party, and also segmented by province.

 

- 2017 Elections: met all the candidates, according to your district

Live link

 

 
- Candichat: chat with the candidates

-

 

- 2017 Elections: where the main political forces won and where they lost votes

 

 

- 2017 Elections: live map province by province

- 2017 Elections: see who enters and who does not enter the Congress

 

 

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