./us_foreign_budget_complete

17 rows where Fiscal Year = 2018 and US Category ID = 8

✎ View and edit SQL

This data as json, CSV (advanced)

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
31963 31963 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 10 Administrative Costs 911 Operating Expenses 91010 Operating Expenses 8 Program Support 41 Direct Administrative Costs 39 Department of State and U.S. Agency for International Development State/USAID 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2018 1500000 1712867
55368 55368 1002 WLD World 7 World       124 F Office of Foreign Assistance Resources Foreign Assistance Dashboard 10 Administrative Costs 911 Operating Expenses 91010 Operating Expenses 8 Program Support 41 Direct Administrative Costs 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2018 2500000 2854779
55377 55377 1002 WLD World 7 World       124 F Office of Foreign Assistance Resources Foreign Assistance Program Evaluation 10 Administrative Costs 912 Program Design and Learning 91020 Program Design and Learning 8 Program Support 41 Direct Administrative Costs 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 2018 874000 998031
55381 55381 1002 WLD World 7 World       124 F Office of Foreign Assistance Resources Foreign Assistance Program Evaluation 10 Administrative Costs 912 Program Design and Learning 91020 Program Design and Learning 8 Program Support 41 Direct Administrative Costs 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2018 1000000 1141911
59106 59106 1002 WLD World 7 World       998   Unknown - Budget Data USAID Capital Investment Fund 10 Administrative Costs 911 Operating Expenses 91010 Operating Expenses 8 Program Support 41 Direct Administrative Costs 39 Department of State and U.S. Agency for International Development State/USAID   345137000 Budget for Operating Expenses of USAID Budget for Operating Expenses of USAID 1 Appropriated and Planned 2018 197100000 225070756
59117 59117 1002 WLD World 7 World       998   Unknown - Budget Data USAID Capital Investment Fund 10 Administrative Costs 911 Operating Expenses 91010 Operating Expenses 8 Program Support 41 Direct Administrative Costs 39 Department of State and U.S. Agency for International Development State/USAID   345137000 Budget for Operating Expenses of USAID Budget for Operating Expenses of USAID 18 President's Budget Requests 2018 157980000 180399178
59214 59214 1002 WLD World 7 World       998   Unknown - Budget Data USAID Development Credit Authority Admin 10 Administrative Costs 911 Operating Expenses 91010 Operating Expenses 8 Program Support 41 Direct Administrative Costs 39 Department of State and U.S. Agency for International Development State/USAID   345137000 Budget for Operating Expenses of USAID Budget for Operating Expenses of USAID 1 Appropriated and Planned 2018 10000000 11419115
59224 59224 1002 WLD World 7 World       998   Unknown - Budget Data USAID Development Credit Authority Admin 10 Administrative Costs 911 Operating Expenses 91010 Operating Expenses 8 Program Support 41 Direct Administrative Costs 39 Department of State and U.S. Agency for International Development State/USAID   345137000 Budget for Operating Expenses of USAID Budget for Operating Expenses of USAID 18 President's Budget Requests 2018 9120000 10414233
59630 59630 1002 WLD World 7 World       998   Unknown - Budget Data USAID Inspector General Operating Expense 10 Administrative Costs 911 Operating Expenses 91010 Operating Expenses 8 Program Support 41 Direct Administrative Costs 39 Department of State and U.S. Agency for International Development State/USAID   345137000 Budget for Operating Expenses of USAID Budget for Operating Expenses of USAID 1 Appropriated and Planned 2018 72800000 83131157
59641 59641 1002 WLD World 7 World       998   Unknown - Budget Data USAID Inspector General Operating Expense 10 Administrative Costs 911 Operating Expenses 91010 Operating Expenses 8 Program Support 41 Direct Administrative Costs 39 Department of State and U.S. Agency for International Development State/USAID   345137000 Budget for Operating Expenses of USAID Budget for Operating Expenses of USAID 18 President's Budget Requests 2018 69000000 78791893
59654 59654 1002 WLD World 7 World       998   Unknown - Budget Data USAID Inspector General Operating Expense 10 Administrative Costs 911 Operating Expenses 91010 Operating Expenses 8 Program Support 41 Direct Administrative Costs 39 Department of State and U.S. Agency for International Development State/USAID 1 345145000 Budget for Operating Expenses of USAID - Overseas Contingency Operations (OCO) Budget for Operating Expenses of USAID - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2018 2500000 2854779
59655 59655 1002 WLD World 7 World       998   Unknown - Budget Data USAID Inspector General Operating Expense 10 Administrative Costs 911 Operating Expenses 91010 Operating Expenses 8 Program Support 41 Direct Administrative Costs 39 Department of State and U.S. Agency for International Development State/USAID 1 345145000 Budget for Operating Expenses of USAID - Overseas Contingency Operations (OCO) Budget for Operating Expenses of USAID - Overseas Contingency Operations (OCO) 18 President's Budget Requests 2018 2500000 2854779
59686 59686 1002 WLD World 7 World       998   Unknown - Budget Data USAID Operating Expense 10 Administrative Costs 911 Operating Expenses 91010 Operating Expenses 8 Program Support 41 Direct Administrative Costs 39 Department of State and U.S. Agency for International Development State/USAID   345137000 Budget for Operating Expenses of USAID Budget for Operating Expenses of USAID 1 Appropriated and Planned 2018 1189609000 1358428195
59697 59697 1002 WLD World 7 World       998   Unknown - Budget Data USAID Operating Expense 10 Administrative Costs 911 Operating Expenses 91010 Operating Expenses 8 Program Support 41 Direct Administrative Costs 39 Department of State and U.S. Agency for International Development State/USAID   345137000 Budget for Operating Expenses of USAID Budget for Operating Expenses of USAID 18 President's Budget Requests 2018 1045797000 1194207619
59714 59714 1002 WLD World 7 World       998   Unknown - Budget Data USAID Operating Expense 10 Administrative Costs 911 Operating Expenses 91010 Operating Expenses 8 Program Support 41 Direct Administrative Costs 39 Department of State and U.S. Agency for International Development State/USAID 1 345145000 Budget for Operating Expenses of USAID - Overseas Contingency Operations (OCO) Budget for Operating Expenses of USAID - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2018 158067000 180498525
59721 59721 1002 WLD World 7 World       998   Unknown - Budget Data USAID Operating Expense 10 Administrative Costs 911 Operating Expenses 91010 Operating Expenses 8 Program Support 41 Direct Administrative Costs 39 Department of State and U.S. Agency for International Development State/USAID 1 345145000 Budget for Operating Expenses of USAID - Overseas Contingency Operations (OCO) Budget for Operating Expenses of USAID - Overseas Contingency Operations (OCO) 18 President's Budget Requests 2018 136555000 155933725
59754 59754 1002 WLD World 7 World       998   Unknown - Budget Data USAID Program Management Initiatives 10 Administrative Costs 911 Operating Expenses 91010 Operating Expenses 8 Program Support 41 Direct Administrative Costs 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 2018 3104000 3544493

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