./us_foreign_budget_complete

25 rows where Income Group Name = "Upper Middle Income Country", International Sector Code = 230 and Region Name = "Western Hemisphere"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country Name, International Purpose Code, Funding Agency ID, 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
2581 2581 32 ARG Argentina 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Defense Nuclear Nonproliferation (DNN) 4 Infrastructure 230 Energy 23181 Energy education/training 5 Economic Development 28 Infrastructure 13 Department of Energy DOE   344853000 Budget for Office of International Nuclear Safeguards Budget for Office of International Nuclear Safeguards 1 Appropriated and Planned 2022 10000 10000
2582 2582 32 ARG Argentina 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Defense Nuclear Nonproliferation (DNN) 4 Infrastructure 230 Energy 23181 Energy education/training 5 Economic Development 28 Infrastructure 13 Department of Energy DOE   344853000 Budget for Office of International Nuclear Safeguards Budget for Office of International Nuclear Safeguards 1 Appropriated and Planned 2023 31000 29568
2583 2583 32 ARG Argentina 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Defense Nuclear Nonproliferation (DNN) 4 Infrastructure 230 Energy 23181 Energy education/training 5 Economic Development 28 Infrastructure 13 Department of Energy DOE   344853000 Budget for Office of International Nuclear Safeguards Budget for Office of International Nuclear Safeguards 18 President's Budget Requests 2023 108000 103010
2584 2584 32 ARG Argentina 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Defense Nuclear Nonproliferation (DNN) 4 Infrastructure 230 Energy 23181 Energy education/training 5 Economic Development 28 Infrastructure 13 Department of Energy DOE   344853000 Budget for Office of International Nuclear Safeguards Budget for Office of International Nuclear Safeguards 18 President's Budget Requests 2024 10000 9318
5249 5249 76 BRA Brazil 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Defense Nuclear Nonproliferation (DNN) 4 Infrastructure 230 Energy 23181 Energy education/training 5 Economic Development 28 Infrastructure 13 Department of Energy DOE   344853000 Budget for Office of International Nuclear Safeguards Budget for Office of International Nuclear Safeguards 1 Appropriated and Planned 2022 108000 108000
5250 5250 76 BRA Brazil 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Defense Nuclear Nonproliferation (DNN) 4 Infrastructure 230 Energy 23181 Energy education/training 5 Economic Development 28 Infrastructure 13 Department of Energy DOE   344853000 Budget for Office of International Nuclear Safeguards Budget for Office of International Nuclear Safeguards 1 Appropriated and Planned 2023 220000 209836
5251 5251 76 BRA Brazil 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Defense Nuclear Nonproliferation (DNN) 4 Infrastructure 230 Energy 23181 Energy education/training 5 Economic Development 28 Infrastructure 13 Department of Energy DOE   344853000 Budget for Office of International Nuclear Safeguards Budget for Office of International Nuclear Safeguards 18 President's Budget Requests 2023 183000 174545
5252 5252 76 BRA Brazil 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Defense Nuclear Nonproliferation (DNN) 4 Infrastructure 230 Energy 23181 Energy education/training 5 Economic Development 28 Infrastructure 13 Department of Energy DOE   344853000 Budget for Office of International Nuclear Safeguards Budget for Office of International Nuclear Safeguards 18 President's Budget Requests 2024 110000 102496
8715 8715 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 2015 3500000 4198066
8716 8716 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 2016 3000000 3568770
8717 8717 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 2015 3500000 4198066
8718 8718 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 2016 5000000 5947950
8719 8719 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 4000000 4674896
8720 8720 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 2000000 2138575
19182 19182 388 JAM Jamaica 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Jamaica 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 2000000 2398895
19183 19183 388 JAM Jamaica 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Jamaica 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 2000000 2379180
19184 19184 388 JAM Jamaica 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Jamaica 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 2500000 2998619
19185 19185 388 JAM Jamaica 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Jamaica 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 2000000 2379180
19186 19186 388 JAM Jamaica 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Jamaica 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 2000000 2337448
26788 26788 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 4000000 4758360
26789 26789 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 6000000 7196685
26790 26790 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 6000000 7137540
26791 26791 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 2015 6000000 7196685
26792 26792 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 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 6000000 7012343
39461 39461 740 SUR Suriname 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Defense Nuclear Nonproliferation (DNN) 4 Infrastructure 230 Energy 23181 Energy education/training 5 Economic Development 28 Infrastructure 13 Department of Energy DOE   344853000 Budget for Office of International Nuclear Safeguards Budget for Office of International Nuclear Safeguards 18 President's Budget Requests 2024 228000 212446

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