./us_foreign_budget_complete

36 rows where Country ID = 686, International Sector Code = 112 and Managing Sub-agency or Bureau Name = "African Affairs"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Funding Account ID, Funding Agency Name, Activity ID, Fiscal Year

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
35179 35179 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2006 1613000 2255191
35180 35180 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2007 2008000 2732520
35181 35181 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2008 1832000 2442085
35182 35182 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2009 1510000 1992605
35183 35183 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 18 President's Budget Requests 2008 1555000 2072840
35184 35184 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 18 President's Budget Requests 2009 1575000 2078379
35199 35199 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2006 16845000 23551580
35200 35200 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 6600000 8981392
35201 35201 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2008 13000000 17329205
35202 35202 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2009 13000000 17154878
35203 35203 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2010 12000000 15698733
35204 35204 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2011 13000000 16670978
35205 35205 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2012 19000000 23926700
35206 35206 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2013 20150000 24918880
35207 35207 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 22500000 27296965
35208 35208 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2015 14000000 16792266
35209 35209 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2016 15000000 17843850
35210 35210 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2017 17500000 20452668
35211 35211 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 19685000 22478528
35212 35212 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 20000000 22399502
35213 35213 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 20000000 22104616
35214 35214 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2008 7750000 10330872
35215 35215 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2009 9700000 12800178
35216 35216 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2010 9700000 12689809
35217 35217 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2011 13000000 16670978
35218 35218 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2012 12000000 15111600
35219 35219 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2013 9500000 11748355
35220 35220 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 6000000 7279191
35221 35221 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2015 6500000 7796409
35222 35222 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2016 5421000 6448768
35223 35223 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2017 5542000 6477068
35224 35224 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 4000000 5443268
35225 35225 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 6800000 7764998
35226 35226 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 4250000 4759894
35227 35227 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 1500000 1657846
35228 35228 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Senegal 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2021 1500000 1603931

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