2025-02-03_foreign-assistance: ./us_foreign_budget_complete: 10 rows where Fiscal Year = 2006, Income Group Name = "Lower Middle Income Country" and International Sector Name = "Water Supply and Sanitation"

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

descending

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 Account ID	Funding Account Name	Funding Agency ID	Funding Agency Name	Funding Agency Acronym	Activity ID	Activity Name	Activity Description	Transaction Type ID	Transaction Type Name	Fiscal Year	current_amount	constant_amount
2767	2767	50	BGD	Bangladesh	4	South and Central Asia	2	Lower Middle Income Country	LMIC	57	SCA	South and Central Asian Affairs		2	Health and Population	140	Water Supply and Sanitation	14020	Water supply and sanitation - large systems	3	Health	18	Water Supply and Sanitation	12x2278	Public Law 480 Title II Grants	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	1600000	2237016
4269	4269	68	BOL	Bolivia	6	Western Hemisphere	2	Lower Middle Income Country	LMIC	58	WHA	Western Hemisphere Affairs		2	Health and Population	140	Water Supply and Sanitation	14020	Water supply and sanitation - large systems	3	Health	18	Water Supply and Sanitation	12x2278	Public Law 480 Title II Grants	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	1568000	2192275
13975	13975	288	GHA	Ghana	5	Sub-Saharan Africa	2	Lower Middle Income Country	LMIC	53	AF	African Affairs		2	Health and Population	140	Water Supply and Sanitation	14020	Water supply and sanitation - large systems	3	Health	18	Water Supply and Sanitation	12x2278	Public Law 480 Title II Grants	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	1650000	2306922
17080	17080	356	IND	India	4	South and Central Asia	2	Lower Middle Income Country	LMIC	57	SCA	South and Central Asian Affairs	India	2	Health and Population	140	Water Supply and Sanitation	14020	Water supply and sanitation - large systems	3	Health	18	Water Supply and Sanitation	72x1021	Agency for International Development, Development Assistance	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	2237000	3127628
17555	17555	360	IDN	Indonesia	1	East Asia and Oceania	2	Lower Middle Income Country	LMIC	54	EAP	East Asian and Pacific Affairs	Indonesia	2	Health and Population	140	Water Supply and Sanitation	14020	Water supply and sanitation - large systems	3	Health	18	Water Supply and Sanitation	72x1021	Agency for International Development, Development Assistance	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	5000000	6990674
20840	20840	404	KEN	Kenya	5	Sub-Saharan Africa	2	Lower Middle Income Country	LMIC	53	AF	African Affairs	Kenya	2	Health and Population	140	Water Supply and Sanitation	14020	Water supply and sanitation - large systems	3	Health	18	Water Supply and Sanitation	19x1031	Department of State, Global Health Programs	39	Department of State and U.S. Agency for International Development	State/USAID	345013000	Budget for Global Health Programs	Budget for Global Health Programs	1	Appropriated and Planned	2006	1000000	1398135
20841	20841	404	KEN	Kenya	5	Sub-Saharan Africa	2	Lower Middle Income Country	LMIC	53	AF	African Affairs	Kenya	2	Health and Population	140	Water Supply and Sanitation	14020	Water supply and sanitation - large systems	3	Health	18	Water Supply and Sanitation	72x1021	Agency for International Development, Development Assistance	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	3172000	4434884
26253	26253	478	MRT	Mauritania	5	Sub-Saharan Africa	2	Lower Middle Income Country	LMIC	53	AF	African Affairs		2	Health and Population	140	Water Supply and Sanitation	14020	Water supply and sanitation - large systems	3	Health	18	Water Supply and Sanitation	12x2278	Public Law 480 Title II Grants	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	2705000	3781955
33124	33124	608	PHL	Philippines	1	East Asia and Oceania	2	Lower Middle Income Country	LMIC	54	EAP	East Asian and Pacific Affairs	Philippines	2	Health and Population	140	Water Supply and Sanitation	14020	Water supply and sanitation - large systems	3	Health	18	Water Supply and Sanitation	72x1021	Agency for International Development, Development Assistance	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	2710000	3788945
33149	33149	608	PHL	Philippines	1	East Asia and Oceania	2	Lower Middle Income Country	LMIC	54	EAP	East Asian and Pacific Affairs	Philippines	2	Health and Population	140	Water Supply and Sanitation	14020	Water supply and sanitation - large systems	3	Health	18	Water Supply and Sanitation	72x1037	Economic Support Fund	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	949000	1326830

Advanced export

JSON shape: default, array, newline-delimited

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