home / 2025-02-03_foreign-assistance

./us_foreign_budget_complete

15 rows where Fiscal Year = 2017 and Managing Sub-agency or Bureau Name = "Foreign Agricultural Service"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: International Category ID, International Category Name, International Sector Code, International Sector Name, International Purpose Code

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 OCO Flag Activity ID Activity Name Activity Description Transaction Type ID Transaction Type Name Fiscal Year current_amount constant_amount
47039 47039 1002 WLD World 7 World       8 FAS Foreign Agricultural Service   1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2017 201262000 235219709
47043 47043 1002 WLD World 7 World       8 FAS Foreign Agricultural Service   1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2017 200000000 233744780
47044 47044 1002 WLD World 7 World       8 FAS Foreign Agricultural Service   2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 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 2017 5000000 5843619
47047 47047 1002 WLD World 7 World       8 FAS Foreign Agricultural Service   2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 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 2017 5000000 5843619
47051 47051 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 2017 148029000 173005030
47055 47055 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 2017 150000000 175308585
47059 47059 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 2017 1716000000 2005530209
47067 47067 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 2017 2300000 2688065
47073 47073 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 2017 3150000 3681480
47080 47080 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 2017 500000 584362
47085 47085 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 2017 551035 644008
47090 47090 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 2017 500000 584362
47095 47095 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 2017 360000 420741
47098 47098 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   345184000 Budget for Salaries and Expenses, Foreign Agricultural Service - Scientific Exchanges Program Budget for Salaries and Expenses, Foreign Agricultural Service - Scientific Exchanges Program 1 Appropriated and Planned 2017 600000 701234
47101 47101 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   345184000 Budget for Salaries and Expenses, Foreign Agricultural Service - Scientific Exchanges Program Budget for Salaries and Expenses, Foreign Agricultural Service - Scientific Exchanges Program 18 President's Budget Requests 2017 560000 654485

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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
);
Powered by Datasette · Queries took 6020.205ms