./us_foreign_budget_complete

24 rows where Fiscal Year = 2008, International Sector Code = 720 and Region ID = 7

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Funding Account ID, Activity Description, 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
50543 50543 1002 WLD World 7 World       56 NEA Near Eastern Affairs Middle East Partnership Initiative (MEPI) 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2008 10000000 13330158
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
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
54500 54500 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 1 Appropriated and Planned 2008 21143000 28183952
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
54576 54576 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, OA - 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   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2008 244895000 326448898
54608 54608 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, OA - 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   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2008 24862000 33141438
54636 54636 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, OA - 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   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2008 30159000 40202423
54694 54694 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, OA - 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   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2008 302965000 403857123
54729 54729 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, OA - 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   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2008 56341000 75103442
54761 54761 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, OA - 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   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2008 51926000 69218177
54794 54794 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, OA - 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   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2008 25365000 33811945
54821 54821 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 1 Appropriated and Planned 2008 211671000 282160782
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
54862 54862 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   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 18 President's Budget Requests 2008 720327000 960207252
55644 55644 1002 WLD World 7 World       998   Unknown - Budget Data   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   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2008 -284164000 -378795094
55656 55656 1002 WLD World 7 World       998   Unknown - Budget Data   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   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 18 President's Budget Requests 2008 619900000 826336477
56605 56605 1002 WLD World 7 World       998   Unknown - Budget Data DCHA - Ocean Freight 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2008 2000000 2666032
56612 56612 1002 WLD World 7 World       998   Unknown - Budget Data DCHA Contingency 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   345028000 Budget for International Disaster and Famine Assistance Budget for International Disaster and Famine Assistance 18 President's Budget Requests 2008 183800000 245008299
57001 57001 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/FFP - Non-Contingency 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2008 3500000 4665555
57027 57027 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/OFDA 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   345028000 Budget for International Disaster and Famine Assistance Budget for International Disaster and Famine Assistance 1 Appropriated and Planned 2008 386765000 515563845
57232 57232 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/PPM 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2008 400000 533206
57248 57248 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/VfP 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2008 100000 133302
59191 59191 1002 WLD World 7 World       998   Unknown - Budget Data USAID Democracy, Conflict and Humanitarian Assistance (DCHA) 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2008 5780000 7704831

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