home / 2025-02-03_foreign-assistance

./us_foreign_budget_complete

6 rows where Activity ID = 345061000 and International Sector Name = "Energy"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type ID, Transaction Type Name, Fiscal Year, current_amount, 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 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
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 6917.48ms