2025-02-03_foreign-assistance: ./us_foreign_budget_complete: 12 rows where International Category Name = "Administrative Costs" and Region Name = "Middle East and North Africa"

12 rows where International Category Name = "Administrative Costs" and Region Name = "Middle East and North Africa"

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
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
13961	13961	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	10	Administrative Costs	911	Operating Expenses	91010	Operating Expenses	8	Program Support	41	Direct Administrative Costs	72x1037	Economic Support Fund	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	1300000	1239938
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
61205	61205	1022	MEN	Middle East Region	3	Middle East and North Africa				37	ANE	Bureau for Asia and Near East	Asia Middle East Regional	10	Administrative Costs	912	Program Design and Learning	91020	Program Design and Learning	8	Program Support	41	Direct Administrative Costs	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	2007	50000	68041
61206	61206	1022	MEN	Middle East Region	3	Middle East and North Africa				37	ANE	Bureau for Asia and Near East	Asia Middle East Regional	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	1290000	1755454
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
);