./us_foreign_budget_complete

32 rows where Activity Name = "Budget for Foreign Military Financing Program", Income Group Name = "Upper Middle Income Country" and Region ID = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type 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
5047 5047 72 BWA Botswana 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Botswana 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 1 Appropriated and Planned 2008 300000 399905
5048 5048 72 BWA Botswana 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Botswana 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 1 Appropriated and Planned 2010 200000 261646
5049 5049 72 BWA Botswana 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Botswana 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 1 Appropriated and Planned 2011 339000 434728
5050 5050 72 BWA Botswana 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Botswana 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 1 Appropriated and Planned 2012 200000 251860
5051 5051 72 BWA Botswana 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Botswana 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 1 Appropriated and Planned 2013 190000 234967
5052 5052 72 BWA Botswana 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Botswana 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 1 Appropriated and Planned 2014 200000 242640
5053 5053 72 BWA Botswana 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Botswana 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 18 President's Budget Requests 2010 200000 261646
5054 5054 72 BWA Botswana 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Botswana 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 18 President's Budget Requests 2011 340000 436010
5055 5055 72 BWA Botswana 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Botswana 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 18 President's Budget Requests 2012 200000 251860
5056 5056 72 BWA Botswana 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Botswana 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 18 President's Budget Requests 2013 200000 247334
5057 5057 72 BWA Botswana 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Botswana 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 18 President's Budget Requests 2014 200000 242640
12494 12494 266 GAB Gabon 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Gabon 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 1 Appropriated and Planned 2010 520000 680278
12495 12495 266 GAB Gabon 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Gabon 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 1 Appropriated and Planned 2011 200000 256477
12496 12496 266 GAB Gabon 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Gabon 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 18 President's Budget Requests 2010 200000 261646
12497 12497 266 GAB Gabon 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Gabon 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 18 President's Budget Requests 2011 200000 256477
12498 12498 266 GAB Gabon 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Gabon 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 18 President's Budget Requests 2012 200000 251860
37811 37811 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 1 Appropriated and Planned 2010 800000 1046582
37812 37812 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 1 Appropriated and Planned 2011 798000 1023342
37813 37813 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 1 Appropriated and Planned 2012 700000 881510
37814 37814 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 1 Appropriated and Planned 2013 665000 822385
37815 37815 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 1 Appropriated and Planned 2014 700000 849239
37816 37816 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 1 Appropriated and Planned 2015 450000 539751
37817 37817 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 1 Appropriated and Planned 2016 300000 356877
37818 37818 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 18 President's Budget Requests 2008 100000 133302
37819 37819 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 18 President's Budget Requests 2010 800000 1046582
37820 37820 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 18 President's Budget Requests 2011 800000 1025906
37821 37821 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 18 President's Budget Requests 2012 700000 881510
37822 37822 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 18 President's Budget Requests 2013 700000 865668
37823 37823 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 18 President's Budget Requests 2014 700000 849239
37824 37824 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 18 President's Budget Requests 2015 450000 539751
37825 37825 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 18 President's Budget Requests 2016 450000 535316
37826 37826 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 18 President's Budget Requests 2017 300000 350617

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