./us_foreign_aid_dac_sector

17 rows where International Sector Name = "Post-Secondary Education" and Transaction Type Name = "President's Budget Requests"

✎ 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
275 275 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2008 142608000 190098715
276 276 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2009 135476000 178774941
277 277 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2010 188044000 246004375
278 278 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2011 248837000 319104313
279 279 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2012 233499000 294045291
280 280 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2013 174887000 216277322
281 281 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2014 221906000 269216017
282 282 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2015 249592000 299372519
283 283 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2016 255649000 304117501
284 284 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2017 226352000 264542994
285 285 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2018 131150000 149761691
286 286 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2019 117419000 131506358
287 287 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2020 107319000 118612265
288 288 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2021 129489000 138460983
289 289 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2022 206168000 206168000
290 290 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2023 237766000 226780826
291 291 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2024 231566000 215768459

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