Tania.Blanga: Added images to steps

2023-02-17T04:45:51Z

Added images to steps

← Older revision		Revision as of 04:45, 17 February 2023
Line 21:		Line 21:


	'''Step 1:''' To pull Mortality Database data, first navigate to the [https://platform.who.int/mortality Mortality Database] page		'''Step 1:''' To pull Mortality Database data, first navigate to the [https://platform.who.int/mortality Mortality Database] page. In this example, we will be pulling data for Child Mortality Rate.

			[[File:MORT STEP1.png\|frameless\|750x750px]]

	~~In this example, we will be pulling data for '''SeriesHealthMortChilRateFem''', '''SeriesHealthMortChilRateMale''', and '''SeriesHealthMortChilRateTotal''' (Child Mortality Rate)~~


	'''Step 2:''' Scroll down to the Causes of Death Explorer tab and select the correct cause. In our example, we will select ''all causes''


			'''Step 2:''' Scroll down to the Causes of Death Explorer tab and select the correct cause. In our example, we will select "all causes"

			[[File:MORT STEP2.png\|frameless\|750x750px]]



	You will be navigated to this page:		You will be navigated to this page:

			[[File:MORT STEP2A.png\|frameless\|750x750px]]



	'''Step 3:''' Select the Map icon		'''Step 3:''' Select the Map icon

			[[File:MORT STEP3.png\|frameless\|750x750px]]



	You will be navigated to this page:		You will be navigated to this page:

			[[File:MORT STEP3A.png\|frameless\|750x750px]]



			'''Step 4:''' Select all of the relevant filters. In our example, we will set the country filter as "select all" and data type filter as "Age-standardized death rate per 100 000 standard population".

			[[File:MORT STEP4.png\|frameless\|750x750px]]

	~~'''Step 4:''' Select all of the relevant filters. In our example, we will select the country and data type filters as shown below.~~


	'''Step 5:''' Once you've selected your filters, select the Export Data icon		'''Step 5:''' Once you've selected your filters, select the Export Data icon

			[[File:MORT STEP5.png\|frameless\|750x750px]]



	This pop-up will appear:		This pop-up will appear:

			[[File:MORT STEP5A.png\|frameless\|750x750px]]
	~~'''Step 6~~:~~''' Select the first drop down titled "filtered data" and select "full data"~~


	'''Step 7:''' Under the second drop down titled "Years", select "Select All" to select all available years		'''Step 6:''' Select the first drop down titled "filtered data" and select "full data". Under the second drop down titled "Years", select "Select All" to select all available years. Under the third drop down titled "Age Groups", select the desired age group (for our example, we will select 1-4).

			[[File:MORT STEP6.png\|frameless\|750x750px]]

	~~'''Step 8:''' Under the third drop down titled "Age Groups", select the desired age group. For our example, we will select 1-4~~

			'''Step 7:''' After you've selected everything, click Export to download the data in a .csv format. For our example, this download will have data for all three series that can later be filtered and cleaned in Excel.

	~~'''Step 9~~:''' After you've selected everything, click Export to download the data in a .csv format. For our example, this download will have data for all three series that can later be filtered and cleaned in Excel.		[[File:MORT STEP7.png\|frameless\|750x750px]]

Tania.Blanga: Added summary and pulling instructions

2023-02-09T22:19:37Z

Added summary and pulling instructions

New page

== Summary ==
The WHO Mortality Database is a compilation of mortality data by country and area, year, sex, age and cause of death, updated annually through data provided by national authorities from their civil registration and vital statistics system. The WHO Mortality Database is the leading data source for comparative epidemiological studies of mortality by cause and provides cause-of-death data from 1950 to date.

The Data Team uses this dataset for a number of series, including:

* '''SeriesHealthMortAdultRateFemale'''
* '''SeriesHealthMortAdultRateMale'''
* '''SeriesHealthMortChilRateFem'''
* '''SeriesHealthMortChilRateMale'''
* '''SeriesHealthMortChilRateTotal'''
* '''SeriesHealthTBrateHIVnegWHO'''
* '''SeriesHealthTBrateHIVposWHO'''
* '''SeriesHealthMaternDthsper100000'''
* '''SeriesHealthDiarrhoeaDthsPerYearF0to4'''

To pull data from the Mortality Database for uploading into IFs, please follow the instructions below.

== Pulling Instructions ==

'''Step 1:''' To pull Mortality Database data, first navigate to the [https://platform.who.int/mortality Mortality Database] page

In this example, we will be pulling data for '''SeriesHealthMortChilRateFem''', '''SeriesHealthMortChilRateMale''', and '''SeriesHealthMortChilRateTotal''' (Child Mortality Rate)

'''Step 2:''' Scroll down to the Causes of Death Explorer tab and select the correct cause. In our example, we will select ''all causes''

You will be navigated to this page:

'''Step 3:''' Select the Map icon

You will be navigated to this page:

'''Step 4:''' Select all of the relevant filters. In our example, we will select the country and data type filters as shown below.

'''Step 5:''' Once you've selected your filters, select the Export Data icon

This pop-up will appear:

'''Step 6:''' Select the first drop down titled "filtered data" and select "full data"

'''Step 7:''' Under the second drop down titled "Years", select "Select All" to select all available years

'''Step 8:''' Under the third drop down titled "Age Groups", select the desired age group. For our example, we will select 1-4

'''Step 9:''' After you've selected everything, click Export to download the data in a .csv format. For our example, this download will have data for all three series that can later be filtered and cleaned in Excel.

Mortality Database - Revision history

Tania.Blanga: Added images to steps

Tania.Blanga: Added summary and pulling instructions