./us_foreign_budget_complete

22 rows where Fiscal Year = 2007 and International Purpose Code = 12262

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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, current_amount, constant_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
1695 1695 24 AGO Angola 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Angola 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 18500000 25175113
9158 9158 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Democratic Republic of the Congo 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 6700000 9117474
10211 10211 204 BEN Benin 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Benin 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 3600000 4898941
11583 11583 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Ethiopia 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 6700000 9117474
14045 14045 288 GHA Ghana 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Ghana 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 5000000 6804085
20695 20695 404 KEN Kenya 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Kenya 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 6050000 8232943
23328 23328 430 LBR Liberia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Liberia 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 2500000 3402042
24439 24439 450 MDG Madagascar 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Madagascar 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 5000000 6804085
24877 24877 454 MWI Malawi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Malawi 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 18500000 25175113
25694 25694 466 MLI Mali 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Mali 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 4500000 6123676
28387 28387 508 MOZ Mozambique 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Mozambique 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 18000000 24494705
30444 30444 566 NGA Nigeria 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Nigeria 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 6500000 8845310
34704 34704 646 RWA Rwanda 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Rwanda 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 20000000 27216339
35254 35254 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 16700000 22725643
39108 39108 729 SDN Sudan 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Sudan (Pre-July 2011) 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 3000000 4082451
42011 42011 800 UGA Uganda 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Uganda 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 21500000 29257564
44433 44433 834 TZA Tanzania 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Tanzania 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 31000000 42185325
46600 46600 894 ZMB Zambia 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Zambia 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 9470000 12886936
47150 47150 1002 WLD World 7 World       25 GH Bureau for Global Health Global Health - Core 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 32280000 43927171
47924 47924 1002 WLD World 7 World       53 AF African Affairs USAID Africa Regional 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 2000000 2721634
49797 49797 1002 WLD World 7 World       54 EAP East Asian and Pacific Affairs USAID Regional Development Mission-Asia (RDM/A) 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 5500000 7484493
52318 52318 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs USAID Latin America and Caribbean Regional 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 5000000 6804085

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