./us_foreign_aid_country

2,742 rows where Transaction Type Name = "Appropriated and Planned"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Region Name, Income Group Acronym, Income Group Name, Fiscal Year

Region ID 7 ✖

  • 5 848
  • 2 531
  • 6 478
  • 1 347
  • 3 287
  • 4 225
  • 7 26

Transaction Type Name 1 ✖

  • Appropriated and Planned · 2,742 ✖
Link rowid ▼ Country Code Country Name Region ID Region Name Income Group Acronym Income Group Name Transaction Type ID Transaction Type Name Fiscal Year current_amount constant_amount
19 19 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2006 1010780000 1413206677
20 20 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2007 1827785000 2487280793
21 21 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2008 1118106000 1490452938
22 22 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2009 2713193000 3580345749
23 23 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2010 4144868000 5422431199
24 24 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2011 13781695000 17673409892
25 25 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2012 3401639000 4283683995
26 26 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2013 7718829000 9545636217
27 27 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2014 6070245256 7364412190
28 28 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2015 10978130000 13167691312
29 29 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2016 4541138000 5402092464
30 30 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2017 852064000 995827560
31 31 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2018 701627000 801195939
32 32 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2019 476533000 533705093
33 33 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2020 332300000 367268202
34 34 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2021 61324000 65572993
35 35 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2022 153823000 153823000
36 36 AFG Afghanistan 4 South and Central Asia LIC Low Income Country 1 Appropriated and Planned 2023 118000000 112548208
149 149 AFR Africa Region 7 World     1 Appropriated and Planned 2021 33000000 35286491
150 150 AFR Africa Region 7 World     1 Appropriated and Planned 2022 48472000 48472000
151 151 AFR Africa Region 7 World     1 Appropriated and Planned 2023 70439000 67184604
155 155 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2006 32171000 44979394
156 156 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2007 42060000 57235960
157 157 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2008 42203000 56257266
158 158 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2009 55967000 73854388
159 159 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2010 84115000 110041573
160 160 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2011 60871000 78059931
161 161 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2012 59735000 75224286
162 162 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2013 53676000 66379442
163 163 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2014 54788000 66468717
164 164 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2015 55146000 66144735
165 165 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2016 51612000 61397120
166 166 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2017 43942000 51356067
167 167 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2018 42023000 47986546
168 168 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2019 33619000 37652442
169 169 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2020 45360000 50133270
170 170 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2021 38071000 40708848
171 171 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2022 42129000 42129000
172 172 AGO Angola 5 Sub-Saharan Africa LMIC Lower Middle Income Country 1 Appropriated and Planned 2023 57699000 55033212
273 273 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2006 30248000 42290781
274 274 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2007 26748000 36399132
275 275 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2008 24101000 32127013
276 276 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2009 23030000 30390527
277 277 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2010 29521000 38620190
278 278 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2011 27706000 35529700
279 279 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2012 22717000 28607519
280 280 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2013 21578000 26684842
281 281 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2014 32007321 38831231
282 282 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2015 15462000 18545859
283 283 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2016 15374000 18288757
284 284 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2017 13977000 16335255
285 285 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2018 12747000 14555945
286 286 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2019 8979000 10056257
287 287 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2020 10190000 11262303
288 288 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2021 11332000 12117167
289 289 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2022 13202000 13202000
290 290 ALB Albania 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2023 11982000 11428413
432 432 ARE United Arab Emirates 3 Middle East and North Africa HIC High Income Country 1 Appropriated and Planned 2022 40048 40048
433 433 ARE United Arab Emirates 3 Middle East and North Africa HIC High Income Country 1 Appropriated and Planned 2023 336620 321068
480 480 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2006 1632000 2281756
481 481 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2007 1605000 2184111
482 482 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2008 1973000 2630041
483 483 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2009 1670000 2203742
484 484 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2010 1500000 1962341
485 485 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2011 1343000 1722241
486 486 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2012 1095000 1378933
487 487 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2013 765000 946052
488 488 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2014 589000 714574
489 489 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2015 2085000 2500847
490 490 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2016 579000 688773
491 491 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2017 624000 729284
492 492 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2018 2918000 3332098
493 493 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2019 3089000 3459603
494 494 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2020 3100000 3426215
495 495 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2021 715000 764541
496 496 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2022 750630 750630
497 497 ARG Argentina 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2023 853480 814048
608 608 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2006 74498000 104158244
609 609 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2007 63792000 86809236
610 610 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2008 62634000 83492109
611 611 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2009 52357000 69090611
612 612 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2010 45599000 59653877
613 613 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2011 60687000 77823970
614 614 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2012 61665000 77654738
615 615 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2013 52861000 65371556
616 616 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2014 58798100 71333765
617 617 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2015 16532000 19829268
618 618 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2016 20367000 24228381
619 619 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2017 25159000 29403925
620 620 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2018 26672000 30457062
621 621 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2019 30084000 33693331
622 622 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2020 30605000 33825589
623 623 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2021 30252000 32348086
624 624 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2022 44342207 44342207
625 625 ARM Armenia 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2023 32806246 31290544
700 700 ASN Asia Region 7 World     1 Appropriated and Planned 2021 155072000 165816563
701 701 ASN Asia Region 7 World     1 Appropriated and Planned 2022 210821000 210821000
702 702 ASN Asia Region 7 World     1 Appropriated and Planned 2023 195863034 186813843
988 988 AZE Azerbaijan 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2006 46006000 64322589
989 989 AZE Azerbaijan 2 Europe and Eurasia UMIC Upper Middle Income Country 1 Appropriated and Planned 2007 39368000 53572642

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "./us_foreign_aid_country" (
"Country Code" TEXT,
  "Country Name" TEXT,
  "Region ID" INTEGER,
  "Region Name" TEXT,
  "Income Group Acronym" TEXT,
  "Income Group Name" TEXT,
  "Transaction Type ID" INTEGER,
  "Transaction Type Name" TEXT,
  "Fiscal Year" TEXT,
  "current_amount" INTEGER,
  "constant_amount" INTEGER
);