./us_foreign_budget_complete

44 rows where Activity ID = 345014000, Fiscal Year = 2007 and International Category ID = 2

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Region ID, Income Group ID, Income Group Acronym

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
1797 1797 24 AGO Angola 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Angola 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 1320000 1796278
4988 4988 72 BWA Botswana 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Botswana 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 64053000 87164408
6624 6624 116 KHM Cambodia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Cambodia 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 1600000 2177307
8072 8072 156 CHN China (P.R.C.) 1 East Asia and Oceania 3 Upper Middle Income Country UMIC 54 EAP East Asian and Pacific Affairs China 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 1950000 2653593
9295 9295 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 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 3000000 4082451
10474 10474 214 DOM Dominican Republic 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Dominican Republic 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 1000000 1360817
11698 11698 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Ethiopia 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 230181000 313234205
12295 12295 262 DJI Djibouti 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Djibouti 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 300000 408245
12598 12598 268 GEO Georgia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Georgia 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 710000 966180
14165 14165 288 GHA Ghana 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Ghana 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 300000 408245
15475 15475 328 GUY Guyana 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guyana 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 25306000 34436834
15825 15825 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs Haiti 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 77285000 105170738
16531 16531 340 HND Honduras 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Honduras 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 750000 1020613
17054 17054 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs India 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 8971000 12207889
17532 17532 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Indonesia 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 250000 340204
18860 18860 384 CIV Cote d'Ivoire 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Cote d'Ivoire 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 68708000 93499011
19325 19325 398 KAZ Kazakhstan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Kazakhstan 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 270000 367421
20812 20812 404 KEN Kenya 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Kenya 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 337918000 459844540
21554 21554 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 160000 217731
23077 23077 426 LSO Lesotho 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Lesotho 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 6400000 8709228
23445 23445 430 LBR Liberia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Liberia 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 950000 1292776
25014 25014 454 MWI Malawi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Malawi 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 2900000 3946369
28502 28502 508 MOZ Mozambique 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Mozambique 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 148403000 201949317
29010 29010 516 NAM Namibia 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Namibia 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 86930000 118295817
29858 29858 558 NIC Nicaragua 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Nicaragua 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 100000 136082
30564 30564 566 NGA Nigeria 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Nigeria 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 281944000 383674172
34457 34457 643 RUS Russia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Russia 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 5345000 7273567
34790 34790 646 RWA Rwanda 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Rwanda 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 91861000 125006005
35372 35372 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 300000 408245
36546 36546 704 VNM Vietnam 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Vietnam 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 62935000 85643014
37669 37669 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 371432000 505450959
38161 38161 716 ZWE Zimbabwe 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Zimbabwe 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 4000000 5443268
39163 39163 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 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 3000000 4082451
39491 39491 748 SWZ Eswatini 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Eswatini 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 6200000 8437065
39885 39885 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 354000 481729
41559 41559 795 TKM Turkmenistan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Turkmenistan 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 250000 340204
42129 42129 800 UGA Uganda 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Uganda 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 210660000 286669697
42646 42646 804 UKR Ukraine 2 Europe and Eurasia 2 Lower Middle Income Country LMIC 55 EUR European and Eurasian Affairs Ukraine 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 1628000 2215410
44550 44550 834 TZA Tanzania 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Tanzania 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 176542000 240241345
45363 45363 860 UZB Uzbekistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Uzbekistan 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 40000 54433
46718 46718 894 ZMB Zambia 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Zambia 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 181897000 247528520
51062 51062 1002 WLD World 7 World       57 SCA South and Central Asian Affairs Central Asia Regional 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 232000 315710
52089 52089 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs USAID Caribbean Regional 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 1500000 2041225
54908 54908 1002 WLD World 7 World       70 GAC Global AIDS Coordinator, Office of Global AIDS Coordinator and Health Diplomacy (S/GAC) 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 776685000 1056926108

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