./us_foreign_aid_dac_sector

17 rows where International Sector Name = "Basic Education" 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
144 144 1 Education 112 Basic Education 18 President's Budget Requests 2008 535298000 713560686
145 145 1 Education 112 Basic Education 18 President's Budget Requests 2009 648889000 856277815
146 146 1 Education 112 Basic Education 18 President's Budget Requests 2010 1001332000 1309970277
147 147 1 Education 112 Basic Education 18 President's Budget Requests 2011 850043000 1090080597
148 148 1 Education 112 Basic Education 18 President's Budget Requests 2012 749647000 944030469
149 149 1 Education 112 Basic Education 18 President's Budget Requests 2013 573081000 708711482
150 150 1 Education 112 Basic Education 18 President's Budget Requests 2014 501355000 608243114
151 151 1 Education 112 Basic Education 18 President's Budget Requests 2015 534291000 640854040
152 152 1 Education 112 Basic Education 18 President's Budget Requests 2016 600484000 714329773
153 153 1 Education 112 Basic Education 18 President's Budget Requests 2017 772782000 903168794
154 154 1 Education 112 Basic Education 18 President's Budget Requests 2018 377901000 431529493
155 155 1 Education 112 Basic Education 18 President's Budget Requests 2019 394530000 441863773
156 156 1 Education 112 Basic Education 18 President's Budget Requests 2020 299386000 330890631
157 157 1 Education 112 Basic Education 18 President's Budget Requests 2021 301043000 321901546
158 158 1 Education 112 Basic Education 18 President's Budget Requests 2022 912560000 912560000
159 159 1 Education 112 Basic Education 18 President's Budget Requests 2023 923560000 880890036
160 160 1 Education 112 Basic Education 18 President's Budget Requests 2024 883886000 823586863

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