./us_foreign_budget_complete

12 rows where Fiscal Year = 2020 and International Category ID = 10

✎ 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
51463 51463 1002 WLD World 7 World       57 SCA South and Central Asian Affairs State South and Central Asia Regional 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 2020 250000 276308
52069 52069 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs State Western Hemisphere Regional 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2020 1000000 1105231
55379 55379 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 2020 600000 663138
55383 55383 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 2020 600000 663138
59108 59108 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 2020 210300000 232430042
59119 59119 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 2020 198300000 219167272
59632 59632 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 2020 75500000 83444927
59643 59643 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 2020 71500000 79024004
59688 59688 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 2020 1377246000 1522174730
59699 59699 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 2020 1275200000 1409390346
59734 59734 1002 WLD World 7 World       998   Unknown - Budget Data USAID Policy, Planning and Learning (PPL) 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2020 13550000 14975878
59756 59756 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 2020 1604000 1772790

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