home / 2025-02-03_foreign-assistance

./us_foreign_aid_country

3 rows where Fiscal Year = 2020, Income Group Name = "High Income Country" and current_amount = 400000

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Region ID, Region Name, Transaction Type ID, Transaction Type Name

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
1813 1813 BHR Bahrain 3 Middle East and North Africa HIC High Income Country 18 President's Budget Requests 2020 400000 442092
3174 3174 CHL Chile 6 Western Hemisphere HIC High Income Country 18 President's Budget Requests 2020 400000 442092
20596 20596 URY Uruguay 6 Western Hemisphere HIC High Income Country 1 Appropriated and Planned 2020 400000 442092

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
);
Powered by Datasette · Queries took 161.186ms