./us_foreign_aid_country
18 rows where Country Name = "Indonesia", Region ID = 1 and Transaction Type ID = 1
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8698 | 8698 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2006 | 157168000 | 219742042 |
| 8699 | 8699 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2007 | 158686000 | 215942599 |
| 8700 | 8700 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2008 | 186590000 | 248727415 |
| 8701 | 8701 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2009 | 263097000 | 347184378 |
| 8702 | 8702 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2010 | 220789000 | 288842287 |
| 8703 | 8703 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2011 | 207208000 | 265719994 |
| 8704 | 8704 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2012 | 179212000 | 225681673 |
| 8705 | 8705 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2013 | 166955000 | 206468063 |
| 8706 | 8706 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2014 | 138402849 | 167910120 |
| 8707 | 8707 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2015 | 136971000 | 164289533 |
| 8708 | 8708 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2016 | 129075000 | 153546332 |
| 8709 | 8709 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2017 | 133126000 | 155587538 |
| 8710 | 8710 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2018 | 131195000 | 149813080 |
| 8711 | 8711 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2019 | 129097000 | 144585424 |
| 8712 | 8712 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2020 | 128275000 | 141773482 |
| 8713 | 8713 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2021 | 139130000 | 148769981 |
| 8714 | 8714 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2022 | 160665253 | 160665253 |
| 8715 | 8715 | IDN | Indonesia | 1 | East Asia and Oceania | LMIC | Lower Middle Income Country | 1 | Appropriated and Planned | 2023 | 152852779 | 145790730 |
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 );