./us_foreign_aid_country

6 rows where Country Name = "Yemen (former P.D.R.)" and Region ID = 3

✎ View and edit SQL

This data as json, CSV (advanced)

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
14718 14718   Yemen (former P.D.R.) 3 Middle East and North Africa     2 Obligations 1970 300000 1850480
14719 14719   Yemen (former P.D.R.) 3 Middle East and North Africa     2 Obligations 1971 2400000 14085000
14720 14720   Yemen (former P.D.R.) 3 Middle East and North Africa     2 Obligations 1972 100000 560211
14721 14721   Yemen (former P.D.R.) 3 Middle East and North Africa     2 Obligations 1973 101000 542414
14722 14722   Yemen (former P.D.R.) 3 Middle East and North Africa     2 Obligations 1974 1600000 8021027
14723 14723   Yemen (former P.D.R.) 3 Middle East and North Africa     2 Obligations 1975 1000 4543

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