2025-02-03_foreign-assistance: ./us_foreign_budget_complete: 13 rows where Managing Sub-agency or Bureau Name = "Near Eastern Affairs" and US Category Name = "Program Support"

13 rows where Managing Sub-agency or Bureau Name = "Near Eastern Affairs" and US Category Name = "Program Support"

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	OCO Flag	Activity ID	Activity Name	Activity Description	Transaction Type ID	Transaction Type Name	Fiscal Year	current_amount	constant_amount
13870	13870	275	PSE	West Bank and Gaza	3	Middle East and North Africa	2	Lower Middle Income Country	LMIC	56	NEA	Near Eastern Affairs	West Bank and Gaza	10	Administrative Costs	912	Program Design and Learning	91020	Program Design and Learning	8	Program Support	41	Direct Administrative Costs	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	2007	6020000	8192118
13871	13871	275	PSE	West Bank and Gaza	3	Middle East and North Africa	2	Lower Middle Income Country	LMIC	56	NEA	Near Eastern Affairs	West Bank and Gaza	10	Administrative Costs	912	Program Design and Learning	91020	Program Design and Learning	8	Program Support	41	Direct Administrative Costs	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	18	President's Budget Requests	2009	5000000	6598030
18668	18668	368	IRQ	Iraq	3	Middle East and North Africa	3	Upper Middle Income Country	UMIC	56	NEA	Near Eastern Affairs	Iraq	10	Administrative Costs	912	Program Design and Learning	91020	Program Design and Learning	8	Program Support	41	Direct Administrative Costs	11x1022	International Narcotics Control and Law Enforcement	39	Department of State and U.S. Agency for International Development	State/USAID		345047000	Budget for International Narcotics Control and Law Enforcement, H.R. 2346 Spring Supplemental	Budget for International Narcotics Control and Law Enforcement, H.R. 2346 Spring Supplemental	18	President's Budget Requests	2009	3000000	3958818
18669	18669	368	IRQ	Iraq	3	Middle East and North Africa	3	Upper Middle Income Country	UMIC	56	NEA	Near Eastern Affairs	Iraq	10	Administrative Costs	912	Program Design and Learning	91020	Program Design and Learning	8	Program Support	41	Direct Administrative Costs	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	18	President's Budget Requests	2009	13000000	17154878
22958	22958	422	LBN	Lebanon	3	Middle East and North Africa	3	Upper Middle Income Country	UMIC	56	NEA	Near Eastern Affairs	Lebanon	10	Administrative Costs	912	Program Design and Learning	91020	Program Design and Learning	8	Program Support	41	Direct Administrative Costs	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	2007	120000	163298
28225	28225	504	MAR	Morocco	3	Middle East and North Africa	2	Lower Middle Income Country	LMIC	56	NEA	Near Eastern Affairs	Morocco	10	Administrative Costs	912	Program Design and Learning	91020	Program Design and Learning	8	Program Support	41	Direct Administrative Costs	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	2007	123000	167380
28226	28226	504	MAR	Morocco	3	Middle East and North Africa	2	Lower Middle Income Country	LMIC	56	NEA	Near Eastern Affairs	Morocco	10	Administrative Costs	912	Program Design and Learning	91020	Program Design and Learning	8	Program Support	41	Direct Administrative Costs	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	2007	190000	258555
46435	46435	887	YEM	Yemen	3	Middle East and North Africa	1	Low Income Country	LIC	56	NEA	Near Eastern Affairs	Yemen	10	Administrative Costs	912	Program Design and Learning	91020	Program Design and Learning	8	Program Support	41	Direct Administrative Costs	11x1022	International Narcotics Control and Law Enforcement	39	Department of State and U.S. Agency for International Development	State/USAID		345040000	Budget for International Narcotics Control and Law Enforcement	Budget for International Narcotics Control and Law Enforcement	18	President's Budget Requests	2009	50000	65980
50352	50352	1002	WLD	World	7	World				56	NEA	Near Eastern Affairs	MENA Initiative	10	Administrative Costs	912	Program Design and Learning	91020	Program Design and Learning	8	Program Support	41	Direct Administrative Costs	19x1156	Middle East and North Africa Incentive Fund	39	Department of State and U.S. Agency for International Development	State/USAID		345095000	Budget for Middle East and North Africa Incentive Fund	Budget for Middle East and North Africa Incentive Fund	18	President's Budget Requests	2014	475000000	576269268
50544	50544	1002	WLD	World	7	World				56	NEA	Near Eastern Affairs	Middle East Partnership Initiative (MEPI)	10	Administrative Costs	912	Program Design and Learning	91020	Program Design and Learning	8	Program Support	41	Direct Administrative Costs	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	500000	659803
50568	50568	1002	WLD	World	7	World				56	NEA	Near Eastern Affairs	Middle East Response Fund (MERF)	10	Administrative Costs	912	Program Design and Learning	91020	Program Design and Learning	8	Program Support	41	Direct Administrative Costs	11x1022	International Narcotics Control and Law Enforcement	39	Department of State and U.S. Agency for International Development	State/USAID	1	345042000	Budget for International Narcotics Control and Law Enforcement - Overseas Contingency Operations (OCO)	Budget for International Narcotics Control and Law Enforcement - Overseas Contingency Operations (OCO)	1	Appropriated and Planned	2012	5000000	6296500
50569	50569	1002	WLD	World	7	World				56	NEA	Near Eastern Affairs	Middle East Response Fund (MERF)	10	Administrative Costs	912	Program Design and Learning	91020	Program Design and Learning	8	Program Support	41	Direct Administrative Costs	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	2011	135000000	173121690
61221	61221	1022	MEN	Middle East Region	3	Middle East and North Africa				56	NEA	Near Eastern Affairs	Middle East Response Fund (MERF)	10	Administrative Costs	912	Program Design and Learning	91020	Program Design and Learning	8	Program Support	41	Direct Administrative Costs	19x1156	Middle East and North Africa Incentive Fund	39	Department of State and U.S. Agency for International Development	State/USAID		345095000	Budget for Middle East and North Africa Incentive Fund	Budget for Middle East and North Africa Incentive Fund	18	President's Budget Requests	2013	700000000	865668271

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