./us_foreign_budget_complete

25 rows where Fiscal Year = 2022, Income Group Name = "Lower Middle Income Country" and International Sector Name = "Water Supply and Sanitation"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Operating Unit, Activity Name, 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
3521 3521 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Bangladesh 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   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2022 4000000 4000000
3523 3523 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Bangladesh 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   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2022 4000000 4000000
7016 7016 116 KHM Cambodia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Cambodia 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   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2022 850000 850000
7018 7018 116 KHM Cambodia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Cambodia 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   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2022 500000 500000
13888 13888 275 PSE West Bank and Gaza 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data West Bank and Gaza 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 27500000 27500000
13890 13890 275 PSE West Bank and Gaza 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data West Bank and Gaza 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 25000000 25000000
14485 14485 288 GHA Ghana 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Ghana 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   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2022 14800000 14800000
14487 14487 288 GHA Ghana 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Ghana 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   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2022 9500000 9500000
17340 17340 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data India 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   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2022 4700000 4700000
17342 17342 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data India 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   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2022 6000000 6000000
18070 18070 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Indonesia 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   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2022 6684000 6684000
18072 18072 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Indonesia 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   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2022 5400000 5400000
21328 21328 404 KEN Kenya 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Kenya 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   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2022 19700000 19700000
21330 21330 404 KEN Kenya 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Kenya 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   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2022 16825000 16825000
30990 30990 566 NGA Nigeria 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Nigeria 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   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2022 10800000 10800000
30992 30992 566 NGA Nigeria 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Nigeria 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   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2022 6620000 6620000
32317 32317 598 PNG Papua New Guinea 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Papua New Guinea 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   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2022 2600000 2600000
33730 33730 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Philippines 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   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2022 4200000 4200000
33732 33732 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Philippines 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   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2022 3000000 3000000
35665 35665 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Senegal 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   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2022 11500000 11500000
35667 35667 686 SEN Senegal 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Senegal 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   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2022 6500000 6500000
38450 38450 716 ZWE Zimbabwe 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Zimbabwe 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2022 3601000 3601000
44285 44285 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Egypt 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 13000000 13000000
46986 46986 894 ZMB Zambia 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Zambia 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   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2022 7750000 7750000
46988 46988 894 ZMB Zambia 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Zambia 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   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2022 5500000 5500000

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