Friday, September 2, 2011

QWIDS

These days, my task at the ISU relates to making use of the OECD DAC Database (http://stats.oecd.org/qwids/) to dig deeper as concerns a presentation that Kerry delivered at the Albanian Cooperation and Assistance Symposium on 31 May

From this database, I was able to obtain big numbers associated with the investments made by the OECD DAC Members which are States Parties that are responsible for helping other States Parties with significant numbers of survivors for five “detailed sector codes”: basic health care, basic health infrastructure, health personnel development, medical education and training, and medical services, from 2005 to 2009

 What I have to do now is find out what exactly have States Parties that are OECD DAC Members invested in with respect to basic health care, basic health infrastructure, health personnel development, medical education and training, and, medical services in States that are responsible for a significant number of landmine survivors? Who has provided what, when, specifically for what through / to whom?

As a starting point I have use one detailed sector code for one affected State Party (perhaps starting with Cambodia, followed by Ethiopia, Mozambique and Uganda) and compiled an inventory of what each State Party that is an OECD DAC Member has done in 2005.  The next step will be to do the same for 206-2009.  With this Query Wizard I am able to get a table that represents everything that all of the donors in question have spent in the affected country in question for matters related to the detailed sector code in question in each year from 2005 to 2009. Each entry in the table should link to additional information regarding what the investment represents. This additional Information may be slim. However, it could be used as a starting point to pursue complementary information from the relevant aid agency’s web site.

Anyhow, this is what I will be doing for the next couple of weeks.  I just thought it would be interesting to share what type of work I’m doing.