research question

Which cartels are involved in avocado traffic in Mexico?

Jalisco Jalisco Nueva Generación Cartel(CJNG) Nayarit Jalisco Nueva Generación Cartel(CJNG) Google search results State City ‘aguacate AND ‘place name’ Michoacán Baja California / Mexicali Jalisco Nueva Generación Cartel(CJNG) * SAGARPA Agricoltural Statistics 2017 Jalisco Nueva Generación Cartel(CJNG) Colima Michoacan / Los Reyes Jalisco Nueva Generación Cartel(CJNG) Michoacan / Peribán Jalisco Nueva Generación Cartel(CJNG) Michoacan / Tancítaro Los Cuinis 87 83 85 65 86 84 87 88 69 67 56 20 67 Jalisco Nueva Generación La Familia Michoacana La Tercera Hermandad Los Caballeros Templarios Los Cuinis Avocado productionvolume (ton) by state in 2017 * 0100,0001,2 mln1,6 mln Michoacan/ Uruapan Jalisco Nueva Generación Cartel(CJNG)
Description Protocol Data


This visualization’s purpose is showing which cartels are in the Mexican territory scene; our a particular perspective is related to how much they are set in the territory considering the avocado production in each Mexican state. In fact, in the previous visualization 1 and 2, it emerged the link between avocado trade and organized crime, something we wanted to go deep in. The graph above is a map of Mexico, where each state’s color is related to how much avocado is produced there. The presence of criminal activities related to avocado in a certain city or region is highlighted with circles, representing how much a cartel appears on Google results if searched in a query containing the same city. The map’s outcome is the high presence of cartels in Michoacàn related to the avocado production; the state is the most productive one in Mexico. CJNG cartel (Jalisco Nueva Generaciòn Cartel) appears to be the more connected one to the illegal avocado trade market.


example of protocol

We used Google set in Incognito mode to search for “avocado AND cartels” setting Mexico as a geographic area. Instant Data Scraper has been used to select the first 100 results from which we manually extract the cartel’s name, and the places were mentioned together. To show how much a cartel was linked to the territory, we listed more results, searched keeping the same settings: “name of the cartel AND state name” and “name of the cartel AND city name.” Considering the total amount of Google pages, we used the circles to display how much the cartel was present in that territory. Finally, we used data collected from the Mexican government dataset “Estatistica de producciòn Agricola” (2017) to compare the effective presence of the cartel in that location related to the avocado production.


Data Source:
Google News Instant Data Scraper RAWgraphs SAGARPA Agricoltural Statistics 2017
Timestamp: 19/10/2018
View Dataset

The dataset has been created setting the following information: name of the cartels related to avocado that emerged scraping the first 100 results from Google, followed by geographical area of action. To this has been added the result of the query set to identify how many times the cartel has been mentioned along with the state name in Google.