home / 2025-02-03_foreign-assistance

./us_foreign_budget_complete

8 rows where current_amount = 172000

✎ View and edit SQL

This data as json, CSV (advanced)

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
2597 2597 44 BHS Bahamas 6 Western Hemisphere 4 High Income Country HIC 58 WHA Western Hemisphere Affairs Bahamas, The 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 11x1081 International Military Education and Training 39 Department of State and U.S. Agency for International Development State/USAID   345038000 Budget for International Military Education and Training Budget for International Military Education and Training 1 Appropriated and Planned 2014 172000 208670
9905 9905 188 CRI Costa Rica 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Costa Rica 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 11x1081 International Military Education and Training 39 Department of State and U.S. Agency for International Development State/USAID   345038000 Budget for International Military Education and Training Budget for International Military Education and Training 1 Appropriated and Planned 2008 172000 229279
10827 10827 218 ECU Ecuador 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Ecuador 3 Governance 151 Government and Civil Society 15160 Human rights 2 Democracy, Human Rights, and Governance 7 Rule of Law and Human Rights 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 172000 229279
31977 31977 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Defense Nuclear Nonproliferation (DNN) 3 Governance 152 Conflict, Peace, and Security 1520010 Disarmament of Weapons of Mass Destruction (WMD) 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 89x0240 Weapons Activities, National Nuclear Security Administration, Energy 13 Department of Energy DOE   344854000 Budget for Office of Nuclear Export Controls Budget for Office of Nuclear Export Controls 18 President's Budget Requests 2023 172000 164053
39460 39460 740 SUR Suriname 6 Western Hemisphere 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 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 2012 172000 216600
44258 44258 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Defense Nuclear Nonproliferation (DNN) 4 Infrastructure 230 Energy 23181 Energy education/training 5 Economic Development 28 Infrastructure 89x0309 Department of Energy, Defense Nuclear Nonproliferation 13 Department of Energy DOE   344853000 Budget for Office of International Nuclear Safeguards Budget for Office of International Nuclear Safeguards 1 Appropriated and Planned 2023 172000 164053
44259 44259 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Defense Nuclear Nonproliferation (DNN) 4 Infrastructure 230 Energy 23181 Energy education/training 5 Economic Development 28 Infrastructure 89x0309 Department of Energy, Defense Nuclear Nonproliferation 13 Department of Energy DOE   344853000 Budget for Office of International Nuclear Safeguards Budget for Office of International Nuclear Safeguards 18 President's Budget Requests 2023 172000 164053
50998 50998 1002 WLD World 7 World       56 NEA Near Eastern Affairs United Arab Emirates 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 11x1075 Nonproliferation, Anti-Terrorism, Demining and Related Programs 39 Department of State and U.S. Agency for International Development State/USAID   345115000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Export Control and Related Border Security Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Export Control and Related Border Security Assistance 1 Appropriated and Planned 2007 172000 234061

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