Global Health Observatory (GHO)

From Pardee Wiki
Revision as of 18:43, 30 April 2016 by Wikiadmin (talk | contribs) (Undo revision 469 by Dave (talk))

Jump to navigation Jump to search

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