Global Health Observatory (GHO): Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
(Added summary and pulling instructions)
Tags: Replaced Visual edit
No edit summary
Line 1: Line 1:
== Summary ==
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 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 Observatory (GHO). The GHO provides over 1000 health indicators for the 194 WHO member states. The IFs system uses various measures from the GHO including diabetes relative risk, mortality and burden of disease, obesity, tobacco smoking prevalence, and life expectancy.


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 http://apps.who.int/gho/data/node.home]


The Data Team uses this database as the source for almost 80 different series, including:
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.


* '''SeriesHealthyLifeExpFemales'''
= Series pulled from WHOSIS =
* '''SeriesHealthyLifeExpMales'''
* '''SeriesHealthYLLComDis%'''
* '''SeriesHealthYLLInjuries%'''
* '''SeriesHealthYLLNonComDis%'''
* '''SeriesMalnChil%WHOWeight'''
* '''SeriesHealthObesityFemales18+Est%'''
* '''SeriesLifeExpectancy65to69FWHO'''
* '''SeriesMalnNewBorns%'''
* '''SeriesHealthCommDisFemales0to4'''
* '''SeriesHealthCommDisMales0to4'''
* '''SeriesHealthDiabetesRRFemales15to29'''


{| bgcolor="#ffffff" border="1" cellspacing="0"
|+ <font face="Calibri" color="#000000">'''DataDict 720'''</font>
|-
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Table</font>
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Group</font>
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Definition</font>
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Source</font>
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Last IFs Update</font>
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">UsedInPreprocessor</font>
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Years</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthCommDisFemales0to4</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Deaths by Communicable Diseases among female children under 5</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthCommDisMales0to4</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Deaths by Communicable Diseases among male children under 5</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRFemales15to29</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among females 15 to 29</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRFemales30to44</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among females 30 to 44</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRFemales45to59</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among females 45 to 59</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRFemales60to69</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among females 60 to 69</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRFemales70to79</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among females 70 to 79</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRFemales80to100</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among females 80 plus</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRMales15to29</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among Males 15 to 29</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRMales30to44</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among Males 30 to 44</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRMales45to59</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among Males 45 to 59</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRMales60to69</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among Males 60 to 69</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRMales70to79</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among males 70 to 79</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthDiabetesRRMales80to100</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Diabetes Relative Risk among Males 80 plus</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortChilDiarrh%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Deaths among children under 5 due to diarrhoeal diseases</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortChilHIV%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Deaths among children under 5 due to HIV/AIDS</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortChilInjuries%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Deaths among children under 5 due to injuries</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortChilMalaria%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Deaths among children under 5 due to malaria</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortChilMeasles%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Deaths among children under 5 due to measles</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortChilNeoNatal%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Deaths among children under 5 due to neonatal causes</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortChilOther%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Deaths among children under 5 due to other causes</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortChilPneu%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Deaths among children under 5 due to pneumonia</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortNeoNatAsphyxia%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Neonatal deaths due to asphyxia</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortNeoNatCongen%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Neonatal deaths due to congenital causes</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortNeoNatDiarrh%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Neonatal deaths due to diarrhoea</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortNeoNatInfect%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Neonatal deaths due to infection</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortNeoNatOther%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Neonatal deaths due to other causes</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortNeoNatPreTerm%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Neonatal deaths due to other preterm</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortNeoNatRate</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Neonatal mortality rate per 1000 live births</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2008/07/11</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortNeoNatTetanus%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Neonatal deaths due to tetanus</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortRateCancer</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Age-standardized mortality rate for cancer</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortRateCardVasc</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Age-standardized mortality rate for cardiovascular disease</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortRateInjuries</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Age-standardized mortality rate for injuries</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthMortRateNonComDis</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Age-standardized mortality rate for non-communicable diseases</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthObesityChildren%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Children under 5 overweight for age</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2006/12</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthObesityFemales%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Obesity among females 15 and older</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2006/12</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthObesityMales%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Obesity among males 15 and older</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2006/12</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthPolioCasesConf</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Number of confirmed poliomyelitis cases</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingAdolescents%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Tobacco smoking among adolescents 13-15</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2006/12</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingImpactFemales30to44</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Health impact for females 30 to 44</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingImpactFemales45to59</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Health impact for females 45 to 59</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingImpactFemales60to69</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Health impact for females 60 to 69</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingImpactFemales70to100</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Health impact for females 70 to 100</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingImpactMales30to44</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Health impact for males 30 to 44</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingImpactMales45to59</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Health impact for males 45 to 59</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingImpactMales60to69</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Health impact for males 60 to 69</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthSmokingImpactMales70to100</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Health impact for males 70 and older</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/06</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthyLifeExpFemales</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Healthy life expectancy (HALE) at birth, females</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthyLifeExpMales</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Healthy life expectancy (HALE) at birth, males</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthYLLComDis%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Years of life lost to communicable diseases</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthYLLInjuries%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Years of life lost to injuries</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesHealthYLLNonComDis%</font>
| <font face="Calibri" color="#000000">Population, Health</font>
| <font face="Calibri" color="#000000">Years of life lost to non-communicable diseases</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2007/01</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesMalnChil%WHOWeight</font><br/>
| <font face="Calibri" color="#000000">SocioPolitical, Agriculture</font>
| <font face="Calibri" color="#000000">Children under five years of age underweight for age</font>
| <font face="Calibri" color="#000000">WHO Statistical Information System (WHOSIS) available at [http://www3.who.int/whosis/core/core_select.cfm http://www3.who.int/whosis/core/core_select.cfm]</font>
| <font face="Calibri" color="#000000">2006/12</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|}


To pull from the GHO for uploading into IFs, please follow the instructions below.
= Instructions on pulling GHO data =


= Steps to Pull Data from the GHO =
1. Go to the GHO page for the data being pulled.


&nbsp;&nbsp; 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= http://apps.who.int/gho/data/node.resources?search=]


'''Step 1:''' Navigate to the [https://www.who.int/data/gho GHO Data Home Page]
2. Underneath the title, there will be two tabs, "Data" and "Downloads". Click on "Downloads".


3. Download the data in the Excel List format.


'''Step 2:''' Click the Indicators tab, which can be found on the top bar. As an example, we will be pulling data for '''SeriesHealthyLifeExpFemales''' and '''SeriesHealthyLifeExpMales''' (Healthy Life Expectancy at Birth)
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&nbsp;% (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_(general_instructions) 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&nbsp;%, continue on to step 6.


You will be navigated to this page:
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).


'''Step 3:''' Search the name of the indicator using the search bar. In our example, we will search "Healthy Life Expectancy":
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.
 
 
When you see your desired indicator, click it. You will be navigated to this page:
 
 
'''Step 4:''' Click the tab titled "Data"
 
 
You will be navigated to this view:
 
 
'''Step 5:''' Right click the link in the corner of the page (circled below) and open the link as a new tab to download the data in a .csv format

Revision as of 17:56, 17 May 2016

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

DataDict 720
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.

Retrieved from "https://pardeewiki.du.edu//index.php?title=Global_Health_Observatory_(GHO)&oldid=697"