./us_foreign_aid_country

766 rows where Income Group Acronym = "UMIC" and Region ID = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country Code, Country Name, Transaction Type ID, Transaction Type Name

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
3179 3179 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2006 8910000 12457380
3180 3180 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2007 15710000 21378433
3181 3181 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2008 21839000 29111732
3182 3182 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2009 26208000 34584236
3183 3183 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2010 27200000 35583794
3184 3184 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2011 17999000 23081610
3185 3185 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2012 14300000 18007990
3186 3186 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2013 13924000 17219379
3187 3187 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2014 12300000 14922341
3188 3188 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2015 12225000 14663246
3189 3189 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2016 25300000 30096627
3190 3190 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2017 23800000 27815629
3191 3191 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2018 25000000 28547786
3192 3192 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2019 25040000 28044177
3193 3193 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2020 25000000 27630771
3194 3194 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2021 17000000 18177888
3195 3195 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2022 12046328 12046328
3196 3196 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2023 12050965 11494191
3197 3197 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 1980 455000 1437047
3198 3198 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 1981 1702000 4895456
3199 3199 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 1982 106000 285072
3200 3200 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 1990 330250 683050
3201 3201 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 1991 412362 823442
3202 3202 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 1992 594380 1157931
3203 3203 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 1993 1883366 3584945
3204 3204 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 1994 2022322 3767204
3205 3205 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 1995 2416566 4408103
3206 3206 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 1996 3111950 5571660
3207 3207 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 1997 2637568 4639975
3208 3208 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 1998 2785954 4840327
3209 3209 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 1999 43362144 74416096
3210 3210 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2000 5926374 9963265
3211 3211 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2001 10816979 17754855
3212 3212 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2002 23443104 37883239
3213 3213 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2003 27226038 43167718
3214 3214 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2004 37453403 57968005
3215 3215 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2005 39512062 59348311
3216 3216 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2006 45488024 66174746
3217 3217 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2007 61328985 86829383
3218 3218 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2008 99567606 138100410
3219 3219 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2009 61321422 84191942
3220 3220 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2010 88028919 119822583
3221 3221 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2011 84669327 112981905
3222 3222 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2012 60504731 79297965
3223 3223 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2013 97696734 125760211
3224 3224 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2014 62813420 79407984
3225 3225 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2015 40021459 50076067
3226 3226 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2016 41334870 51309210
3227 3227 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2017 50661802 61842874
3228 3228 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2018 33694062 40237076
3229 3229 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2019 25981140 30463148
3230 3230 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2020 32173611 37237440
3231 3231 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2021 14031060 15699104
3232 3232 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2022 2240607 2343108
3233 3233 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2023 12814059 12814059
3234 3234 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 2 Obligations 2024 10720177 10441334
3235 3235 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2001 7974979 13090032
3236 3236 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2002 21964611 35494045
3237 3237 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2003 22526706 35716784
3238 3238 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2004 21182672 32785200
3239 3239 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2005 24388489 36632242
3240 3240 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2006 17739101 25806368
3241 3241 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2007 38409499 54380044
3242 3242 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2008 66725258 92548034
3243 3243 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2009 48025769 65937536
3244 3244 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2010 85975222 117027138
3245 3245 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2011 64645780 86262683
3246 3246 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2012 49624697 65038514
3247 3247 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2013 52075034 67033621
3248 3248 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2014 47211393 59684080
3249 3249 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2015 30723469 38442124
3250 3250 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2016 45527247 56513238
3251 3251 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2017 38469067 46959204
3252 3252 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2018 35989487 42978257
3253 3253 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2019 24117568 28278090
3254 3254 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2020 24394316 28233757
3255 3255 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2021 13688595 15315920
3256 3256 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2022 10559702 11042767
3257 3257 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2023 9732867 9732867
3258 3258 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 3 Disbursements 2024 14577073 14197900
3259 3259 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 18 President's Budget Requests 2008 9290000 12383717
3260 3260 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 18 President's Budget Requests 2009 7000000 9237242
3261 3261 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 18 President's Budget Requests 2010 13158000 17213661
3262 3262 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 18 President's Budget Requests 2011 12850000 16478620
3263 3263 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 18 President's Budget Requests 2012 12850000 16182005
3264 3264 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 18 President's Budget Requests 2013 7300000 9027683
3265 3265 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 18 President's Budget Requests 2014 7698000 9339202
3266 3266 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 18 President's Budget Requests 2015 6825000 8186228
3267 3267 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 18 President's Budget Requests 2016 6800000 8089212
3268 3268 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 18 President's Budget Requests 2017 6800000 7947323
3269 3269 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 18 President's Budget Requests 2018 1500000 1712867
3270 3270 CHN China (P.R.C.) 1 East Asia and Oceania UMIC Upper Middle Income Country 18 President's Budget Requests 2023 40000 38152
6623 6623 FJI Fiji 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2006 729000 1019241
6624 6624 FJI Fiji 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2011 43000 55142
6625 6625 FJI Fiji 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2015 213000 255482
6626 6626 FJI Fiji 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2016 186000 221264
6627 6627 FJI Fiji 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2017 189000 220889
6628 6628 FJI Fiji 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2018 200000 228382
6629 6629 FJI Fiji 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2019 196000 219515
6630 6630 FJI Fiji 1 East Asia and Oceania UMIC Upper Middle Income Country 1 Appropriated and Planned 2020 200000 221046

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