./us_foreign_aid_dac_sector

3 rows where Fiscal Year = 2001, International Category Name = "Infrastructure" and Transaction Type ID = 2

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ International Category ID International Category Name International Sector Code International Sector Name Transaction Type ID Transaction Type Name Fiscal Year current_amount constant_amount
965 965 4 Infrastructure 210 Transport and Storage 2 Obligations 2001 15155265 24875658
1030 1030 4 Infrastructure 220 Communications 2 Obligations 2001 8948960 14688711
1083 1083 4 Infrastructure 230 Energy 2 Obligations 2001 56929114 93442738

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "./us_foreign_aid_dac_sector" (
"International Category ID" INTEGER,
  "International Category Name" TEXT,
  "International Sector Code" INTEGER,
  "International Sector Name" TEXT,
  "Transaction Type ID" INTEGER,
  "Transaction Type Name" TEXT,
  "Fiscal Year" INTEGER,
  "current_amount" INTEGER,
  "constant_amount" INTEGER
);