./us_foreign_budget_complete

22 rows where Income Group Acronym = "UMIC", International Sector Code = 240 and Region ID = 6

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country Code, Activity ID, Transaction Type 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
5183 5183 76 BRA Brazil 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Brazil 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2008 483000 643847
5184 5184 76 BRA Brazil 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Brazil 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2009 300000 395882
14968 14968 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 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   344983000 Budget for Development Assistance, H.R. 2863 Supplemental Budget for Development Assistance, H.R. 2863 Supplemental 1 Appropriated and Planned 2006 1050000 1468042
19187 19187 388 JAM Jamaica 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Jamaica 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2008 1765000 2352773
19188 19188 388 JAM Jamaica 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Jamaica 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2017 8000000 9349791
19189 19189 388 JAM Jamaica 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Jamaica 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2009 500000 659803
19190 19190 388 JAM Jamaica 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Jamaica 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2011 1500000 1923574
26793 26793 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2006 2056000 2874565
26794 26794 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2007 3100000 4218533
26795 26795 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 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 2008 750000 999762
32485 32485 600 PRY Paraguay 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Paraguay 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2009 180000 237529
32486 32486 600 PRY Paraguay 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Paraguay 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2012 600000 755580
32487 32487 600 PRY Paraguay 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Paraguay 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2013 1433000 1772147
32488 32488 600 PRY Paraguay 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Paraguay 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2014 2000000 2426397
32489 32489 600 PRY Paraguay 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Paraguay 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2015 1825000 2188992
32490 32490 600 PRY Paraguay 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Paraguay 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2016 2527000 3006094
32491 32491 600 PRY Paraguay 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Paraguay 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2017 1729000 2020724
32492 32492 600 PRY Paraguay 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Paraguay 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2014 2000000 2426397
32493 32493 600 PRY Paraguay 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Paraguay 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2015 2073000 2486455
32494 32494 600 PRY Paraguay 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Paraguay 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2016 2844000 3383194
32495 32495 600 PRY Paraguay 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Paraguay 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2017 1740000 2033580
32496 32496 600 PRY Paraguay 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Paraguay 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 2011 450000 577072

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