./us_foreign_budget_complete

70 rows where Fiscal Year = 2007 and International Sector Name = "Other Social Infrastructure and Services"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Income Group Acronym, US Sector ID, Funding Agency Acronym, Activity Name

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
742 742 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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
744 744 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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 2007 2500000 3402042
746 746 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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 500000 680408
771 771 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 39 Department of State and U.S. Agency for International Development State/USAID   344996000 Budget for Economic Support Fund, H.R. 2206 Supplemental Budget for Economic Support Fund, H.R. 2206 Supplemental 1 Appropriated and Planned 2007 10000000 13608169
779 779 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 169740000 230985068
799 799 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345046000 Budget for International Narcotics Control and Law Enforcement, H.R. 2206 Supplemental Budget for International Narcotics Control and Law Enforcement, H.R. 2206 Supplemental 1 Appropriated and Planned 2007 27000000 36742057
817 817 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 2007 9000000 12247352
820 820 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 64948000 88382339
829 829 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   344996000 Budget for Economic Support Fund, H.R. 2206 Supplemental Budget for Economic Support Fund, H.R. 2206 Supplemental 1 Appropriated and Planned 2007 155000000 210926626
2625 2625 44 BHS Bahamas 6 Western Hemisphere 4 High Income Country HIC 58 WHA Western Hemisphere Affairs Bahamas, The 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 500000 680408
2788 2788 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 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 2007 1812000 2465800
3336 3336 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Bangladesh 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 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 2007 6000 8165
4012 4012 51 ARM Armenia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Armenia 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2007 1150000 1564939
4031 4031 51 ARM Armenia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Armenia 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2007 1350000 1837103
4274 4274 68 BOL Bolivia 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs   3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 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 2007 3008000 4093337
4397 4397 68 BOL Bolivia 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Bolivia 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 61690000 83948797
5164 5164 76 BRA Brazil 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Brazil 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 4000000 5443268
6360 6360 112 BLR Belarus 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Belarus 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2007 480000 653192
8134 8134 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 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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 1500000 2041225
8622 8622 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 26550000 36129690
8656 8656 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 351334000 478101260
9659 9659 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Democratic Republic of the Congo 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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 1300000 1769062
9661 9661 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Democratic Republic of the Congo 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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 2007 2306000 3138044
10869 10869 218 ECU Ecuador 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Ecuador 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 15640000 21283177
10892 10892 218 ECU Ecuador 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Ecuador 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 644000 876366
12993 12993 268 GEO Georgia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Georgia 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2007 50000 68041
13696 13696 275 PSE West Bank and Gaza 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs West Bank and Gaza 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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 2000000 2721634
13977 13977 288 GHA Ghana 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 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 2007 4350000 5919554
14616 14616 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs   3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 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 2007 390000 530719
14961 14961 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 1850000 2517511
15649 15649 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs   3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 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 2007 2927000 3983111
16134 16134 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs Haiti 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 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 2007 1750000 2381430
16139 16139 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs Haiti 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 1900000 2585552
16452 16452 340 HND Honduras 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs   3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 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 2007 2514000 3421094
17897 17897 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Indonesia 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 500000 680408
19174 19174 388 JAM Jamaica 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Jamaica 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 900000 1224735
19606 19606 398 KAZ Kazakhstan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Kazakhstan 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2007 450000 612368
20601 20601 404 KEN Kenya 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 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 2007 900000 1224735
21879 21879 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2007 300000 408245
22285 22285 418 LAO Laos 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Laos 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 900000 1224735
22858 22858 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Lebanon 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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 400000 544327
23240 23240 430 LBR Liberia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 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 2007 2500000 3402042
24343 24343 450 MDG Madagascar 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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 2007 1200000 1632980
24765 24765 454 MWI Malawi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 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 2007 4105000 5586154
26753 26753 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 14656000 19944133
30842 30842 566 NGA Nigeria 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Nigeria 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 200000 272163
31737 31737 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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 53031000 72165483
31746 31746 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 5300000 7212330
32198 32198 591 PAN Panama 6 Western Hemisphere 4 High Income Country HIC 58 WHA Western Hemisphere Affairs Panama 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 3250000 4422655
32777 32777 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 102765000 139844353
33508 33508 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 100000 136082
34581 34581 643 RUS Russia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Russia 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2007 2841000 3866081
34624 34624 646 RWA Rwanda 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 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 2007 4559000 6203964
40193 40193 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2007 5300000 7212330
41767 41767 795 TKM Turkmenistan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Turkmenistan 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2007 200000 272163
45008 45008 854 BFA Burkina Faso 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 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 2007 1917000 2608686
45889 45889 862 VEN Venezuela 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Venezuela 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 786000 1069602
47786 47786 1002 WLD World 7 World       53 AF African Affairs State Africa Regional 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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 7250000 9865923
48217 48217 1002 WLD World 7 World       53 AF African Affairs USAID Africa Regional 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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 2007 4450000 6055635
48219 48219 1002 WLD World 7 World       53 AF African Affairs USAID Africa Regional 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 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 2007 900000 1224735
49661 49661 1002 WLD World 7 World       54 EAP East Asian and Pacific Affairs State East Asia and Pacific Regional 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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 100000 136082
49663 49663 1002 WLD World 7 World       54 EAP East Asian and Pacific Affairs State East Asia and Pacific Regional 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 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 10000 13608
51952 51952 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs State Western Hemisphere Regional 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 2200000 2993797
53329 53329 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs State International Narcotics and Law Enforcement Affairs (INL) 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2007 147030000 200080915
57828 57828 1002 WLD World 7 World       998   Unknown - Budget Data Global Health - International Partnerships 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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 1782000 2424976
59165 59165 1002 WLD World 7 World       998   Unknown - Budget Data USAID Democracy, Conflict and Humanitarian Assistance (DCHA) 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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
59168 59168 1002 WLD World 7 World       998   Unknown - Budget Data USAID Democracy, Conflict and Humanitarian Assistance (DCHA) 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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 2007 13200000 17962784
59171 59171 1002 WLD World 7 World       998   Unknown - Budget Data USAID Democracy, Conflict and Humanitarian Assistance (DCHA) 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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 23760000 32333011
59417 59417 1002 WLD World 7 World       998   Unknown - Budget Data USAID Economic Growth, Education and Environment (E3) 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 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 2007 290000 394637
60587 60587 1018 EUN Europe Region 2 Europe and Eurasia       55 EUR European and Eurasian Affairs Eurasia Regional 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2007 131000 178267

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