Clean the mortality database from the SSA/INEGI
R Makefile
Switch branches/tags
Nothing to show
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
cache
clean-data
data
diagnostics
doc
graphs
lib
logs
profiling
reports
src
ssa-database
tests
.gitignore
LICENSE
README.md
TODO
death.index.Rproj
makefile
run_all.R

README.md

This program cleans up the mortality database from the SSA/INEGI

run_all.R ##downloads and cleans the mortality files

clean-data/mortality-database.sqlite

Cleaned Data

Once the program is run you'll find a bunch of files in the clean-data directory:

  • mortality-database.sqlite : All registered deaths in Mexico from 2004 to 2010 in sqlite format
  • injury-intent.csv.bz2: Injury intent (accidents, suicides, homicides, legal interventions and deaths of unspecified injury intent) deaths in csv format
  • di[year].sinais.csv.bz: The raw 'uncleaned' mortality files (see below) in csv format

Marital status was recorded differently in 2012 (Separated added) insurance was recorded differently in 2012 (IMSS oportunidades added) education was recorded differently in 2012 Data Sources

The mortality files are from the SSA/INEGI available at

SINAIS

If for some reason the files are not downloaded automatically you can download them manually and place the files in the "ssa-database" directory. The files you need to dowload are:

2004

2005

2006

2007

2008

2009

2010

Author: Diego Valle-Jones