2025-02-03_foreign-assistance: ./us_foreign_budget_complete: 7 rows where Funding Agency ID = 5 and Managing Sub-agency or Bureau Name = "Forest Service"

7 rows where Funding Agency ID = 5 and Managing Sub-agency or Bureau Name = "Forest Service"

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	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
7212	7212	124	CAN	Canada	6	Western Hemisphere	4	High Income Country	HIC	9	FS	Forest Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12xB001	Department of Agriculture, Forest Service - Unknown Funding Account	5	Department of Agriculture	AGR	344975000	Budget for Department of Agriculture, Forest Service - Unknown Funding Account	Budget for Department of Agriculture, Forest Service - Unknown Funding Account	18	President's Budget Requests	2018	400000	456765
11006	11006	222	SLV	El Salvador	6	Western Hemisphere	2	Lower Middle Income Country	LMIC	9	FS	Forest Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12xB001	Department of Agriculture, Forest Service - Unknown Funding Account	5	Department of Agriculture	AGR	344975000	Budget for Department of Agriculture, Forest Service - Unknown Funding Account	Budget for Department of Agriculture, Forest Service - Unknown Funding Account	18	President's Budget Requests	2018	126000	143881
19053	19053	388	JAM	Jamaica	6	Western Hemisphere	3	Upper Middle Income Country	UMIC	9	FS	Forest Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12xB001	Department of Agriculture, Forest Service - Unknown Funding Account	5	Department of Agriculture	AGR	344975000	Budget for Department of Agriculture, Forest Service - Unknown Funding Account	Budget for Department of Agriculture, Forest Service - Unknown Funding Account	18	President's Budget Requests	2018	110000	125610
34399	34399	643	RUS	Russia	2	Europe and Eurasia	3	Upper Middle Income Country	UMIC	9	FS	Forest Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12xB001	Department of Agriculture, Forest Service - Unknown Funding Account	5	Department of Agriculture	AGR	344975000	Budget for Department of Agriculture, Forest Service - Unknown Funding Account	Budget for Department of Agriculture, Forest Service - Unknown Funding Account	18	President's Budget Requests	2018	100000	114191
47109	47109	1002	WLD	World	7	World				9	FS	Forest Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12xB001	Department of Agriculture, Forest Service - Unknown Funding Account	5	Department of Agriculture	AGR	344975000	Budget for Department of Agriculture, Forest Service - Unknown Funding Account	Budget for Department of Agriculture, Forest Service - Unknown Funding Account	18	President's Budget Requests	2018	6000000	6851469
60367	60367	1016	ENS	Eastern Asia Region	1	East Asia and Oceania				9	FS	Forest Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12xB001	Department of Agriculture, Forest Service - Unknown Funding Account	5	Department of Agriculture	AGR	344975000	Budget for Department of Agriculture, Forest Service - Unknown Funding Account	Budget for Department of Agriculture, Forest Service - Unknown Funding Account	18	President's Budget Requests	2018	200000	228382
60395	60395	1018	EUN	Europe Region	2	Europe and Eurasia				9	FS	Forest Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12xB001	Department of Agriculture, Forest Service - Unknown Funding Account	5	Department of Agriculture	AGR	344975000	Budget for Department of Agriculture, Forest Service - Unknown Funding Account	Budget for Department of Agriculture, Forest Service - Unknown Funding Account	18	President's Budget Requests	2018	300000	342573

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