Tag: r | Atom Feed

Myths about Ciudad Juarez

Last year there were over 2,600 murders in Ciudad Juarez, and if the more than 1,800 murders so far this year are any indications, there will be even more murders in 2010. Ciudad Juarez is a scary place, but it wasn’t always that way…

I learned from Noel Maurer’s Blog that Ciudad Juarez used to have a low murder rate before 1993, but it rose steeply after the local leader of the Juarez Cartel, Aguilar Guajardo, died, and Amado Carillo replaced him. After Amado Carrillo had firmly established himself thing calmed down somewhat, but by then the violence had switched to a new equilibrium. But anyways, go read Noel Maurer’s take on it


    Hacking the CISEN homicide data

    The director of the CISEN, the Mexican agency in charge of generating intelligence to safeguard Mexico’s security, said in a presentation yesterday that the number of homicides linked to the drug war was a little over 28,000 since the start of the Calderon administration.

    Guillermo Valdés didn’t provide the raw data so I used Engauge to digitize the slide with the homicide data from the presentation:



    Mystery solved: The discrepancy in homicide data

    I’ve been complaining about how homicide statistics from police sources were too low in 2009, with the entire state of Chihuahua having less homicides than its biggest city. I was thinking of finding out if I could use the IFAI (Freedom of Information Access) to obtain the original CIEISP forms which the state police forces are supposed to fill out each month and send to the National System of Public Security (SNSP) for tallying, to see if there were any unusual patterns, but someone beat me to requesting the data.

    You can see the request here, and download the excel file with the CIEISP forms here.

    The main difference between the datasets is that the CIEISP forms usually report lower numbers than the data the SNSP gave to the ICESI. This is not surprising since the CIEISP forms have no recorded homicides in some states during the last months of the year (the request was made in December 2009), but the numbers for Chihuahua in both datasets are identical, with a total of 2523 homicides recorded. More importantly, in the months of November and December there were no homicides registered in the CIEISP forms, and the data for October looks incomplete. That’s the reason Chihuahua had such a low homicide rate according to the police, the data they gave to the ICESI only includes 9¾ months of homicides.


    Homicide in North America


    I’m surprised by how similar the trends are (excluding the drug war in Mexico). There were big decreases in the homicide rate in all three countries starting in the early nineties, which then slowed down around 2000.


    The most violent municipalities in Mexico (2008)

    • The top six most violent municipalities are near the US border. Ciudad Juárez is in a class by itself with 113 homicides per 100,000 people.
    • José Azueta is the municipality where Zihuatanejo is located. Mazátlan, another popular tourist destination, also appears on the list. 
    • Lázaro Cárdenas is the largest ...

    The police records for 2009 are out.

    The 2009 homicide numbers collected by the SNSP (National System of Public Security) are finally out, you can download the data from the ICESI, which is a civic institution not affiliated with the government.

    If you remember, one of the conclusions from my statistical analysis of the drug war was that:

    The police records in 2008 are missing more than a thousand homicides in Chihuahua! Just to give you some perspective, in Ciudad Juarez, Chihuahua’s biggest city, there were more than 1,600 homicides, more than the 1,414 reported in the whole state according to police records. I strongly recommend against using data obtained from the police records from the SNSP or the UN homicide statistics if you need the latest homicide numbers.
    In the latest incarnation of the data, the number of homicides in Chihuahua in 2008 were updated to 2,030 and now resemble the numbers from the Statistical Yearbooks; however, you can still download the data as it appeared in 2008 from the ICESI. At least the SNSP realized that the 2008 numbers were ridiculously low. But what about 2009, well…

    I can’t compare the police records to the vital statistics since they won’t be out until November or December, but I can compare them to press reports.

    In Ciudad Juarez there were 2,642 homicides during 2009, but according to the police data, in the whole state of Chihuahua there were 2,523 homicides, sigh… history repeats itself.
    For the whole of Mexico there were 15,255 homicides, which if the number is to believed would correspond to a homicide rate of 14.2. I obviously don’t trust the data and stand by my assertion that the homicide rate according to the vital statistics from the INEGI will be closer to my prediction of 15.5 than 14.2.

    This is getting to be completely ridiculous. The code to generate the chart is after the jump.


    Statistical Analysis and Visualization of the Drug War in Mexico

    On December 11, 2006 Felipe Calderon, as the first significant act of his presidency, sent the army to his home state of Michoacan. He claimed that it was to regain control of territories lost to the drug cartels, and indeed, a new cartel had started operating in Michocan. But the fact that he won the election by the slim margin of 0.6% and his main rival declared himself the legitimate president of Mexico surely influenced him.

    In the beginning, the war proved a success by all objective measures: in 2007 the homicide rate decreased to its lowest level in recorded history and murders in Michoacan went down by more than 40%. Not that it mattered much, all the while the government was losing the psychological war—the use of torture and beheadings became common in executions carried out by drug cartels as they sought to protect their turfs and intimidate the population.

    And then 2008 rolled around and the Sinaloa Cartel decided to take advantage of the weakening of the other cartels and the corruption that is endemic in Mexico to gain control of the drug trade…

    Sources: Homicide data from INEGI, population data from CONAPO.
    2009 estimate based on execution rates


    Cluster analysis of what the world eats


    Weird dietary habits in the US

    Using this database of food consumption data the blog Canibais e Reis kindly put together, I calculated all values for which the US was at least 2 standard deviations from the world average.

    Here are the outliers in standard deviations from the world mean:

    Poultry.Meat..kcal.day…2003 2 ...



    Mexico’s Economy

    Yesterday the INEGI released the GDP figures for 2009, and since it was an annus horribilis for Mexico, I thought I’d put up a couple of charts. Looking through the Banco de Información Económica I found two series of historical seasonally adjusted GDP data available:
    1. GDP in 1993 pesos ...

    Unless otherwise stated, the content of this page is licensed under the Creative Commons Attribution 3.0 License, and code samples are licensed under the Apache 2.0 License. Privacy policy

    Disclaimer: This website is not affiliated with any of the organizations or institutions to which Diego Valle-Jones belongs. All opinions are my own.

    Special Projects:

    Blogs I like: