./us_foreign_budget_complete

19 rows where International Sector Name = "Unallocated/ Unspecified" and Managing Sub-agency or Bureau Name = "Office of International Affairs"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Funding Account ID, Funding Account Name, Activity ID, Activity Name, Activity Description, Transaction Type ID, Transaction Type Name, Fiscal Year, current_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
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 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
55512 55512 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 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 18 President's Budget Requests 2021 47395000 50678886
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 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
55514 55514 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 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 18 President's Budget Requests 2021 1001400000 1070784597
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 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
55516 55516 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 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 18 President's Budget Requests 2021 206500000 220807888
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 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
55518 55518 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 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 18 President's Budget Requests 2021 225948752 241604197
55519 55519 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 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 1 Appropriated and Planned 2015 2400897448 2879750601
55520 55520 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 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 1 Appropriated and Planned 2016 2280249910 2712562546
55521 55521 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 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 1 Appropriated and Planned 2017 1770577148 2069315826
55522 55522 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 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 1 Appropriated and Planned 2018 1758553159 2008112072
55523 55523 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 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 1 Appropriated and Planned 2019 1515697159 1697543074
55524 55524 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 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 2015 2565504159 3077187720
55525 55525 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 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 2016 2811846331 3344944346
55526 55526 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 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 2017 2285021148 2670558823
55527 55527 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 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 2018 1480498000 1690597689
55528 55528 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 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 2019 1416422159 1586357546
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 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
);