home / 2025-02-03_foreign-assistance

./us_foreign_budget_complete

22 rows where Income Group Name = "Upper Middle Income Country", International Sector Code = 151 and US Category ID = 7

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Region Name, Operating Unit, US Sector ID, Activity ID, Activity Name, Activity Description, Transaction Type ID, 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 Account ID Funding Account 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
2194 2194 31 AZE Azerbaijan 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Azerbaijan 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 72x0306 Assistance for Europe, Eurasia and Central Asia (AEECA) 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2011 60000 76943
8460 8460 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 72x1021 Agency for International Development, Development Assistance 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 10650000 11770708
8461 8461 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 72x1037 Economic Support Fund 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 2020 8607000 9512722
8462 8462 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 72xB001 Economic Support Fund and Development Fund 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 20000000 21385752
8834 8834 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Colombia 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 72x1021 Agency for International Development, Development Assistance 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 14130000 15109034
8835 8835 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Colombia 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 72x1021 Agency for International Development, Development Assistance 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 9763000 9763000
8836 8836 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Colombia 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 72x1021 Agency for International Development, Development Assistance 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 18128000 17290457
8837 8837 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Colombia 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 72x1037 Economic Support Fund 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 8887000 9502759
8838 8838 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Colombia 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 72x1037 Economic Support Fund 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 7087000 7087000
8839 8839 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Colombia 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 72x1037 Economic Support Fund 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 18700000 18700000
8840 8840 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Colombia 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 72x1037 Economic Support Fund 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 33700000 32143005
8841 8841 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Colombia 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 72x1037 Economic Support Fund 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 33700000 31400969
10970 10970 218 ECU Ecuador 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Ecuador 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 72x1037 Economic Support Fund 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 500000 534644
12807 12807 268 GEO Georgia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Georgia 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 72x0306 Assistance for Europe, Eurasia and Central Asia (AEECA) 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2020 125000 138154
13267 13267 268 GEO Georgia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Georgia 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 72x0306 Assistance for Europe, Eurasia and Central Asia (AEECA) 39 Department of State and U.S. Agency for International Development State/USAID   344894000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 18 President's Budget Requests 2023 125000 119225
13268 13268 268 GEO Georgia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Georgia 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 72x0306 Assistance for Europe, Eurasia and Central Asia (AEECA) 39 Department of State and U.S. Agency for International Development State/USAID   344894000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 18 President's Budget Requests 2024 125000 116472
15143 15143 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Guatemala 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 72x1021 Agency for International Development, Development Assistance 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 5050000 5050000
15144 15144 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Guatemala 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 72x1021 Agency for International Development, Development Assistance 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 5595000 5336502
32927 32927 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Peru 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 72x1021 Agency for International Development, Development Assistance 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 10000000 9537984
32928 32928 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Peru 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 39 Migration Management 72x1021 Agency for International Development, Development Assistance 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 10000000 9317795
62684 62684 1071 CS-KM Kosovo 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Kosovo 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 72x0306 Assistance for Europe, Eurasia and Central Asia (AEECA) 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 18 President's Budget Requests 2008 2100000 2799333
62685 62685 1071 CS-KM Kosovo 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Kosovo 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 72x0306 Assistance for Europe, Eurasia and Central Asia (AEECA) 39 Department of State and U.S. Agency for International Development State/USAID   344952000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA), H.R. 2206 Supplemental Budget for Assistance for Europe, Eurasia and Central Asia (AEECA), H.R. 2206 Supplemental 1 Appropriated and Planned 2007 4000000 5443268

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
);
Powered by Datasette · Queries took 5290.955ms