./us_foreign_budget_complete

42 rows where Funding Account Name = "Agency for International Development, Development Assistance" and International Sector Code = 122

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Region ID, Income Group Acronym, Managing Sub-agency or Bureau Acronym

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
5074 5074 76 BRA Brazil 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Brazil 2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 1333000 1743868
9132 9132 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Democratic Republic of the Congo 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 14 Pandemic Influenza and Other Emerging Threats (PIOET) 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2006 120000 167776
14714 14714 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2016 3000000 3568770
16488 16488 340 HND Honduras 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Honduras 2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 1550000 2027753
22134 22134 418 LAO Laos 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Laos 2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2014 750000 909899
22135 22135 418 LAO Laos 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Laos 2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2015 1000000 1199448
22136 22136 418 LAO Laos 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Laos 2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2017 2000000 2337448
22137 22137 418 LAO Laos 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Laos 2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2016 5900000 7018581
22138 22138 418 LAO Laos 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Laos 2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 9900000 11570367
29823 29823 558 NIC Nicaragua 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Nicaragua 2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 750000 981171
56640 56640 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 14 Pandemic Influenza and Other Emerging Threats (PIOET) 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2018 14000000 15986761
56641 56641 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 14 Pandemic Influenza and Other Emerging Threats (PIOET) 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2019 24895000 27881780
56642 56642 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2008 9600000 12796951
56643 56643 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2009 10000000 13196060
56644 56644 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 11100000 14521328
56645 56645 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2011 7069000 9065165
56646 56646 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2012 11500000 14481950
56647 56647 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2013 10984000 13583572
56648 56648 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2014 16541000 20067516
56649 56649 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2015 16541000 19840062
56650 56650 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2016 13000000 15464670
56651 56651 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2017 13000000 15193411
56652 56652 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2009 5160000 6809167
56653 56653 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 9600000 12558986
56654 56654 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2011 9600000 12310876
56655 56655 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2012 9000000 11333700
56656 56656 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2013 5000000 6183345
56657 56657 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2014 6460000 7837262
56658 56658 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2015 4036000 4840970
56659 56659 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2016 3093000 3679402
56660 56660 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 2500000 2921810
58121 58121 1002 WLD World 7 World       998   Unknown - Budget Data ODP - Private Sector Alliances (PSA) 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2006 232000 324367
58122 58122 1002 WLD World 7 World       998   Unknown - Budget Data ODP - Private Sector Alliances (PSA) 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2008 550000 733159
58123 58123 1002 WLD World 7 World       998   Unknown - Budget Data ODP - Private Sector Alliances (PSA) 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 800000 1046582
58124 58124 1002 WLD World 7 World       998   Unknown - Budget Data ODP - Private Sector Alliances (PSA) 2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2011 400000 512953
58125 58125 1002 WLD World 7 World       998   Unknown - Budget Data ODP - Private Sector Alliances (PSA) 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2006 187000 261451
58341 58341 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Learning, Evaluation and Research 2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2013 1378000 1704130
58456 58456 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Science and Technology 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2011 150000 192357
58457 58457 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Science and Technology 2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2013 1050000 1298502
59133 59133 1002 WLD World 7 World       998   Unknown - Budget Data USAID Democracy, Conflict and Humanitarian Assistance (DCHA) 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2006 7600000 10625824
59134 59134 1002 WLD World 7 World       998   Unknown - Budget Data USAID Democracy, Conflict and Humanitarian Assistance (DCHA) 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2007 8200000 11158699
59135 59135 1002 WLD World 7 World       998   Unknown - Budget Data USAID Democracy, Conflict and Humanitarian Assistance (DCHA) 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2008 6000000 7998095

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
);