home / 2025-02-03_foreign-assistance

./us_foreign_budget_complete

2 rows where Country ID = 702, Fiscal Year = 2023 and Region Name = "East Asia and Oceania"

✎ 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
36454 36454 702 SGP Singapore 1 East Asia and Oceania 4 High Income Country HIC 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   344852000 Budget for International Nonproliferation Export Control Program Budget for International Nonproliferation Export Control Program 1 Appropriated and Planned 2023 231046 220371
36457 36457 702 SGP Singapore 1 East Asia and Oceania 4 High Income Country HIC 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 105000 100149

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