./us_foreign_budget_complete

35 rows where Fiscal Year = 2010, International Category Name = "Humanitarian" and International Sector Name = "Disaster Prevention and Preparedness"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Managing Sub-agency or Bureau 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
35 35 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs   9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 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 2010 2500000 3270569
2846 2846 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 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 2010 4000000 5232911
2859 2859 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 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 2010 5000000 6541139
3459 3459 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Bangladesh 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 1500000 1962342
3466 3466 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Bangladesh 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 1500000 1962342
12011 12011 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Ethiopia 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 1000000 1308228
12016 12016 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Ethiopia 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 1000000 1308228
15686 15686 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs   9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 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 2010 427000 558613
15690 15690 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs   9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 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 2010 324000 423866
16318 16318 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs Haiti 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2010 650000 850348
16325 16325 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs Haiti 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2010 1050000 1373639
21244 21244 404 KEN Kenya 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Kenya 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 525000 686820
24410 24410 450 MDG Madagascar 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 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 2010 1107000 1448208
24423 24423 450 MDG Madagascar 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 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 2010 500000 654114
25202 25202 454 MWI Malawi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Malawi 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 170000 222399
25204 25204 454 MWI Malawi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Malawi 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 170000 222399
26843 26843 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 200000 261646
30038 30038 558 NIC Nicaragua 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Nicaragua 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 500000 654114
31068 31068 583 FSM Micronesia, Federated States of 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Micronesia 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 500000 654114
31077 31077 583 FSM Micronesia, Federated States of 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Micronesia 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 500000 654114
31129 31129 584 MHL Marshall Islands 1 East Asia and Oceania 3 Upper Middle Income Country UMIC 54 EAP East Asian and Pacific Affairs Marshall Islands 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 500000 654114
31138 31138 584 MHL Marshall Islands 1 East Asia and Oceania 3 Upper Middle Income Country UMIC 54 EAP East Asian and Pacific Affairs Marshall Islands 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 500000 654114
46545 46545 894 ZMB Zambia 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 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 2010 5000000 6541139
49772 49772 1002 WLD World 7 World       54 EAP East Asian and Pacific Affairs State East Asia and Pacific Regional 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2010 1110000 1452133
49781 49781 1002 WLD World 7 World       54 EAP East Asian and Pacific Affairs State East Asia and Pacific Regional 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2010 610000 798019
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
55672 55672 1002 WLD World 7 World       998   Unknown - Budget Data   9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 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 2010 22000000 28781010
56586 56586 1002 WLD World 7 World       998   Unknown - Budget Data DCHA - FEWSNet 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 18000000 23548099
56597 56597 1002 WLD World 7 World       998   Unknown - Budget Data DCHA - FEWSNet 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 18000000 23548099
56617 56617 1002 WLD World 7 World       998   Unknown - Budget Data DCHA Disaster Mitigation (not Fews) 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 12000000 15698733
57018 57018 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/FFP - Non-Contingency 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 6000000 7849366
57070 57070 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/OFDA 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   345028000 Budget for International Disaster and Famine Assistance Budget for International Disaster and Famine Assistance 1 Appropriated and Planned 2010 52000000 68027841
57081 57081 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/OFDA 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   345028000 Budget for International Disaster and Famine Assistance Budget for International Disaster and Famine Assistance 18 President's Budget Requests 2010 50000000 65411386
58196 58196 1002 WLD World 7 World       998   Unknown - Budget Data ODP - Private Sector Alliances (PSA) 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 500000 654114
58197 58197 1002 WLD World 7 World       998   Unknown - Budget Data ODP - Private Sector Alliances (PSA) 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 540000 706443

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