./us_foreign_budget_complete

34 rows where Fiscal Year = 2014 and International Sector Code = 740

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Managing Sub-agency or Bureau ID, Operating Unit, Funding Account ID, Funding Agency Acronym, constant_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
2850 2850 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 2014 3200000 3882235
3462 3462 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 2014 278000 337269
3470 3470 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 2014 300000 363960
9091 9091 180 COD Congo (Kinshasa) 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 2014 1147000 1391539
14646 14646 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 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 2014 150000 181980
16322 16322 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 2014 1500000 1819798
16329 16329 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 2014 1500000 1819798
18027 18027 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Indonesia 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 2014 6006000 7286470
24414 24414 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 2014 1211000 1469183
24812 24812 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 2014 880000 1067615
30135 30135 562 NER Niger 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 2014 1540000 1868326
31072 31072 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 2014 500000 606599
31081 31081 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 2014 500000 606599
31133 31133 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 2014 500000 606599
31142 31142 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 2014 500000 606599
31957 31957 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 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 2014 5000000 6065992
38027 38027 716 ZWE Zimbabwe 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 1 Appropriated and Planned 2014 3398000 4122448
38890 38890 728 SSD South Sudan 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs South Sudan 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 2014 1000000 1213198
49776 49776 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 2014 600000 727919
49785 49785 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 2014 1127000 1367275
51462 51462 1002 WLD World 7 World       57 SCA South and Central Asian Affairs State South and Central Asia 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 2014 250000 303300
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
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
55360 55360 1002 WLD World 7 World       122 OST Office of Science and Technolgy OST - Office of Science and Technology 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 2014 4000000 4852794
55671 55671 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 1 Appropriated and Planned 2014 2000000 2426397
56590 56590 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 2014 12000000 14558382
56601 56601 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 2014 11997000 14554742
56995 56995 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/FFP - 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   345028000 Budget for International Disaster and Famine Assistance Budget for International Disaster and Famine Assistance 1 Appropriated and Planned 2014 9241000 11211167
57074 57074 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 2014 125918000 152763524
57084 57084 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 2014 100000000 121319846
57091 57091 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 1 345030000 Budget for International Disaster and Famine Assistance - Overseas Contingency Operations (OCO) Budget for International Disaster and Famine Assistance - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2014 5000000 6065992
58407 58407 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Learning, Evaluation and Research 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 2014 3418000 4146712
58409 58409 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Learning, Evaluation and Research 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 2014 4583000 5560089
58449 58449 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Policy 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 2014 200000 242640

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