Analysis of the UNAM's entrance exam

on Apr 7, 2014
The UNAM is Mexico's biggest and most important university. To enter it students must either take an exam or graduate from a high school run by the UNAM in less than 4 years with a grade point average of at least 70% (although some majors like medicine require 90% for pase directo). The admission exam is given twice a year, in February and June, and any student from any high school with at least a grade point average of 70% can take it. If the student meets the requirements for entering the UNAM, passing the exam guarantees him admission. The exam has 120 questions.

Interactive map of the drug war in Mexico - 2012

on Jan 7, 2014

It's that time of the year again when I update the interactive map of the drug war in Mexico. The map now uses 30 day months to calculate homicide rates and the new CONAPO population estimates. As usual there is also a Spanish version. All deaths registered without a date of occurrence were assumed to have occurred in the same month they were registered and all deaths without a municipio of occurrence were assumed to have taken place where they were registered. Various events are worth checking out:

Changes in homicide rates

on Dec 18, 2013
More examples of using the mxmortalitydb package! Changes and trends in homicide rates in the most violent metro areas or big municipios. There was a big increase in violence in Nuevo Laredo. For comparison the homicide rate in Chicago (metro area) was 8.2.


An R package with all injury intent deaths registered in Mexico 2004-2012

on Dec 17, 2013
This is a data only package containing all injury intent deaths (accidents, suicides, homicides, legal interventions, and deaths of unspecified intent) registered by the SSA/INEGI from 2004 to 2012. The data source for the database is the INEGI. In addition the data was coded with the Injury Mortality Matrix provided by the CDC.

The package is only available from github, to install:

devtools::install_github("diegovalle/mxmortalitydb")

be sure to visit its github page to find out more!

Continuously updated crime information

on Sep 30, 2013
I've put together a simple website to keep people up to date on the latest crime information. The site polls the SESNSP website many times a day to see if there is new crime information, and if there is, it cleans up the data and makes it available for download.

http://crimenmexico.diegovalle.net/en/csv/ (Engish)
http://crimenmexico.diegovalle.net/es/csv/ (Spanish)

There's also a simple report based on the data. In the future I hope to also include homicide data from the INEGI, and municipio population from the CONAPO (the data now includes municipio population and information for all state level and federal crimes), so the data is bound to change at some point. If you'd like to see another crime or municipio added to the data or report feel free to contact me.

For major updates or announcements follow me on twitter

P.S. Keep in mind that the numbers refer to police reports and not number of victims.

State population datasets 1990-2030

on Aug 28, 2013

Cleaned up Mexican population estimates by five-year age groups and gender 1990-2030 (mid-year) at the state level:

Original data from the CONAPO website

The best high schools in Mexico City (COMIPEMS analysis)

on Jul 31, 2013
Click on the map to visit the interactive version
In Mexico City all ninth graders who want to enroll in a public high school (grades 10 trough 12 in Mexico) must take an exam called COMIPEMS. In order to ensure students are assigned in a fair way to a school of their choice the following steps are taken: