./us_foreign_aid_country

9 rows where Country Code = "PIT"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ Country Code Country Name Region ID Region Name Income Group Acronym Income Group Name Transaction Type ID Transaction Type Name Fiscal Year current_amount constant_amount
15530 15530 PIT Pacific Island Trust Territory 1 East Asia and Oceania     2 Obligations 2002 80850 130651
15531 15531 PIT Pacific Island Trust Territory 1 East Asia and Oceania     2 Obligations 2008 29175 40466
15532 15532 PIT Pacific Island Trust Territory 1 East Asia and Oceania     2 Obligations 2009 4115032 5649780
15533 15533 PIT Pacific Island Trust Territory 1 East Asia and Oceania     3 Disbursements 2003 44802 71035
15534 15534 PIT Pacific Island Trust Territory 1 East Asia and Oceania     3 Disbursements 2005 36048 54145
15535 15535 PIT Pacific Island Trust Territory 1 East Asia and Oceania     3 Disbursements 2008 18709 25950
15536 15536 PIT Pacific Island Trust Territory 1 East Asia and Oceania     3 Disbursements 2009 124466 170887
15537 15537 PIT Pacific Island Trust Territory 1 East Asia and Oceania     3 Disbursements 2010 300000 408352
15538 15538 PIT Pacific Island Trust Territory 1 East Asia and Oceania     3 Disbursements 2011 3701032 4938620

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "./us_foreign_aid_country" (
"Country Code" TEXT,
  "Country Name" TEXT,
  "Region ID" INTEGER,
  "Region Name" TEXT,
  "Income Group Acronym" TEXT,
  "Income Group Name" TEXT,
  "Transaction Type ID" INTEGER,
  "Transaction Type Name" TEXT,
  "Fiscal Year" TEXT,
  "current_amount" INTEGER,
  "constant_amount" INTEGER
);