./us_foreign_budget_complete

37 rows where Fiscal Year = 2017, International Sector Name = "Trade Policy and Regulations" and Region Name = "World"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Managing Sub-agency or Bureau 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
47379 47379 1002 WLD World 7 World       53 AF African Affairs African Union 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 2017 189000 220889
47841 47841 1002 WLD World 7 World       53 AF African Affairs State Africa Regional 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 2017 1000000 1168724
48293 48293 1002 WLD World 7 World       53 AF African Affairs USAID Africa Regional 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 7001000 8182236
48615 48615 1002 WLD World 7 World       53 AF African Affairs USAID East Africa Regional 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2017 5000000 5843619
48628 48628 1002 WLD World 7 World       53 AF African Affairs USAID East Africa Regional 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 25000000 29218097
48799 48799 1002 WLD World 7 World       53 AF African Affairs USAID Sahel Regional Program 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 500000 584362
48947 48947 1002 WLD World 7 World       53 AF African Affairs USAID Southern Africa Regional 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2017 5000000 5843619
48960 48960 1002 WLD World 7 World       53 AF African Affairs USAID Southern Africa Regional 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 22500000 26296288
49260 49260 1002 WLD World 7 World       53 AF African Affairs USAID West Africa Regional 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2017 5000000 5843619
49273 49273 1002 WLD World 7 World       53 AF African Affairs USAID West Africa Regional 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 22500000 26296288
49712 49712 1002 WLD World 7 World       54 EAP East Asian and Pacific Affairs State East Asia and Pacific Regional 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 2017 6640000 7760327
49725 49725 1002 WLD World 7 World       54 EAP East Asian and Pacific Affairs State East Asia and Pacific Regional 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 2017 10170000 11885922
49962 49962 1002 WLD World 7 World       54 EAP East Asian and Pacific Affairs USAID Regional Development Mission-Asia (RDM/A) 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 2600000 3038682
50275 50275 1002 WLD World 7 World       55 EUR European and Eurasian Affairs Europe and Eurasia Regional 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   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2017 200000 233745
50279 50279 1002 WLD World 7 World       55 EUR European and Eurasian Affairs Europe and Eurasia Regional 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 1 344950000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) - Overseas Contingency Operations (OCO Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) - Overseas Contingency Operations (OCO 1 Appropriated and Planned 2017 500000 584362
50514 50514 1002 WLD World 7 World       56 NEA Near Eastern Affairs Middle East Partnership Initiative (MEPI) 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 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2017 6175000 7216870
50934 50934 1002 WLD World 7 World       56 NEA Near Eastern Affairs USAID Middle East Regional (MER) 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2017 1737000 2030073
50943 50943 1002 WLD World 7 World       56 NEA Near Eastern Affairs USAID Middle East Regional (MER) 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 2017 3000000 3506172
51259 51259 1002 WLD World 7 World       57 SCA South and Central Asian Affairs Central Asia Regional 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 1 344950000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) - Overseas Contingency Operations (OCO Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) - Overseas Contingency Operations (OCO 1 Appropriated and Planned 2017 3100000 3623044
51265 51265 1002 WLD World 7 World       57 SCA South and Central Asian Affairs Central Asia Regional 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 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 18 President's Budget Requests 2017 3000000 3506172
51417 51417 1002 WLD World 7 World       57 SCA South and Central Asian Affairs State South and Central Asia Regional 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 2017 1150000 1344032
51428 51428 1002 WLD World 7 World       57 SCA South and Central Asian Affairs State South and Central Asia Regional 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 2017 3415000 3991192
52011 52011 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs State Western Hemisphere Regional 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 2017 6000000 7012343
52203 52203 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs USAID Central America Regional 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2017 5640000 6591603
52213 52213 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs USAID Central America Regional 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 9198000 10749922
53377 53377 1002 WLD World 7 World       63 IO International Organization Affairs IO - IDLO International Development Law Organization 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   345054000 Budget for International Organizations and Programs, State - IO - IDLO International Development Law Organization Budget for International Organizations and Programs, State - IO - IDLO International Development Law Organization 18 President's Budget Requests 2017 400000 467490
53515 53515 1002 WLD World 7 World       63 IO International Organization Affairs IO - OAS Development Assistance 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   345063000 Budget for International Organizations and Programs, State - IO - OAS Development Assistance Budget for International Organizations and Programs, State - IO - OAS Development Assistance 18 President's Budget Requests 2017 3000000 3506172
53861 53861 1002 WLD World 7 World       63 IO International Organization Affairs IO - WTO Technical Assistance 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   345091000 Budget for International Organizations and Programs, State - IO - WTO Technical Assistance Budget for International Organizations and Programs, State - IO - WTO Technical Assistance 1 Appropriated and Planned 2017 600000 701234
53873 53873 1002 WLD World 7 World       63 IO International Organization Affairs IO - WTO Technical Assistance 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   345091000 Budget for International Organizations and Programs, State - IO - WTO Technical Assistance Budget for International Organizations and Programs, State - IO - WTO Technical Assistance 18 President's Budget Requests 2017 600000 701234
54213 54213 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 2017 10500000 12271601
55539 55539 1002 WLD World 7 World       144 EB Economic and Business Affairs Bureau of Economic and Business Affairs (EB) 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 2017 100000 116872
57498 57498 1002 WLD World 7 World       998   Unknown - Budget Data E3 - Trade & Regulatory Reform 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2017 7674000 8968787
57499 57499 1002 WLD World 7 World       998   Unknown - Budget Data E3 - Trade & Regulatory Reform 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 2017 6000000 7012343
58443 58443 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Policy 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 100000 116872
58914 58914 1002 WLD World 7 World       998   Unknown - Budget Data USAID Asia Regional 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 600000 701234
59520 59520 1002 WLD World 7 World       998   Unknown - Budget Data USAID Economic Growth, Education and Environment (E3) 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 7310000 8543372
59533 59533 1002 WLD World 7 World       998   Unknown - Budget Data USAID Economic Growth, Education and Environment (E3) 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 2017 5000000 5843619

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