./us_foreign_budget_complete

20 rows where Fiscal Year = 2010, International Sector Code = 210 and Managing Sub-agency or Bureau Acronym = "AF"

✎ View and edit SQL

This data as json, CSV (advanced)

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
9690 9690 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Democratic Republic of the Congo 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2010 30000 39247
9691 9691 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Democratic Republic of the Congo 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2010 500000 654114
14348 14348 288 GHA Ghana 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Ghana 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 3122000 4084287
23765 23765 430 LBR Liberia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Liberia 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2010 17502000 22896601
23772 23772 430 LBR Liberia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Liberia 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2010 18502000 24204829
24363 24363 450 MDG Madagascar 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2010 1201000 1571181
28677 28677 508 MOZ Mozambique 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Mozambique 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 15000000 19623416
30847 30847 566 NGA Nigeria 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Nigeria 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 1500000 1962342
34939 34939 646 RWA Rwanda 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Rwanda 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 10000000 13082277
39312 39312 729 SDN Sudan 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Sudan (Pre-July 2011) 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2010 81308000 106369379
39315 39315 729 SDN Sudan 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Sudan (Pre-July 2011) 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2010 112393000 147035638
44748 44748 834 TZA Tanzania 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Tanzania 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 1000000 1308228
48229 48229 1002 WLD World 7 World       53 AF African Affairs USAID Africa Regional 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 5400000 7064430
48242 48242 1002 WLD World 7 World       53 AF African Affairs USAID Africa Regional 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 15000000 19623416
48594 48594 1002 WLD World 7 World       53 AF African Affairs USAID East Africa Regional 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 4621000 6045320
48599 48599 1002 WLD World 7 World       53 AF African Affairs USAID East Africa Regional 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 3511000 4593188
48928 48928 1002 WLD World 7 World       53 AF African Affairs USAID Southern Africa Regional 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 300000 392468
48931 48931 1002 WLD World 7 World       53 AF African Affairs USAID Southern Africa Regional 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 1700000 2223987
49237 49237 1002 WLD World 7 World       53 AF African Affairs USAID West Africa Regional 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 2000000 2616455
49241 49241 1002 WLD World 7 World       53 AF African Affairs USAID West Africa Regional 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 11977000 15668643

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