./us_foreign_budget_complete

17 rows where Income Group Name = "Low Income Country", International Sector Code = 140 and Region ID = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Managing Sub-agency or Bureau ID, Funding Account ID, Funding Account Name, Activity ID, Activity Name, Activity Description, Transaction Type ID, Transaction Type Name, Fiscal Year, 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
46078 46078 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 18 President's Budget Requests 2009 376000 496172
46079 46079 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 3344000 4135421
46080 46080 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 2000000 2337448
46081 46081 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 500000 641191
46082 46082 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 2000000 2518600
46083 46083 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 2500000 3032996
46084 46084 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 1000000 1236669
46085 46085 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 1000000 1213198
46086 46086 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 1300000 1546467
46087 46087 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 39 Department of State and U.S. Agency for International Development State/USAID 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2018 2000000 2283823
46088 46088 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 5000000 5599875
46089 46089 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 56 NEA Near Eastern Affairs Yemen 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 2400000 2566290
46455 46455 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 998   Unknown - Budget Data Yemen 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 39 Department of State and U.S. Agency for International Development State/USAID   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2022 1671000 1671000
46456 46456 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 998   Unknown - Budget Data Yemen 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 39 Department of State and U.S. Agency for International Development State/USAID   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2023 1400000 1335318
46457 46457 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 998   Unknown - Budget Data Yemen 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 39 Department of State and U.S. Agency for International Development State/USAID   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2022 3000000 3000000
46458 46458 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 998   Unknown - Budget Data Yemen 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 39 Department of State and U.S. Agency for International Development State/USAID   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2023 2500000 2384496
46459 46459 887 YEM Yemen 3 Middle East and North Africa 1 Low Income Country LIC 998   Unknown - Budget Data Yemen 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 39 Department of State and U.S. Agency for International Development State/USAID   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2024 1900000 1770381

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