./us_foreign_budget_complete

47 rows where Fiscal Year = 2014, Funding Account ID = "72x1037" and International Sector Name = "General Environmental Protection"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country Code, Region ID, Operating Unit, Transaction Type Name

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
8188 8188 156 CHN China (P.R.C.) 1 East Asia and Oceania 3 Upper Middle Income Country UMIC 54 EAP East Asian and Pacific Affairs China 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 2014 2000000 2426397
8197 8197 156 CHN China (P.R.C.) 1 East Asia and Oceania 3 Upper Middle Income Country UMIC 54 EAP East Asian and Pacific Affairs China 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 2014 900000 1091879
8739 8739 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 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 2014 23000000 27903565
8750 8750 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 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 2014 12000000 14558382
13139 13139 268 GEO Georgia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Georgia 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 2014 2000000 2426397
13142 13142 268 GEO Georgia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Georgia 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 2014 2000000 2426397
16257 16257 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs Haiti 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 2014 11800000 14315742
16266 16266 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs Haiti 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 2014 14000000 16984778
19677 19677 398 KAZ Kazakhstan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Kazakhstan 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 2014 2500000 3032996
19678 19678 398 KAZ Kazakhstan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Kazakhstan 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 2014 2500000 3032996
20398 20398 400 JOR Jordan 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Jordan 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 2014 7000000 8492389
23837 23837 430 LBR Liberia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Liberia 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 2014 4000000 4852794
23845 23845 430 LBR Liberia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Liberia 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 2014 4800000 5823353
23848 23848 430 LBR Liberia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Liberia 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 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2014 1430000 1734874
26814 26814 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 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 2014 11100000 13466503
29601 29601 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 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 2014 10000000 12131985
29606 29606 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 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 2014 5000000 6065992
29609 29609 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 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 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2014 3000000 3639595
32873 32873 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 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 2014 18368000 22284029
36936 36936 704 VNM Vietnam 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Vietnam 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 2014 15000000 18197977
38870 38870 728 SSD South Sudan 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs South Sudan 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 2014 7000000 8492389
38873 38873 728 SSD South Sudan 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs South Sudan 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 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2014 4070000 4937718
44218 44218 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 2014 15155000 18386023
49743 49743 1002 WLD World 7 World       54 EAP East Asian and Pacific Affairs State East Asia and Pacific Regional 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 2014 375000 454949
49752 49752 1002 WLD World 7 World       54 EAP East Asian and Pacific Affairs State East Asia and Pacific Regional 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 2014 1146000 1390325
50008 50008 1002 WLD World 7 World       54 EAP East Asian and Pacific Affairs USAID Regional Development Mission-Asia (RDM/A) 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 2014 7000000 8492389
50284 50284 1002 WLD World 7 World       55 EUR European and Eurasian Affairs Europe and Eurasia Regional 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 2014 5533000 6712627
50287 50287 1002 WLD World 7 World       55 EUR European and Eurasian Affairs Europe and Eurasia Regional 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 2014 5582000 6772074
50962 50962 1002 WLD World 7 World       56 NEA Near Eastern Affairs USAID Middle East Regional (MER) 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 2014 900000 1091879
51281 51281 1002 WLD World 7 World       57 SCA South and Central Asian Affairs Central Asia Regional 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 2014 175000 212310
51282 51282 1002 WLD World 7 World       57 SCA South and Central Asian Affairs Central Asia Regional 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 2014 2000000 2426397
51442 51442 1002 WLD World 7 World       57 SCA South and Central Asian Affairs State South and Central Asia Regional 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 2014 1000000 1213198
52030 52030 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs State Western Hemisphere Regional 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 2014 1000000 1213198
52040 52040 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs State Western Hemisphere Regional 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 2014 3000000 3639595
52042 52042 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs State Western Hemisphere Regional 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   344994000 Budget for Economic Support Fund, Central American Unaccompanied Children Supplemental Budget for Economic Support Fund, Central American Unaccompanied Children Supplemental 18 President's Budget Requests 2014 15000000 18197977
54069 54069 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 2014 95500000 115860453
54076 54076 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 2014 90500000 109794461
54085 54085 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 1 Appropriated and Planned 2014 1200000 1455838
54092 54092 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 2014 2000000 2426397
54100 54100 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 2014 622000 754609
54108 54108 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 2014 1000000 1213198
54149 54149 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 2014 1184000 1436427
54159 54159 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 2014 350000 424619
54187 54187 1002 WLD World 7 World       65 OES Oceans and International Environmental and Scientific Affairs OES/OP Other Programs 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 2014 2050000 2487057
54220 54220 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 2014 10500000 12738584
54229 54229 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 2014 10500000 12738584
54249 54249 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 2014 1000000 1213198

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