./us_foreign_aid_dac_sector

6 rows where International Sector Name = "Energy" and Transaction Type ID = 18

✎ 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
1131 1131 4 Infrastructure 230 Energy 18 President's Budget Requests 2015 181602000 217822077
1132 1132 4 Infrastructure 230 Energy 18 President's Budget Requests 2016 289000000 343791516
1133 1133 4 Infrastructure 230 Energy 18 President's Budget Requests 2017 338631000 395766146
1134 1134 4 Infrastructure 230 Energy 18 President's Budget Requests 2021 2000000 2138575
1135 1135 4 Infrastructure 230 Energy 18 President's Budget Requests 2023 171926574 163983287
1136 1136 4 Infrastructure 230 Energy 18 President's Budget Requests 2024 238700339 222416087

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