./us_foreign_budget_complete

24 rows where Managing Sub-agency or Bureau ID = 65 and US Category Name = "Education and Social Services"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: International Purpose Code, International Purpose Name, US Sector ID, Transaction Type ID

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
54112 54112 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 2010 500000 654114
54113 54113 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 2011 750000 961787
54114 54114 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 2012 500000 629650
54115 54115 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 2013 170000 210234
54116 54116 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 2014 150000 181980
54117 54117 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 2015 275000 329848
54118 54118 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 2016 537000 638810
54119 54119 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 18 President's Budget Requests 2011 750000 961787
54120 54120 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 18 President's Budget Requests 2012 800000 1007440
54121 54121 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 18 President's Budget Requests 2013 500000 618334
54122 54122 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 18 President's Budget Requests 2014 500000 606599
54123 54123 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 18 President's Budget Requests 2015 400000 479779
54124 54124 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 18 President's Budget Requests 2016 400000 475836
54125 54125 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 18 President's Budget Requests 2017 350000 409053
54141 54141 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 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 2008 500000 666508
54167 54167 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OP Other Programs 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 2009 5000000 6598030
54168 54168 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OP Other Programs 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 2010 5000000 6541139
54169 54169 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OP Other Programs 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 2013 600000 742001
54170 54170 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OP Other Programs 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 2015 1325000 1589268
54171 54171 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OP Other Programs 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 2016 631000 750631
54172 54172 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OP Other Programs 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 18 President's Budget Requests 2015 1200000 1439337
54173 54173 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OP Other Programs 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 18 President's Budget Requests 2016 1200000 1427508
54174 54174 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OP Other Programs 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher 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 18 President's Budget Requests 2017 1200000 1402469
54257 54257 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs State Oceans and International Environmental and Scientific Affairs (OES) 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 2006 400000 559254

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