./us_foreign_budget_complete

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Managing Sub-agency or Bureau ID, Activity Name, 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
5177 5177 76 BRA Brazil 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Brazil 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 990000 1384153
5178 5178 76 BRA Brazil 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Brazil 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 899000 1223374
5179 5179 76 BRA Brazil 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Brazil 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 3000000 3958818
5180 5180 76 BRA Brazil 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Brazil 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 2011 2500000 3205957
5181 5181 76 BRA Brazil 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Brazil 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 3000000 3847149
5182 5182 76 BRA Brazil 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Brazil 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 2012 5000000 6296500
5238 5238 76 BRA Brazil 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Brazil 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2022 2000000 2000000
8713 8713 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 2019 2500000 2799938
8714 8714 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 2020 7000000 7736616
10613 10613 214 DOM Dominican Republic 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Dominican Republic 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 943000 1283250
10614 10614 214 DOM Dominican Republic 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Dominican Republic 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 2019 2000000 2239950
10615 10615 214 DOM Dominican Republic 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Dominican Republic 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 1750000 2332778
10616 10616 214 DOM Dominican Republic 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Dominican Republic 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2021 5000000 5346438
10895 10895 218 ECU Ecuador 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Ecuador 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 2020 1850000 2044677
19181 19181 388 JAM Jamaica 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Jamaica 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 1800000 1989415
26786 26786 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 750000 1048601
26787 26787 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 150000 204123
45892 45892 862 VEN Venezuela 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Venezuela 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2021 15000000 16039314

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