Global Health Observatory (GHO): Difference between revisions
Jump to navigation
Jump to search
(Created page with "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 re...") |
No edit summary |
||
| (9 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
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 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. | |||
= Series pulled from WHOSIS = | = Series pulled from WHOSIS = | ||
{| | {| bgcolor="#ffffff" border="1" cellspacing="0" | ||
|+ <font face="Calibri" color="#000000">'''DataDict 720'''</font> | |+ <font face="Calibri" color="#000000">'''DataDict 720'''</font> | ||
|- | |- | ||
! bgcolor="#c0c0c0 | ! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Table</font> | ||
! bgcolor="#c0c0c0 | ! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Group</font> | ||
! bgcolor="#c0c0c0 | ! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Definition</font> | ||
! bgcolor="#c0c0c0 | ! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Source</font> | ||
! bgcolor="#c0c0c0 | ! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Last IFs Update</font> | ||
! bgcolor="#c0c0c0 | ! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">UsedInPreprocessor</font> | ||
! bgcolor="#c0c0c0 | ! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Years</font> | ||
|- valign="TOP" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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" | |- 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/> | |||
|} | |} | ||
= 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= 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_(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 %, 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. | |||
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
| 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.