./us_foreign_budget_complete

23 rows where Fiscal Year = 2010, Funding Account ID = "19x1143" and International Sector Name = "Emergency Response"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Operating Unit, Transaction Type ID

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
54502 54502 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 2010 25246000 33027517
54514 54514 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 2010 26236000 34322662
54578 54578 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 2010 345780000 452358980
54588 54588 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 18 President's Budget Requests 2010 286961000 375410334
54599 54599 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   345103000 Budget for Migration and Refugee Assistance, Department of State, H.R. 4899 Supplemental Budget for Migration and Refugee Assistance, Department of State, H.R. 4899 Supplemental 1 Appropriated and Planned 2010 40000000 52329109
54610 54610 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 2010 36020000 47122362
54621 54621 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 18 President's Budget Requests 2010 33479000 43798156
54634 54634 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   345103000 Budget for Migration and Refugee Assistance, Department of State, H.R. 4899 Supplemental Budget for Migration and Refugee Assistance, Department of State, H.R. 4899 Supplemental 1 Appropriated and Planned 2010 8000000 10465822
54638 54638 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 2010 47850000 62598696
54648 54648 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 18 President's Budget Requests 2010 36799000 48141472
54696 54696 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 2010 544500000 712329992
54704 54704 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 18 President's Budget Requests 2010 530000000 693360690
54715 54715 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   345103000 Budget for Migration and Refugee Assistance, Department of State, H.R. 4899 Supplemental Budget for Migration and Refugee Assistance, Department of State, H.R. 4899 Supplemental 1 Appropriated and Planned 2010 60000000 78493663
54731 54731 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 2010 148200000 193879348
54743 54743 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 18 President's Budget Requests 2010 76522000 100108201
54753 54753 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   345103000 Budget for Migration and Refugee Assistance, Department of State, H.R. 4899 Supplemental Budget for Migration and Refugee Assistance, Department of State, H.R. 4899 Supplemental 1 Appropriated and Planned 2010 27000000 35322148
54763 54763 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 2010 130950000 171312419
54772 54772 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 18 President's Budget Requests 2010 106718000 139611445
54783 54783 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   345103000 Budget for Migration and Refugee Assistance, Department of State, H.R. 4899 Supplemental Budget for Migration and Refugee Assistance, Department of State, H.R. 4899 Supplemental 1 Appropriated and Planned 2010 30000000 39246831
54796 54796 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 2010 48500000 63449044
54808 54808 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 18 President's Budget Requests 2010 38590000 50484508
54823 54823 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 2010 324000000 423865780
54835 54835 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 2010 305375000 399500039

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