./us_foreign_budget_complete

25 rows where Income Group ID = 1, Transaction Type ID = 1 and US Category Name = "Program Support"

✎ 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
1036 1036 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 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 2007 15126000 20583717
1037 1037 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 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 2007 19440000 26454281
1039 1039 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 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   344996000 Budget for Economic Support Fund, H.R. 2206 Supplemental Budget for Economic Support Fund, H.R. 2206 Supplemental 1 Appropriated and Planned 2007 12000000 16329803
6192 6192 108 BDI Burundi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Burundi 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 561000 763418
6193 6193 108 BDI Burundi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Burundi 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 2007 568000 772944
6194 6194 108 BDI Burundi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Burundi 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 2007 226000 307545
9745 9745 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Democratic Republic of the Congo 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 166000 225896
9746 9746 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Democratic Republic of the Congo 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 2007 719000 978427
9747 9747 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Democratic Republic of the Congo 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 2007 108000 146968
12024 12024 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Ethiopia 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 182000 247669
12025 12025 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Ethiopia 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 2007 197000 268081
12026 12026 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Ethiopia 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 2007 25000 34020
25207 25207 454 MWI Malawi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Malawi 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 332000 451791
25208 25208 454 MWI Malawi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Malawi 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 2007 272000 370142
28755 28755 508 MOZ Mozambique 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Mozambique 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 360000 489894
28756 28756 508 MOZ Mozambique 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Mozambique 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 2007 490000 666800
29648 29648 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 220000 299380
29649 29649 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 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 2007 78000 106144
29650 29650 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 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 2007 87000 118391
35015 35015 646 RWA Rwanda 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Rwanda 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   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2007 100000 136082
35016 35016 646 RWA Rwanda 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Rwanda 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 2007 213000 289854
36374 36374 694 SLE Sierra Leone 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Sierra Leone 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 2007 1369000 1862958
36375 36375 694 SLE Sierra Leone 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Sierra Leone 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 2007 47000 63958
37507 37507 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Somalia 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 2007 921000 1253312
40324 40324 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 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   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2007 602000 819212

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