./us_foreign_budget_complete

32 rows where Fiscal Year = 2018, Income Group Name = "Lower Middle Income Country" and International Sector Name = "Basic Education"

✎ 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
2877 2877 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Bangladesh 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2018 15000000 17128672
2890 2890 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Bangladesh 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2018 7000000 7993380
5442 5442 104 MMR Burma (Myanmar) 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Burma 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2018 2000000 2283823
6469 6469 116 KHM Cambodia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Cambodia 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2018 5000000 5709557
11021 11021 222 SLV El Salvador 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs El Salvador 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2018 12000000 13702938
11033 11033 222 SLV El Salvador 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs El Salvador 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2018 3565000 4070914
12265 12265 262 DJI Djibouti 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Djibouti 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2018 2000000 2283823
13434 13434 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 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2018 12500000 14273894
13997 13997 288 GHA Ghana 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Ghana 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2018 20000000 22838230
14013 14013 288 GHA Ghana 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Ghana 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2018 5000000 5709557
16473 16473 340 HND Honduras 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Honduras 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2018 14635000 16711875
16485 16485 340 HND Honduras 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Honduras 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2018 13000000 14844849
16942 16942 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs India 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2018 3000000 3425734
20641 20641 404 KEN Kenya 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Kenya 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2018 18000000 20554407
20654 20654 404 KEN Kenya 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Kenya 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2018 8000000 9135292
21437 21437 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2018 4800000 5481175
21453 21453 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2018 2000000 2283823
22118 22118 418 LAO Laos 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Laos 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2018 2000000 2283823
27893 27893 504 MAR Morocco 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Morocco 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2018 4500000 5138602
27894 27894 504 MAR Morocco 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Morocco 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2018 3650000 4167977
29807 29807 558 NIC Nicaragua 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Nicaragua 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2018 3000000 3425734
30403 30403 566 NGA Nigeria 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Nigeria 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2018 25000000 28547787
30421 30421 566 NGA Nigeria 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Nigeria 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID 1 344992000 Budget for Economic Support Fund and Development Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund and Development Fund - Overseas Contingency Operations (OCO) 18 President's Budget Requests 2018 16000000 18270584
31227 31227 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2018 4188000 4782325
31233 31233 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID 1 344992000 Budget for Economic Support Fund and Development Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund and Development Fund - Overseas Contingency Operations (OCO) 18 President's Budget Requests 2018 29602000 33802864
32989 32989 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2018 15500000 17699628
33005 33005 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2018 7700000 8792719
35211 35211 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2018 19685000 22478528
35225 35225 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2018 6800000 7764998
43766 43766 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2018 13000000 14844849
43767 43767 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2018 13000000 14844849
46558 46558 894 ZMB Zambia 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Zambia 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2018 8400000 9592057

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