2025-02-03_foreign-assistance: ./us_foreign_budget_complete: 10 rows where Fiscal Year = 2009, International Sector Code = 140 and Region ID = 4

10 rows where Fiscal Year = 2009, International Sector Code = 140 and Region ID = 4

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
293	293	4	AFG	Afghanistan	4	South and Central Asia	1	Low Income Country	LIC	57	SCA	South and Central Asian Affairs	Afghanistan	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	2009	16000000	21113696
298	298	4	AFG	Afghanistan	4	South and Central Asia	1	Low Income Country	LIC	57	SCA	South and Central Asian Affairs	Afghanistan	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	18	President's Budget Requests	2009	1000000	1319606
305	305	4	AFG	Afghanistan	4	South and Central Asia	1	Low Income Country	LIC	57	SCA	South and Central Asian Affairs	Afghanistan	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	344993000	Budget for Economic Support Fund, Bridge Supplemental	Budget for Economic Support Fund, Bridge Supplemental	1	Appropriated and Planned	2009	3000000	3958818
2770	2770	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	2009	2815000	3714691
17079	17079	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	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	18	President's Budget Requests	2009	1001000	1320926
17083	17083	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	2009	2000000	2639212
31389	31389	586	PAK	Pakistan	4	South and Central Asia	2	Lower Middle Income Country	LMIC	57	SCA	South and Central Asian Affairs	Pakistan	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	2009	3574000	4716272
31391	31391	586	PAK	Pakistan	4	South and Central Asia	2	Lower Middle Income Country	LMIC	57	SCA	South and Central Asian Affairs	Pakistan	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	18	President's Budget Requests	2009	5000000	6598030
31394	31394	586	PAK	Pakistan	4	South and Central Asia	2	Lower Middle Income Country	LMIC	57	SCA	South and Central Asian Affairs	Pakistan	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	344997000	Budget for Economic Support Fund, H.R. 2346 Spring Supplemental	Budget for Economic Support Fund, H.R. 2346 Spring Supplemental	1	Appropriated and Planned	2009	12000000	15835272
39901	39901	762	TJK	Tajikistan	4	South and Central Asia	1	Low Income Country	LIC	57	SCA	South and Central Asian Affairs	Tajikistan	2	Health and Population	140	Water Supply and Sanitation	14020	Water supply and sanitation - large systems	3	Health	18	Water Supply and Sanitation	72x0306	Assistance for Europe, Eurasia and Central Asia (AEECA)	39	Department of State and U.S. Agency for International Development	State/USAID	344946000	Budget for Assistance for Europe, Eurasia and Central Asia (AEECA)	Budget for Assistance for Europe, Eurasia and Central Asia (AEECA)	18	President's Budget Requests	2009	150000	197941

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