./us_foreign_budget_complete

11 rows where Activity Description = "Budget for Department of the Treasury, Office of Technical Assistance - Unknown Funding Account" and Funding Agency ID = 4

✎ View and edit SQL

This data as json, CSV (advanced)

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

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
);