home / 2025-02-03_foreign-assistance

./us_foreign_aid_country

12 rows where Country Code = "MAC"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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
11685 11685 MAC China (Macau, S.A.R., P.R.C.) 1 East Asia and Oceania HIC High Income Country 2 Obligations 2004 360 557
11686 11686 MAC China (Macau, S.A.R., P.R.C.) 1 East Asia and Oceania HIC High Income Country 2 Obligations 2008 11800 16367
11687 11687 MAC China (Macau, S.A.R., P.R.C.) 1 East Asia and Oceania HIC High Income Country 2 Obligations 2010 7400 10073
11688 11688 MAC China (Macau, S.A.R., P.R.C.) 1 East Asia and Oceania HIC High Income Country 2 Obligations 2012 23000 30144
11689 11689 MAC China (Macau, S.A.R., P.R.C.) 1 East Asia and Oceania HIC High Income Country 2 Obligations 2013 188142 242186
11690 11690 MAC China (Macau, S.A.R., P.R.C.) 1 East Asia and Oceania HIC High Income Country 2 Obligations 2014 39731 50227
11691 11691 MAC China (Macau, S.A.R., P.R.C.) 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2004 360 557
11692 11692 MAC China (Macau, S.A.R., P.R.C.) 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2008 11800 16367
11693 11693 MAC China (Macau, S.A.R., P.R.C.) 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2010 7400 10073
11694 11694 MAC China (Macau, S.A.R., P.R.C.) 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2012 22500 29489
11695 11695 MAC China (Macau, S.A.R., P.R.C.) 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2013 188142 242186
11696 11696 MAC China (Macau, S.A.R., P.R.C.) 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2014 37515 47427

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 6782.305ms