2025-02-03_foreign-assistance: ./us_foreign_budget_complete: 14 rows where Fiscal Year = 2007, International Sector Code = 720 and Managing Sub-agency or Bureau Acronym = "SCA"

14 rows where Fiscal Year = 2007, International Sector Code = 720 and Managing Sub-agency or Bureau Acronym = "SCA"

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
21	21	4	AFG	Afghanistan	4	South and Central Asia	1	Low Income Country	LIC	57	SCA	South and Central Asian Affairs		9	Humanitarian	720	Emergency Response	72050	Relief co-ordination; protection and support services	7	Humanitarian Assistance	37	Protection, Assistance and Solutions	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	2007	29996000	40819065
32	32	4	AFG	Afghanistan	4	South and Central Asia	1	Low Income Country	LIC	57	SCA	South and Central Asian Affairs		9	Humanitarian	720	Emergency Response	72050	Relief co-ordination; protection and support services	7	Humanitarian Assistance	37	Protection, Assistance and Solutions	12x2278	Public Law 480 Title II Grants	5	Department of Agriculture	AGR	345174000	Budget for Public Law 480 Title II Grants, H.R. 2206 Supplemental	Budget for Public Law 480 Title II Grants, H.R. 2206 Supplemental	1	Appropriated and Planned	2007	30000000	40824508
2833	2833	50	BGD	Bangladesh	4	South and Central Asia	2	Lower Middle Income Country	LMIC	57	SCA	South and Central Asian Affairs		9	Humanitarian	720	Emergency Response	72050	Relief co-ordination; protection and support services	7	Humanitarian Assistance	37	Protection, Assistance and Solutions	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	2007	3527000	4799601
3451	3451	50	BGD	Bangladesh	4	South and Central Asia	2	Lower Middle Income Country	LMIC	57	SCA	South and Central Asian Affairs	Bangladesh	9	Humanitarian	720	Emergency Response	72050	Relief co-ordination; protection and support services	7	Humanitarian Assistance	37	Protection, Assistance and Solutions	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	25000	34020
7413	7413	144	LKA	Sri Lanka	4	South and Central Asia	3	Upper Middle Income Country	UMIC	57	SCA	South and Central Asian Affairs		9	Humanitarian	720	Emergency Response	72050	Relief co-ordination; protection and support services	7	Humanitarian Assistance	37	Protection, Assistance and Solutions	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	2007	14086000	19168467
21993	21993	417	KGZ	Kyrgyzstan	4	South and Central Asia	2	Lower Middle Income Country	LMIC	57	SCA	South and Central Asian Affairs	Kyrgyz Republic	9	Humanitarian	720	Emergency Response	72050	Relief co-ordination; protection and support services	7	Humanitarian Assistance	37	Protection, Assistance and Solutions	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)	1	Appropriated and Planned	2007	750000	1020613
29092	29092	524	NPL	Nepal	4	South and Central Asia	1	Low Income Country	LIC	57	SCA	South and Central Asian Affairs		9	Humanitarian	720	Emergency Response	72050	Relief co-ordination; protection and support services	7	Humanitarian Assistance	37	Protection, Assistance and Solutions	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	2007	6056000	8241107
29640	29640	524	NPL	Nepal	4	South and Central Asia	1	Low Income Country	LIC	57	SCA	South and Central Asian Affairs	Nepal	9	Humanitarian	720	Emergency Response	72050	Relief co-ordination; protection and support services	7	Humanitarian Assistance	37	Protection, Assistance and Solutions	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	150000	204123
29641	29641	524	NPL	Nepal	4	South and Central Asia	1	Low Income Country	LIC	57	SCA	South and Central Asian Affairs	Nepal	9	Humanitarian	720	Emergency Response	72050	Relief co-ordination; protection and support services	7	Humanitarian Assistance	37	Protection, Assistance and Solutions	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	1205000	1639784
31937	31937	586	PAK	Pakistan	4	South and Central Asia	2	Lower Middle Income Country	LMIC	57	SCA	South and Central Asian Affairs	Pakistan	9	Humanitarian	720	Emergency Response	72050	Relief co-ordination; protection and support services	7	Humanitarian Assistance	37	Protection, Assistance and Solutions	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	50000000	68040847
31940	31940	586	PAK	Pakistan	4	South and Central Asia	2	Lower Middle Income Country	LMIC	57	SCA	South and Central Asian Affairs	Pakistan	9	Humanitarian	720	Emergency Response	72050	Relief co-ordination; protection and support services	7	Humanitarian Assistance	37	Protection, Assistance and Solutions	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	50000000	68040847
39718	39718	762	TJK	Tajikistan	4	South and Central Asia	1	Low Income Country	LIC	57	SCA	South and Central Asian Affairs		9	Humanitarian	720	Emergency Response	72050	Relief co-ordination; protection and support services	7	Humanitarian Assistance	37	Protection, Assistance and Solutions	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	2007	8478000	11537006
40309	40309	762	TJK	Tajikistan	4	South and Central Asia	1	Low Income Country	LIC	57	SCA	South and Central Asian Affairs	Tajikistan	9	Humanitarian	720	Emergency Response	72050	Relief co-ordination; protection and support services	7	Humanitarian Assistance	37	Protection, Assistance and Solutions	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)	1	Appropriated and Planned	2007	1165000	1585352
45670	45670	860	UZB	Uzbekistan	4	South and Central Asia	2	Lower Middle Income Country	LMIC	57	SCA	South and Central Asian Affairs	Uzbekistan	9	Humanitarian	720	Emergency Response	72050	Relief co-ordination; protection and support services	7	Humanitarian Assistance	37	Protection, Assistance and Solutions	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)	1	Appropriated and Planned	2007	750000	1020613

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