Description
The visualization is designed to show in detail the most controversial aspects related to avocado trade, analyzing a more specific query compared to the first one. From the first Google search, some problems emerged, even though not on the surface. Consequentially, with this second investigation, we tried to identify this concerns better, still not forcing the results into having more specific useful content. We searched for aguacate+traffic and avocado+trade on Google with the main intent of comparing them. Thanks to this query, we were able to find more controversial elements related to the avocado trade. Twenty-eight results on criminal events are present, including organized crime, murders and thefts derived from the high value of this product. Environmental issues are present in the results; in particular, an interesting reference was found in fair trade cooperative websites, companies that mainly promote a more sustainable farming and equal conditions for producers. Being able to find them in the USA query results is interesting; the reason might be that in the States it is already possible to find some kind of awareness towards intensive farming.
On the left side, the graph shows Mexico and USA as cores from which links are connected to their queries; they are connected to a sub-categorization that belongs to the categories previously identified for visualization 1. To make these categories more solid, we paired them with some extracts from the articles we considered for visualization 2.
Protocol
For this protocol we started from a more specific query, the aim being to let the issues emerge; we preferred not to use targeted words, to not influence the results. For this reason, we searched for “aguacate+trafico” and “avocado trade” in Google Mexico and USA. We used Instant Data Scraper to fasten the process and harvest the data; they have been listed in the ranking with their links. For both queries, the first 50 results have been sorted in the categories we identified in protocol 1; though we did a further categorization to better highlight the content, they talked about. The “Other” category includes websites related to avocado varieties, healthy benefits of avocado, recipes, general information about avocados. The choice to aggregate them is due to their low number in results.
Data
Data Source:
Google advanced Instant Data Scraper
Timestamp: 19/10/2018
View Dataset
Using Instant Data Scraper, we collected the information necessary by listing the first 50 Google results both for Mexico and USA. This dataset is set up by rank, title and link of each website, finally categorizing their content.