2025-02-03_foreign-assistance: ./us_foreign_budget_complete: 14 rows where Fiscal Year = 2012, International Sector Name = "Other Social Infrastructure and Services" and Region Name = "East Asia and Oceania"

14 rows where Fiscal Year = 2012, International Sector Name = "Other Social Infrastructure and Services" and Region Name = "East Asia and Oceania"

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
6969	6969	116	KHM	Cambodia	1	East Asia and Oceania	2	Lower Middle Income Country	LMIC	998		Unknown - Budget Data		3	Governance	160	Other Social Infrastructure and Services	16063	Narcotics control	1	Peace and Security	4	Counter-Narcotics	97xB001	Department of Defense - Unknown Funding Account	7	Department of Defense	DOD	345192000	Budget for Unknown Department of Defense Account	Budget for Unknown Department of Defense Account	1	Appropriated and Planned	2012	1189000	1497308
8139	8139	156	CHN	China (P.R.C.)	1	East Asia and Oceania	3	Upper Middle Income Country	UMIC	54	EAP	East Asian and Pacific Affairs	China	3	Governance	160	Other Social Infrastructure and Services	16010	Social Protection	4	Education and Social Services	23	Social Services	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	2012	4100000	5163130
8151	8151	156	CHN	China (P.R.C.)	1	East Asia and Oceania	3	Upper Middle Income Country	UMIC	54	EAP	East Asian and Pacific Affairs	China	3	Governance	160	Other Social Infrastructure and Services	16010	Social Protection	4	Education and Social Services	23	Social Services	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	2012	2800000	3526040
17902	17902	360	IDN	Indonesia	1	East Asia and Oceania	2	Lower Middle Income Country	LMIC	54	EAP	East Asian and Pacific Affairs	Indonesia	3	Governance	160	Other Social Infrastructure and Services	16063	Narcotics control	1	Peace and Security	4	Counter-Narcotics	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	1	Appropriated and Planned	2012	490000	617057
17915	17915	360	IDN	Indonesia	1	East Asia and Oceania	2	Lower Middle Income Country	LMIC	54	EAP	East Asian and Pacific Affairs	Indonesia	3	Governance	160	Other Social Infrastructure and Services	16063	Narcotics control	1	Peace and Security	4	Counter-Narcotics	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	2012	500000	629650
18036	18036	360	IDN	Indonesia	1	East Asia and Oceania	2	Lower Middle Income Country	LMIC	998		Unknown - Budget Data		3	Governance	160	Other Social Infrastructure and Services	16063	Narcotics control	1	Peace and Security	4	Counter-Narcotics	97xB001	Department of Defense - Unknown Funding Account	7	Department of Defense	DOD	345192000	Budget for Unknown Department of Defense Account	Budget for Unknown Department of Defense Account	1	Appropriated and Planned	2012	1378000	1735315
22290	22290	418	LAO	Laos	1	East Asia and Oceania	2	Lower Middle Income Country	LMIC	54	EAP	East Asian and Pacific Affairs	Laos	3	Governance	160	Other Social Infrastructure and Services	16063	Narcotics control	1	Peace and Security	4	Counter-Narcotics	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	1	Appropriated and Planned	2012	250000	314825
22301	22301	418	LAO	Laos	1	East Asia and Oceania	2	Lower Middle Income Country	LMIC	54	EAP	East Asian and Pacific Affairs	Laos	3	Governance	160	Other Social Infrastructure and Services	16063	Narcotics control	1	Peace and Security	4	Counter-Narcotics	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	2012	220000	277046
33687	33687	608	PHL	Philippines	1	East Asia and Oceania	2	Lower Middle Income Country	LMIC	998		Unknown - Budget Data		3	Governance	160	Other Social Infrastructure and Services	16063	Narcotics control	1	Peace and Security	4	Counter-Narcotics	97xB001	Department of Defense - Unknown Funding Account	7	Department of Defense	DOD	345192000	Budget for Unknown Department of Defense Account	Budget for Unknown Department of Defense Account	1	Appropriated and Planned	2012	2419000	3046247
34172	34172	626	TLS	Timor-Leste	1	East Asia and Oceania	2	Lower Middle Income Country	LMIC	54	EAP	East Asian and Pacific Affairs	Timor-Leste	3	Governance	160	Other Social Infrastructure and Services	16063	Narcotics control	1	Peace and Security	4	Counter-Narcotics	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	2012	200000	251860
36819	36819	704	VNM	Vietnam	1	East Asia and Oceania	2	Lower Middle Income Country	LMIC	54	EAP	East Asian and Pacific Affairs	Vietnam	3	Governance	160	Other Social Infrastructure and Services	16010	Social Protection	4	Education and Social Services	23	Social Services	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	2012	5200000	6548360
36830	36830	704	VNM	Vietnam	1	East Asia and Oceania	2	Lower Middle Income Country	LMIC	54	EAP	East Asian and Pacific Affairs	Vietnam	3	Governance	160	Other Social Infrastructure and Services	16010	Social Protection	4	Education and Social Services	23	Social Services	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	18	President's Budget Requests	2012	1400000	1763020
36981	36981	704	VNM	Vietnam	1	East Asia and Oceania	2	Lower Middle Income Country	LMIC	998		Unknown - Budget Data		3	Governance	160	Other Social Infrastructure and Services	16063	Narcotics control	1	Peace and Security	4	Counter-Narcotics	97xB001	Department of Defense - Unknown Funding Account	7	Department of Defense	DOD	345192000	Budget for Unknown Department of Defense Account	Budget for Unknown Department of Defense Account	1	Appropriated and Planned	2012	391000	492386
40727	40727	764	THA	Thailand	1	East Asia and Oceania	3	Upper Middle Income Country	UMIC	998		Unknown - Budget Data		3	Governance	160	Other Social Infrastructure and Services	16063	Narcotics control	1	Peace and Security	4	Counter-Narcotics	97xB001	Department of Defense - Unknown Funding Account	7	Department of Defense	DOD	345192000	Budget for Unknown Department of Defense Account	Budget for Unknown Department of Defense Account	1	Appropriated and Planned	2012	1112000	1400342

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