./us_foreign_aid_implementing

10 rows where Fiscal Year = 2011 and Managing Agency Acronym = "DOT"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country Code, Country Name, Transaction Type ID, Transaction Type Name, 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
43426 43426 15 DOT Department of Transportation AFG Afghanistan 2 Obligations 2011 1032731 1378066
43433 43433 15 DOT Department of Transportation AFG Afghanistan 3 Disbursements 2011 1032731 1378066
43490 43490 15 DOT Department of Transportation CHN China (P.R.C.) 2 Obligations 2011 68833 91850
43496 43496 15 DOT Department of Transportation CHN China (P.R.C.) 3 Disbursements 2011 68833 91850
43570 43570 15 DOT Department of Transportation HTI Haiti 2 Obligations 2011 4281 5713
43573 43573 15 DOT Department of Transportation HTI Haiti 3 Disbursements 2011 4281 5713
43586 43586 15 DOT Department of Transportation IRQ Iraq 2 Obligations 2011 199200 265810
43592 43592 15 DOT Department of Transportation IRQ Iraq 3 Disbursements 2011 199200 265810
43701 43701 15 DOT Department of Transportation SSN Sub-Saharan Africa Region 2 Obligations 2011 1370215 1828401
43706 43706 15 DOT Department of Transportation SSN Sub-Saharan Africa Region 3 Disbursements 2011 1370215 1828401

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