Global Health Observatory (GHO)
The World Health Organization (WHO)'s Statistical Interactive Database (WHOSIS) is now called the Global Health Observatory (GHO). There are 53 series that come from the WHO Statistical Information System (WHOSIS). Most have not been updated since 2007, some are even older. 20 of these series are being read into the preprocessor.
The WHO Statistical Information System (WHOSIS) was an interactive database bringing together core health statistics, but has now been absorbed into the Global Health Obserbatory (GHO). The GHO provides over 1000 health indicators for the 194 WHO member states and can be accessed online: http://apps.who.int/gho/data/node.home
The IFs system uses various measures from WHOSIS including diabetes relative risk, mortality and burden of disease, obesity, tobacco smoking prevalence, and life expectancy. As the series are updated, data will come from the GHO instead of WHOSIS.
Series pulled from WHOSIS
| Table | Group | Definition | Source | Last IFs Update | UsedInPreprocessor | Years |
|---|---|---|---|---|---|---|
| SeriesHealthCommDisFemales0to4 | Population, Health | Deaths by Communicable Diseases among female children under 5 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | No | |
| SeriesHealthCommDisMales0to4 | Population, Health | Deaths by Communicable Diseases among male children under 5 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | No | |
| SeriesHealthDiabetesRRFemales15to29 | Population, Health | Diabetes Relative Risk among females 15 to 29 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthDiabetesRRFemales30to44 | Population, Health | Diabetes Relative Risk among females 30 to 44 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthDiabetesRRFemales45to59 | Population, Health | Diabetes Relative Risk among females 45 to 59 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthDiabetesRRFemales60to69 | Population, Health | Diabetes Relative Risk among females 60 to 69 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthDiabetesRRFemales70to79 | Population, Health | Diabetes Relative Risk among females 70 to 79 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthDiabetesRRFemales80to100 | Population, Health | Diabetes Relative Risk among females 80 plus | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthDiabetesRRMales15to29 | Population, Health | Diabetes Relative Risk among Males 15 to 29 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthDiabetesRRMales30to44 | Population, Health | Diabetes Relative Risk among Males 30 to 44 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthDiabetesRRMales45to59 | Population, Health | Diabetes Relative Risk among Males 45 to 59 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthDiabetesRRMales60to69 | Population, Health | Diabetes Relative Risk among Males 60 to 69 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthDiabetesRRMales70to79 | Population, Health | Diabetes Relative Risk among males 70 to 79 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthDiabetesRRMales80to100 | Population, Health | Diabetes Relative Risk among Males 80 plus | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthMortChilDiarrh% | Population, Health | Deaths among children under 5 due to diarrhoeal diseases | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortChilHIV% | Population, Health | Deaths among children under 5 due to HIV/AIDS | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortChilInjuries% | Population, Health | Deaths among children under 5 due to injuries | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortChilMalaria% | Population, Health | Deaths among children under 5 due to malaria | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortChilMeasles% | Population, Health | Deaths among children under 5 due to measles | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortChilNeoNatal% | Population, Health | Deaths among children under 5 due to neonatal causes | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortChilOther% | Population, Health | Deaths among children under 5 due to other causes | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortChilPneu% | Population, Health | Deaths among children under 5 due to pneumonia | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortNeoNatAsphyxia% | Population, Health | Neonatal deaths due to asphyxia | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortNeoNatCongen% | Population, Health | Neonatal deaths due to congenital causes | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortNeoNatDiarrh% | Population, Health | Neonatal deaths due to diarrhoea | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortNeoNatInfect% | Population, Health | Neonatal deaths due to infection | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortNeoNatOther% | Population, Health | Neonatal deaths due to other causes | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortNeoNatPreTerm% | Population, Health | Neonatal deaths due to other preterm | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortNeoNatRate | Population, Health | Neonatal mortality rate per 1000 live births | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2008/07/11 | No | |
| SeriesHealthMortNeoNatTetanus% | Population, Health | Neonatal deaths due to tetanus | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortRateCancer | Population, Health | Age-standardized mortality rate for cancer | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortRateCardVasc | Population, Health | Age-standardized mortality rate for cardiovascular disease | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortRateInjuries | Population, Health | Age-standardized mortality rate for injuries | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthMortRateNonComDis | Population, Health | Age-standardized mortality rate for non-communicable diseases | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthObesityChildren% | Population, Health | Children under 5 overweight for age | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2006/12 | No | |
| SeriesHealthObesityFemales% | Population, Health | Obesity among females 15 and older | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2006/12 | No | |
| SeriesHealthObesityMales% | Population, Health | Obesity among males 15 and older | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2006/12 | No | |
| SeriesHealthPolioCasesConf | Population, Health | Number of confirmed poliomyelitis cases | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthSmokingAdolescents% | Population, Health | Tobacco smoking among adolescents 13-15 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2006/12 | No | |
| SeriesHealthSmokingImpactFemales30to44 | Population, Health | Health impact for females 30 to 44 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthSmokingImpactFemales45to59 | Population, Health | Health impact for females 45 to 59 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthSmokingImpactFemales60to69 | Population, Health | Health impact for females 60 to 69 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthSmokingImpactFemales70to100 | Population, Health | Health impact for females 70 to 100 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthSmokingImpactMales30to44 | Population, Health | Health impact for males 30 to 44 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthSmokingImpactMales45to59 | Population, Health | Health impact for males 45 to 59 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthSmokingImpactMales60to69 | Population, Health | Health impact for males 60 to 69 | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthSmokingImpactMales70to100 | Population, Health | Health impact for males 70 and older | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/06 | Yes | |
| SeriesHealthyLifeExpFemales | Population, Health | Healthy life expectancy (HALE) at birth, females | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthyLifeExpMales | Population, Health | Healthy life expectancy (HALE) at birth, males | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthYLLComDis% | Population, Health | Years of life lost to communicable diseases | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthYLLInjuries% | Population, Health | Years of life lost to injuries | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesHealthYLLNonComDis% | Population, Health | Years of life lost to non-communicable diseases | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2007/01 | No | |
| SeriesMalnChil%WHOWeight |
SocioPolitical, Agriculture | Children under five years of age underweight for age | WHO Statistical Information System (WHOSIS) available at http://www3.who.int/whosis/core/core_select.cfm | 2006/12 | No |
Instructions on pulling GHO data
1. Go to the GHO page for the data being pulled.
A link should be provided in the description above. If it is not, search for it here: http://apps.who.int/gho/data/node.resources?search=
2. Underneath the title, there will be two tabs, "Data" and "Downloads". Click on "Downloads".
3. Download the data in the Excel List format.
4. The data will be found in the "data-text" sheet in the excel file.
5. If the data being pulled is anything other than the child or neonatal mortality % (e.g., HealthMortChilMalaria%, HealthMortNeoNatCongen%), save the file and import into IFs. Further directions on data importing can be found here: http://pardee.du.edu/wiki/index.php?title=Importing_data_%28general_instructions%29. The country concordance that should be used is WHO 2012. If the data being pulled is child or neonatal mortality %, continue on to step 6.
6. The data for child and neonatal mortality includes both in the same column of the spreadsheet, so it needs to be separated into two distinct columns to be imported into IFs. First, create a new sheet in the excel file. Then, make sure the years in the "data-text" are in order (sort A to Z). Sort the countries next (A to Z). This will make sure that the years and countries will line up when you move both the neonatal mortality and the under 5 mortality. Next, select the "Age Group" column and select only 0-27 days. Move the columns for year, country, age, and distribution of death (numeric) to the new sheet.
Go back to "data-text" and select only 0-4 years in the "Age Group" column. Move the columns for age and distribution of death (numeric) to the new sheet. In the new sheet there should be 6 columns: year, country, age group (0-27 days), distribution of deaths (numerical) (0-27 days), age group (0-4 years), and distribution of deaths (numerical) (0-4 years).
Save this file and save a copy. Import the first copy of the file into IFs for one of the age groups, then import the second age group using the second copy of the excel file. The country concordance that should be used is WHO 2012.