home / 2025-02-03_foreign-assistance

./us_foreign_budget_complete

20 rows where Funding Agency Acronym = "MCC" and Transaction Type ID = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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 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
55597 55597 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2004 985628849 1466102539
55598 55598 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2005 1475303339 2129828608
55599 55599 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2006 1735405836 2426331264
55600 55600 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2007 1746300029 2376394669
55601 55601 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2008 1484150601 1978396159
55602 55602 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2009 871299646 1149772235
55603 55603 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2010 1105000000 1445591627
55604 55604 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2011 898200000 1151836314
55605 55605 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2012 898200000 1131103260
55606 55606 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2013 852727727 1054541910
55607 55607 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2014 898200000 1089694855
55608 55608 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2015 899500000 1078903086
55609 55609 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2016 901000000 1071820612
55610 55610 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2017 905000000 1057695128
55611 55611 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2018 905000000 1033429906
55612 55612 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2019 905000000 1013577464
55613 55613 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2020 905000000 1000233895
55614 55614 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2021 912000000 975190286
55615 55615 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2022 397000000 397000000
55616 55616 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 95x2750 Millennium Challenge Corporation, Expenses 3 Millennium Challenge Corporation MCC   344879000 Budget for Millennium Challenge Corporation Budget for Millennium Challenge Corporation 1 Appropriated and Planned 2023 830000000 791652655

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