./us_foreign_aid_dac_sector

4 rows where Fiscal Year = 2001, International Category Name = "Education" 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
16 16 1 Education 111 Education, Level Unspecified 2 Obligations 2001 18340146 30103288
96 96 1 Education 112 Basic Education 2 Obligations 2001 87335133 143350814
161 161 1 Education 113 Upper Secondary Education 2 Obligations 2001 24815 40731
227 227 1 Education 114 Post-Secondary Education 2 Obligations 2001 20200066 33156138

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