./us_foreign_budget_complete

39 rows where Income Group Acronym = "UMIC", International Sector Code = 114 and Region ID = 6

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country Name, Managing Sub-agency or Bureau Name, Activity Name, Transaction Type Name, Fiscal Year

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
8771 8771 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Colombia 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 1000000 1069288
8772 8772 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Colombia 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 1000000 1000000
8773 8773 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Colombia 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2400000 2289116
14679 14679 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 205000 270519
14680 14680 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 200000 261646
14681 14681 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 1911000 2363274
14682 14682 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2239000 2716351
14683 14683 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2500000 2998619
14684 14684 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 3000000 3568770
14685 14685 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2500000 2921810
14686 14686 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 4000000 4567646
14687 14687 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2020 2100000 2320985
14688 14688 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2500000 2998619
14689 14689 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2500000 2973975
14690 14690 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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
14691 14691 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2018 3000000 3425734
14692 14692 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2019 2500000 2799938
14693 14693 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2020 2500000 2763077
15079 15079 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2021 1430000 1529081
15080 15080 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2022 2500000 2500000
15081 15081 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2023 1000000 953798
15082 15082 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2022 3000000 3000000
15083 15083 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2023 3000000 2861395
15084 15084 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Guatemala 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2024 3000000 2795339
26439 26439 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2045000 2859186
26440 26440 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2700000 3562936
26441 26441 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 1300000 1700696
26442 26442 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2500000 3205957
26443 26443 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 4000000 5037200
26444 26444 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2866000 3544293
26445 26445 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2700000 3562936
26446 26446 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2700000 3532215
26447 26447 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2304000 2954610
26448 26448 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 7350000 9255855
26449 26449 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2000000 2473338
26450 26450 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2007 2500000 3402042
26451 26451 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2008 2500000 3332539
26452 26452 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 650000 788579
26453 26453 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 2008 2700000 3599143

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