./us_foreign_budget_complete

25 rows where Fiscal Year = 2014 and Funding Account ID = "11x1032"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Activity Name, current_amount

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
7328 7328 140 CAF Central African Republic 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Central African Republic 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 1 345159000 Budget for Peace Keeping Operations - Overseas Contingency Operations (OCO) Budget for Peace Keeping Operations - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2014 10000000 12131985
9545 9545 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   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 1 Appropriated and Planned 2014 10000000 12131985
9554 9554 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   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 18 President's Budget Requests 2014 11000000 13345183
15354 15354 324 GIN Guinea 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Guinea 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   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 1 Appropriated and Planned 2014 580000 703655
18953 18953 384 CIV Cote d'Ivoire 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Cote d'Ivoire 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   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 1 Appropriated and Planned 2014 500000 606599
18955 18955 384 CIV Cote d'Ivoire 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Cote d'Ivoire 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   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 18 President's Budget Requests 2014 2000000 2426397
23658 23658 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 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 1 Appropriated and Planned 2014 2000000 2426397
23667 23667 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 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 18 President's Budget Requests 2014 2000000 2426397
25936 25936 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 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 1 Appropriated and Planned 2014 2720000 3299900
25938 25938 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 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 18 President's Budget Requests 2014 83750000 101605371
37360 37360 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Somalia 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   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 1 Appropriated and Planned 2014 42350000 51378955
37372 37372 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Somalia 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   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 18 President's Budget Requests 2014 70000000 84923892
37383 37383 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Somalia 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 1 345159000 Budget for Peace Keeping Operations - Overseas Contingency Operations (OCO) Budget for Peace Keeping Operations - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2014 158000000 191685356
38763 38763 728 SSD South Sudan 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs South Sudan 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   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 1 Appropriated and Planned 2014 30700000 37245193
38765 38765 728 SSD South Sudan 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs South Sudan 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   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 18 President's Budget Requests 2014 38000000 46101541
38772 38772 728 SSD South Sudan 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs South Sudan 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 1 345159000 Budget for Peace Keeping Operations - Overseas Contingency Operations (OCO) Budget for Peace Keeping Operations - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2014 12000000 14558382
47695 47695 1002 WLD World 7 World       53 AF African Affairs State Africa Regional 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   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 1 Appropriated and Planned 2014 23650000 28692144
47708 47708 1002 WLD World 7 World       53 AF African Affairs State Africa Regional 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   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 18 President's Budget Requests 2014 21150000 25659147
50575 50575 1002 WLD World 7 World       56 NEA Near Eastern Affairs Multinational Force and Observers (MFO) 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   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 1 Appropriated and Planned 2014 36000000 43675145
50582 50582 1002 WLD World 7 World       56 NEA Near Eastern Affairs Multinational Force and Observers (MFO) 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   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 18 President's Budget Requests 2014 28000000 33969557
54363 54363 1002 WLD World 7 World       66 PM Political-Military Affairs PM - GPOI, Global Peace Operations Initiative 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   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 1 Appropriated and Planned 2014 71000000 86137091
54375 54375 1002 WLD World 7 World       66 PM Political-Military Affairs PM - GPOI, Global Peace Operations Initiative 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   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 18 President's Budget Requests 2014 75000000 90989884
54413 54413 1002 WLD World 7 World       66 PM Political-Military Affairs PM - Peacekeeping Response 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 1 345159000 Budget for Peace Keeping Operations - Overseas Contingency Operations (OCO) Budget for Peace Keeping Operations - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2014 20000000 24263969
54427 54427 1002 WLD World 7 World       66 PM Political-Military Affairs PM - TSCTP, Trans-Sahara Counter-Terrorism Partnership 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   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 1 Appropriated and Planned 2014 16100000 19532495
54433 54433 1002 WLD World 7 World       66 PM Political-Military Affairs PM - TSCTP, Trans-Sahara Counter-Terrorism Partnership 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   345158000 Budget for Peace Keeping Operations Budget for Peace Keeping Operations 18 President's Budget Requests 2014 16100000 19532495

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