Data warehouse for project proposals in humanitarian assistance

I posted the following at Opendata, please, if you are a programmer, contribute:

Proof of concept: Data warehouse for project proposals in humanitarian assistance:

For the moment nearly every donor and every UN-agency requires project forms to be filled according to their own template. They are quite strict on this, and non-compliance leads to delays in approval or even refusal.

When analysing the requirements however, it is obvious that the content in most forms is for 90 % the same. It should be possible to use a common database, with 90 % common data, and the additional data depending on the needs of the donor.

The application would be a website, where the applicant chooses first the donor he wishes to apply for. The webpage will let him fill in the form for this donor, but save the data in a common database. In an official version, it would be possible to submit from the site electronically to the donor.

If the application is unsuccessful, the applicant would be able to choose in a new donor, and fill in only the missing fields, without the need to reformat everything.

When this application would be accepted by the donors and NGOs alike, the project data would authorize learning to a very high degree: most open data efforts only make metadata available, like budgets, and project title. With this data warehouse coördination and comparative evaluation would be much facilitated, as all data are in the same format.

The proof of concept would bring together the forms of the major humanitarian donors: ECHO (European Commission), USAID, DFID, Sida, Germany.


This effort could provide the ” hardware” (ok, technically software) of the “new accountability paradigm to reflect the reality of the Aid Industrial Complex“, and links up with the IATI effort for transparency.

This entry was posted in development and tagged . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.