./us_foreign_budget_complete

18 rows where Fiscal Year = 2019 and US Category Name = "Program Support"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country ID, Country Code, Country Name, Region ID, Region Name, Managing Sub-agency or Bureau ID, Managing Sub-agency or Bureau Acronym, Managing Sub-agency or Bureau Name, Operating Unit, International Sector Code, International Sector Name, International Purpose Code, International Purpose Name, Funding Account ID, Funding Account Name, Funding Agency ID, Funding Agency Name, Funding Agency Acronym, Activity ID, Activity Name, Activity Description, Transaction Type ID, Transaction Type Name, current_amount, 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
8760 8760 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 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 2019 7000000 7839826
8763 8763 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 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 2019 10000000 11199751
52068 52068 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 2019 1200000 1343970
55378 55378 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 2019 600000 671985
55382 55382 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 2019 874000 978858
57024 57024 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/FFP - Non-Contingency 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 2019 2500000 2799938
57025 57025 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/FFP - Non-Contingency 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 2019 1500000 1679963
59107 59107 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 2019 225000000 251994397
59118 59118 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 2019 190900000 213803246
59215 59215 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 2019 10000000 11199751
59631 59631 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 2019 76600000 85790092
59642 59642 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 2019 71500000 80078219
59687 59687 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 2019 1214808000 1360554709
59698 59698 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 2019 1114920000 1248682636
59715 59715 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 2019 158067000 177031104
59755 59755 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 2019 3104000 3476403
59860 59860 1002 WLD World 7 World       999   not applicable   10 Administrative Costs 911 Operating Expenses 91010 Operating Expenses 8 Program Support 41 Direct Administrative Costs 38 U.S. International Development Finance Corporation DFC   344966000 Budget for Corporate Capital Account, United States International Development Finance Corporation - Administrative Expenses Budget for Corporate Capital Account, United States International Development Finance Corporation - Administrative Expenses 18 President's Budget Requests 2019 94000000 105277659
59861 59861 1002 WLD World 7 World       999   not applicable   10 Administrative Costs 912 Program Design and Learning 91020 Program Design and Learning 8 Program Support 41 Direct Administrative Costs 38 U.S. International Development Finance Corporation DFC   344967000 Budget for Corporate Capital Account, United States International Development Finance Corporation - Inspections and Evaluations Budget for Corporate Capital Account, United States International Development Finance Corporation - Inspections and Evaluations 18 President's Budget Requests 2019 2000000 2239950

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