The data used for this visualisation was collected as part of the Donor Division of Labour Exercise conducted in 2006–2007 in the Aid Information Map (AIM).* All mistakes, errors and omissions in this visualization are the responsibility of Publish What You Fund alone. The data and research reported here do not reflect the official view of the Ministry of Finance, Planning and Economic Development. This data is not used by the Government of Uganda to allocate resources or for any other official purpose and no ministry staff were involved in the development of this visualization.
*For more details see http://www.odi.org.uk/work/projects/details.asp?id=143&title=uganda-development-partner-division-labour-exercise, report http://www.odi.org.uk/work/projects/details.asp?id=143&title=uganda-development-partner-division-labour-exercise.
The Google Spreadsheet in this package shows spending by the Ugandan government and aid donors on development projects and recurring budget spending, between 2003 and 2007. The files marked CURRENT-- contain a cleaned and normalised version of this data.
Four of the five original tables were obtained from the Ugandan government. They show spending on development and recurring budgets over four years (akin to capital and current spending).
- Timescale: The dataset shows actual spending for 2003-4, 2004-5, and 2005-6, and projected donor spending up to 2009-10.
- Format: CSV, Google Docs, and originally in Access - Please contact Publish What You Fund
amountin UGX (Ugandan Shillings);
amount_dollarsin USD (US Dollars). Some of the data is also provided in the donor's original currency (
amount_donor); the currency is identified by the column
- Mark Brough, Publish What You Fund, email@example.com
Changes to the data
In order to create a data set that can be easily analysed, some changes have been made to the data:
Conversion of values to a common currency
- The original data did not have a common currency throughout the five tables
The common currency (UGX, Ugandan Shillings), was created by converting projects in the
FDTtable from USD to UGX. The ratio was based on the ratio found in the
Donor Developmenttable, using the following conversion rates:
- 2003/4: 1 USD = 1.847 UGX
- 2004/5: 1 USD = 1.804 UGX
- 2005/6: 1 USD = 1.779 UGX
- All subsequent years used the ratio 1 USD = 1.779 UGX
- In the original data, commitment and disbursement amounts for each year were provided in separate columns.
In the final data, a new row has been created for each year, for both commitment and disbursement. Many of these rows have '0' values for the amounts, which have been retained to allow easy analysis of changes to spending amounts over time. The commitment/disbursement distinction is provided by
The original data was provided in five separate sheets.
- Government of Uganda spending on Development budget projects (GoU Development)
- Donor spending on Development budget projects (Donor Development)
- Non Wage Recurrent spending on recurrent budget programmes (NB: different from projects - Non Wage Recurrent Mapped)
- Wage Recurrent spending on recurrent budget programmes.
- FDT data, which is the Donor Development data that was sent to donors to ask them to verify and correct information.
In the final data, these five sheets have been merged.
The existing fields have been retained where they have different meanings, so there are three different fields for
The original data had some overlap between Donor Development and FDT data. In order to get round this problem, Donor Development rows were marked as
Duplicateif the same
Project Codeexisted in the FDT data. These 'Duplicate' rows have been removed from the final data in order to avoid confusion and to prevent double-counting, but they are freely available on request.
- The existing fields have been retained where they have different meanings, so there are three different fields for
- Budget Support is money given directly to the government which they can spend on their own priorities. General Budget Support is given directly to the Treasury or Finance Ministry, and Sector Budget Support is given to an individual sector.
The Budget Support in the original data was thus double-counting. In order to avoid double-counting but to retain budget support for analysis, budget support 'offset' rows have been created with:
- Negative amounts equal to the value of the budget support provided.
bs_offsetcolumn is set to '1', denoting that a row is a value created to offset budget support from Government of Uganda spending.
This row is then attributed to the Government (via
spending_source_type) in order to show at the higher levels of aggregation the amount of Government of Uganda Revenues minus the amount of budget support.
- This is necessary to avoid double-counting when showing aggregations (of Government of Uganda spending, budget support and project aid) at higher levels, but it does not affect the actual amounts in the projects.
- An alternate method considered was to pro-rate out the budget support to each project, and show the proportion of funding provided by Government Uganda revenues and then individual donors to that individual project. However, because of the nature of budget support, it is impossible to accurately track it through the system down to an individual project level. Below the higher levels, budget support thus becomes part of Government of Uganda revenues. It is also not possible to discern the different preferences that donors may have in funding one project rather than another, although it is well known that some donors will certainly not like to be seen to be funding certain government projects.
- This conceptual shift in revenues from 'Budget Support' to 'Government of Uganda' when looking from the higher, aggregate level, to the lower individual project level is something to bear in mind when working with this data.
The classification used in this data set is
subsector. These are shortened versions of
Sector Objectiverespectively. The only change is for the Sector Objective
Disaster Management and Humanitarian Supportwhich was in the SWG
Macroeconomic and Financial Sector Management. This seemed to be incorrectly classified so it has been merged into the Sector Objective
Policies and Performanceunder the same SWG.
- The classification used in this data set is
- CURRENT-- Final cleaned, normalised version of data 29 text/x-osdata-csv
- CURRENT - Metadata for loader system 11 text/x-osmapping-csv
- OLD-- Five sheets of Uganda budget data from 2003-7, listing... 19 GDocs
- OLD-- See Page 26, Figure 1 for the definite list of MTEF, S... 5 PDF
- OLD-- Plan for matching up the GDocs sheets, by Mark 7 XLSX
- OLD-- Joined master sheet by Mark, all things combined 5 CSV
- OLD-- MySQL version of the master sheet 3 SQL
- OLD-- Preliminary version from Refine 5 CSV
- OLD-- Metadata for final Uganda data 11 CSV
- OLD-- Transposed Metadata for loader system 7 GDocs
- TESTING -- Small (100 rows) version of Final cleaned, normal... 7 CSV
- CURRENT -- Uganda data 311011 fixed text/x-osdata-csv
- CURRENT - Uganda budget model JSON file JSON
- Uganda budget model JSON file 2011-11-07 JSON
|Автор||Mark Brough, Publish What You Fund|
|Администратор||Maintainer not given|
Uganda Budget and Aid to Uganda, 2003-2007. Mark Brough, Publish What You Fund.
Retrieved 07:21, May 22, 2013 (UTC).
the Data Hub