./us_foreign_budget_complete

21 rows where Country ID = 320, Income Group Name = "Upper Middle Income Country" and International Sector Code = 114

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Managing Sub-agency or Bureau ID, Managing Sub-agency or Bureau Name, Funding Account Name, Transaction Type ID, constant_amount

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

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