./us_foreign_budget_complete

44 rows where Fiscal Year = 2007, International Sector Code = 122 and Managing Sub-agency or Bureau Name = "African Affairs"

✎ 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
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
1723 1723 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 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 407000 553852
9133 9133 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 12220 Basic health care 3 Health 15 Other Public Health Threats 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 273000 371503
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
9187 9187 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 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 1550000 2109266
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
11558 11558 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Ethiopia 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 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 500000 680408
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
11612 11612 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Ethiopia 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 1200000 1632980
12271 12271 262 DJI Djibouti 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Djibouti 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 75000 102061
12281 12281 262 DJI Djibouti 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Djibouti 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 2007 75000 102061
14019 14019 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 12220 Basic health care 3 Health 15 Other Public Health Threats 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 495000 673604
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
14074 14074 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 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 500000 680408
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
20724 20724 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 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 1500000 2041225
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
24906 24906 454 MWI Malawi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Malawi 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 1381000 1879288
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
28362 28362 508 MOZ Mozambique 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Mozambique 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 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 412000 560657
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
28416 28416 508 MOZ Mozambique 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Mozambique 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 1000000 1360817
28999 28999 516 NAM Namibia 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Namibia 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 1180000 1605764
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
30473 30473 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 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 1600000 2177307
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
35283 35283 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 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 800000 1088654
37622 37622 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 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
39098 39098 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 12220 Basic health care 3 Health 15 Other Public Health Threats 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 3570000 4858116
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
39120 39120 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 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 500000 680408
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
42040 42040 800 UGA Uganda 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Uganda 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 1900000 2585552
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
44462 44462 834 TZA Tanzania 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Tanzania 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 400000 544327
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
46629 46629 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 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 1000000 1360817
47917 47917 1002 WLD World 7 World       53 AF African Affairs USAID Africa Regional 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 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 2273000 3093137
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
47953 47953 1002 WLD World 7 World       53 AF African Affairs USAID Africa Regional 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 2410000 3279569
48425 48425 1002 WLD World 7 World       53 AF African Affairs USAID East Africa Regional 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 747000 1016530

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