| Child health data in API [message #9726] |
Tue, 10 May 2016 14:37  |
nchakraborty
Messages: 6
Registered: April 2016
|
Member |
|
|
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  |
Trevor-DHS
Messages: 802
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.
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
