home / 2025-02-03_foreign-assistance

./us_foreign_budget_complete

7 rows where Country Name = "Pakistan" and Funding Agency Name = "Department of Defense"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: International Sector Code, International Sector Name, International Purpose Code, International Purpose Name, US Sector ID, US Sector Name, 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
31967 31967 586 PAK Pakistan 4 South and Central Asia 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 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 2011 502780000 644756470
31968 31968 586 PAK Pakistan 4 South and Central Asia 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 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 2014 1541380 1870000
31969 31969 586 PAK Pakistan 4 South and Central Asia 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) 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 2011 4890000 6270852
31970 31970 586 PAK Pakistan 4 South and Central Asia 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) 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 1730000 2178589
31971 31971 586 PAK Pakistan 4 South and Central Asia 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) 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 2014 4430000 5374469
31972 31972 586 PAK Pakistan 4 South and Central Asia 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 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 2011 38722000 49656430
31973 31973 586 PAK Pakistan 4 South and Central Asia 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 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 629000 792100

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