MPIDR Technical Report

A VBA program for data extraction from the WHO Mortality Database

Andreev, E. M.
MPIDR Technical Report TR-2010-004, 5 pages.
Rostock, Max-Planck-Institut für demografische Forschung (Mai 2010)


The WHO Mortality Database (WHOMD) contains data on populations and deaths classified by sex, age, and detailed causes of death for all countries reporting mortality statistics to the WHO. For many industrialized countries, these data cover a long period starting in the early 1950s. The database includes four huge datasets corresponding to four revisions of the International Classification of Diseases from ICD7 to ICD10. The file format and size make it difficult for inexperienced users to extract data. The WHO itself does not provide a program for extracting data from the database. The Excel spreadsheet WHO-db.xls includes a VBA program permitting the user to extract data from the WHOMD files for a chosen country, calendar period, and single or grouped causes of death. It also allows the user to retrieve data for several countries and years.
Das Max-Planck-Institut für demografische Forschung (MPIDR) in Rostock ist eines der international führenden Zentren für Bevölkerungswissenschaft. Es gehört zur Max-Planck-Gesellschaft, einer der weltweit renommiertesten Forschungsgemeinschaften.