Data set: 1986 Surveys of disadvantaged areas and groups in Mogadishu

Why:  This post is expected to the beginning of a series of posts that will make a number of data sets that I have accumulated over the year publicly available and thus open to wider analysis and use. It would be useful if this data set could be found a home within a website that specialises in Open Data for development purposes and which includes data generated by NGOs, and not just big organisations such as the World Bank

Background on this data set

In 1986 Oxfam UK, CCFD France and UNICEF funded BOCD Somalia (now known as Progressio) to carry out an extensive survey of disadvantaged areas and groups within Mogadishu, Somalia.

The findings of that survey and related research were documented in a report published in 1988, which is now available as a pdf

The survey results were digitalised in 1986 and have been preserved since then. Although the original software package that was used (Trajectories) is not longer in public use (and was never very easy to use) the original data files can be read by Excel, and with some effort re-formated to make them easy to analyse.

The process of converting the 1986 files into usable Excel files is now underway. Progress will be reported here.

  • Waaberi . This district, shown here on Google Maps, was chosen for use as a comparison group, based on its the middle income status of its households, as identified by a prior household survey. The data set contains information on 36 fields on 218 households. The sampling process is described in page 363 of the above report. The Waaberi Excel file contains the following information:
    • Raw data
    • Questions used and answer codes. The original Somali language survey form, used in the six area focused survey is available here in pdf format
    • References to previous analysis,
    • Terms and Conditions
    • Citation and attribution requirements
  • Gubadley. This was a squatter area to the NE of the city, now shown as Degmada Heliwaa on Google Maps. The data set contains information on 82 fields on 218 households. The sampling process is described in page 363 of the above report. The Gubadley Excel file contains the same supporting information as in the Waaberi file above.
  • Yet to come
    • Areas
      • Yaqshiid (Heegan obbosibo)
      • Karaan (Beesha Shukri obbosibo)
      • Wadajir (Damme Yasin obbosibo)
      • Wadajir (Halane obbosibo)
      • Cabdul Casiis
    • Groups
      • Market women
      • Street children
      • Working children
      • Beggars
      • Prostitutes

Inquiries about these data sets should be directed to



%d bloggers like this: