home / 2025-02-03_foreign-assistance

./us_foreign_aid_funding

4 rows where Fiscal Year = 2013 and Funding Agency Acronym = "DHS"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: current_amount

Link rowid ▼ Funding Agency ID Funding Agency Acronym Funding Agency Name Funding Account ID Funding Account Name Country Code Country Name Transaction Type ID Transaction Type Name Fiscal Year current_amount constant_amount
107787 107787 14 DHS Department of Homeland Security 70x0110 Department of Homeland Security, Office of the Secretary and Executive Management CRI Costa Rica 2 Obligations 2013 65033 83714
107789 107789 14 DHS Department of Homeland Security 70x0110 Department of Homeland Security, Office of the Secretary and Executive Management CRI Costa Rica 3 Disbursements 2013 65033 83714
107823 107823 14 DHS Department of Homeland Security 70x0530 Department of Homeland Security, Customs and Border Protection, Border and Transportation Security GEO Georgia 2 Obligations 2013 4677541 6021169
107829 107829 14 DHS Department of Homeland Security 70x0530 Department of Homeland Security, Customs and Border Protection, Border and Transportation Security GEO Georgia 3 Disbursements 2013 4677541 6021169

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "./us_foreign_aid_funding" (
"Funding Agency ID" INTEGER,
  "Funding Agency Acronym" TEXT,
  "Funding Agency Name" TEXT,
  "Funding Account ID" TEXT,
  "Funding Account 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
);
Powered by Datasette · Queries took 2422.153ms