./us_foreign_aid_dac_sector

48 rows where International Sector Name = "Communications"

✎ 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
1030 1030 4 Infrastructure 220 Communications 2 Obligations 2001 8948960 14688711
1031 1031 4 Infrastructure 220 Communications 2 Obligations 2002 28479224 46021434
1032 1032 4 Infrastructure 220 Communications 2 Obligations 2003 25488383 40412608
1033 1033 4 Infrastructure 220 Communications 2 Obligations 2004 154641394 239344183
1034 1034 4 Infrastructure 220 Communications 2 Obligations 2005 125428465 188397351
1035 1035 4 Infrastructure 220 Communications 2 Obligations 2006 70542935 102623959
1036 1036 4 Infrastructure 220 Communications 2 Obligations 2007 23989189 33963813
1037 1037 4 Infrastructure 220 Communications 2 Obligations 2008 5622186 7797985
1038 1038 4 Infrastructure 220 Communications 2 Obligations 2009 30572341 41974643
1039 1039 4 Infrastructure 220 Communications 2 Obligations 2010 17256979 23489740
1040 1040 4 Infrastructure 220 Communications 2 Obligations 2011 9575364 12777273
1041 1041 4 Infrastructure 220 Communications 2 Obligations 2012 17111186 22426049
1042 1042 4 Infrastructure 220 Communications 2 Obligations 2013 11862740 15270323
1043 1043 4 Infrastructure 220 Communications 2 Obligations 2014 9731676 12302670
1044 1044 4 Infrastructure 220 Communications 2 Obligations 2015 6135874 7677389
1045 1045 4 Infrastructure 220 Communications 2 Obligations 2016 10762431 13359465
1046 1046 4 Infrastructure 220 Communications 2 Obligations 2017 1883073 2298666
1047 1047 4 Infrastructure 220 Communications 2 Obligations 2018 2516862 3005609
1048 1048 4 Infrastructure 220 Communications 2 Obligations 2019 24966717 29273721
1049 1049 4 Infrastructure 220 Communications 2 Obligations 2020 13598498 15738774
1050 1050 4 Infrastructure 220 Communications 2 Obligations 2021 39643423 44356303
1051 1051 4 Infrastructure 220 Communications 2 Obligations 2022 21579152 22566324
1052 1052 4 Infrastructure 220 Communications 2 Obligations 2023 61071469 61071469
1053 1053 4 Infrastructure 220 Communications 2 Obligations 2024 156574974 152502246
1054 1054 4 Infrastructure 220 Communications 3 Disbursements 2001 39233956 64398127
1055 1055 4 Infrastructure 220 Communications 3 Disbursements 2002 53293553 86120521
1056 1056 4 Infrastructure 220 Communications 3 Disbursements 2003 29628409 46976743
1057 1057 4 Infrastructure 220 Communications 3 Disbursements 2004 35232414 54530509
1058 1058 4 Infrastructure 220 Communications 3 Disbursements 2005 149188899 224086241
1059 1059 4 Infrastructure 220 Communications 3 Disbursements 2006 72239277 105091740
1060 1060 4 Infrastructure 220 Communications 3 Disbursements 2007 49912980 70666639
1061 1061 4 Infrastructure 220 Communications 3 Disbursements 2008 32599589 45215679
1062 1062 4 Infrastructure 220 Communications 3 Disbursements 2009 17527100 24064025
1063 1063 4 Infrastructure 220 Communications 3 Disbursements 2010 32550585 44306974
1064 1064 4 Infrastructure 220 Communications 3 Disbursements 2011 13259021 17692692
1065 1065 4 Infrastructure 220 Communications 3 Disbursements 2012 12399615 16251024
1066 1066 4 Infrastructure 220 Communications 3 Disbursements 2013 10078408 12973440
1067 1067 4 Infrastructure 220 Communications 3 Disbursements 2014 9510979 12023669
1068 1068 4 Infrastructure 220 Communications 3 Disbursements 2015 8258182 10332884
1069 1069 4 Infrastructure 220 Communications 3 Disbursements 2016 -2425402 -3010671
1070 1070 4 Infrastructure 220 Communications 3 Disbursements 2017 10811042 13197041
1071 1071 4 Infrastructure 220 Communications 3 Disbursements 2018 11943959 14263348
1072 1072 4 Infrastructure 220 Communications 3 Disbursements 2019 4278430 5016503
1073 1073 4 Infrastructure 220 Communications 3 Disbursements 2020 15244776 17644163
1074 1074 4 Infrastructure 220 Communications 3 Disbursements 2021 12714432 14225937
1075 1075 4 Infrastructure 220 Communications 3 Disbursements 2022 31091859 32514210
1076 1076 4 Infrastructure 220 Communications 3 Disbursements 2023 21580822 21580822
1077 1077 4 Infrastructure 220 Communications 3 Disbursements 2024 50162042 48857263

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