./us_foreign_budget_complete

27 rows where Fiscal Year = 2017 and International Sector Code = 230

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Managing Sub-agency or Bureau ID, current_amount

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
3363 3363 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Bangladesh 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 3000000 3506172
8719 8719 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2017 4000000 4674896
11920 11920 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Ethiopia 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 2000000 2337448
17225 17225 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs India 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 12000000 14024687
17940 17940 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Indonesia 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 8000000 9349791
19186 19186 388 JAM Jamaica 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Jamaica 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 2000000 2337448
19640 19640 398 KAZ Kazakhstan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Kazakhstan 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2017 2500000 2921810
21142 21142 404 KEN Kenya 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Kenya 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 2000000 2337448
26792 26792 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2017 6000000 7012343
33552 33552 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 4000000 4674896
36868 36868 704 VNM Vietnam 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Vietnam 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 3000000 3506172
37850 37850 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 3000000 3506172
48260 48260 1002 WLD World 7 World       53 AF African Affairs USAID Africa Regional 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 4500000 5259258
48936 48936 1002 WLD World 7 World       53 AF African Affairs USAID Southern Africa Regional 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 2000000 2337448
49943 49943 1002 WLD World 7 World       54 EAP East Asian and Pacific Affairs USAID Regional Development Mission-Asia (RDM/A) 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 3000000 3506172
50267 50267 1002 WLD World 7 World       55 EUR European and Eurasian Affairs Europe and Eurasia Regional 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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) 18 President's Budget Requests 2017 5000000 5843619
52193 52193 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs USAID Central America Regional 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 3000000 3506172
52500 52500 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs USAID Latin America and Caribbean Regional 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 500000 584362
53404 53404 1002 WLD World 7 World       63 IO International Organization Affairs IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   345056000 Budget for International Organizations and Programs, State - IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change Budget for International Organizations and Programs, State - IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change 18 President's Budget Requests 2017 4500000 5259258
53472 53472 1002 WLD World 7 World       63 IO International Organization Affairs IO - Montreal Protocol Multilateral Fund 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   345061000 Budget for International Organizations and Programs, State - IO - Montreal Protocol Multilateral Fund Budget for International Organizations and Programs, State - IO - Montreal Protocol Multilateral Fund 18 President's Budget Requests 2017 32500000 37983527
54062 54062 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/CC Climate Change 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2017 37131000 43395887
54263 54263 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs State Oceans and International Environmental and Scientific Affairs (OES) 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2017 150000000 175308585
55493 55493 1002 WLD World 7 World       128 ENR Energy Resources Bureau for Energy Resources (ENR) 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2017 4000000 4674896
57944 57944 1002 WLD World 7 World       998   Unknown - Budget Data LAB - Data, Analysis, and Research Center (DAR) 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 10000000 11687239
57965 57965 1002 WLD World 7 World       998   Unknown - Budget Data LAB - Development Innovation Center (DI) 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 10000000 11687239
58006 58006 1002 WLD World 7 World       998   Unknown - Budget Data LAB - Mission Engagement & Operations Center (MEO) 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 5000000 5843619
59466 59466 1002 WLD World 7 World       998   Unknown - Budget Data USAID Economic Growth, Education and Environment (E3) 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 16000000 18699582

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