home / 2025-02-03_foreign-assistance

./us_foreign_budget_complete

11 rows where Funding Agency Name = "Department of State and U.S. Agency for International Development", International Sector Name = "Energy" and Managing Sub-agency or Bureau Acronym = "IO"

✎ View and edit SQL

This data as json, CSV (advanced)

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 Account ID Funding Account 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
53400 53400 1002 WLD World 7 World       63 IO International Organization Affairs IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 19x1005 Department of State, International Organizations and Programs 39 Department of State and U.S. Agency for International Development State/USAID   345056000 Budget for International Organizations and Programs, State - IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change Budget for International Organizations and Programs, State - IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change 1 Appropriated and Planned 2015 5000000 5997238
53401 53401 1002 WLD World 7 World       63 IO International Organization Affairs IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 19x1005 Department of State, International Organizations and Programs 39 Department of State and U.S. Agency for International Development State/USAID   345056000 Budget for International Organizations and Programs, State - IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change Budget for International Organizations and Programs, State - IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change 1 Appropriated and Planned 2016 5000000 5947950
53402 53402 1002 WLD World 7 World       63 IO International Organization Affairs IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 19x1005 Department of State, International Organizations and Programs 39 Department of State and U.S. Agency for International Development State/USAID   345056000 Budget for International Organizations and Programs, State - IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change Budget for International Organizations and Programs, State - IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change 18 President's Budget Requests 2015 5400000 6477017
53403 53403 1002 WLD World 7 World       63 IO International Organization Affairs IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 19x1005 Department of State, International Organizations and Programs 39 Department of State and U.S. Agency for International Development State/USAID   345056000 Budget for International Organizations and Programs, State - IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change Budget for International Organizations and Programs, State - IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change 18 President's Budget Requests 2016 5400000 6423786
53404 53404 1002 WLD World 7 World       63 IO International Organization Affairs IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 19x1005 Department of State, International Organizations and Programs 39 Department of State and U.S. Agency for International Development State/USAID   345056000 Budget for International Organizations and Programs, State - IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change Budget for International Organizations and Programs, State - IO - Intergovernmental Panel on Climate Change / UN Framework Convention on Climate Change 18 President's Budget Requests 2017 4500000 5259258
53467 53467 1002 WLD World 7 World       63 IO International Organization Affairs IO - Montreal Protocol Multilateral Fund 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 19x1005 Department of State, International Organizations and Programs 39 Department of State and U.S. Agency for International Development State/USAID   345061000 Budget for International Organizations and Programs, State - IO - Montreal Protocol Multilateral Fund Budget for International Organizations and Programs, State - IO - Montreal Protocol Multilateral Fund 1 Appropriated and Planned 2015 25500000 30585913
53468 53468 1002 WLD World 7 World       63 IO International Organization Affairs IO - Montreal Protocol Multilateral Fund 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 19x1005 Department of State, International Organizations and Programs 39 Department of State and U.S. Agency for International Development State/USAID   345061000 Budget for International Organizations and Programs, State - IO - Montreal Protocol Multilateral Fund Budget for International Organizations and Programs, State - IO - Montreal Protocol Multilateral Fund 1 Appropriated and Planned 2016 25335000 30138263
53469 53469 1002 WLD World 7 World       63 IO International Organization Affairs IO - Montreal Protocol Multilateral Fund 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 19x1005 Department of State, International Organizations and Programs 39 Department of State and U.S. Agency for International Development State/USAID   345061000 Budget for International Organizations and Programs, State - IO - Montreal Protocol Multilateral Fund Budget for International Organizations and Programs, State - IO - Montreal Protocol Multilateral Fund 1 Appropriated and Planned 2019 31000000 34719228
53470 53470 1002 WLD World 7 World       63 IO International Organization Affairs IO - Montreal Protocol Multilateral Fund 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 19x1005 Department of State, International Organizations and Programs 39 Department of State and U.S. Agency for International Development State/USAID   345061000 Budget for International Organizations and Programs, State - IO - Montreal Protocol Multilateral Fund Budget for International Organizations and Programs, State - IO - Montreal Protocol Multilateral Fund 18 President's Budget Requests 2015 25500000 30585913
53471 53471 1002 WLD World 7 World       63 IO International Organization Affairs IO - Montreal Protocol Multilateral Fund 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 19x1005 Department of State, International Organizations and Programs 39 Department of State and U.S. Agency for International Development State/USAID   345061000 Budget for International Organizations and Programs, State - IO - Montreal Protocol Multilateral Fund Budget for International Organizations and Programs, State - IO - Montreal Protocol Multilateral Fund 18 President's Budget Requests 2016 25500000 30334546
53472 53472 1002 WLD World 7 World       63 IO International Organization Affairs IO - Montreal Protocol Multilateral Fund 4 Infrastructure 230 Energy 23210 Energy generation, renewable sources - multiple technologies 6 Environment 36 Clean Productive Environment 19x1005 Department of State, International Organizations and Programs 39 Department of State and U.S. Agency for International Development State/USAID   345061000 Budget for International Organizations and Programs, State - IO - Montreal Protocol Multilateral Fund Budget for International Organizations and Programs, State - IO - Montreal Protocol Multilateral Fund 18 President's Budget Requests 2017 32500000 37983527

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
);
Powered by Datasette · Queries took 6462.044ms