./us_foreign_aid_implementing

8 rows where Country Name = "China (P.R.C.)" and Managing Agency ID = 11

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type ID, Transaction Type Name

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
37272 37272 11 DOL Department of Labor CHN China (P.R.C.) 2 Obligations 2004 3500000 5417079
37273 37273 11 DOL Department of Labor CHN China (P.R.C.) 2 Obligations 2015 900000 1126107
37274 37274 11 DOL Department of Labor CHN China (P.R.C.) 3 Disbursements 2006 121026 176065
37275 37275 11 DOL Department of Labor CHN China (P.R.C.) 3 Disbursements 2007 482295 682832
37276 37276 11 DOL Department of Labor CHN China (P.R.C.) 3 Disbursements 2008 1120559 1554217
37277 37277 11 DOL Department of Labor CHN China (P.R.C.) 3 Disbursements 2010 1757741 2392590
37278 37278 11 DOL Department of Labor CHN China (P.R.C.) 3 Disbursements 2016 335186 416069
37279 37279 11 DOL Department of Labor CHN China (P.R.C.) 3 Disbursements 2017 345888 422225

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