./us_foreign_budget_complete

27 rows where Fiscal Year = 2016, Managing Sub-agency or Bureau Acronym = "OES" and Region ID = 7

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: International Category Name, constant_amount

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
54059 54059 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/CC Climate Change 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 14950000 17784371
54061 54061 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/CC Climate Change 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 45600000 54245305
54071 54071 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/CC Climate Change 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 9450000 11241626
54078 54078 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/CC Climate Change 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 21000000 24981391
54094 54094 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/FTA-E FTA Environment 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 4850000 5769512
54102 54102 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/M Mercury 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 450000 535316
54110 54110 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/M Mercury 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 850000 1011152
54118 54118 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 537000 638810
54124 54124 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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
54138 54138 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 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 150000 178439
54151 54151 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 1000000 1189590
54161 54161 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 600000 713754
54165 54165 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OESP OES Partnerships 7 Other 430 Other Multisector 43010 Multisector aid 9 Multi-sector 52 Multi-sector - Unspecified 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 100000 118959
54171 54171 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OP Other Programs 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 631000 750631
54173 54173 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OP Other Programs 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 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 1200000 1427508
54179 54179 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OP Other Programs 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 719000 855315
54181 54181 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OP Other Programs 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 1650000 1962824
54204 54204 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/SPFF South Pacific Forum Fisheries 5 Economic Growth 331 Trade Policy and Regulations 33110 Trade policy and administrative management 5 Economic Development 26 Trade and Investment 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 10500000 12490695
54212 54212 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/SPFF South Pacific Forum Fisheries 5 Economic Growth 331 Trade Policy and Regulations 33110 Trade policy and administrative management 5 Economic Development 26 Trade and Investment 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 10500000 12490695
54222 54222 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/SPFF South Pacific Forum Fisheries 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 10500000 12490695
54231 54231 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/SPFF South Pacific Forum Fisheries 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 10500000 12490695
54251 54251 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/W Water 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 531000 631672
54255 54255 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/W Water 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 850000 1011152
54261 54261 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs State Oceans and International Environmental and Scientific Affairs (OES) 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 300000000 356877007
54262 54262 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs State Oceans and International Environmental and Scientific Affairs (OES) 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 105000000 124906953
54268 54268 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs State Oceans and International Environmental and Scientific Affairs (OES) 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 700000000 832713017
54276 54276 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs State Oceans and International Environmental and Scientific Affairs (OES) 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 245000000 291449556

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