WHO

WHO2BodyParts =WHO death statistics=
 * Source:http://www.who.int/healthinfo/statistics/mortality_rawdata/en/index.html
 * AU:World Health Organization Department of Health Statistics and Information Systems
 * TI:WHO Mortality Data base documentation
 * Date:1 May 2013 update

Part 1: Background, file descriptions including record counts (pages 2-10)
Annex Table 1. Age group formats Annex Table 2. Description of fields “Admin1”, “Subdiv”, and “List” Annex 3. Instructions for importing the comma separated values (CSV)files into Microsoft Access Annex 4. Conditions on the use of the WHO Mortality Data Base

Part 2: Causes of death: code descriptions (pages 11-47)
*Table 1. ICD7 List A * Table 2. ICD7 List B * Table 3. ICD8 List A * Table 4. ICD8 List B * Table 5. ICD9 Basic Tabulation List (BTL) * Table 6. ICD9 Special coding for some newly independent states of former USSR * Table 7. ICD9 China data coding Warning to users: Data for China are only for selected urban and rural areas and represent less than 10% of all deaths occurring in the country. * Table 8. ICD10 Mortality Tabulation List 1 * Table 9. ICD10 detailed 3rd and 4th character * Table 10. ICD10 Special list for Portugal - data for 2004-2005 * Table 11. List of country codes-names

Part 3: Frequently asked questions (page 48)
AU:World Health Organization Department of Measurement and Health Information Systems WHO Mortality Data base documentation The users' attention is brought to the fact that some data might differ from those as published by the countries. This is mainly because (a) WHO uses standard classifications to present the data (b) some countries do not implement the ICD10 updates and (c) also the WHO Mortality Data base is regularly updated.

Background

 * The data available for download from this web site are official national statistics in the sense that they have been transmitted to the World Health Organization by the competent authorities of the countries concerned.
 * The WHO Mortality Data base comprises deaths registered in national vital registration systems, with underlying cause of death as coded by the relevant national authority. Underlying cause of death is defined as “the disease or injury which initiated the train of morbid events leading directly to death, or the circumstances of the accident or violence which produced the fatal injury” in accordance with the rules of the International Classification of Diseases.
 * The database contains number of deaths by country, year, sex, age group and cause of death as far back from 1950. Data are included only for countries reporting data properly coded according to the International Classification of Diseases (ICD).

System requirements and installation:

 * The database is available for PC. At least 500 MB of free space is required to download and install the data set to the user’s PC.
 * The data set is distributed in compressed form.
 * All the files are in ASCII format only (csv files with comma separated values); however their format allows for easy importing into any Data Base Management System (DBMS), for e.g. Microsoft Access, SPSS, Dbase, SAS.
 * Users should have the necessary knowledge to operate a DBMS for a comprehensive use of the database.
 * Instructions for importing the csv files into Microsoft Access are listed in Annex Table 3.
 * However users are strongly recommended not to try to import the data into spreadsheets because of the excessive number of records.
 * There are over 1 millin records in one data file.

Description of the data files:
There are 8 files, named

MortIcd07.zip: mortality data aggregated according to the Lists A and B of the 7th revision of the ICD. Total records: 281,749 (excluding first row of field names) MortIcd08.zip: mortality data aggregated according to the Lists A and B of the 8th revision of the ICD. Total records 380,627 (excluding first row of field names). MortIcd09.zip: mortality data aggregated according to the Basic Tabulation List (BTL) of the 9th revision of the ICD. Total records 893,359 (excluding first row of field names) MortIcd10.zip: mortality data according to the detailed 10th revision of the ICD, either with 3 characters or 4 characters ICD 10 codes. Total records 2,409,038 (excluding first row of field names). Pop.zip: reference population and live births. Note population and livebirths are both in units. Population figures are mid-year population. Total records 8,580 (excluding first row of field names). Country_codes.zip: Country codes and names. Total records 227 (excluding first row of field names) Availability.zip: List of countries-years included in the data base for mortality and population data. This is an Excel file with two worksheets. Note that the fields “Admin1”, “Subdiv”, “List”, “Cause”, “Frmat” and “IM_Frmat” should be treated as characters. The other fields can be treated as numerical variables. Notes.zip: Notes related to data for some countries-years. Total records 57 (excluding first row of field names)

Data layout of ICDxMortality table
Column name	Content Country	Country code – see file “Country_codes.zip” Admin1	Specified region/Category pertinent to each country– see Annex Table 2 below. If both fields 'Admin1' and 'Subdiv' are blank, data reported refer to the country. Subdiv	Category of data – see Annex Table 2 below. If both fields 'Admin1' and 'Subdiv' are blank, data reported refer to the country. Year 	Year to which data refer List  	 List of ICD revision used – see Annex Table 2 below. Cause	Cause of death – For details consult Part 2 below or ICD publications Sex  	1 male, 2 female and 9 sex unspecified Frmat	Age-group format for breakdown of deaths at 0-95+ yrs – see Annex Table 1 below for details IM_Frmat	Age format for breakdown of infant deaths (0 year) – see Annex Table 1 below for details Deaths1	Deaths at all ages Deaths2	Deaths at age 0 year Deaths3	Deaths at age 1 year Deaths4	Deaths at age 2 years Deaths5	Deaths at age 3 years Deaths6	Deaths at age 4 years Deaths7	Deaths at age 5-9 years Deaths8	Deaths at age 10-14 years Deaths9	Deaths at age 15-19 years Deaths10	Deaths at age 20-24 years Deaths11	Deaths at age 25-29 years Deaths12	Deaths at age 30-34 years Deaths13	Deaths at age 35-39 years Deaths14	Deaths at age 40-44 years Deaths15	Deaths at age 45-49 years Deaths16	Deaths at age 50-54 years Deaths17	Deaths at age 55-59 years Deaths18	Deaths at age 60-64 years Deaths19	Deaths at age 65-69 years Deaths20	Deaths at age 70-74 years Deaths21	Deaths at age 75-79 years Deaths22	Deaths at age 80-84 years Deaths23	Deaths at age 85-89 years Deaths24	Deaths at age 90-94 years Deaths25	Deaths at age 95 years and above Deaths26	Deaths at age unspecified IM_deaths1	Infant deaths at age 0 day IM_deaths2	Infant deaths at age 1-6 days IM_deaths3	Infant deaths at age 7-27 days IM_deaths4	Infant deaths at age 28-364 days
 * For files MortIcd7.zip, MortIcd8.zip, MortIcd9.zip and MortIcd10.zip, the layout for each line of data is as follows:

Column name	Content Country	Country code – see file “Country_codes.zip” Admin1	Specified region/Category pertinent to each country– see file “Country_codes.zip”. If this field is blank, data reported refer to the country Subdiv1	Category of data – see Annex Table 2 below. If this field is blank, data reported refer to the country. Year	Year to which data refer Sex	1 male, 2 female Frmat	Age-group format for breakdown of deaths at 0-95+ yrs – see Annex Table 1 below for details Pop1	Population at all ages Pop2	Population at age 0 year Pop3	Population at age1 year Pop4	Population at age 2 years Pop5	Population at age 3 years Pop6	Population at age 4 years Pop7	Population at age 5-9 years Pop8	Population at age 10-14 years Pop9	Population at age 15-19 years Pop10	Population at age 20-24 years Pop11	Population at age 25-29 years Pop12	Population at age 30-34 years Pop13	Population at age 35-39 years Pop14	Population at age 40-44 years Pop15	Population at age 45-49 years Pop16	Population at age 50-54 years Pop17	Population at age 55-59 years Pop18	Population at age 60-64 years Pop19	Population at age 65-69 years Pop20	Population at age 70-74 years Pop21	Population at age 75-79 years Pop22	Population at age 80-84 years Pop23	Population at age 85-89 years Pop24	Population at age 90-94 years Pop25	Population at age 95 years and over Pop26	Population at age unspecified Lb  	 Live births Column name	Content Country	Country code Name	Country name Note that the above fields should be read together with fields “Admin1” and “Subdiv” in the data files.
 * The layout of each record of the Pop.zip file is as follows:
 * The layout of each record of the Country_codes.zip file is as follows: