./us_foreign_budget_complete

20 rows where Fiscal Year = 2007 and International Sector Code = 740

✎ 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

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
2843 2843 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 2007 6454000 8782713
3456 3456 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 2007 32000 43546
12006 12006 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 200000 272163
12008 12008 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 2007 989000 1345848
12428 12428 262 DJI Djibouti 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Djibouti 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 2007 150000 204123
16315 16315 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 2007 350000 476286
21240 21240 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 1 Appropriated and Planned 2007 100000 136082
24408 24408 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 2007 480000 653192
24811 24811 454 MWI Malawi 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 2007 310000 421853
25199 25199 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 2007 298000 405523
26840 26840 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 1 Appropriated and Planned 2007 100000 136082
28751 28751 508 MOZ Mozambique 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Mozambique 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 2007 200000 272163
33678 33678 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 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   344996000 Budget for Economic Support Fund, H.R. 2206 Supplemental Budget for Economic Support Fund, H.R. 2206 Supplemental 1 Appropriated and Planned 2007 700000 952572
47867 47867 1002 WLD World 7 World       53 AF African Affairs State Africa 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 2007 1000000 1360817
48380 48380 1002 WLD World 7 World       53 AF African Affairs USAID Africa 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 2007 3700000 5035023
49769 49769 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 2007 300000 408245
52111 52111 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs USAID Caribbean 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2007 698000 949850
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
59199 59199 1002 WLD World 7 World       998   Unknown - Budget Data USAID Democracy, Conflict and Humanitarian Assistance (DCHA) 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 2007 4800000 6531921
59201 59201 1002 WLD World 7 World       998   Unknown - Budget Data USAID Democracy, Conflict and Humanitarian Assistance (DCHA) 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 2007 56375000 76716055

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