home / 2025-02-03_foreign-assistance

./us_foreign_aid_implementing

28 rows where Country Name = "Mexico" and Managing Agency ID = 10

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type ID, Transaction Type Name, Fiscal Year, current_amount, constant_amount

Link rowid ▼ Managing Agency ID Managing Agency Acronym Managing Agency Name Country Code Country Name Transaction Type ID Transaction Type Name Fiscal Year current_amount constant_amount
36554 36554 10 DOJ Department of Justice MEX Mexico 2 Obligations 2008 77710 107784
36555 36555 10 DOJ Department of Justice MEX Mexico 2 Obligations 2009 3303795 4535984
36556 36556 10 DOJ Department of Justice MEX Mexico 2 Obligations 2010 5004463 6811941
36557 36557 10 DOJ Department of Justice MEX Mexico 2 Obligations 2011 955826 1275444
36558 36558 10 DOJ Department of Justice MEX Mexico 2 Obligations 2012 302964 397067
36559 36559 10 DOJ Department of Justice MEX Mexico 2 Obligations 2013 143997 185360
36560 36560 10 DOJ Department of Justice MEX Mexico 2 Obligations 2014 97709 123522
36561 36561 10 DOJ Department of Justice MEX Mexico 2 Obligations 2016 109020 135327
36562 36562 10 DOJ Department of Justice MEX Mexico 2 Obligations 2017 334704 408575
36563 36563 10 DOJ Department of Justice MEX Mexico 2 Obligations 2018 333098 397780
36564 36564 10 DOJ Department of Justice MEX Mexico 2 Obligations 2019 311843 365638
36565 36565 10 DOJ Department of Justice MEX Mexico 2 Obligations 2020 151850 175750
36566 36566 10 DOJ Department of Justice MEX Mexico 2 Obligations 2022 2192 2292
36567 36567 10 DOJ Department of Justice MEX Mexico 2 Obligations 2023 149818 149818
36568 36568 10 DOJ Department of Justice MEX Mexico 3 Disbursements 2008 76552 106178
36569 36569 10 DOJ Department of Justice MEX Mexico 3 Disbursements 2009 3303795 4535984
36570 36570 10 DOJ Department of Justice MEX Mexico 3 Disbursements 2010 4354451 5927163
36571 36571 10 DOJ Department of Justice MEX Mexico 3 Disbursements 2011 181400 242059
36572 36572 10 DOJ Department of Justice MEX Mexico 3 Disbursements 2012 126236 165446
36573 36573 10 DOJ Department of Justice MEX Mexico 3 Disbursements 2013 118078 151995
36574 36574 10 DOJ Department of Justice MEX Mexico 3 Disbursements 2014 97709 123522
36575 36575 10 DOJ Department of Justice MEX Mexico 3 Disbursements 2016 48832 60615
36576 36576 10 DOJ Department of Justice MEX Mexico 3 Disbursements 2017 346882 423440
36577 36577 10 DOJ Department of Justice MEX Mexico 3 Disbursements 2018 330397 394554
36578 36578 10 DOJ Department of Justice MEX Mexico 3 Disbursements 2019 343048 402227
36579 36579 10 DOJ Department of Justice MEX Mexico 3 Disbursements 2020 156355 180963
36580 36580 10 DOJ Department of Justice MEX Mexico 3 Disbursements 2022 1634 1709
36581 36581 10 DOJ Department of Justice MEX Mexico 3 Disbursements 2023 149819 149819

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "./us_foreign_aid_implementing" (
"Managing Agency ID" INTEGER,
  "Managing Agency Acronym" TEXT,
  "Managing Agency Name" TEXT,
  "Country Code" TEXT,
  "Country Name" TEXT,
  "Transaction Type ID" INTEGER,
  "Transaction Type Name" TEXT,
  "Fiscal Year" INTEGER,
  "current_amount" INTEGER,
  "constant_amount" INTEGER
);
Powered by Datasette · Queries took 3392.754ms