./us_foreign_aid_country
24 rows where Country Code = "WLD", Region Name = "World" and Transaction Type ID = 3
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21405 | 21405 | WLD | World | 7 | World | 3 | Disbursements | 2001 | 2717782174 | 4460934123 | ||
| 21406 | 21406 | WLD | World | 7 | World | 3 | Disbursements | 2002 | 3462035645 | 5594528587 | ||
| 21407 | 21407 | WLD | World | 7 | World | 3 | Disbursements | 2003 | 2784996537 | 4415697157 | ||
| 21408 | 21408 | WLD | World | 7 | World | 3 | Disbursements | 2004 | 5647078981 | 8740191769 | ||
| 21409 | 21409 | WLD | World | 7 | World | 3 | Disbursements | 2005 | 5455677082 | 8194592061 | ||
| 21410 | 21410 | WLD | World | 7 | World | 3 | Disbursements | 2006 | 4338441455 | 6311447291 | ||
| 21411 | 21411 | WLD | World | 7 | World | 3 | Disbursements | 2007 | 4875297563 | 6902430593 | ||
| 21412 | 21412 | WLD | World | 7 | World | 3 | Disbursements | 2008 | 6643339321 | 9214321356 | ||
| 21413 | 21413 | WLD | World | 7 | World | 3 | Disbursements | 2009 | 7133384287 | 9793861320 | ||
| 21414 | 21414 | WLD | World | 7 | World | 3 | Disbursements | 2010 | 6418057343 | 8736086610 | ||
| 21415 | 21415 | WLD | World | 7 | World | 3 | Disbursements | 2011 | 7660143160 | 10221618599 | ||
| 21416 | 21416 | WLD | World | 7 | World | 3 | Disbursements | 2012 | 9467424314 | 12408079010 | ||
| 21417 | 21417 | WLD | World | 7 | World | 3 | Disbursements | 2013 | 9756996971 | 12559702710 | ||
| 21418 | 21418 | WLD | World | 7 | World | 3 | Disbursements | 2014 | 9471872425 | 11974227989 | ||
| 21419 | 21419 | WLD | World | 7 | World | 3 | Disbursements | 2015 | 9191363550 | 11500509900 | ||
| 21420 | 21420 | WLD | World | 7 | World | 3 | Disbursements | 2016 | 10916951344 | 13551273536 | ||
| 21421 | 21421 | WLD | World | 7 | World | 3 | Disbursements | 2017 | 10356411727 | 12642071624 | ||
| 21422 | 21422 | WLD | World | 7 | World | 3 | Disbursements | 2018 | 10680873430 | 12754981536 | ||
| 21423 | 21423 | WLD | World | 7 | World | 3 | Disbursements | 2019 | 10824102328 | 12691366373 | ||
| 21424 | 21424 | WLD | World | 7 | World | 3 | Disbursements | 2020 | 11651134104 | 13484914409 | ||
| 21425 | 21425 | WLD | World | 7 | World | 3 | Disbursements | 2021 | 15672172097 | 17535307250 | ||
| 21426 | 21426 | WLD | World | 7 | World | 3 | Disbursements | 2022 | 18822629483 | 19683700490 | ||
| 21427 | 21427 | WLD | World | 7 | World | 3 | Disbursements | 2023 | 15562334047 | 15562334047 | ||
| 21428 | 21428 | WLD | World | 7 | World | 3 | Disbursements | 2024 | 11519464353 | 11219827724 |
Advanced export
JSON shape: default, array, newline-delimited
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 );