./us_foreign_budget_complete

35 rows where Funding Agency ID = 7 and Region ID = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country ID, Country Code, Country Name, Income Group ID, Income Group Name, Income Group Acronym, International Category ID, International Sector Name, International Purpose Code, US Sector ID, Funding Account Name, Activity Description

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
1656 1656 12 DZA Algeria 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 135160 163976
1657 1657 12 DZA Algeria 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 82000 105155
13872 13872 275 PSE West Bank and Gaza 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 117338 142354
18670 18670 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 38801 47073
18671 18671 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 880000 1128497
18672 18672 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 5404000 6556124
18673 18673 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 66500000 85278462
18674 18674 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   7 Other 430 Other Multisector 43010 Multisector aid 9 Multi-sector 52 Multi-sector - Unspecified 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 7664000 9297953
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 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
18676 18676 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Defense Security Cooperation University/Institutional Capacity Building Direcorate 7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 7 Department of Defense DOD   344845000 Budget for Ministry of Defence Advisor 332 a Budget for Ministry of Defence Advisor 332 a 1 Appropriated and Planned 2023 3280000 3128459
18677 18677 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Defense Security Cooperation University/Institutional Capacity Building Direcorate 7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 7 Department of Defense DOD   344845000 Budget for Ministry of Defence Advisor 332 a Budget for Ministry of Defence Advisor 332 a 18 President's Budget Requests 2024 900000 838602
20442 20442 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 663337 804759
20443 20443 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 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 41385000 51179545
20444 20444 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 50160000 60854035
20445 20445 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   7 Other 430 Other Multisector 43010 Multisector aid 9 Multi-sector 52 Multi-sector - Unspecified 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 11162000 13541721
20450 20450 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Defense Security Cooperation University/Institutional Capacity Building Direcorate 7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 7 Department of Defense DOD   344845000 Budget for Ministry of Defence Advisor 332 a Budget for Ministry of Defence Advisor 332 a 1 Appropriated and Planned 2023 410000 391057
20451 20451 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Defense Security Cooperation University/Institutional Capacity Building Direcorate 7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 7 Department of Defense DOD   344845000 Budget for Ministry of Defence Advisor 332 a Budget for Ministry of Defence Advisor 332 a 18 President's Budget Requests 2024 300000 279534
22959 22959 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 935183 1134563
22960 22960 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 5000 6066
22961 22961 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 2260000 2898185
22962 22962 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2012 6484000 8165301
24163 24163 434 LBY Libya 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 37995 46095
24164 24164 434 LBY Libya 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 30000000 38471487
24165 24165 434 LBY Libya 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 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 22177000 27425607
28227 28227 504 MAR Morocco 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 600986 729115
28228 28228 504 MAR Morocco 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 115601 140247
28229 28229 504 MAR Morocco 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 163000 209028
28975 28975 512 OMN Oman 3 Middle East and North Africa 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 312049 378577
41257 41257 788 TUN Tunisia 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 510759 619652
41258 41258 788 TUN Tunisia 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data   7 Other 430 Other Multisector 43010 Multisector aid 9 Multi-sector 52 Multi-sector - Unspecified 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 20780000 25210264
41264 41264 788 TUN Tunisia 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Defense Security Cooperation University/Institutional Capacity Building Direcorate 7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 7 Department of Defense DOD   344845000 Budget for Ministry of Defence Advisor 332 a Budget for Ministry of Defence Advisor 332 a 1 Appropriated and Planned 2023 820000 782115
41265 41265 788 TUN Tunisia 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Defense Security Cooperation University/Institutional Capacity Building Direcorate 7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 7 Department of Defense DOD   344845000 Budget for Ministry of Defence Advisor 332 a Budget for Ministry of Defence Advisor 332 a 18 President's Budget Requests 2024 600000 559068
44251 44251 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 274031 332454
46436 46436 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2014 257897 312880
46437 46437 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 998   Unknown - Budget Data   3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 47026000 60305338

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