Pardee Wiki - User contributions [en]

FishstatJ, FAO

2017-07-16T23:06:02Z

AlisaNelson:

= Introduction =

FAO Fishtatj is software used by the Food and Agriculture Organization to handle their fisheries and aquaculture data. Data from Fishtatj is separated into four different workspaces, which must each be downloaded separately: Global Production, Global Commodities, Regional, and Food Balance. The Global Production and Global Commodities workspaces are used for the data discussed in this article. Once downloaded, the data in each of these workspaces may be manipulated and converted to an excel file using the Fishtatj software. FAO Fishtatj and workspaces can be downloaded [http://www.fao.org/fishery/statistics/software/fishstatj/en here] and additional help can be found using the [http://www.fao.org/fishery/static/FishStatJ/FishStatJ_3.02.1-Manual.pdf Fishtatj manual] or FAO [https://www.youtube.com/watch?v=QlHxEHOzS1g&feature=youtu.be help videos]. The following series are IFs data collected using Fishstatj:

{| border="1" cellpadding="0" cellspacing="0" width="572"
|- height="20"
| height="20" width="219" | Variable
| width="210" | Definition
| width="143" | Workspace
|- height="60"
| height="60" width="219" | AgFishAquaProdAqAnimalsFSJ
| width="210" | Total Aquatic Animals Aquaculture Production (tonnes) from FishstatJ
| width="143" | Global Production
|- height="60"
| height="60" width="219" | AgFishAquaProdAqPlantsFSJ
| width="210" | Total Aquatic Plants Aquaculture Production (tonnes) from FishstatJ
| width="143" | Global Production
|- height="60"
| height="60" width="219" | AgFishAquaProdCephalopodsFSJ
| width="210" | Total Cephalopods Aquaculture Production (tonnes) from FishstatJ
| width="143" | Global Production
|- height="60"
| height="60" width="219" | AgFishAquaProdCrustaceansFSJ
| width="210" | Total Crustaceans Aquaculture Production (tonnes) from FishstatJ
| width="143" | Global Production
|- height="60"
| height="60" width="219" | AgFishAquaProdDemersalFSJ
| width="210" | Total  Demersal Aquaculture Production (tonnes) from FishstatJ
| width="143" | Global Production
|- height="60"
| height="60" width="219" | AgFishAquaProdFreshwaterFSJ
| width="210" | Total Freshwater Aquaculture Production (tonnes) from FishstatJ
| width="143" | Global Production
|- height="60"
| height="60" width="219" | AgFishAquaProdMarineFSJ
| width="210" | Total Marine Aquaculture Production (tonnes) from FishstatJ
| width="143" | Global Production
|- height="60"
| height="60" width="219" | AgFishAquaProdMolluscsFSJ
| width="210" | Total Molluscs Aquaculture Production (tonnes) from FishstatJ
| width="143" | Global Production
|- height="60"
| height="60" width="219" | AgFishAquaProdOthersFSJ
| width="210" | Total Others Aquaculture Production (tonnes) from FishstatJ
| width="143" | Global Production
|- height="60"
| height="60" width="219" | AgFishAquaProdPelagicFSJ
| width="210" | Total Pelagic Aquaculture Production (tonnes) from FishstatJ
| width="143" | Global Production
|- height="60"
| height="60" width="219" | AgFishCatchProdAqAnimalsFSJ
| width="210" | Total Aquatic Animals Catch Production (tonnes) from FishstatJ
| width="143" | Global Production
|- height="60"
| height="60" width="219" | AgFishCatchProdAqMammalsFSJ
| width="210" | Total Aquatic Mammals Catch Production (tonnes) from FishstatJ
| width="143" | Global Production
|- height="60"
| height="60" width="219" | AgFishCatchProdAqPlantsFSJ
| width="210" | Total Aquatic Plants Catch Production (tonnes) from FishstatJ
| width="143" | Global Production
|- height="40"
| height="40" width="219" | AgFishCatchProdCephalopodsFSJ
| width="210" | Total Cephalopods Capture Production from FishstatJ
| width="143" | Global Production
|- height="40"
| height="40" width="219" | AgFishCatchProdCrustaceansFSJ
| width="210" | Total Crustaceans Capture Production from FishstatJ
| width="143" | Global Production
|- height="40"
| height="40" width="219" | AgFishCatchProdDemersalFSJ
| width="210" | Total Demersal Capture Production from FishstatJ
| width="143" | Global Production
|- height="40"
| height="40" width="219" | AgFishCatchProdFreshwaterFSJ
| width="210" | Total Freshwater Capture Production from FishstatJ
| width="143" | Global Production
|- height="40"
| height="40" width="219" | AgFishCatchProdMarineFSJ
| width="210" | Total Marine Capture Production from FishstatJ
| width="143" | Global Production
|- height="40"
| height="40" width="219" | AgFishCatchProdMolluscsFSJ
| width="210" | Total Molluscs Capture Production from FishstatJ
| width="143" | Global Production
|- height="40"
| height="40" width="219" | AgFishCatchProdOthersFSJ
| width="210" | Total Others Capture Production from FishstatJ
| width="143" | Global Production
|- height="60"
| height="60" width="219" | AgFishCatchProdPelagicFSJ
| width="210" | Total Pelagic Capture Production (tonnes) from Fishstatj
| width="143" | Global Production
|- height="60"
| height="60" width="219" | AgFishExportVal
| width="210" | Global Commodities Production and Trade Value of Fish Exports (USD)
| width="143" | Global Commodities
|- height="60"
| height="60" width="219" | AgFishImportVal
| width="210" | Global Commodities Production and Trade Value of Fish Imports (USD)
| width="143" | Global Commodities
|- height="40"
| height="40" width="219" | AgFishProdAquaInland
| width="210" | Fish,Production, Inland Aquaculture
| width="143" | Global Production
|- height="40"
| height="40" width="219" | AgFishProdAquaMarine
| width="210" | Fish, production, Marine Aquaculture
| width="143" | Global Production
|- height="20"
| height="20" width="219" | AgFishProdCatchInland
| width="210" | Fish, Production, Inland Catch
| width="143" | Global Production
|- height="20"
| height="20" width="219" | AgFishProdCatchMarine
| width="210" | Fish, Production, Marine Catch
| width="143" | Global Production
|}

= Data Collection =

After downloading Fishtatj and the Global Commodity and Global Production workspaces, open the program and load the Global Production dataset. Within this workspace, there are three tabs: Global Capture Production (Quantity), Global Aquaculture Production (Value), and Global Aquaculture Production (Quantity). Data can be further manipulated using the level of aggregation tool (blue arrow) and the filter tool - the first option under the data tab (green arrow).

[[File:FAO Fishtatj Help Image.png]]

== Global Capture Production (Quantity) tab of the Global Production dataset ==

AgFishCatchProdAqAnimalsFSJ through AgFishCatchProdPelagicFSJ (see list in Introduction):

Using the aggregation tool, set the country dimension to detailed, the species to grouped, and the fishing area to aggregated. For the species division, choose "FAOSTAT group of commodities." Using the filter tool under the data tab, make sure that ALL species, countries and fishing areas have been included. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened. The species correspond to the different data series as follows:

{| border="1" cellpadding="0" cellspacing="0" width="448"
|- height="20"
| height="20" width="232" | AgFishCatchProdAqAnimalsFSJ
| width="216" | Aquatic Animals NEI
|- height="20"
| height="20" | AgFishCatchProdAqMammalsFSJ
| Aquatic Mammals
|- height="20"
| height="20" | AgFishCatchProdAqPlantsFSJ
| Aquatic Plants
|- height="20"
| height="20" | AgFishCatchProdCephalopodsFSJ
| Cephalopods
|- height="20"
| height="20" | AgFishCatchProdCrustaceansFSJ
| Crustaceans
|- height="20"
| height="20" | AgFishCatchProdDemersalFSJ
| Demersal Marine Fish
|- height="20"
| height="20" | AgFishCatchProdFreshwaterFSJ
| Freshwater and Diadromous Fish
|- height="20"
| height="20" | AgFishCatchProdMarineFSJ
| Marine Fish NEI
|- height="20"
| height="20" | AgFishCatchProdMolluscsFSJ
| Molluscs excl. Cephalopods
|- height="20"
| height="20" | AgFishCatchProdPelagicFSJ
| Pelagic Marine Fish
|}

AgFishProdCatchInland and AgFishProdCatchMarine:

Using the aggregation tool, set the country dimension to detailed, the species to aggregated, and the fishing area to grouped. For the fishing area division, choose "Inland/Marine areas". Using the filter tool under the data tab, make sure that ALL species, countries and fishing areas have been included. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened. The marine areas data correspond to AgFishProdCatchMarine and the inland waters data correspond to AgFishProdCatchInland.

== Global Aquaculture Production (Quantity) tab of the Global Production dataset ==

AgFishAquaProdAqAnimalsFSJ through AgFishAquaProdPelagicFSJ (see list in Introduction):

Using the aggregation tool, set the country dimension to detailed, the species to grouped, and the aquaculture area and environment both to aggregated. For the species division, choose "FAOSTAT group of commodities". Using the filter tool under the data tab, make sure that ALL species, countries, aquaculture areas, and environments have been included. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened. The species correspond to the different data series as follows:

{| border="1" cellpadding="0" cellspacing="0" width="448"
|- height="20"
| height="20" width="232" | AgFishAquaProdAqAnimalsFSJ
| width="216" | Aquatic Animals NEI
|- height="20"
| height="20" width="232" | AgFishAquaProdAqPlantsFSJ
| Aquatic Plants
|- height="20"
| height="20" width="232" | AgFishAquaProdCephalopodsFSJ
| Cephalopods
|- height="20"
| height="20" width="232" | AgFishAquaProdCrustaceansFSJ
| Crustaceans
|- height="20"
| height="20" width="232" | AgFishAquaProdDemersalFSJ
| Demersal Marine Fish
|- height="20"
| height="20" width="232" | AgFishAquaProdFreshwaterFSJ
| Freshwater and Diadromous Fish
|- height="20"
| height="20" width="232" | AgFishAquaProdMarineFSJ
| Marine Fish NEI
|- height="20"
| height="20" width="232" | AgFishAquaProdMolluscsFSJ
| Molluscs excl. Cephalopods
|- height="20"
| height="20" width="232" | AgFishAquaProdPelagicFSJ
| Pelagic Marine Fish
|}

AgFishProdAquaInland and AgFishProdAquaMarine:

Under the aggregation tool, set the country dimension to detailed, the species and enviroment both to aggregated, and the aquaculture area to grouped. For the aquaculture division, choose "Inland/Marine areas". Using the filter tool under the data tab, make sure that ALL species, countries, aquaculture areas, and evironments have been included. All rows must be selected (ctrl/cmd + a). Data can then be saved as a .csv file by using the second option under the edit tab. This file can then be saved as a more updated excel file (.xls or .xlsx) once it is opened. The marine areas data correspond to AgFishProdAquaMarine and the inland waters data correspond to AgFishProdAquaInland.

== Global Commodities Workspace ==

Close the workspace. Then open the Global Commodities Workspace. The two series found in this workspace are AgFishExportVal and AgFishImportVal. Using the aggregation tool, set the country dimension to detailed, the commodity to aggregated, and the 

File:FAO Fishtatj Help Image.png

2017-07-16T22:13:51Z

AlisaNelson:

FishstatJ, FAO

2017-07-16T21:44:38Z

AlisaNelson:

FishstatJ, FAO

2017-07-16T21:42:28Z

AlisaNelson:

FishstatJ, FAO

2017-07-12T13:44:54Z

AlisaNelson: Created page with "= Introduction = = Data = = Steps ="

= Introduction =

= Data =

= Steps =

Energy Data, BGR

2017-06-21T00:52:34Z

AlisaNelson:

The Federal Institute for Geosciences and Natural Resources, or BGR, is a German Agency which publishes data on oil and gas resources and reserves. BGR data can be accessed [http://www.bgr.bund.de/EN/Themen/Energie/Produkte/energy_study_2014_summary_en.html;jsessionid=15BA5CB5AEB1632F61A4DB9B0A3DC1A7.1_cid292&nbsp here]. This data is useful because resources and reserves are broken into their unconventional sub-components such as shale gas, tight oil, and coalbed methane. This is important in initializing total resources and reserves in the model, especially with the rise in unconventional gas and oil production in North America.

= Series pulled from BGR =

{| border="1" cellpadding="0" cellspacing="0" width="64"
|- height="20"
| height="20" width="64" | SeriesEnCumProdGasBGR
|- height="20"
| height="20" | SeriesEnCumProdOilBGR
|- height="20"
| height="20" | SeriesEnReserCBMBGR
|- height="20"
| height="20" | SeriesEnReserGasBGR
|- height="20"
| height="20" | SeriesEnReserHeavyOilBGR
|- height="20"
| height="20" | SeriesEnReserOilBGR
|- height="20"
| height="20" | SeriesEnReserOilSandsBGR
|- height="20"
| height="20" | SeriesEnReserShaleGasBGR
|- height="20"
| height="20" | SeriesEnReserShaleOilBGR
|- height="20"
| height="20" | SeriesEnResorCBMBGR
|- height="20"
| height="20" | SeriesEnResorGasBGR
|- height="20"
| height="20" | SeriesEnResorHeavyOilBGR
|- height="20"
| height="20" | SeriesEnResorOilBGR
|- height="20"
| height="20" | SeriesEnResorOilSandsBGR
|- height="20"
| height="20" | SeriesEnResorShaleGasBGR
|- height="20"
| height="20" | SeriesEnResorShaleOilBGR
|- height="20"
| height="20" | SeriesEnResorTightGasBGR
|}

= Instructions on importing BGR data =

'''Process of importing and blending:'''

In preparing these series, I first downloaded the relevant energy reports from the BGR website, or are available through a google search of "BGR Energy Resources [YEAR]". I then exported the appropriate tables from these PDFs into separate excel sheets. Next, I broke these excel sheets down into the individual series, each of the 17 series onto its own excel sheet.

Each one of these 17 sheets has tabs for raw data for each year, formatted data for each year, and data for import (including data for all years). The [YEAR] tabs have the raw data pulled from the two Energy Study excel sheets. The [YEAR] Formatted tabs have the same data as the [YEAR] tabs, only it has been formatted into a IFs-compatible format. The Data for Import tab has these two years combined.

Finally, I took all the Data for Import tabs from the 17 sheets and combined them into one sheet (Energy Series Final Version for Import). I then imported all series into Ifs from this sheet. Once I imported the data into Ifs, I blended the series with the existing data and exported all the series to the Access table “Imported Series” in folder “Imported Series”.

'''Some notes on the formatting process:'''

In 2014, term changed from Shale Oil to Tight Oil (applies to Series EnReserShaleOil and EnResourceShaleOil) not to be confused with Tight Gas.

Table numbers don’t stay the same over different years in the energy reports.

Differences between resources and reserves: “…[That] part of a mineral resource, which has been fully evaluated and is deemed commercially viable to work, is called a mineral reserve [in effect, resources will always be larger than resources]” In effect, resources shouldn’t change over time, while reserves can.

''-Source: ''[http://www.bgs.ac.uk/mineralsUK/mineralsYou/resourcesReserves.html ''http://www.bgs.ac.uk/mineralsUK/mineralsYou/resourcesReserves.html'']''; Accessed 3/6/16''

Sudan and South Sudan: Most of the time, BGR lists reserve and resource values for "Sudan" and "South Sudan" individually. On occasion though, BGR will use "Sudan and South Sudan" as a composite, representing aggregated data for both of the countries but not providing it on an individual basis. This is rare, and only takes place in series EnReserGasBGR and EnResorGasBGR. In these cases, I calculated the values for "Sudan" and "South Sudan" by taking the value of "Sudan and South Sudan" and dividing it by the ratio of land mass between Sudan (728,215 sqm) and South Sudan (239,285 sqm). Also, per Steve Hedden, we don't enter values for Sudan in the series EnCumProdGas and EnCumProdOil.

Another issue that needs mentioning is BGR's usage of dashes ("-") in its Energy Reports. Dashes are intrepreted as 0's based on the definition given by BGR in the Energy Reports.

BGR occasionally uses "n.s." in its data, which is intrepreted as a null value. In the German translation, "k. A." is used instead of "n.s.". 

If there is a less than sign in the data, it is dropped and the value preceding it is entered as is. Ex. <0.05 is entered as 0.05.

'''Reference Data''''': Listed below is each BGR series I updated, all with the name of the table in the Energy Report pdf, and the column of the table used.''

#EnCumProdGasBGR: uses table Natural Gas in XXXX (year), column Cum. Production
#EnCumProdOilBGR: uses table Crude Oil in XXXX (year), column Cum. Production
#EnReserCBMBGR: Coalbed Methane Reserves. Table Natural Gas Resources (under CBM)
#EnReserGasBGR: Uses table Natural Gas in XXXX (Year), Column: Reserves
#EnReserHeavyOilBGR: Uses table Crude Oil Reserves, Extra Heavy Oil column
#EnReserOilBGR: Utilizes table Crude Oil in XXXX (year), column Reserves
#EnReserOilSandsBGR: Uses table Crude Oil Reserves, column Oil Sand
#EnReserShaleGasBGR: Uses table Natural Gas Reserves, column Shale Gas
#EnReserShaleOilBGR: Uses table Crude Oil Reserves, column Shale Oil
#EnResorCBMBGR: Uses table Natural Gas Resources, column CBM
#11.EnResorGasBGR: Uses table Natural Gas in XXXX (year), column Remaining Potential
#EnResorHeavyOilBGR: Uses table Crude Oil Resources, column Extra Heavy Oil
#EnResorOilBGR: Uses table Crude Oil in XXXX (year), column Remaining Potential
#EnResorOilSandsBGR: table Crude Oil Resources, column Oil Sand<ol style="list-style-type: lower-alpha;"
#EnResorShaleGasBGR: table Natural Gas Resources in XXXX, Column Shale Gas
#EnResorShaleOilBGR: table Crude Oil Resources, Column Shale Oil
#EnResorTightGasBGR: table Natural Gas Resources, column Tight Gas<ol style="list-style-type: lower-alpha;">
</ol></ol>

United Nations Statistics Division: MDG Indicators

2017-04-01T23:33:40Z

AlisaNelson:

= '''United Nations Statistics Division: Millennium Development Goals (MDG) Indicators''' =

The Millennium Development Goals (MDG) database presents the official data, definitions, methodologies and sources for more than 60 indicators to measure progress towards the eight MDGs. The data and analyses are the product of the work of the [http://mdgs.un.org/unsd/mdg/Host.aspx?Content=IAEG.htm Inter-agency and Expert Group (IAEG) on MDG Indicators], coordinated by the United Nations Statistics Division. Data is provided from 1989 to present on the 189 UN member countries. The IFs system uses data on health, demographics, and sanitation.

{| cellspacing="0" border="1" bgcolor="#ffffff"
|+ '''DataDict'''
|-
! bgcolor="#c0c0c0" | Table
! bgcolor="#c0c0c0" | Source
! bgcolor="#c0c0c0" | Last IFs Update
! bgcolor="#c0c0c0" | UsedInPreprocessorFileName
|- valign="top"
| SeriesAidDon%GNI
| United Nations Statistics Division
| 12/02/17
| ECON
|- valign="top"
| SeriesHealthChilSleepTreatedNets
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesAidDonLDCs%GNI
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesPopContrUseTotal%UN
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesPopContrUseModern%UN
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesHealthTBDthsper100000
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesHealthHIVWomKnowCondsProt
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesHealthHIVWomCompreKnow
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesHealthHIVRateWomAnteNatal
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesHealthHIVWomCondUse
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesHealthBrthsAttnSkilledPers
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesPopSlum%Urban
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesHealthMalarChilTreated
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesMalnChil%WeightModSevere
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesMalnChil%WeightSevere
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesMalnPop%UN
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesSafImprovedWaterUN%
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesSafImprovedWaterUN%Rural
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesSanitationAccess%UN
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesSanitationAccessRural%UN
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesWomParlUN%
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|- valign="top"
| SeriesHealthHIVMenCondUse
| United Nations Statistics Division available at [http://mdgs.un.org/unsd/mdg/ http://mdgs.un.org/unsd/mdg/]
| 12/02/17
| 
|}

== Importing Data ==

<samp></samp>Data can be found on the UN Statistics division [http://mdgs.un.org/unsd/mdg/default.aspx website] under the Data tab > Country Level Data. The names of the series can then be searched. The series, as seen in the UN Statistics Division Dataset are as follows. Note that blank definitions mean the series was not found.

{| border="0" cellpadding="0" cellspacing="0" width="445"
|- height="20"
| height="20" width="158" | '''Series'''
| width="287" | '''Definition from Source'''
|- height="40"
| height="40" width="158" | SeriesAidDon%GNI
| width="287" | Net ODA as a percentage of OECD/DAC donors GNI
|- height="40"
| height="40" width="158" | SeriesAidDonLDCs%GNI
| width="287" | Net ODA to LDCs as a percentage of OECD/DAC donors GNI
|- height="40"
| height="40" width="158" | SeriesHealthBrthsAttnSkilledPers
| width="287" | Births attended by skilled health personnel, percentage
|- height="40"
| height="40" width="158" | SeriesHealthChilSleepTreatedNets
| width="287" | Children under 5 sleeping under insecticide-treated bed nets, percentage
|- height="40"
| height="40" width="158" | SeriesHealthHIVMenCondUse
| width="287" | Condom use at last high-risk sex, 15-24 years old, men, percentage
|- height="40"
| height="40" width="158" | SeriesHealthHIVRateWomAnteNatal
| width="287" |
|- height="60"
| height="60" width="158" | SeriesHealthHIVWomCompreKnow
| width="287" | Women 15-24 years old with comprehensive correct knowledge of HIV/AIDS, percentage
|- height="40"
| height="40" width="158" | SeriesHealthHIVWomCondUse
| width="287" | Condom use at last high-risk sex, 15-24 years old, women, percentage
|- height="40"
| height="40" width="158" | SeriesHealthHIVWomKnowCondsProt
| width="287" |
|- height="40"
| height="40" width="158" | SeriesHealthMalarChilTreated
| width="287" | Children under 5 with fever being treated with anti-malarial drugs, percentage
|- height="40"
| height="40" width="158" | SeriesHealthTBDthsper100000
| width="287" | Tuberculosis death rate per year per 100,000 population (mid-point)
|- height="40"
| height="40" width="158" | SeriesMalnChil%WeightModSevere
| width="287" | Children under 5 moderately or severely underweight, percentage
|- height="40"
| height="40" width="158" | SeriesMalnChil%WeightSevere
| width="287" | Children under 5 severely underweight, percentage
|- height="20"
| height="20" width="158" | SeriesMalnPop%UN
| width="287" | Population undernourished, percentage
|- height="60"
| height="60" width="158" | SeriesPopContrUseModern%UN
| width="287" | Current contraceptive use among married women 15-49 years old, modern methods, percentage
|- height="60"
| height="60" width="158" | SeriesPopContrUseTotal%UN
| width="287" | Current contraceptive use among married women 15-49 years old, any method, percentage
|- height="40"
| height="40" width="158" | SeriesPopSlum%Urban
| width="287" | Slum population as percentage of urban, percentage
|- height="40"
| height="40" width="158" | SeriesSafImprovedWaterUN%
| width="287" | Proportion of the population using improved drinking water sources, total
|- height="40"
| height="40" width="158" | SeriesSafImprovedWaterUN%Rural
| width="287" | Proportion of the population using improved drinking water sources, rural
|- height="40"
| height="40" width="158" | SeriesSanitationAccess%UN
| width="287" | Proportion of the population using improved sanitation facilities, total
|- height="40"
| height="40" width="158" | SeriesSanitationAccessRural%UN
| width="287" | Proportion of the population using improved sanitation facilities, rural
|- height="40"
| height="40" width="158" | SeriesWomParlUN%
| width="287" | Seats held by women in national parliament, percentage
|}

Select the series, then "All Countries" in the country tab and click the "View Data" button. From the data viewing screen, the data can be downloaded as an excel file which is ready for [http://pardee.du.edu/wiki/index.php?title=Importing_data_(general_instructions) import into IFs]. A country concordance table ("UN Statistics Division") was created for this series - this is the country concordance that should be used.

Carbon Dioxide Information and Analysis Center (CDIAC)

2017-01-12T23:54:09Z

AlisaNelson:

The EmissionsCarbonCDIAC data comes from the Carbon Dioxide Information Analysis Center (CDIAC) and is currently [http://cdiac.ornl.gov/trends/emis/tre_coun.html available online]. As this website will no longer be accessible past September 30, 2017, a new link to the data, which will be available through the US Department of Energy, will be provided when necessary.

The CDIAC is located at the Oak Ridge National laboratory and functions underneath the US Department of Energy, focusing on global climate change research. The organization publishes a number of datasets, including data on climate, atmospheric gases, and vegetation. The only data from the CDIAC used in IFs is total fossil-fuel CO2 emissions, which is available from 1751 to 2013, but has been imported to IFs beginning in the year 1800.

== CDIAC Calculations ==

The CO2 emissions prior to 1950 were calculated using historical energy statistics found in academic publications. Post-1950 emissions data has mostly come from energy statistics published by the United Nations. See more detail on the CDIAC methods and sources [http://cdiac.ornl.gov/trends/emis/overview_2013.html here].

Two main equations, derived from the work of [http://journals.co-action.net/index.php/tellusb/article/viewFile/14907/16719 Marland and Rotty (1984)] and [https://www.osti.gov/scitech/biblio/207068/ Boden et. al (1995)], were used in calculating carbon emissions for this data. In order to calculate the CO2 emissions from fossil fuels, three variables were used, including the amount of fuel produced and consumed (P), the fraction of the fuel that becomes oxidized (FO), and a factor for carbon content of the fuel (C). The following equation was used:

<math>CO_2{_i} = (P_i) (FO_i) (C_i) </math>

where <math> _i </math> is the group of fuel being calculated, chosen from gases, liquids, or solids. This equation was used to calculate global CO2 estimates for each fuel group. A total of the caclulations for each group was then used to calculate the total CO2 emissions for each country, used in IFs. In order to estimate the amount of fuel consumed (P), another equation was used:

<math>Consumption  = production + imports - exports - bunkers - changes in stocks </math>

where "bunkers" refers to fuel used by ships and aircraft used in international trade.

== Negative Emissions ==

There are negative emissions for a number of countries in this dataset, for Australia in the 1950s, Venezuela in 1930, and Iran in 1950, among others. A possible explanation has been provided by the CDIAC in their discussion of the CO2 trends for the [http://cdiac.ornl.gov/trends/emis/tre_ira.html Islamic Republic of Iran]:

''Energy statistics for the Islamic Republic of Iran in the early 1950s and the corresponding CO2 emissions estimates should be used with caution. Domestic fuel consumption is calculated as the difference between production plus imports and exports plus changes in stocks. When both production and exports are very large and very similar, a small error in either estimate can make it appear that domestic consumption was negative.''

This is a plausible explanation for other countries with negative emissions, as they were all for years in the late 1800s or early to mid 1900s, or had poor data availability during the years their emissions appear negative.

== Pulling CDIAC Fossil Fuel CO2 Emissions Data ==

For general instructions on how to import data into IFs, visit the [http://pardee.du.edu/wiki/index.php?title=Importing_data_(general_instructions) data import page].

Carbon Dioxide Information and Analysis Center (CDIAC)

2017-01-12T23:37:21Z

AlisaNelson:

The EmissionsCarbonCDIAC data comes from the Carbon Dioxide Information Analysis Center (CDIAC) and is currently [http://cdiac.ornl.gov/trends/emis/tre_coun.html available online]. As this website will no longer be accessible past September 30, 2017, a new link to the data, which will be available through the US Department of Energy, will be provided when necessary.

The CDIAC is located at the Oak Ridge National laboratory and functions underneath the US Department of Energy, focusing on global climate change research. The organization publishes a number of datasets, including data on climate, atmospheric gases, and vegetation. The only data from the CDIAC used in IFs is total fossil-fuel CO2 emissions, which is available from 1751 to 2013, but has been imported to IFs beginning in the year 1800.

== CDIAC Calculations ==

The CO2 emissions prior to 1950 were calculated using historical energy statistics found in academic publications. Post-1950 emissions data has mostly come from energy statistics published by the United Nations. See more detail on the CDIAC methods and sources [http://cdiac.ornl.gov/trends/emis/overview_2013.html here].

Two main equations, derived from the work of [http://journals.co-action.net/index.php/tellusb/article/viewFile/14907/16719 Marland and Rotty (1984)] and [https://www.osti.gov/scitech/biblio/207068/ Boden et. al (1995)], were used in calculating carbon emissions for this data. In order to calculate the CO2 emissions from fossil fuels, three variables were used, including the amount of fuel produced and consumed (P), the fraction of the fuel that becomes oxidized (FO), and a factor for carbon content of the fuel (C). The following equation was used:

CO2i = (Pi) (FOi) (Ci)

where ''i'' is the group of fuel being calculated, chosen from gases, liquids, or solids. This equation was used to calculate global CO2 estimates for each fuel group. A total of the caclulations for each group was then used to calculate the total CO2 emissions for each country, used in IFs. In order to estimate the amount of fuel consumed (P), another equation was used:

Consumption  = production + imports - exports - bunkers - changes in stocks

where "bunkers" refers to fuel used by ships and aircraft used in international trade.

== Negative Emissions ==

There are negative emissions for a number of countries in this dataset, for Australia in the 1950s, Venezuela in 1930, and Iran in 1950, among others. A possible explanation has been provided by the CDIAC in their discussion of the CO2 trends for the [http://cdiac.ornl.gov/trends/emis/tre_ira.html Islamic Republic of Iran]:

''Energy statistics for the Islamic Republic of Iran in the early 1950s and the corresponding CO2 emissions estimates should be used with caution. Domestic fuel consumption is calculated as the difference between production plus imports and exports plus changes in stocks. When both production and exports are very large and very similar, a small error in either estimate can make it appear that domestic consumption was negative.''

This is a plausible explanation for other countries with negative emissions, as they were all for years in the late 1800s or early to mid 1900s, or had poor data availability during the years their emissions appear negative.

== Pulling CDIAC Fossil Fuel CO2 Emissions Data ==

For general instructions on how to import data into IFs, visit the [http://pardee.du.edu/wiki/index.php?title=Importing_data_(general_instructions) data import page].

Carbon Dioxide Information and Analysis Center (CDIAC)

2017-01-12T23:36:34Z

AlisaNelson:

The EmissionsCarbonCDIAC data comes from the Carbon Dioxide Information Analysis Center (CDIAC) and is currently <a href="[http://cdiac.ornl.gov/trends/emis/tre_coun.html http://cdiac.ornl.gov/trends/emis/tre_coun.html]" alt="[http://cdiac.ornl.gov/trends/emis/tre_coun.html http://cdiac.ornl.gov/trends/emis/tre_coun.html]" title="[http://cdiac.ornl.gov/trends/emis/tre_coun.html http://cdiac.ornl.gov/trends/emis/tre_coun.html]">available online</a>. As this website will no longer be accessible past September 30, 2017, a new link to the data, which will be available through the US Department of Energy, will be provided when necessary.

The CDIAC is located at the Oak Ridge National laboratory and functions underneath the US Department of Energy, focusing on global climate change research. The organization publishes a number of datasets, including data on climate, atmospheric gases, and vegetation. The only data from the CDIAC used in IFs is total fossil-fuel CO2 emissions, which is available from 1751 to 2013, but has been imported to IFs beginning in the year 1800.

== CDIAC Calculations ==

The CO2 emissions prior to 1950 were calculated using historical energy statistics found in academic publications. Post-1950 emissions data has mostly come from energy statistics published by the United Nations. See more detail on the CDIAC methods and sources <a href="[http://cdiac.ornl.gov/trends/emis/overview_2013.html http://cdiac.ornl.gov/trends/emis/overview_2013.html]" alt="[http://cdiac.ornl.gov/trends/emis/overview_2013.html http://cdiac.ornl.gov/trends/emis/overview_2013.html]" title="[http://cdiac.ornl.gov/trends/emis/overview_2013.html http://cdiac.ornl.gov/trends/emis/overview_2013.html]">here</a>.

Two main equations, derived from the work of <a href="[http://journals.co-action.net/index.php/tellusb/article/viewFile/14907/16719 http://journals.co-action.net/index.php/tellusb/article/viewFile/14907/16719]" alt="[http://journals.co-action.net/index.php/tellusb/article/viewFile/14907/16719 http://journals.co-action.net/index.php/tellusb/article/viewFile/14907/16719]" title="[http://journals.co-action.net/index.php/tellusb/article/viewFile/14907/16719 http://journals.co-action.net/index.php/tellusb/article/viewFile/14907/16719]">Marland and Rotty (1984)</a> and <a href="[https://www.osti.gov/scitech/biblio/207068/ https://www.osti.gov/scitech/biblio/207068/]" alt="[https://www.osti.gov/scitech/biblio/207068/ https://www.osti.gov/scitech/biblio/207068/]" title="[https://www.osti.gov/scitech/biblio/207068/ https://www.osti.gov/scitech/biblio/207068/]">Boden et. al (1995)</a>, were used in calculating carbon emissions for this data. In order to calculate the CO2 emissions from fossil fuels, three variables were used, including the amount of fuel produced and consumed (P), the fraction of the fuel that becomes oxidized (FO), and a factor for carbon content of the fuel (C). The following equation was used: <math>CO2i = (Pi) (FOi) (Ci)/,<math>
where i is the group of fuel being calculated, chosen from gases, liquids, or solids. This equation was used to calculate global CO2 estimates for each fuel group. A total of the caclulations for each group was then used to calculate the total CO2 emissions for each country, used in IFs. In order to estimate the amount of fuel consumed (P), another equation was used:
Consumption  = production + imports - exports - bunkers - changes in stocks
where "bunkers" refers to fuel used by ships and aircraft used in international trade.

<h2> Negative Emissions </h2>
There are negative emissions for a number of countries in this dataset, for Australia in the 1950s, Venezuela in 1930, and Iran in 1950, among others. A possible explanation has been provided by the CDIAC in their discussion of the CO2 trends for the <a href="http://cdiac.ornl.gov/trends/emis/tre_ira.html" alt="http://cdiac.ornl.gov/trends/emis/tre_ira.html" title="http://cdiac.ornl.gov/trends/emis/tre_ira.html">Islamic Republic of Iran</a>:
Energy statistics for the Islamic Republic of Iran in the early 1950s and the corresponding CO2 emissions estimates should be used with caution. Domestic fuel consumption is calculated as the difference between production plus imports and exports plus changes in stocks. When both production and exports are very large and very similar, a small error in either estimate can make it appear that domestic consumption was negative.
This is a plausible explanation for other countries with negative emissions, as they were all for years in the late 1800s or early to mid 1900s, or had poor data availability during the years their emissions appear negative.

<h2> Pulling CDIAC Fossil Fuel CO2 Emissions Data </h2>
For general instructions on how to import data into IFs, visit the <a href="http://pardee.du.edu/wiki/index.php?title=Importing_data_(general_instructions)" alt="http://pardee.du.edu/wiki/index.php?title=Importing_data_(general_instructions)" title="http://pardee.du.edu/wiki/index.php?title=Importing_data_(general_instructions)">data import page</a>.
</math>

Carbon Dioxide Information and Analysis Center (CDIAC)

2017-01-12T23:28:06Z

AlisaNelson:

The EmissionsCarbonCDIAC data comes from the Carbon Dioxide Information Analysis Center (CDIAC) and is currently [http://cdiac.ornl.gov/trends/emis/tre_coun.html available online]. As this website will no longer be accessible past September 30, 2017, a new link to the data, which will be available through the US Department of Energy, will be provided when necessary.

The CDIAC is located at the Oak Ridge National laboratory and functions underneath the US Department of Energy, focusing on global climate change research. The organization publishes a number of datasets, including data on climate, atmospheric gases, and vegetation. The only data from the CDIAC used in IFs is total fossil-fuel CO2 emissions, which is available from 1751 to 2013, but has been imported to IFs beginning in the year 1800.

== CDIAC Calculations ==

The CO2 emissions prior to 1950 were calculated using historical energy statistics found in academic publications. Post-1950 emissions data has mostly come from energy statistics published by the United Nations. See more detail on the CDIAC methods and sources [http://cdiac.ornl.gov/trends/emis/overview_2013.html here].

Two main equations, derived from the work of [http://journals.co-action.net/index.php/tellusb/article/viewFile/14907/16719 Marland and Rotty (1984)] and [https://www.osti.gov/scitech/biblio/207068/ Boden et. al (1995)], were used in calculating carbon emissions for this data. In order to calculate the CO2 emissions from fossil fuels, three variables were used, including the amount of fuel produced and consumed (P), the fraction of the fuel that becomes oxidized (FO), and a factor for carbon content of the fuel (C). The following equation was used:

CO2i = (Pi) (FOi) (Ci)

where ''i'' is the group of fuel being calculated, chosen from gases, liquids, or solids. This equation was used to calculate global CO2 estimates for each fuel group. A total of the caclulations for each group was then used to calculate the total CO2 emissions for each country, used in IFs. In order to estimate the amount of fuel consumed (P), another equation was used:

Consumption  = production + imports - exports - bunkers - changes in stocks

where "bunkers" refers to fuel used by ships and aircraft used in international trade.

== Negative Emissions ==

There are negative emissions for a number of countries in this dataset, for Australia in the 1950s, Venezuela in 1930, and Iran in 1950, among others. A possible explanation has been provided by the CDIAC in their discussion of the CO2 trends for the [http://cdiac.ornl.gov/trends/emis/tre_ira.html Islamic Republic of Iran]:

''Energy statistics for the Islamic Republic of Iran in the early 1950s and the corresponding CO2 emissions estimates should be used with caution. Domestic fuel consumption is calculated as the difference between production plus imports and exports plus changes in stocks. When both production and exports are very large and very similar, a small error in either estimate can make it appear that domestic consumption was negative.''

This is a plausible explanation for other countries with negative emissions, as they were all for years in the late 1800s or early to mid 1900s, or had poor data availability during the years their emissions appear negative.

== Pulling CDIAC Fossil Fuel CO2 Emissions Data ==

For general instructions on how to import data into IFs, visit the [http://pardee.du.edu/wiki/index.php?title=Importing_data_(general_instructions) data import page].

Carbon Dioxide Information and Analysis Center (CDIAC)

2017-01-09T16:30:32Z

AlisaNelson:

The EmissionsCarbonCDIAC data comes from the Carbon Dioxide Information Analysis Center (CDIAC) and is currently [http://cdiac.ornl.gov/trends/emis/tre_coun.html available online]. As this website will no longer be accessible past September 30, 2017, a new link to the data, which will be available through the US Department of Energy, will be provided when necessary.

The CDIAC is located at the Oak Ridge National laboratory and functions underneath the US Department of Energy, focusing on global climate change research. The organization publishes a number of datasets, including data on climate, atmospheric gases, and vegetation. The only data from the CDIAC used in IFs is total fossil-fuel CO2 emissions, which is available from 1751 to 2013, but has been imported to IFs beginning in the year 1800.

== CDIAC Calculations ==

The CO2 emissions prior to 1950 were calculated using historical energy statistics found in academic publications. Post-1950 emissions data has mostly come from energy statistics published by the United Nations. See more detail on the CDIAC methods and sources [http://cdiac.ornl.gov/trends/emis/overview_2013.html here].

Two main equations, derived from the work of [http://journals.co-action.net/index.php/tellusb/article/viewFile/14907/16719 Marland and Rotty (1984)] and [https://www.osti.gov/scitech/biblio/207068/ Boden et. al (1995)], were used in calculating carbon emissions for this data. In order to calculate the CO2 emissions from fossil fuels, three variables were used, including the amount of fuel produced and consumed (P), the fraction of the fuel that becomes oxidized (FO), and a factor for carbon content of the fuel (C). The following equation was used:

CO2i = (Pi) (FOi) (Ci)

where ''i'' is the group of fuel being calculated, chosen from gases, liquids, or solids. This equation was used to calculate global CO2 estimates for each fuel group. A total of the caclulations for each group was then used to calculate the total CO2 emissions for each country, used in IFs. In order to estimate the amount of fuel consumed (P), another equation was used:

Consumption  = production + imports - exports - bunkers - changes in stocks

where "bunkers" refers to fuel used by ships and aircraft used in international trade.

== Negative Emissions ==

There are negative emissions for a number of countries in this dataset, for Australia in the 1950s, Venezuela in 1930, and Iran in 1950, among others. A possible explanation has been provided by the CDIAC in their discussion of the CO2 trends for the [http://cdiac.ornl.gov/trends/emis/tre_ira.html Islamic Republic of Iran]:

''Energy statistics for the Islamic Republic of Iran in the early 1950s and the corresponding CO2 emissions estimates should be used with caution. Domestic fuel consumption is calculated as the difference between production plus imports and exports plus changes in stocks. When both production and exports are very large and very similar, a small error in either estimate can make it appear that domestic consumption was negative.''

This is a plausible explanation for other countries with negative emissions, as they were all for years in the late 1800s or early to mid 1900s, or had poor data availability during the years their emissions appear negative.

== Pulling CDIAC Fossil Fuel CO2 Emissions Data ==

Carbon Dioxide Information and Analysis Center (CDIAC)

2017-01-09T16:13:33Z

AlisaNelson:

<parsererror>XML Parsing Error: not well-formed Location: http://pardee.du.edu/wiki/index.php?title=Carbon_Emissions_Data_(CDIAC)&action=edit Line Number 2, Column 14:<sourcetext>font-family:"Calibri",sans-serif;mso-fareast-font-family:"Times New Roman"; -------------^</sourcetext></parsererror>

Carbon Dioxide Information and Analysis Center (CDIAC)

2017-01-06T23:03:54Z

AlisaNelson:

Carbon Dioxide Information and Analysis Center (CDIAC)

2017-01-06T22:11:58Z

AlisaNelson: Created page with "The EmissionsCarbonCDIAC data comes from the Carbon Dioxide Information Analysis Center and is currently [http://cdiac.ornl.gov/trends/emis/tre_coun.html available online]."

The EmissionsCarbonCDIAC data comes from the Carbon Dioxide Information Analysis Center and is currently [http://cdiac.ornl.gov/trends/emis/tre_coun.html available online].

Environmental data

2017-01-06T22:04:12Z

AlisaNelson:

Back to [[Data|data]]

[[Environmental_preprocessor|Environmental preprocessor]]

[[Carbon_Emissions_Data_(CDIAC)]]

Environmental preprocessor

2017-01-05T23:43:54Z

AlisaNelson:

= Sources =

[[FAO|FAO]], [[WRI|WRI]], [[World_Development_Indicators|WDI]], [[Global_Footprint_Network|Global_Footprint_Network]], 

= Environmental series pulled into the model  =

{| cellspacing="0" border="1" bgcolor="#ffffff"
|+ '''DataDict'''
|-
! bgcolor="#c0c0c0" | Table
! bgcolor="#c0c0c0" | Source
! bgcolor="#c0c0c0" | Last IFs Update
! bgcolor="#c0c0c0" | UsedInPreprocessorFileName
|- valign="top"
| SeriesEnvAvgAnnTemp
| [http://www.cgd.ucar.edu/cas/wigley/magicc/ http://www.cgd.ucar.edu/cas/wigley/magicc/] and [http://na.unep.net/globalpop/1-degree/description.php http://na.unep.net/globalpop/1-degree/description.php]
| 2009/07/27
| ENV
|- valign="top"
| SeriesEnvAvgAnnTempChg
| [http://www.cgd.ucar.edu/cas/wigley/magicc/ http://www.cgd.ucar.edu/cas/wigley/magicc/] and [http://na.unep.net/globalpop/1-degree/description.php http://na.unep.net/globalpop/1-degree/description.php]
| 2009/07/27
| ENV
|- valign="top"
| SeriesEnvPrecipitation
| [http://www.cgd.ucar.edu/cas/wigley/magicc/ http://www.cgd.ucar.edu/cas/wigley/magicc/] and [http://na.unep.net/globalpop/1-degree/description.php http://na.unep.net/globalpop/1-degree/description.php]
| 2009/07/27
| ENV
|- valign="top"
| SeriesEnvPrecipitationChg
| [http://www.cgd.ucar.edu/cas/wigley/magicc/ http://www.cgd.ucar.edu/cas/wigley/magicc/] and [http://na.unep.net/globalpop/1-degree/description.php http://na.unep.net/globalpop/1-degree/description.php]
| 2009/07/27
| ENV
|- valign="top"
| SeriesEnvPM10
| [[World_Development_Indicators|WDI 2014 May BATCH PULL]]
| 2014/06/11
| ENV
|- valign="top"
| SeriesEmissionsCarbonCDIAC
| Carbon Dioxide Information Analysis Center 
| 2013/08/06
| ENV
|- valign="top"
| SeriesEnvSolidFuelsImproved
| Randall Kuhn prepared it from GACC tables and remove the ones that were implausible and for tiny countries. Then added regional figures based on the old WHO data, basically taking the lower of the rural and urban figures.
| 2013/12/19
| ENV
|}

Global Health Observatory (GHO)

2016-05-14T00:29:00Z

AlisaNelson:

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 =

{| bgcolor="#ffffff" border="1" cellspacing="0"
|+ '''DataDict 720'''
|-
! bgcolor="#c0c0c0" | Table
! bgcolor="#c0c0c0" | Group
! bgcolor="#c0c0c0" | Definition
! bgcolor="#c0c0c0" | Source
! bgcolor="#c0c0c0" | Last IFs Update
! bgcolor="#c0c0c0" | UsedInPreprocessor
! bgcolor="#c0c0c0" | Years
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| SeriesHealthMortNeoNatAsphyxia%
| Population, Health
| Neonatal deaths due to asphyxia
| 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]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| SeriesHealthMortNeoNatDiarrh%
| Population, Health
| Neonatal deaths due to diarrhoea
| 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]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| SeriesHealthMortNeoNatInfect%
| Population, Health
| Neonatal deaths due to infection
| 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]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2008/07/11
| align="RIGHT" | No
| 
|- valign="TOP"
| SeriesHealthMortNeoNatTetanus%
| Population, Health
| Neonatal deaths due to tetanus
| 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]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2006/12
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2006/12
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2006/12
| align="RIGHT" | No
| 
|- valign="TOP"
| SeriesHealthPolioCasesConf
| Population, Health
| Number of confirmed poliomyelitis cases
| 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]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2006/12
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2006/12
| align="RIGHT" | 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= 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.

Global Health Observatory (GHO)

2016-04-29T22:02:14Z

AlisaNelson:

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 =

{| bgcolor="#ffffff" border="1" cellspacing="0"
|+ '''DataDict 720'''
|-
! bgcolor="#c0c0c0" | Table
! bgcolor="#c0c0c0" | Group
! bgcolor="#c0c0c0" | Definition
! bgcolor="#c0c0c0" | Source
! bgcolor="#c0c0c0" | Last IFs Update
! bgcolor="#c0c0c0" | UsedInPreprocessor
! bgcolor="#c0c0c0" | Years
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| SeriesHealthMortNeoNatAsphyxia%
| Population, Health
| Neonatal deaths due to asphyxia
| 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]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| SeriesHealthMortNeoNatDiarrh%
| Population, Health
| Neonatal deaths due to diarrhoea
| 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]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| SeriesHealthMortNeoNatInfect%
| Population, Health
| Neonatal deaths due to infection
| 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]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2008/07/11
| align="RIGHT" | No
| 
|- valign="TOP"
| SeriesHealthMortNeoNatTetanus%
| Population, Health
| Neonatal deaths due to tetanus
| 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]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2006/12
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2006/12
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2006/12
| align="RIGHT" | No
| 
|- valign="TOP"
| SeriesHealthPolioCasesConf
| Population, Health
| Number of confirmed poliomyelitis cases
| 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]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2006/12
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/06
| align="RIGHT" | Yes
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2007/01
| align="RIGHT" | No
| 
|- valign="TOP"
| 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 http://www3.who.int/whosis/core/core_select.cfm]
| 2006/12
| align="RIGHT" | 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.