./us_foreign_budget_complete

33 rows where Fiscal Year = 2023, International Sector Code = 410 and Region ID = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: International Purpose Name, current_amount, 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
1677 1677 12 DZA Algeria 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Algeria 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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 250000 238450
1678 1678 12 DZA Algeria 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Algeria 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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 500000 476899
13940 13940 275 PSE West Bank and Gaza 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data West Bank and Gaza 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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 53516000 51043474
13943 13943 275 PSE West Bank and Gaza 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data West Bank and Gaza 7 Other 410 General Environmental Protection 41030 Bio-diversity 6 Environment 35 Natural Resources and Biodiversity 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 16470000 15709059
13944 13944 275 PSE West Bank and Gaza 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data West Bank and Gaza 7 Other 410 General Environmental Protection 41030 Bio-diversity 6 Environment 35 Natural Resources and Biodiversity 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
18758 18758 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Iraq 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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 9335000 8903708
18760 18760 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Iraq 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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
18763 18763 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Iraq 7 Other 410 General Environmental Protection 41030 Bio-diversity 6 Environment 35 Natural Resources and Biodiversity 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 2160000 2060204
18764 18764 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Iraq 7 Other 410 General Environmental Protection 41030 Bio-diversity 6 Environment 35 Natural Resources and Biodiversity 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
20577 20577 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Jordan 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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 16150000 15403844
20579 20579 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Jordan 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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 40000000 38151935
20582 20582 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Jordan 7 Other 410 General Environmental Protection 41030 Bio-diversity 6 Environment 35 Natural Resources and Biodiversity 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 9064000 8645229
23046 23046 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Lebanon 7 Other 410 General Environmental Protection 41030 Bio-diversity 6 Environment 35 Natural Resources and Biodiversity 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 1000000 953798
24222 24222 434 LBY Libya 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Libya 7 Other 410 General Environmental Protection 41030 Bio-diversity 6 Environment 35 Natural Resources and Biodiversity 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 1375000 1311473
28298 28298 504 MAR Morocco 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Morocco 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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
28301 28301 504 MAR Morocco 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Morocco 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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 2000000 1907597
28302 28302 504 MAR Morocco 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Morocco 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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 800000 763039
41349 41349 788 TUN Tunisia 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Tunisia 7 Other 410 General Environmental Protection 41030 Bio-diversity 6 Environment 35 Natural Resources and Biodiversity 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
41351 41351 788 TUN Tunisia 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Tunisia 7 Other 410 General Environmental Protection 41030 Bio-diversity 6 Environment 35 Natural Resources and Biodiversity 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 2000000 1907597
44347 44347 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Egypt 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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 3840000 3662586
44349 44349 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Egypt 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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 11000000 10491782
44352 44352 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Egypt 7 Other 410 General Environmental Protection 41030 Bio-diversity 6 Environment 35 Natural Resources and Biodiversity 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 4160000 3967801
44354 44354 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Egypt 7 Other 410 General Environmental Protection 41030 Bio-diversity 6 Environment 35 Natural Resources and Biodiversity 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 3000000 2861395
61298 61298 1023 MNS Middle East and North Africa Region 3 Middle East and North Africa       998   Unknown - Budget Data Bureau of Near Eastern Affairs 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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 5000000 4768992
61299 61299 1023 MNS Middle East and North Africa Region 3 Middle East and North Africa       998   Unknown - Budget Data Bureau of Near Eastern Affairs 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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 6000000 5722790
61301 61301 1023 MNS Middle East and North Africa Region 3 Middle East and North Africa       998   Unknown - Budget Data Bureau of Near Eastern Affairs 7 Other 410 General Environmental Protection 41030 Bio-diversity 6 Environment 35 Natural Resources and Biodiversity 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 1500000 1430698
61317 61317 1023 MNS Middle East and North Africa Region 3 Middle East and North Africa       998   Unknown - Budget Data Middle East Multilaterals (DOS) 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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 500000 476899
61434 61434 1023 MNS Middle East and North Africa Region 3 Middle East and North Africa       998   Unknown - Budget Data Middle East Regional (USAID) 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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 6000000 5722790
61438 61438 1023 MNS Middle East and North Africa Region 3 Middle East and North Africa       998   Unknown - Budget Data Middle East Regional (USAID) 7 Other 410 General Environmental Protection 41030 Bio-diversity 6 Environment 35 Natural Resources and Biodiversity 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
61440 61440 1023 MNS Middle East and North Africa Region 3 Middle East and North Africa       998   Unknown - Budget Data Middle East Regional (USAID) 7 Other 410 General Environmental Protection 41030 Bio-diversity 6 Environment 35 Natural Resources and Biodiversity 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 625000 596124
61456 61456 1023 MNS Middle East and North Africa Region 3 Middle East and North Africa       998   Unknown - Budget Data Middle East Regional Cooperation (DOS) 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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 1500000 1430698
61573 61573 1026 MNA North Africa Region 3 Middle East and North Africa       998   Unknown - Budget Data Sahel Regional Program (USAID) 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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 2400000 2289116
61575 61575 1026 MNA North Africa Region 3 Middle East and North Africa       998   Unknown - Budget Data Sahel Regional Program (USAID) 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 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 4500000 4292093

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