home / 2025-02-03_foreign-assistance

./us_foreign_budget_complete

5 rows where Activity ID = 345056000 and International Sector Name = "Energy"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type ID, 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 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

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 4325.032ms