./us_foreign_budget_complete

20 rows where Funding Account ID = "11xB001" and International Sector Name = "Unallocated/ Unspecified"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Managing Sub-agency or Bureau ID, Transaction Type ID, Transaction Type Name, Fiscal Year

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
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
55588 55588 1002 WLD World 7 World       998   Unknown - Budget Data   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 2006 1277235340 1785747156
55589 55589 1002 WLD World 7 World       998   Unknown - Budget Data   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 2007 1241868720 1689955996
55590 55590 1002 WLD World 7 World       998   Unknown - Budget Data   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 2008 1277288635 1702645896
55591 55591 1002 WLD World 7 World       998   Unknown - Budget Data   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 2009 1493869092 1971318608
55592 55592 1002 WLD World 7 World       998   Unknown - Budget Data   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 2010 2255670000 2950930014
55593 55593 1002 WLD World 7 World       998   Unknown - Budget Data   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 2011 1973561391 2530861364
55594 55594 1002 WLD World 7 World       998   Unknown - Budget Data   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 2012 2649388064 3336374389
55595 55595 1002 WLD World 7 World       998   Unknown - Budget Data   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 2013 2574000871 3183186975
55596 55596 1002 WLD World 7 World       998   Unknown - Budget Data   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 2014 2640229000 3203121753

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