./us_foreign_budget_complete

32 rows where International Category Name = "Humanitarian" and Managing Sub-agency or Bureau Acronym = "IO"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: International Purpose Code

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
53548 53548 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA 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   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 1 Appropriated and Planned 2008 2976000 3967055
53549 53549 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA 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   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 1 Appropriated and Planned 2010 3000000 3924683
53550 53550 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA 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   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 1 Appropriated and Planned 2016 2700000 3211893
53551 53551 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA 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   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 1 Appropriated and Planned 2017 2500000 2921810
53552 53552 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA 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   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 1 Appropriated and Planned 2018 2500000 2854779
53553 53553 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA 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   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 1 Appropriated and Planned 2019 2500000 2799938
53554 53554 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA 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   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 1 Appropriated and Planned 2020 3500000 3868308
53555 53555 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA 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   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 18 President's Budget Requests 2009 2000000 2639212
53556 53556 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA 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   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 18 President's Budget Requests 2010 3000000 3924683
53557 53557 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA 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   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 18 President's Budget Requests 2011 3000000 3847149
53558 53558 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA 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   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 18 President's Budget Requests 2012 2940000 3702342
53559 53559 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 39 Department of State and U.S. Agency for International Development State/USAID   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 1 Appropriated and Planned 2009 3000000 3958818
53560 53560 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 39 Department of State and U.S. Agency for International Development State/USAID   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 1 Appropriated and Planned 2011 2940000 3770206
53561 53561 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 39 Department of State and U.S. Agency for International Development State/USAID   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 1 Appropriated and Planned 2012 3000000 3777900
53562 53562 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 39 Department of State and U.S. Agency for International Development State/USAID   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 1 Appropriated and Planned 2013 2800000 3462673
53563 53563 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 39 Department of State and U.S. Agency for International Development State/USAID   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 1 Appropriated and Planned 2014 3000000 3639595
53564 53564 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 39 Department of State and U.S. Agency for International Development State/USAID   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 1 Appropriated and Planned 2015 3000000 3598343
53565 53565 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 39 Department of State and U.S. Agency for International Development State/USAID   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 18 President's Budget Requests 2013 2900000 3586340
53566 53566 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 39 Department of State and U.S. Agency for International Development State/USAID   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 18 President's Budget Requests 2014 2800000 3396956
53567 53567 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 39 Department of State and U.S. Agency for International Development State/USAID   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 18 President's Budget Requests 2015 2800000 3358453
53568 53568 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 39 Department of State and U.S. Agency for International Development State/USAID   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 18 President's Budget Requests 2016 2500000 2973975
53569 53569 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 39 Department of State and U.S. Agency for International Development State/USAID   345069000 Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs Budget for International Organizations and Programs, State - IO - UN OCHA UN Office for the Coordination of Humanitarian Affairs 18 President's Budget Requests 2017 2500000 2921810
53744 53744 1002 WLD World 7 World       63 IO International Organization Affairs IO - UNESCO/ICSECA International Contributions for Scientific, Educational, and Cultural Activities 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 39 Department of State and U.S. Agency for International Development State/USAID   345084000 Budget for International Organizations and Programs, State - IO - UNESCO/ICSECA International Contributions for Scientific, Educational, and Cultural Activities Budget for International Organizations and Programs, State - IO - UNESCO/ICSECA International Contributions for Scientific, Educational, and Cultural Activities 1 Appropriated and Planned 2008 992000 1322352
53745 53745 1002 WLD World 7 World       63 IO International Organization Affairs IO - UNESCO/ICSECA International Contributions for Scientific, Educational, and Cultural Activities 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 39 Department of State and U.S. Agency for International Development State/USAID   345084000 Budget for International Organizations and Programs, State - IO - UNESCO/ICSECA International Contributions for Scientific, Educational, and Cultural Activities Budget for International Organizations and Programs, State - IO - UNESCO/ICSECA International Contributions for Scientific, Educational, and Cultural Activities 1 Appropriated and Planned 2009 1000000 1319606
53746 53746 1002 WLD World 7 World       63 IO International Organization Affairs IO - UNESCO/ICSECA International Contributions for Scientific, Educational, and Cultural Activities 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 39 Department of State and U.S. Agency for International Development State/USAID   345084000 Budget for International Organizations and Programs, State - IO - UNESCO/ICSECA International Contributions for Scientific, Educational, and Cultural Activities Budget for International Organizations and Programs, State - IO - UNESCO/ICSECA International Contributions for Scientific, Educational, and Cultural Activities 18 President's Budget Requests 2009 1000000 1319606
53747 53747 1002 WLD World 7 World       63 IO International Organization Affairs IO - UNESCO/ICSECA International Contributions for Scientific, Educational, and Cultural Activities 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 39 Department of State and U.S. Agency for International Development State/USAID   345084000 Budget for International Organizations and Programs, State - IO - UNESCO/ICSECA International Contributions for Scientific, Educational, and Cultural Activities Budget for International Organizations and Programs, State - IO - UNESCO/ICSECA International Contributions for Scientific, Educational, and Cultural Activities 18 President's Budget Requests 2010 1000000 1308228
53896 53896 1002 WLD World 7 World       63 IO International Organization Affairs International Organizations (IO) 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   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 2006 805000 1125499
53897 53897 1002 WLD World 7 World       63 IO International Organization Affairs International Organizations (IO) 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   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 805000 1095458
53898 53898 1002 WLD World 7 World       63 IO International Organization Affairs International Organizations (IO) 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   345092000 Budget for International Organizations and Programs, State - International Organizations (IO) Budget for International Organizations and Programs, State - International Organizations (IO) 18 President's Budget Requests 2008 2000000 2666032
53899 53899 1002 WLD World 7 World       63 IO International Organization Affairs International Organizations (IO) 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 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 2006 990000 1384153
53900 53900 1002 WLD World 7 World       63 IO International Organization Affairs International Organizations (IO) 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 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 990000 1347209
53901 53901 1002 WLD World 7 World       63 IO International Organization Affairs International Organizations (IO) 9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 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) 18 President's Budget Requests 2008 1000000 1333016

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