./us_foreign_budget_complete

34 rows where Funding Account ID = "11x0040" and International Category ID = 9

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Managing Sub-agency or Bureau ID, Managing Sub-agency or Bureau Name, Operating Unit, Activity ID, Activity Name, Activity Description, Transaction Type ID, current_amount, constant_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
54526 54526 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 1 Appropriated and Planned 2008 44636000 59500492
54527 54527 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 1 Appropriated and Planned 2009 40000000 52784240
54528 54528 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 1 Appropriated and Planned 2010 45000000 58870247
54529 54529 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 1 Appropriated and Planned 2011 49900000 63990906
54530 54530 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 1 Appropriated and Planned 2012 27200000 34252960
54531 54531 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 1 Appropriated and Planned 2013 25823000 31934503
54532 54532 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 1 Appropriated and Planned 2014 50000000 60659923
54533 54533 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 1 Appropriated and Planned 2015 50000000 59972378
54534 54534 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 1 Appropriated and Planned 2016 50000000 59479501
54535 54535 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 1 Appropriated and Planned 2017 10000000 11687239
54536 54536 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 1 Appropriated and Planned 2018 1000000 1141911
54537 54537 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 1 Appropriated and Planned 2019 1000000 1119975
54538 54538 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 1 Appropriated and Planned 2020 100000 110523
54539 54539 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 18 President's Budget Requests 2009 45000000 59382270
54540 54540 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 18 President's Budget Requests 2010 75000000 98117079
54541 54541 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 18 President's Budget Requests 2011 45000000 57707230
54542 54542 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 18 President's Budget Requests 2012 32000000 40297600
54543 54543 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 18 President's Budget Requests 2013 50000000 61833448
54544 54544 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 18 President's Budget Requests 2014 250000000 303299615
54545 54545 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 18 President's Budget Requests 2015 50000000 59972378
54546 54546 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 18 President's Budget Requests 2016 50000000 59479501
54547 54547 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 18 President's Budget Requests 2017 10000000 11687239
54548 54548 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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 1 345190000 Budget for United States Emergency Refugee and Migration Assistance Fund - Overseas Contingency Operations (OCO) Budget for United States Emergency Refugee and Migration Assistance Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2017 40000000 46748956
54549 54549 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Emergency Funds 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 1 345190000 Budget for United States Emergency Refugee and Migration Assistance Fund - Overseas Contingency Operations (OCO) Budget for United States Emergency Refugee and Migration Assistance Fund - Overseas Contingency Operations (OCO) 18 President's Budget Requests 2017 40000000 46748956
54856 54856 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration State Population, Refugees and Migration (PRM) 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 1 Appropriated and Planned 2006 29700000 41524603
54857 54857 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration State Population, Refugees and Migration (PRM) 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 1 Appropriated and Planned 2007 55000000 74844932
54858 54858 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration State Population, Refugees and Migration (PRM) 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   345189000 Budget for United States Emergency Refugee and Migration Assistance Fund Budget for United States Emergency Refugee and Migration Assistance Fund 18 President's Budget Requests 2008 55000000 73315867
54859 54859 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration State Population, Refugees and Migration (PRM) 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   345191000 Budget for United States Emergency Refugee and Migration Assistance Fund, H.R. 2206 Supplemental Budget for United States Emergency Refugee and Migration Assistance Fund, H.R. 2206 Supplemental 1 Appropriated and Planned 2007 55000000 74844932
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
56436 56436 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 2022 100000 100000
56437 56437 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 2023 100000 95380
56438 56438 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 18 President's Budget Requests 2022 100000 100000
56439 56439 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 18 President's Budget Requests 2023 100000000 95379838
56440 56440 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 18 President's Budget Requests 2024 100000000 93177950

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