./us_foreign_budget_complete

32 rows where Funding Account Name = "Public Law 480 Title II Grants", Income Group Acronym = "LIC" and US Sector Name = "Natural Resources and Biodiversity"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country ID, Country Code, Country Name, Transaction Type ID, Transaction Type Name, Fiscal Year

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
5928 5928 108 BDI Burundi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2017 329000 384510
9069 9069 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2013 4775000 5905094
9070 9070 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2014 8867000 10757431
9071 9071 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 6261000 7509741
9072 9072 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2017 20293000 23716914
9073 9073 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2018 15321000 17495226
9074 9074 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 5100000 6117183
11479 11479 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2009 15000000 19794090
11480 11480 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2010 15310000 20028966
11481 11481 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2011 19443000 24933371
11482 11482 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2012 11476000 14451727
11483 11483 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2013 31444000 38885819
11484 11484 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2014 27301000 33121531
11485 11485 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 30375000 36433220
11486 11486 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2017 46097000 53874666
11487 11487 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2018 24490000 27965413
11488 11488 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2019 10264000 11495424
11489 11489 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2011 10000000 12823829
11490 11490 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2012 10000000 12593000
11491 11491 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2013 9000000 11130021
11492 11492 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 32100000 38502267
11493 11493 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 30000000 35061717
24397 24397 450 MDG Madagascar 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2017 791000 924461
24398 24398 450 MDG Madagascar 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2018 445000 508151
24399 24399 450 MDG Madagascar 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2019 1147000 1284611
24801 24801 454 MWI Malawi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2016 333000 396133
24802 24802 454 MWI Malawi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2018 5570000 6360447
24803 24803 454 MWI Malawi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2019 53000 59359
25627 25627 466 MLI Mali 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2017 360000 420741
30120 30120 562 NER Niger 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2014 700000 849239
38520 38520 728 SSD South Sudan 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2011 3252000 4170309
38521 38521 728 SSD South Sudan 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2013 7105000 8786533

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