./us_foreign_budget_complete

51 rows where Income Group ID = 3, International Sector Name = "Basic Health" and US Sector ID = 19

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Funding Account ID, Funding Agency Acronym, Activity ID

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
8256 8256 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs   2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2018 2004000 2288391
14581 14581 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs   2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2010 18000000 23548099
14582 14582 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs   2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2011 16416000 21051598
14583 14583 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs   2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2012 9377000 11808456
14584 14584 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs   2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2013 6057000 7490504
14585 14585 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs   2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2014 2981000 3616545
14586 14586 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs   2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2015 3519000 4220856
14587 14587 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs   2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2016 3525000 4193305
14588 14588 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs   2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2017 5345000 6246829
14589 14589 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs   2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2018 6038000 6894862
14590 14590 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs   2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 18 President's Budget Requests 2013 11390000 14085659
14591 14591 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs   2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 18 President's Budget Requests 2015 3000000 3598343
14592 14592 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs   2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 18 President's Budget Requests 2016 3000000 3568770
14593 14593 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs   2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 18 President's Budget Requests 2017 3000000 3506172
14694 14694 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2010 2200000 2878101
14695 14695 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2011 3493000 4479363
14696 14696 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2012 5000000 6296500
14697 14697 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2013 4520000 5589744
14698 14698 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2014 4500000 5459393
14699 14699 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2015 4500000 5397514
14700 14700 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2016 4500000 5353155
14701 14701 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2017 4500000 5259258
14702 14702 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2018 4500000 5138602
14703 14703 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2020 4500000 4973539
14704 14704 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 18 President's Budget Requests 2011 4000000 5129532
14705 14705 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 18 President's Budget Requests 2012 4000000 5037200
14706 14706 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 18 President's Budget Requests 2013 3500000 4328341
14707 14707 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 18 President's Budget Requests 2014 3500000 4246195
14708 14708 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 18 President's Budget Requests 2015 3500000 4198066
14709 14709 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 18 President's Budget Requests 2016 3500000 4163565
14710 14710 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 18 President's Budget Requests 2017 3500000 4090534
14711 14711 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 18 President's Budget Requests 2018 3000000 3425734
14712 14712 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 18 President's Budget Requests 2019 3000000 3359925
14713 14713 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 18 President's Budget Requests 2020 3000000 3315692
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
15085 15085 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data 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   344902000 Budget for Global Health Programs - USAID Budget for Global Health Programs - USAID 1 Appropriated and Planned 2021 4500000 4811794
15086 15086 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data 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   344902000 Budget for Global Health Programs - USAID Budget for Global Health Programs - USAID 1 Appropriated and Planned 2022 4500000 4500000
15087 15087 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data 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   344902000 Budget for Global Health Programs - USAID Budget for Global Health Programs - USAID 1 Appropriated and Planned 2023 4500000 4292093
15088 15088 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data 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   344902000 Budget for Global Health Programs - USAID Budget for Global Health Programs - USAID 18 President's Budget Requests 2022 4500000 4500000
15089 15089 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data 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   344902000 Budget for Global Health Programs - USAID Budget for Global Health Programs - USAID 18 President's Budget Requests 2023 4500000 4292093
15090 15090 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data 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   344902000 Budget for Global Health Programs - USAID Budget for Global Health Programs - USAID 18 President's Budget Requests 2024 4500000 4193008
19851 19851 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Jordan 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 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2015 1400000 1679227
20465 20465 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Jordan 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   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2021 2823000 3018599
20466 20466 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Jordan 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   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2022 3547000 3547000
20467 20467 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Jordan 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   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2023 3347000 3192363
20468 20468 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Jordan 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   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2022 4000000 4000000
20469 20469 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Jordan 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   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2023 4000000 3815194
20470 20470 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Jordan 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   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2024 4000000 3727118
32574 32574 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2010 586000 766621
45803 45803 862 VEN Venezuela 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Venezuela 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2021 5000000 5346438

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