./us_foreign_budget_complete

40 rows where Fiscal Year = 2021 and International Sector Name = "Emergency Response"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Funding Account ID, Funding Account 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
4231 4231 51 ARM Armenia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Armenia 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344894000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2021 2020000 2159961
6248 6248 108 BDI Burundi 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Burundi 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 6742000 7209137
7207 7207 120 CMR Cameroon 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Cameroon 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 18376000 19649229
7410 7410 140 CAF Central African Republic 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Central African Republic 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 26432000 28263410
7962 7962 148 TCD Chad 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Chad 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 22898000 24484547
9004 9004 178 COG Congo (Brazzaville) 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Republic of the Congo 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 2674000 2859275
9894 9894 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Democratic Republic of the Congo 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 122580000 131073273
12122 12122 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Ethiopia 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 219940000 235179114
12462 12462 262 DJI Djibouti 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Djibouti 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 2187000 2338532
13952 13952 275 PSE West Bank and Gaza 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data West Bank and Gaza 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2021 6500000 6950369
16440 16440 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 998   Unknown - Budget Data Haiti 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 3110000 3325484
21389 21389 404 KEN Kenya 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Kenya 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 9906000 10592363
24723 24723 450 MDG Madagascar 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Madagascar 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 16969000 18144741
26186 26186 466 MLI Mali 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Mali 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 13689000 14637478
30376 30376 562 NER Niger 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Niger 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 10715000 11457417
31052 31052 566 NGA Nigeria 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Nigeria 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 1842000 1969628
37586 37586 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Somalia 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 32620000 34880161
38507 38507 716 ZWE Zimbabwe 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Zimbabwe 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 24969000 26699042
38975 38975 728 SSD South Sudan 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data South Sudan 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 117422000 125557888
39414 39414 729 SDN Sudan 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Sudan 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 125193000 133867322
42535 42535 800 UGA Uganda 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Uganda 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 1324000 1415737
44949 44949 834 TZA Tanzania 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Tanzania 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 2354000 2517103
45225 45225 854 BFA Burkina Faso 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Burkina Faso 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 15318000 16379347
46522 46522 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 998   Unknown - Budget Data Yemen 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 368476000 394006816
54525 54525 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Administrative Expenses 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2021 39204000 41920351
54846 54846 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Refugee Admissions 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2021 253800000 271385191
55916 55916 1002 WLD World 7 World       998   Unknown - Budget Data Bureau for Humanitarian Assistance 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 134897000 144243689
55921 55921 1002 WLD World 7 World       998   Unknown - Budget Data Bureau for Humanitarian Assistance 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344903000 Budget for International Disaster and Famine Assistance Budget for International Disaster and Famine Assistance 1 Appropriated and Planned 2021 3836931000 4102782719
56189 56189 1002 WLD World 7 World       998   Unknown - Budget Data Bureau of International Organization Affairs (DOS), UN Office for the Coordination of Humanitarian Affairs 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344928000 Budget for International Organizations and Programs, State - United Nations Office of Co-ordination of Humanitarian Affairs Budget for International Organizations and Programs, State - United Nations Office of Co-ordination of Humanitarian Affairs 1 Appropriated and Planned 2021 3500000 3742507
56429 56429 1002 WLD World 7 World       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Administrative Expenses 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2021 46201000 49402156
56435 56435 1002 WLD World 7 World       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Emergency Fund 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344940000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 1 Appropriated and Planned 2021 100000 106929
56447 56447 1002 WLD World 7 World       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Refugee Admissions 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2021 232900000 249037081
56459 56459 1002 WLD World 7 World       998   Unknown - Budget Data Bureau of Population, Refugees and Migration, Overseas Assistance (DOS) - Protection Priorities 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2021 339700000 363236996
58805 58805 1002 WLD World 7 World       998   Unknown - Budget Data To Be Programmed 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   345037000 Budget for International Humanitarian Assistance Budget for International Humanitarian Assistance 18 President's Budget Requests 2021 5968000000 6381508364
60372 60372 1016 ENS Eastern Asia Region 1 East Asia and Oceania       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, East Asia 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2021 209600000 224122680
60866 60866 1018 EUN Europe Region 2 Europe and Eurasia       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, Europe 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2021 93200000 99657604
61303 61303 1023 MNS Middle East and North Africa Region 3 Middle East and North Africa       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, Near East 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2021 1177770000 1259374850
61668 61668 1029 SAN Southern Asia Region 4 South and Central Asia       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, South Asia 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2021 68400000 73139271
62139 62139 1033 SSN Sub-Saharan Africa Region 5 Sub-Saharan Africa       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, Africa 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2021 902500000 965032054
62286 62286 1035 WHN Western Hemisphere Region 6 Western Hemisphere       998   Unknown - Budget Data Bureau of Population, Refugees and Migration (DOS) - Overseas Assistance, Western Hemisphere 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   344935000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2021 308300000 329661365

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