./us_foreign_budget_complete

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
47376 47376 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 2014 424000 514396
47831 47831 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 1 Appropriated and Planned 2014 500000 606599
47838 47838 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 2014 500000 606599
48280 48280 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 1 Appropriated and Planned 2014 20516000 24889980
48290 48290 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 2014 3961000 4805479
48294 48294 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2014 5100000 6187312
48612 48612 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 2014 8750000 10615487
48625 48625 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 2014 8750000 10615487
48957 48957 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 2014 5175000 6278302
49270 49270 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 2014 7800000 9462948
49709 49709 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 2014 9484000 11505974
49722 49722 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 2014 10136000 12296980
49950 49950 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 1 Appropriated and Planned 2014 1600000 1941118
49959 49959 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 2014 1606000 1948397
50281 50281 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2014 1901000 2306290
50933 50933 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   345095000 Budget for Middle East and North Africa Incentive Fund Budget for Middle East and North Africa Incentive Fund 18 President's Budget Requests 2014 4100000 4974114
50936 50936 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 1 Appropriated and Planned 2014 3170000 3845839
51260 51260 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2014 2625000 3184646
51261 51261 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2014 6500000 7885790
51414 51414 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 2014 2579000 3128839
51425 51425 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 2014 750000 909899
52019 52019 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 18 President's Budget Requests 2014 3000000 3639595
52210 52210 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 2014 1950000 2365737
52521 52521 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs USAID Latin America and Caribbean 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 2014 2500000 3032996
53367 53367 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 1 Appropriated and Planned 2014 600000 727919
53374 53374 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 2014 600000 727919
53505 53505 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 1 Appropriated and Planned 2014 3400000 4124875
53512 53512 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 2014 3400000 4124875
53858 53858 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 2014 1000000 1213198
53870 53870 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 2014 1000000 1213198
54202 54202 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 2014 10500000 12738584
54210 54210 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 2014 10500000 12738584
55433 55433 1002 WLD World 7 World       125 LAB Global Development Lab IDEA - Local Sustainability 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 2014 200000 242640
58387 58387 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Learning, Evaluation and Research 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 2014 921000 1117356
58388 58388 1002 WLD World 7 World       998   Unknown - Budget Data PPL - Learning, Evaluation and Research 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 2014 916000 1111290
58908 58908 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 1 Appropriated and Planned 2014 500000 606599
58911 58911 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 2014 1000000 1213198
59506 59506 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 1 Appropriated and Planned 2014 3541000 4295936
59517 59517 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 2014 3600000 4367514
59523 59523 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 1 Appropriated and Planned 2014 3000000 3639595
59530 59530 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 2014 4500000 5459393

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