home / 2025-02-03_foreign-assistance

./us_foreign_budget_complete

9 rows where Fiscal Year = 2020 and Funding Agency Name = "Department of the Treasury"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: International Category Name, US Category ID

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
55496 55496 1002 WLD World 7 World       133 OIA Office of International Affairs   6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 11x1039 International Fund for Agricultural Development 4 Department of the Treasury TREAS   344963000 Budget for Contribution to the International Fund for Agricultural Development Budget for Contribution to the International Fund for Agricultural Development 1 Appropriated and Planned 2020 30000000 33156925
55497 55497 1002 WLD World 7 World       133 OIA Office of International Affairs   7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 11x0066 Global Environment Facility 4 Department of the Treasury TREAS   345012000 Budget for Global Environment Facility, Environmental Trust Funds Budget for Global Environment Facility, Environmental Trust Funds 1 Appropriated and Planned 2020 139575000 154262592
55508 55508 1002 WLD World 7 World       133 OIA Office of International Affairs   7 Other 430 Other Multisector 43010 Multisector aid 9 Multi-sector 52 Multi-sector - Unspecified 11xB002 Department of the Treasury, Office of Technical Assistance - Unknown Funding Account 4 Department of the Treasury TREAS   344979000 Budget for Department of the Treasury, Office of Technical Assistance - Unknown Funding Account Budget for Department of the Treasury, Office of Technical Assistance - Unknown Funding Account 18 President's Budget Requests 2020 30000000 33156925
55510 55510 1002 WLD World 7 World       133 OIA Office of International Affairs   7 Other 600 Action Relating To Debt 60010 Action relating to debt 9 Multi-sector 40 Debt Relief 11x0091 Debt Restructuring 4 Department of the Treasury TREAS   344970000 Budget for Debt Restructuring - Tropical Forest Conservation Act Budget for Debt Restructuring - Tropical Forest Conservation Act 1 Appropriated and Planned 2020 15000000 16578462
55511 55511 1002 WLD World 7 World       133 OIA Office of International Affairs   7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 11x0067 Asian Development Fund 4 Department of the Treasury TREAS   344960000 Budget for Contribution to the Asian Development Fund, Multilateral Development Banks Budget for Contribution to the Asian Development Fund, Multilateral Development Banks 1 Appropriated and Planned 2020 47395000 52382415
55513 55513 1002 WLD World 7 World       133 OIA Office of International Affairs   7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 11x0073 International Development Association 4 Department of the Treasury TREAS   344962000 Budget for Contribution to the International Development Association - Multilateral Development Banks Budget for Contribution to the International Development Association - Multilateral Development Banks 1 Appropriated and Planned 2020 1097010000 1212449265
55515 55515 1002 WLD World 7 World       133 OIA Office of International Affairs   7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 11x0077 Contribution to the International Bank for Reconstruction and Development 4 Department of the Treasury TREAS   344961000 Budget for Contribution to the International Bank for Reconstruction and Development - Multilateral Development Banks Budget for Contribution to the International Bank for Reconstruction and Development - Multilateral Development Banks 1 Appropriated and Planned 2020 206500000 228230165
55517 55517 1002 WLD World 7 World       133 OIA Office of International Affairs   7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 11x0079 African Development Fund 4 Department of the Treasury TREAS   344959000 Budget for Contribution to the African Development Fund - Multilateral Development Banks Budget for Contribution to the African Development Fund - Multilateral Development Banks 1 Appropriated and Planned 2020 171300000 189326040
55529 55529 1002 WLD World 7 World       133 OIA Office of International Affairs   7 Other 998 Unallocated/ Unspecified 99810 Sectors not specified 9 Multi-sector 52 Multi-sector - Unspecified 11xB001 Department of the Treasury, Office of International Assistance - Unknown Funding Account 4 Department of the Treasury TREAS   344978000 Budget for Department of the Treasury, Office of International Affairs - Unknown Funding Account Budget for Department of the Treasury, Office of International Affairs - Unknown Funding Account 18 President's Budget Requests 2020 1522205000 1682387885

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