2025-02-03_foreign-assistance: ./us_foreign_budget_complete: 16 rows where Fiscal Year = 2015, Funding Agency Name = "Department of Agriculture" and Region Name = "World"

16 rows where Fiscal Year = 2015, Funding Agency Name = "Department of Agriculture" and Region Name = "World"

descending

Link	rowid ▼	Country ID	Country Code	Country Name	Region ID	Region Name	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
47049	47049	1002	WLD	World	7	World	8	FAS	Foreign Agricultural Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12x2277	Public Law 480 Title I Direct Credit and Food for Progress Program Account	5	Department of Agriculture	AGR	345168000	Budget for Public Law 480 Program Account, Title I	Budget for Public Law 480 Program Account, Title I	1	Appropriated and Planned	2015	138000000	165523764
47053	47053	1002	WLD	World	7	World	8	FAS	Foreign Agricultural Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12x2277	Public Law 480 Title I Direct Credit and Food for Progress Program Account	5	Department of Agriculture	AGR	345168000	Budget for Public Law 480 Program Account, Title I	Budget for Public Law 480 Program Account, Title I	18	President's Budget Requests	2015	138000000	165523764
47057	47057	1002	WLD	World	7	World	8	FAS	Foreign Agricultural Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12x2278	Public Law 480 Title II Grants	5	Department of Agriculture	AGR	345170000	Budget for Public Law 480 Title II Grants	Budget for Public Law 480 Title II Grants	1	Appropriated and Planned	2015	1466000000	1758390132
47062	47062	1002	WLD	World	7	World	8	FAS	Foreign Agricultural Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12x2278	Public Law 480 Title II Grants	5	Department of Agriculture	AGR	345170000	Budget for Public Law 480 Title II Grants	Budget for Public Law 480 Title II Grants	18	President's Budget Requests	2015	1466000000	1758390132
47065	47065	1002	WLD	World	7	World	8	FAS	Foreign Agricultural Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12x2900	Foreign Agricultural Service, Salaries and Expenses	5	Department of Agriculture	AGR	345181000	Budget for Salaries and Expenses, Foreign Agricultural Service - Borlaug Fellowship Program	Budget for Salaries and Expenses, Foreign Agricultural Service - Borlaug Fellowship Program	1	Appropriated and Planned	2015	3000000	3598343
47071	47071	1002	WLD	World	7	World	8	FAS	Foreign Agricultural Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12x2900	Foreign Agricultural Service, Salaries and Expenses	5	Department of Agriculture	AGR	345181000	Budget for Salaries and Expenses, Foreign Agricultural Service - Borlaug Fellowship Program	Budget for Salaries and Expenses, Foreign Agricultural Service - Borlaug Fellowship Program	18	President's Budget Requests	2015	2000000	2398895
47078	47078	1002	WLD	World	7	World	8	FAS	Foreign Agricultural Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12x2900	Foreign Agricultural Service, Salaries and Expenses	5	Department of Agriculture	AGR	345182000	Budget for Salaries and Expenses, Foreign Agricultural Service - Faculty Exchange Program	Budget for Salaries and Expenses, Foreign Agricultural Service - Faculty Exchange Program	1	Appropriated and Planned	2015	208942	250615
47083	47083	1002	WLD	World	7	World	8	FAS	Foreign Agricultural Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12x2900	Foreign Agricultural Service, Salaries and Expenses	5	Department of Agriculture	AGR	345182000	Budget for Salaries and Expenses, Foreign Agricultural Service - Faculty Exchange Program	Budget for Salaries and Expenses, Foreign Agricultural Service - Faculty Exchange Program	18	President's Budget Requests	2015	230000	275873
47088	47088	1002	WLD	World	7	World	8	FAS	Foreign Agricultural Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12x2900	Foreign Agricultural Service, Salaries and Expenses	5	Department of Agriculture	AGR	345183000	Budget for Salaries and Expenses, Foreign Agricultural Service - Scientific Cooperation Research Program	Budget for Salaries and Expenses, Foreign Agricultural Service - Scientific Cooperation Research Program	1	Appropriated and Planned	2015	240000	287867
47093	47093	1002	WLD	World	7	World	8	FAS	Foreign Agricultural Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12x2900	Foreign Agricultural Service, Salaries and Expenses	5	Department of Agriculture	AGR	345183000	Budget for Salaries and Expenses, Foreign Agricultural Service - Scientific Cooperation Research Program	Budget for Salaries and Expenses, Foreign Agricultural Service - Scientific Cooperation Research Program	18	President's Budget Requests	2015	240000	287867
47104	47104	1002	WLD	World	7	World	8	FAS	Foreign Agricultural Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12x2903	McGovern-Dole International Food for Education and Child Nutrition Program Grants	5	Department of Agriculture	AGR	345094000	Budget for McGovern-Dole International Food for Education and Child Nutrition Program Grants	Budget for McGovern-Dole International Food for Education and Child Nutrition Program Grants	1	Appropriated and Planned	2015	191626000	229845339
47106	47106	1002	WLD	World	7	World	8	FAS	Foreign Agricultural Service	6	Agriculture	310	Agriculture	31110	Agricultural policy and administrative management	5	Economic Development	29	Agriculture	12x2903	McGovern-Dole International Food for Education and Child Nutrition Program Grants	5	Department of Agriculture	AGR	345094000	Budget for McGovern-Dole International Food for Education and Child Nutrition Program Grants	Budget for McGovern-Dole International Food for Education and Child Nutrition Program Grants	18	President's Budget Requests	2015	196626000	235842577
47342	47342	1002	WLD	World	7	World	53	AF	African 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	2015	12789000	15339735
51489	51489	1002	WLD	World	7	World	58	WHA	Western Hemisphere Affairs	2	Health and Population	122	Basic Health	12240	Basic nutrition	3	Health	19	Nutrition	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	2015	1589000	1905922
55651	55651	1002	WLD	World	7	World	998		Unknown - Budget Data	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	2015	-6535000	-7838390
55662	55662	1002	WLD	World	7	World	998		Unknown - Budget Data	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	18	President's Budget Requests	2015	1169500000	1402753929

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