./us_foreign_budget_complete

33 rows where International Category ID = 7 and Managing Sub-agency or Bureau Name = "Office of International Affairs"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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, 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
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 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
55498 55498 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 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 1 Appropriated and Planned 2015 23500000 28187018
55499 55499 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 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 1 Appropriated and Planned 2016 23500000 27955366
55500 55500 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 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 1 Appropriated and Planned 2017 30000000 35061717
55501 55501 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 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 1 Appropriated and Planned 2018 29796720 34025217
55502 55502 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 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 1 Appropriated and Planned 2019 30000000 33599253
55503 55503 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 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 2015 23500000 28187018
55504 55504 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 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 2016 28000000 33308521
55505 55505 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 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 2017 33500000 39152251
55506 55506 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 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 2018 25455000 29067357
55507 55507 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 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 2019 30000000 33599253
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 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
55509 55509 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 4 Department of the Treasury TREAS   344969000 Budget for Debt Restructuring - Heavily Indebted Poor Countries Initiative, Bilateral Debt Relief Budget for Debt Restructuring - Heavily Indebted Poor Countries Initiative, Bilateral Debt Relief 18 President's Budget Requests 2021 78000000 83404432
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 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 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
);