Global Health Observatory (GHO): Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
m (Removed dead links)
(Added images to steps)
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
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.
== 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 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 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.
The Data Team uses this database as the source for almost 80 different series, including:


= Series pulled from WHOSIS =
* '''SeriesHealthyLifeExpFemales'''
* '''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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</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)</font>
| <font face="Calibri" color="#000000">2006/12</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|}


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


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


&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=]


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


3. Download the data in the Excel List format.
[[File:GHO STEP1.png|frameless|750x750px]]


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


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.
'''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)


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).
[[File:GHO STEP2.png|frameless|750x750px]]


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.
 
 
You will be navigated to this page:
 
[[File:GHO STEP2A.png|frameless|750x750px]]
 
 
'''Step 3:''' Search the name of the indicator using the search bar. In our example, we will search "Healthy Life Expectancy":
 
[[File:GHO STEP3.png|frameless|750x750px]]
 
When you see your desired indicator, click it. You will be navigated to this page:
 
[[File:GHO STEP3A.png|frameless|750x750px]]
 
'''Step 4:''' Click the tab titled "Data"
 
[[File:GHO STEP4 .png|frameless|750x750px]]
 
 
 
You will be navigated to this view:
 
[[File:GHO STEP 4.png|frameless|750x750px]]
 
 
'''Step 5:''' Right click the link in the corner of the page and open the link as a new tab to download the data in a .csv format
 
[[File:GHO STEP5.png|frameless|750x750px]]

Latest revision as of 03:10, 17 February 2023

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

  • SeriesHealthyLifeExpFemales
  • SeriesHealthyLifeExpMales
  • SeriesHealthYLLComDis%
  • SeriesHealthYLLInjuries%
  • SeriesHealthYLLNonComDis%
  • SeriesMalnChil%WHOWeight
  • SeriesHealthObesityFemales18+Est%
  • SeriesLifeExpectancy65to69FWHO
  • SeriesMalnNewBorns%
  • SeriesHealthCommDisFemales0to4
  • SeriesHealthCommDisMales0to4
  • SeriesHealthDiabetesRRFemales15to29


To pull from the GHO for uploading into IFs, please follow the instructions below.

Steps to Pull Data from the GHO

Step 1: Navigate to the GHO Data Home Page

GHO STEP1.png


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)

GHO STEP2.png


You will be navigated to this page:

GHO STEP2A.png


Step 3: Search the name of the indicator using the search bar. In our example, we will search "Healthy Life Expectancy":

GHO STEP3.png

When you see your desired indicator, click it. You will be navigated to this page:

GHO STEP3A.png

Step 4: Click the tab titled "Data"

GHO STEP4 .png


You will be navigated to this view:

GHO STEP 4.png


Step 5: Right click the link in the corner of the page and open the link as a new tab to download the data in a .csv format

GHO STEP5.png