Status:Closed    Asked:Oct 04, 2015 - 09:56 AM

Creating kenya population estimates

Hi, I'm new to using and analyzing IPUMS data.

I'm trying to use IPUMS data for Kenya to estimate population densities by district in Kenya over time. (And am also interested in other variables in association with population).

Is there a way to use the IPUMS data to make population density estimates? I am guessing that I will have to arrange the data in Stata first by district, though I'm not sure how to do that.

Also, when exporting data from Stata into Excel or .cvs to be used in arcGIS, I know that there are case number limitations. Will this be solved if I arrange the data differenty (such as by district?)

Thanks so much

Do you have the same question? Follow this Question

Staff Answer




It is not possible to directly estimate district-level population density for Kenyan districts over time purely using IPUMS-International microdata. Rather, you can estimate the population of a district with IPUMS data and then use a non-IPUMS source to determine the area of the district. The population of a district is simply the sum of the PERWT values for each respondent in that district.

Note that the boundaries of Kenyan districts have changed over time. The IPUMS district variable, GEO2_KEX, harmonizes districts by name, but it does not account for the inconsistent boundaries. As a result, GEO2_KEX is not perfectly comparable over time.

As for exporting from STATA to Excel for use in ArcGIS, yes, you will want to group your output by districts, instead of exporting one observation per respondent.

Hope this helps.


Oct 05, 2015 - 03:44 PM

Report it


USA IPUMS 1980 ancestry variable -- mapping to country names
Did the version of database change since 2011?
Are DATANUM, SERIAL, and PERNUM the same in single-year and 5-year ACS sample...
How can I accurately calculate the median family income by state for families...
Detailed Variables Dropping From Dataset
Are weights adjusted when using "select cases" in an extraction?
Login   |   Register

Share |