./us_foreign_budget_complete

42 rows where Fiscal Year = 2007 and International Sector Code = 240

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country ID, Country Code, Country Name, Region ID, Income Group ID, Income Group Name, Income Group Acronym, Managing Sub-agency or Bureau ID, Funding Account ID, Funding Account Name, Funding Agency ID, Funding Agency Name, Activity Description

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
882 882 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 3462000 4711148
884 884 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 6024000 8197561
1944 1944 24 AGO Angola 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Angola 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 272000 370142
4060 4060 51 ARM Armenia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Armenia 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 100000 136082
4818 4818 70 BIH Bosnia and Herzegovina 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Bosnia and Herzegovina 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 2355000 3204724
6154 6154 108 BDI Burundi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Burundi 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 349000 474925
6891 6891 116 KHM Cambodia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Cambodia 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 1227000 1669722
7682 7682 144 LKA Sri Lanka 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Sri Lanka 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 800000 1088654
13055 13055 268 GEO Georgia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Georgia 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 2637000 3588474
13765 13765 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 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 3000000 4082451
16178 16178 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs Haiti 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 701000 953933
16180 16180 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs Haiti 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 1850000 2517511
17228 17228 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs India 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 665000 904943
18608 18608 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Iraq 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 20000000 27216339
19642 19642 398 KAZ Kazakhstan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Kazakhstan 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 275000 374225
21144 21144 404 KEN Kenya 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Kenya 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 1211000 1647949
21913 21913 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 1372000 1867041
22868 22868 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Lebanon 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 1267000 1724155
22883 22883 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Lebanon 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 6250000 8505106
23785 23785 430 LBR Liberia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Liberia 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 3650000 4966982
25125 25125 454 MWI Malawi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Malawi 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 1360000 1850711
26794 26794 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 3100000 4218533
27069 27069 496 MNG Mongolia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Mongolia 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 2100000 2857716
27448 27448 498 MDA Moldova 2 Europe and Eurasia 2 Lower Middle Income Country LMIC 55 EUR European and Eurasian Affairs Moldova 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 350000 476286
31807 31807 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 2560000 3483691
31809 31809 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 4241000 5771225
33568 33568 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 1700000 2313389
34179 34179 626 TLS Timor-Leste 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Timor-Leste 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 1565000 2129679
34601 34601 643 RUS Russia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Russia 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 2916000 3968142
36003 36003 688 SRB Serbia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Serbia 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 6800000 9253555
40222 40222 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 102000 138803
45018 45018 854 BFA Burkina Faso 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 2024000 2754293
46847 46847 894 ZMB Zambia 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Zambia 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 603000 820573
47820 47820 1002 WLD World 7 World       53 AF African Affairs State Africa Regional 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 750000 1020613
48262 48262 1002 WLD World 7 World       53 AF African Affairs USAID Africa Regional 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 100000 136082
49694 49694 1002 WLD World 7 World       54 EAP East Asian and Pacific Affairs State East Asia and Pacific Regional 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 550000 748449
51405 51405 1002 WLD World 7 World       57 SCA South and Central Asian Affairs State South and Central Asia Regional 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 250000 340204
51986 51986 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs State Western Hemisphere Regional 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 8850000 12043230
53885 53885 1002 WLD World 7 World       63 IO International Organization Affairs International Organizations (IO) 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345092000 Budget for International Organizations and Programs, State - International Organizations (IO) Budget for International Organizations and Programs, State - International Organizations (IO) 1 Appropriated and Planned 2007 4703000 6399922
59177 59177 1002 WLD World 7 World       998   Unknown - Budget Data USAID Democracy, Conflict and Humanitarian Assistance (DCHA) 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 1831000 2491656
59468 59468 1002 WLD World 7 World       998   Unknown - Budget Data USAID Economic Growth, Education and Environment (E3) 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 22951000 31232110
59667 59667 1002 WLD World 7 World       998   Unknown - Budget Data USAID Office of Development Partners (ODP) 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 171000 232700

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