./us_foreign_aid_dac_sector

48 rows where International Sector Name = "Industry"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type ID, Transaction Type Name, Fiscal Year

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
1269 1269 5 Economic Growth 321 Industry 2 Obligations 2001 98758545 162101049
1270 1270 5 Economic Growth 321 Industry 2 Obligations 2002 206120190 333083042
1271 1271 5 Economic Growth 321 Industry 2 Obligations 2003 158350651 251069813
1272 1272 5 Economic Growth 321 Industry 2 Obligations 2004 777429986 1203256972
1273 1273 5 Economic Growth 321 Industry 2 Obligations 2005 78842618 118424004
1274 1274 5 Economic Growth 321 Industry 2 Obligations 2006 54502145 79288249
1275 1275 5 Economic Growth 321 Industry 2 Obligations 2007 68269543 96655803
1276 1276 5 Economic Growth 321 Industry 2 Obligations 2008 91078094 126325442
1277 1277 5 Economic Growth 321 Industry 2 Obligations 2009 76765522 105396098
1278 1278 5 Economic Growth 321 Industry 2 Obligations 2010 80083839 109007973
1279 1279 5 Economic Growth 321 Industry 2 Obligations 2011 131578018 175576401
1280 1280 5 Economic Growth 321 Industry 2 Obligations 2012 67488538 88451002
1281 1281 5 Economic Growth 321 Industry 2 Obligations 2013 81464215 104864880
1282 1282 5 Economic Growth 321 Industry 2 Obligations 2014 103906706 131357614
1283 1283 5 Economic Growth 321 Industry 2 Obligations 2015 103605600 129634435
1284 1284 5 Economic Growth 321 Industry 2 Obligations 2016 96595705 119904807
1285 1285 5 Economic Growth 321 Industry 2 Obligations 2017 48847378 59627998
1286 1286 5 Economic Growth 321 Industry 2 Obligations 2018 9521854 11370899
1287 1287 5 Economic Growth 321 Industry 2 Obligations 2019 8495956 9961600
1288 1288 5 Economic Growth 321 Industry 2 Obligations 2020 4498808 5206884
1289 1289 5 Economic Growth 321 Industry 2 Obligations 2021 7363837 8239269
1290 1290 5 Economic Growth 321 Industry 2 Obligations 2022 7293254 7626889
1291 1291 5 Economic Growth 321 Industry 2 Obligations 2023 3720055 3720055
1292 1292 5 Economic Growth 321 Industry 2 Obligations 2024 4445456 4329822
1293 1293 5 Economic Growth 321 Industry 3 Disbursements 2001 74391231 122104830
1294 1294 5 Economic Growth 321 Industry 3 Disbursements 2002 108738922 175718289
1295 1295 5 Economic Growth 321 Industry 3 Disbursements 2003 155729040 246913146
1296 1296 5 Economic Growth 321 Industry 3 Disbursements 2004 199671735 309039298
1297 1297 5 Economic Growth 321 Industry 3 Disbursements 2005 119804832 179950476
1298 1298 5 Economic Growth 321 Industry 3 Disbursements 2006 111433765 162110821
1299 1299 5 Economic Growth 321 Industry 3 Disbursements 2007 57621232 81579936
1300 1300 5 Economic Growth 321 Industry 3 Disbursements 2008 64240030 89101015
1301 1301 5 Economic Growth 321 Industry 3 Disbursements 2009 108795266 149371696
1302 1302 5 Economic Growth 321 Industry 3 Disbursements 2010 102794134 139920582
1303 1303 5 Economic Growth 321 Industry 3 Disbursements 2011 96292264 128491438
1304 1304 5 Economic Growth 321 Industry 3 Disbursements 2012 73639906 96513039
1305 1305 5 Economic Growth 321 Industry 3 Disbursements 2013 79894196 102843849
1306 1306 5 Economic Growth 321 Industry 3 Disbursements 2014 81836348 103456503
1307 1307 5 Economic Growth 321 Industry 3 Disbursements 2015 95445179 119423878
1308 1308 5 Economic Growth 321 Industry 3 Disbursements 2016 108119983 134209958
1309 1309 5 Economic Growth 321 Industry 3 Disbursements 2017 82888306 101181752
1310 1310 5 Economic Growth 321 Industry 3 Disbursements 2018 65855897 78644397
1311 1311 5 Economic Growth 321 Industry 3 Disbursements 2019 28934105 33925511
1312 1312 5 Economic Growth 321 Industry 3 Disbursements 2020 12800420 14815090
1313 1313 5 Economic Growth 321 Industry 3 Disbursements 2021 11000262 12307990
1314 1314 5 Economic Growth 321 Industry 3 Disbursements 2022 11389848 11910878
1315 1315 5 Economic Growth 321 Industry 3 Disbursements 2023 6601399 6601399
1316 1316 5 Economic Growth 321 Industry 3 Disbursements 2024 3957334 3854405

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