home / 2025-02-03_foreign-assistance

./us_foreign_budget_complete

22 rows where Income Group Acronym = "UMIC", International Sector Code = 720 and Region Name = "Middle East and North Africa"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country ID, Country Code, Country Name, Managing Sub-agency or Bureau ID, Managing Sub-agency or Bureau Name, Operating Unit, International Purpose Code, International Purpose Name, US Sector ID, US Sector Name, Funding Account ID, Funding Account Name, Funding Agency ID, Funding Agency Name, Funding Agency Acronym, Activity ID, Activity Name, Activity Description, Transaction Type ID, Transaction Type Name, Fiscal Year, current_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 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
1546 1546 12 DZA Algeria 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 12x2278 Public Law 480 Title II Grants 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2009 6880000 9078889
1547 1547 12 DZA Algeria 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 12x2278 Public Law 480 Title II Grants 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2010 6213000 8128019
1548 1548 12 DZA Algeria 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 12x2278 Public Law 480 Title II Grants 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2011 8232000 10556576
1549 1549 12 DZA Algeria 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 12x2278 Public Law 480 Title II Grants 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2012 8680000 10930724
1550 1550 12 DZA Algeria 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 12x2278 Public Law 480 Title II Grants 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2013 6598000 8159542
1551 1551 12 DZA Algeria 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 12x2278 Public Law 480 Title II Grants 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2014 4505000 5465459
18170 18170 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 12x2278 Public Law 480 Title II Grants 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2008 23762000 31675121
18171 18171 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 12x2278 Public Law 480 Title II Grants 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2014 34000 41249
18662 18662 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Iraq 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 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 18 President's Budget Requests 2010 20000000 26164554
18663 18663 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Iraq 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 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 18 President's Budget Requests 2011 80000000 102590631
18664 18664 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Iraq 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 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   344996000 Budget for Economic Support Fund, H.R. 2206 Supplemental Budget for Economic Support Fund, H.R. 2206 Supplemental 1 Appropriated and Planned 2007 5000000 6804085
18665 18665 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Iraq 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 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 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2017 4000000 4674896
18675 18675 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   9 Humanitarian 720 Emergency Response 72010 Material relief assistance and services 7 Humanitarian Assistance 51 Humanitarian Assistance - General 97xB001 Department of Defense - Unknown Funding Account 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2013 9434000 11666735
19808 19808 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 12x2278 Public Law 480 Title II Grants 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2013 516000 638121
22460 22460 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 12x2278 Public Law 480 Title II Grants 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2006 281000 392876
22461 22461 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 12x2278 Public Law 480 Title II Grants 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2007 444000 604203
22952 22952 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Lebanon 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 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 2006 13865000 19385139
22953 22953 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Lebanon 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 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 2007 18640000 25365628
22954 22954 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Lebanon 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 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 2008 13000000 17329205
22955 22955 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Lebanon 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 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 2009 5000000 6598030
22956 22956 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Lebanon 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 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 18 President's Budget Requests 2010 3000000 3924683
23989 23989 434 LBY Libya 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 12x2278 Public Law 480 Title II Grants 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2011 5654000 7250593

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