./us_foreign_budget_complete

38 rows where Fiscal Year = 2014, Funding Account ID = "72x1037" and International Sector Name = "Agriculture"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Activity Description

Link rowid ▼ Country ID Country Code Country Name Region ID Region Name Income Group ID Income Group Name Income Group Acronym Managing Sub-agency or Bureau ID Managing Sub-agency or Bureau Acronym Managing Sub-agency or Bureau Name Operating Unit International Category ID International Category Name International Sector Code International Sector Name International Purpose Code International Purpose Name US Category ID US Category Name US Sector ID US Sector Name Funding Agency ID Funding Agency Name Funding Agency Acronym OCO Flag Activity ID Activity Name Activity Description Transaction Type ID Transaction Type Name Fiscal Year current_amount constant_amount
958 958 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 70000000 84923892
967 967 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2014 36500000 44281744
973 973 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 18 President's Budget Requests 2014 80000000 97055877
5746 5746 104 MMR Burma (Myanmar) 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Burma 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2014 20000000 24263969
5753 5753 104 MMR Burma (Myanmar) 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Burma 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 8000000 9705588
9720 9720 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Democratic Republic of the Congo 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2014 1000000 1213198
9726 9726 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Democratic Republic of the Congo 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 8000000 9705588
11283 11283 222 SLV El Salvador 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs El Salvador 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344994000 Budget for Economic Support Fund, Central American Unaccompanied Children Supplemental Budget for Economic Support Fund, Central American Unaccompanied Children Supplemental 18 President's Budget Requests 2014 10000000 12131985
13116 13116 268 GEO Georgia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Georgia 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2014 5000000 6065992
13119 13119 268 GEO Georgia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Georgia 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 5000000 6065992
13816 13816 275 PSE West Bank and Gaza 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs West Bank and Gaza 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 5000000 6065992
15009 15009 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344994000 Budget for Economic Support Fund, Central American Unaccompanied Children Supplemental Budget for Economic Support Fund, Central American Unaccompanied Children Supplemental 18 President's Budget Requests 2014 15000000 18197977
16228 16228 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs Haiti 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2014 28000000 33969557
16236 16236 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs Haiti 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 28000000 33969557
17261 17261 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs India 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 3000000 3639595
21959 21959 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2014 6000000 7279191
21961 21961 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 6000000 7279191
22906 22906 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Lebanon 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2014 3000000 3639595
22913 22913 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Lebanon 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 6000000 7279191
23818 23818 430 LBR Liberia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Liberia 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 8000000 9705588
29568 29568 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2014 11043000 13397351
29577 29577 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 10000000 12131985
29580 29580 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2014 4600000 5580713
31870 31870 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2014 7305000 8862415
31878 31878 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 69000000 83710694
31885 31885 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2014 31776000 38550594
31891 31891 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 18 President's Budget Requests 2014 12000000 14558382
38378 38378 716 ZWE Zimbabwe 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Zimbabwe 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2014 4000000 4852794
38386 38386 716 ZWE Zimbabwe 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Zimbabwe 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 4000000 4852794
38851 38851 728 SSD South Sudan 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs South Sudan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 18000000 21837572
38854 38854 728 SSD South Sudan 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs South Sudan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2014 15500000 18804576
40269 40269 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2014 8000000 9705588
40272 40272 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 10000000 12131985
44194 44194 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2014 7000000 8492389
44202 44202 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 15000000 18197977
46405 46405 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2014 4560000 5532185
46409 46409 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 4560000 5532185
50951 50951 1002 WLD World 7 World       56 NEA Near Eastern Affairs USAID Middle East Regional (MER) 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2014 400000 485279

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "./us_foreign_budget_complete" (
"Country ID" INTEGER,
  "Country Code" TEXT,
  "Country Name" TEXT,
  "Region ID" INTEGER,
  "Region Name" TEXT,
  "Income Group ID" INTEGER,
  "Income Group Name" TEXT,
  "Income Group Acronym" TEXT,
  "Managing Sub-agency or Bureau ID" INTEGER,
  "Managing Sub-agency or Bureau Acronym" TEXT,
  "Managing Sub-agency or Bureau Name" TEXT,
  "Operating Unit" TEXT,
  "International Category ID" INTEGER,
  "International Category Name" TEXT,
  "International Sector Code" INTEGER,
  "International Sector Name" TEXT,
  "International Purpose Code" INTEGER,
  "International Purpose Name" TEXT,
  "US Category ID" INTEGER,
  "US Category Name" TEXT,
  "US Sector ID" INTEGER,
  "US Sector Name" TEXT,
  "Funding Account ID" TEXT,
  "Funding Account Name" TEXT,
  "Funding Agency ID" INTEGER,
  "Funding Agency Name" TEXT,
  "Funding Agency Acronym" TEXT,
  "OCO Flag" INTEGER,
  "Activity ID" INTEGER,
  "Activity Name" TEXT,
  "Activity Description" TEXT,
  "Transaction Type ID" INTEGER,
  "Transaction Type Name" TEXT,
  "Fiscal Year" INTEGER,
  "current_amount" INTEGER,
  "constant_amount" INTEGER
);