./us_foreign_budget_complete

30 rows where Activity Name = "Budget for Development Assistance" and International Sector Code = 111

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country Code, Region Name, Income Group Acronym, Managing Sub-agency or Bureau Name, current_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
8271 8271 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 500000 641191
10394 10394 214 DOM Dominican Republic 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Dominican Republic 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 2000000 2666032
11513 11513 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Ethiopia 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 1500000 1999524
19054 19054 388 JAM Jamaica 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Jamaica 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 1000000 1282383
36515 36515 704 VNM Vietnam 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Vietnam 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 190000 248563
36516 36516 704 VNM Vietnam 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Vietnam 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 110000 141062
55341 55341 1002 WLD World 7 World       122 OST Office of Science and Technolgy OST - Office of Science and Technology 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 6523000 8066792
55342 55342 1002 WLD World 7 World       122 OST Office of Science and Technolgy OST - Office of Science and Technology 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 20100000 24385289
56619 56619 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/ASHA 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 14000000 15986761
58004 58004 1002 WLD World 7 World       998   Unknown - Budget Data LAB - Mission Engagement & Operations Center (MEO) 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 8000000 9595581
58005 58005 1002 WLD World 7 World       998   Unknown - Budget Data LAB - Mission Engagement & Operations Center (MEO) 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 6000000 7137540
58320 58320 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Donor Engagement 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 1000000 1189590
58321 58321 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Donor Engagement 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 1000000 1168724
58332 58332 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Learning, Evaluation and Research 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 4251000 5257080
58333 58333 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Learning, Evaluation and Research 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 5215000 6326830
58334 58334 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Learning, Evaluation and Research 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 16000000 19033440
58335 58335 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Learning, Evaluation and Research 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 5902000 7079140
58336 58336 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Learning, Evaluation and Research 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 7593000 9032557
58414 58414 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Policy 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 332000 402782
58415 58415 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Policy 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 1000000 1189590
58416 58416 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Policy 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 350000 419807
58417 58417 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Policy 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 272000 323568
58418 58418 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Policy 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 1200000 1402469
59232 59232 1002 WLD World 7 World       998   Unknown - Budget Data USAID Economic Growth, Education and Environment (E3) 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 500000 699067
59233 59233 1002 WLD World 7 World       998   Unknown - Budget Data USAID Economic Growth, Education and Environment (E3) 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 500000 680408
59234 59234 1002 WLD World 7 World       998   Unknown - Budget Data USAID Economic Growth, Education and Environment (E3) 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 170000 226613
59235 59235 1002 WLD World 7 World       998   Unknown - Budget Data USAID Economic Growth, Education and Environment (E3) 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 170000 224333
59727 59727 1002 WLD World 7 World       998   Unknown - Budget Data USAID Policy, Planning and Learning (PPL) 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 12500000 14609049
59728 59728 1002 WLD World 7 World       998   Unknown - Budget Data USAID Policy, Planning and Learning (PPL) 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 10036000 11460224
59729 59729 1002 WLD World 7 World       998   Unknown - Budget Data USAID Policy, Planning and Learning (PPL) 1 Education 111 Education, Level Unspecified 11110 Education policy and administrative management 4 Education and Social Services 22 Policies, Regulations, and Systems 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 10036000 11240070

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