The DHS Program User Forum      
Discussions regarding The DHS Program data and results
Home » Dissemination and Capacity Strengthening » Application Programming Interface (API)  » Child health data in API
Child health data in API [message #9726] Tue, 10 May 2016 14:37 Go to next message
Messages: 4
Registered: April 2016
I have used the API to extract information on childhood illness - % children with ARI, Fever and Diarrhea, and % of children treated for the same.

I get 2 values for each survey/indicator/group combination. For example, in the Yemen 2013 survey, for % of children not treated for diarrhea, there are 2 values returned for each wealth quintile.

When referring to the original data, it appears that these 2 values correspond to children born in the past 3 years, and those born in the past 5 years. However, there is no way to distinguish or label this information in the dataset.

Do you have any suggestions for how to CONSISTENTLY capture only 1 of these 2 values for each country and indicator of interest? In other words, I want to be sure that I only keep the values corresponding to children born in the past 5 years.

Thank you
Re: Child health data in API [message #9728 is a reply to message #9726] Tue, 10 May 2016 15:29 Go to previous message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 533
Registered: January 2013
Senior Member
You are correct that the data are for children born in the 3 years preceding the survey or the five years preceding the survey. This information is returned in the field ByVariableLabel and you can use that field to then filter the data. Alternatively you can use ByVariableId as follows:
ByVariableId, ByVariableLabel
14000, Three years preceding the survey
14001, Five years preceding the survey

To get just the data for children born in the five years preceding the survey you will need to access the data for both first and then filter on just the latter. There is no way at present to filter the data at the time of the call - you need to do the filtering after you receive the data. However we are looking at putting some more advanced filtering into the API in the future.
Previous Topic: Child health data in API
Goto Forum:

Current Time: Tue Oct 17 05:47:47 Eastern Daylight Time 2017