./us_foreign_budget_complete

34 rows where Fiscal Year = 2007, Funding Account ID = "11x1075" and Income Group ID = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country Name, US Sector ID

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
552 552 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345105000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance 1 Appropriated and Planned 2007 4900000 6668003
570 570 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345106000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance, H.R. 2206 Supplemental Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance, H.R. 2206 Supplemental 1 Appropriated and Planned 2007 15000000 20412254
572 572 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345112000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Counterterrorism Financing Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Counterterrorism Financing 1 Appropriated and Planned 2007 675000 918551
583 583 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345132000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Terrorist Interdiction Program Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Terrorist Interdiction Program 1 Appropriated and Planned 2007 500000 680408
613 613 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 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 500000 680408
664 664 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345119000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Humanitarian Demining Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Humanitarian Demining 1 Appropriated and Planned 2007 13500000 18371029
670 670 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345131000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Small Arms / Light Arms Destruction Fund Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Small Arms / Light Arms Destruction Fund 1 Appropriated and Planned 2007 1500000 2041225
6113 6113 108 BDI Burundi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Burundi 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345131000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Small Arms / Light Arms Destruction Fund Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Small Arms / Light Arms Destruction Fund 1 Appropriated and Planned 2007 281000 382390
7889 7889 148 TCD Chad 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Chad 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345105000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance 1 Appropriated and Planned 2007 595000 809686
7902 7902 148 TCD Chad 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Chad 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345119000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Humanitarian Demining Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Humanitarian Demining 1 Appropriated and Planned 2007 200000 272163
9589 9589 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Democratic Republic of the Congo 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345131000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Small Arms / Light Arms Destruction Fund Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Small Arms / Light Arms Destruction Fund 1 Appropriated and Planned 2007 1375000 1871123
11833 11833 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Ethiopia 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345105000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance 1 Appropriated and Planned 2007 950000 1292776
11836 11836 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Ethiopia 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345132000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Terrorist Interdiction Program Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Terrorist Interdiction Program 1 Appropriated and Planned 2007 200000 272163
23621 23621 430 LBR Liberia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Liberia 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345106000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance, H.R. 2206 Supplemental Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance, H.R. 2206 Supplemental 1 Appropriated and Planned 2007 5000000 6804085
24587 24587 450 MDG Madagascar 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Madagascar 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345105000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance 1 Appropriated and Planned 2007 50000 68041
25923 25923 466 MLI Mali 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Mali 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345105000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance 1 Appropriated and Planned 2007 950000 1292776
28621 28621 508 MOZ Mozambique 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Mozambique 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345105000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance 1 Appropriated and Planned 2007 250000 340204
28643 28643 508 MOZ Mozambique 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Mozambique 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345119000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Humanitarian Demining Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Humanitarian Demining 1 Appropriated and Planned 2007 440000 598759
29391 29391 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345105000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance 1 Appropriated and Planned 2007 740000 1007005
29411 29411 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345132000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Terrorist Interdiction Program Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Terrorist Interdiction Program 1 Appropriated and Planned 2007 100000 136082
30211 30211 562 NER Niger 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Niger 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345105000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance 1 Appropriated and Planned 2007 432000 587873
33936 33936 624 GNB Guinea-Bissau 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Guinea-Bissau 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345119000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Humanitarian Demining Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Humanitarian Demining 1 Appropriated and Planned 2007 578000 786552
40038 40038 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345105000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance 1 Appropriated and Planned 2007 2404000 3271404
40066 40066 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 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 600000 816490
42272 42272 800 UGA Uganda 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Uganda 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345105000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance 1 Appropriated and Planned 2007 27000 36742
44679 44679 834 TZA Tanzania 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Tanzania 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345105000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance 1 Appropriated and Planned 2007 1689000 2298420
44681 44681 834 TZA Tanzania 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Tanzania 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345112000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Counterterrorism Financing Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Counterterrorism Financing 1 Appropriated and Planned 2007 600000 816490
44684 44684 834 TZA Tanzania 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Tanzania 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 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 13000 17691
46201 46201 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345105000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance 1 Appropriated and Planned 2007 1197000 1628898
46219 46219 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345112000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Counterterrorism Financing Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Counterterrorism Financing 1 Appropriated and Planned 2007 300000 408245
46229 46229 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345132000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Terrorist Interdiction Program Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Terrorist Interdiction Program 1 Appropriated and Planned 2007 257000 349730
46249 46249 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 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 350000 476286
46314 46314 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345119000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Humanitarian Demining Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Humanitarian Demining 1 Appropriated and Planned 2007 375000 510306
46319 46319 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345131000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Small Arms / Light Arms Destruction Fund Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Small Arms / Light Arms Destruction Fund 1 Appropriated and Planned 2007 525000 714429

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