U.S. Foreign Aid by Funding Agency

The dataset for this project is a summary of U.S. foreign aid by funding agency (2001–present time). I plan to focus on which funding agencies/accounts spent/contributed the most money, and where these funds were spent around the world.

variables: - funding agency ID/acronym/name - funding account ID/name - country code/name - transaction type ID/name - fiscal year - current/constant amount (in U.S. dollars, “constant”: adjusted for inflation)

source: foreignassistance.gov/data, one of six pre-made subsets of the cumulative dataset. I considered using the complete dataset, but thought it too big (3.66GB) to comfortably clean.

The dataset required sparse cleaning: I renamed its vars (tolower(), gsub(), names()[] indexes), selected the most important vars (filter()), and removed all NA from them (filter(!is.na())). The first treemap represents which government agencies have spent the most funds on foreign aid in total, as well as how many funding accounts were involved. Per the data, the Department of State has funded almost half of all foreign aid (since 2000), and the U.S.A.I.D. funded most of the other, with smaller contributions by the Dept.s of Agriculture, Defense, and Treasury. The second graph shows in which countries the most amount of money was spent (since 2000). Per the data, >$400B was spent in Afghanistan, followed by Israel, Iraq, Ukraine, and Egypt. I did try to arrange the graph in order, but I was unsuccessful.