./us_foreign_budget_complete

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type Name

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
10715 10715 214 DOM Dominican Republic 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Dominican Republic 5 Economic Growth 250 Business and Other Services 25010 Business Policy and Administation 5 Economic Development 30 Private Sector Competitiveness 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 2000000 2000000
10989 10989 218 ECU Ecuador 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Ecuador 5 Economic Growth 250 Business and Other Services 25010 Business Policy and Administation 5 Economic Development 30 Private Sector Competitiveness 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 2000000 1907597
14969 14969 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 5 Economic Growth 250 Business and Other Services 25010 Business Policy and Administation 5 Economic Development 30 Private Sector Competitiveness 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 1000 1142
14970 14970 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 5 Economic Growth 250 Business and Other Services 25010 Business Policy and Administation 5 Economic Development 30 Private Sector Competitiveness 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 8250000 9118154
15151 15151 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Guatemala 5 Economic Growth 250 Business and Other Services 25010 Business Policy and Administation 5 Economic Development 30 Private Sector Competitiveness 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 3000000 3207863
15152 15152 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Guatemala 5 Economic Growth 250 Business and Other Services 25010 Business Policy and Administation 5 Economic Development 30 Private Sector Competitiveness 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 11636000 11636000
15153 15153 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Guatemala 5 Economic Growth 250 Business and Other Services 25010 Business Policy and Administation 5 Economic Development 30 Private Sector Competitiveness 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 4700000 4482852
15154 15154 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Guatemala 5 Economic Growth 250 Business and Other Services 25010 Business Policy and Administation 5 Economic Development 30 Private Sector Competitiveness 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 12000000 12000000
15155 15155 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Guatemala 5 Economic Growth 250 Business and Other Services 25010 Business Policy and Administation 5 Economic Development 30 Private Sector Competitiveness 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 16500000 15737673
15156 15156 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Guatemala 5 Economic Growth 250 Business and Other Services 25010 Business Policy and Administation 5 Economic Development 30 Private Sector Competitiveness 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 21795000 20308134
19191 19191 388 JAM Jamaica 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Jamaica 5 Economic Growth 250 Business and Other Services 25010 Business Policy and Administation 5 Economic Development 30 Private Sector Competitiveness 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 1235000 1646274
19248 19248 388 JAM Jamaica 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Jamaica 5 Economic Growth 250 Business and Other Services 25010 Business Policy and Administation 5 Economic Development 30 Private Sector Competitiveness 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 1500000 1500000
26796 26796 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 5 Economic Growth 250 Business and Other Services 25010 Business Policy and Administation 5 Economic Development 30 Private Sector Competitiveness 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 3200000 4265650

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