./us_foreign_budget_complete

41 rows where Fiscal Year = 2017, International Sector Code = 310 and Region ID = 7

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type ID

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
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 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 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 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 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 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 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 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 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 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 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 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
48310 48310 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 2017 2000000 2337448
48323 48323 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 2017 2000000 2337448
48645 48645 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 2017 20000000 23374478
48658 48658 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 2017 20000000 23374478
48803 48803 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 2017 12500000 14609049
48810 48810 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 2017 10000000 11687239
48977 48977 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 2017 8000000 9349791
48990 48990 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 2017 7000000 8181067
49291 49291 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 2017 15700000 18348965
49304 49304 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 2017 19000000 22205754
49978 49978 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 2017 2700000 3155555
50949 50949 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2017 400000 467490
50957 50957 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 2017 400000 467490
52223 52223 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 2017 1500000 1753086
52228 52228 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 2017 1500000 1753086
52534 52534 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 2017 1000000 1168724
52544 52544 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 2017 1000000 1168724
55211 55211 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 2017 400000 467490
55223 55223 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 2017 80000000 93497912
55235 55235 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 2017 5000000 5843619
55247 55247 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 2017 21000000 24543202
55259 55259 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 2017 37540000 43873895
55271 55271 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 2017 18000000 21037030
55283 55283 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 2017 144000000 168296241
55294 55294 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 2017 24260000 28353242
55298 55298 1002 WLD World 7 World       96 BFS Bureau for Food Security USAID Bureau For Food Security (BFS) 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 2017 183000000 213876473
55577 55577 1002 WLD World 7 World       998   Unknown - Budget Data   6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2017 15000000 17530858
57483 57483 1002 WLD World 7 World       998   Unknown - Budget Data E3 - Land and Urban 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 2017 1500000 1753086
58921 58921 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 2017 900000 1051852
58928 58928 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 2017 900000 1051852

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