home / 2025-02-03_foreign-assistance

./us_foreign_budget_complete

4 rows where Country Name = "Canada" and Funding Agency Acronym = "DOE"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Activity Description, Fiscal Year

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
7213 7213 124 CAN Canada 6 Western Hemisphere 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 98623 94066
7214 7214 124 CAN Canada 6 Western Hemisphere 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 18 President's Budget Requests 2024 203600 189710
7215 7215 124 CAN Canada 6 Western Hemisphere 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 1 Appropriated and Planned 2022 20231 20231
7216 7216 124 CAN Canada 6 Western Hemisphere 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 139000 132578

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