research question

How did avocado cartels activities develop during time ?

2009 2010 2011 2012 2013 2014 2015 2016 2017 1960 1980 2000 2008 CJNGJalisco Nueva Generación Cartel Sinaloa cartel Guadalajara Juarez cartel Arellano Felix Brothers Tijuana Milenio La Familia Michoacan Los CaballerosTemplarios La TerceraHermandad Los Cuinis 0 50 100 0 50 100 Year of foundation Splitting Google search resultsfor the relation of criminal cartels to avocado trade 1,823,721 9,239,610 2,756,237 2,735,121 3,545,921 120,034,107 62,301,402 39,154,147 3,209,061 744,519 5,778,692 3,562,933 8,895,064 9,474,046 11,248,290 30,886,030 9,474,046 5,292,873 3,859,231 10,502,496 6,868,707 20,154,969 106,622,589 12,665,508 8,503,120 139,996,849 12,165,792 6,562,009 15,600,556 18,068,374 13,096,460 7,814,358 2009 2010 2011 2012 2013 2014 2015 2016 2017 1960 1980 2000 2008
Description Protocol Data

Description

The visualization is focused on the development and the relations between Mexican avocado cartels during the years, and the relevance of every cartel to avocado, based on a Google research, is defined. The central element is a timeline divided in two main parts: the lines represent each cartel evolution, and the colored areas are proportioned to show the link of every cartel to the avocado. In particular, it is possible to note that the most recent cartels, the CJNG and Los Caballeros Templarios, are the most mentioned ones for the illegal avocado trade. Details of their development are also reported.

Protocol

example of protocol

We used the data from the previous protocol to identify which criminal cartels trade avocado in Mexico. In order to know more about the cartel, we relied to InsightCrime, a website that investigates and analyzes organized crime in Latin America and Caribbean. Inside the website we searched for all the cartels name emerged from protocol 5 (query:”cartel name”) and looked at the years in which that cartel developed, along with eventual mentions of other cartels, defining and setting the information in a timeline. A further research, done by setting “aguacate+name of the cartel” allowed us to find out how many times every cartel was mentioned along with avocado by Google results. To achieve this, we considered the total amount of results indicated by Google; we designed each area in a proportional way, sizing them as wider as many results we had for the cartel.

Data

Data Source:
InSightCrime Google advanced RAWgraphs
Timestamp: 19/10/2018
View Dataset

The dataset is an enriched version of the previous one. It contains a list of the mexican criminal cartels, each one paired with the most important dates in their development. In the third column, the cartels’ relevance to avocado trade is reported: it represents the number of times the cartel is mentioned along with avocado in the news for each year.