./us_foreign_budget_complete

48 rows where Fiscal Year = 2016, International Sector Name = "Agriculture" and Region ID = 7

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Funding Agency ID, Funding Agency Acronym

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 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
47050 47050 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 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 2016 138000000 164163423
47054 47054 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 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 2016 138000000 164163423
47058 47058 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 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 2016 1716000000 2041336482
47063 47063 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 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 2016 1716000000 2041336482
47066 47066 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 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 2016 2000000 2379180
47072 47072 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 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 2016 3000000 3568770
47079 47079 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 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 2016 500000 594795
47084 47084 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 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 2016 500000 594795
47089 47089 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 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 2016 240000 285502
47094 47094 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 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 2016 240000 285502
47105 47105 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 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 2016 201626000 239852278
47107 47107 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 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 2016 206626000 245800228
48309 48309 1002 WLD World 7 World       53 AF African Affairs USAID Africa Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 2000000 2379180
48322 48322 1002 WLD World 7 World       53 AF African Affairs USAID Africa Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 2000000 2379180
48644 48644 1002 WLD World 7 World       53 AF African Affairs USAID East Africa Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 18840000 22411876
48657 48657 1002 WLD World 7 World       53 AF African Affairs USAID East Africa Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 20000000 23791800
48802 48802 1002 WLD World 7 World       53 AF African Affairs USAID Sahel Regional Program 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 10000000 11895900
48809 48809 1002 WLD World 7 World       53 AF African Affairs USAID Sahel Regional Program 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 10000000 11895900
48976 48976 1002 WLD World 7 World       53 AF African Affairs USAID Southern Africa Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 7000000 8327130
48989 48989 1002 WLD World 7 World       53 AF African Affairs USAID Southern Africa Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 7000000 8327130
49290 49290 1002 WLD World 7 World       53 AF African Affairs USAID West Africa Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 18000000 21412620
49303 49303 1002 WLD World 7 World       53 AF African Affairs USAID West Africa Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 24000000 28550161
49970 49970 1002 WLD World 7 World       54 EAP East Asian and Pacific Affairs USAID Regional Development Mission-Asia (RDM/A) 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 2700000 3211893
49977 49977 1002 WLD World 7 World       54 EAP East Asian and Pacific Affairs USAID Regional Development Mission-Asia (RDM/A) 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 2700000 3211893
50953 50953 1002 WLD World 7 World       56 NEA Near Eastern Affairs USAID Middle East Regional (MER) 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 400000 475836
50956 50956 1002 WLD World 7 World       56 NEA Near Eastern Affairs USAID Middle East Regional (MER) 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 400000 475836
52222 52222 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs USAID Central America Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 1000000 1189590
52227 52227 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs USAID Central America Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 1500000 1784385
52533 52533 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs USAID Latin America and Caribbean Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 1000000 1189590
52543 52543 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs USAID Latin America and Caribbean Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 1000000 1189590
55206 55206 1002 WLD World 7 World       96 BFS Bureau for Food Security BFS - Board for International Food and Agricultural Development (BIFAD) 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 400000 475836
55210 55210 1002 WLD World 7 World       96 BFS Bureau for Food Security BFS - Board for International Food and Agricultural Development (BIFAD) 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 400000 475836
55217 55217 1002 WLD World 7 World       96 BFS Bureau for Food Security BFS - Community Development 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 80000000 95167202
55222 55222 1002 WLD World 7 World       96 BFS Bureau for Food Security BFS - Community Development 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 80000000 95167202
55229 55229 1002 WLD World 7 World       96 BFS Bureau for Food Security BFS - Disaster Risk Reduction 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 5000000 5947950
55234 55234 1002 WLD World 7 World       96 BFS Bureau for Food Security BFS - Disaster Risk Reduction 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 5000000 5947950
55241 55241 1002 WLD World 7 World       96 BFS Bureau for Food Security BFS - Market Access for Vulnerable Populations 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 18000000 21412620
55246 55246 1002 WLD World 7 World       96 BFS Bureau for Food Security BFS - Market Access for Vulnerable Populations 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 24000000 28550161
55253 55253 1002 WLD World 7 World       96 BFS Bureau for Food Security BFS - Markets, Partnerships and Innovation 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 36000000 42825241
55258 55258 1002 WLD World 7 World       96 BFS Bureau for Food Security BFS - Markets, Partnerships and Innovation 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 42000000 49962781
55265 55265 1002 WLD World 7 World       96 BFS Bureau for Food Security BFS - Monitoring and Evaluation 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 18000000 21412620
55270 55270 1002 WLD World 7 World       96 BFS Bureau for Food Security BFS - Monitoring and Evaluation 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 18000000 21412620
55277 55277 1002 WLD World 7 World       96 BFS Bureau for Food Security BFS - Research and Development 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 130000000 154646703
55282 55282 1002 WLD World 7 World       96 BFS Bureau for Food Security BFS - Research and Development 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 146000000 173680144
55289 55289 1002 WLD World 7 World       96 BFS Bureau for Food Security BFS - USAID Country Support 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 23560000 28026741
55293 55293 1002 WLD World 7 World       96 BFS Bureau for Food Security BFS - USAID Country Support 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 27260000 32428224
58920 58920 1002 WLD World 7 World       998   Unknown - Budget Data USAID Asia Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 900000 1070631
58927 58927 1002 WLD World 7 World       998   Unknown - Budget Data USAID Asia Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2016 900000 1070631

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