./us_foreign_aid_country

139 rows where Country Code = "MEX"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
12221 12221 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2006 66965000 93626095
12222 12222 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2007 65382000 88972935
12223 12223 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2008 53854000 71788232
12224 12224 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2009 432779000 571097763
12225 12225 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2010 757597000 991109391
12226 12226 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2011 262805000 337016636
12227 12227 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2012 413144000 520272239
12228 12228 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2013 265064000 327796420
12229 12229 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2014 206901435 251012502
12230 12230 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2015 164206978 196957659
12231 12231 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2016 160159063 190523623
12232 12232 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2017 138569057 161948968
12233 12233 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2018 151263000 172728958
12234 12234 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2019 162410000 181895155
12235 12235 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2020 157910000 174527000
12236 12236 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2021 158606000 169595429
12237 12237 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2022 130947328 130947328
12238 12238 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 1 Appropriated and Planned 2023 104690663 99853784
12239 12239 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1946 1200000 15054882
12240 12240 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1947 11300000 127839759
12241 12241 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1948 30100000 311118290
12242 12242 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1949 17800000 177956265
12243 12243 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1950 20000000 202774087
12244 12244 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1951 8200000 78878960
12245 12245 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1952 5300000 49012954
12246 12246 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1953 1600000 14532143
12247 12247 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1954 6200000 55649558
12248 12248 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1955 2200000 19602482
12249 12249 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1956 1100000 9557081
12250 12250 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1957 1500000 12558642
12251 12251 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1958 19301000 156862388
12252 12252 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1959 2400000 19211016
12253 12253 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1960 4770000 37663253
12254 12254 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1961 5069000 39487736
12255 12255 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1962 37123000 286266873
12256 12256 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1963 23700000 180590449
12257 12257 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1964 52752000 397250873
12258 12258 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1965 36584000 270819216
12259 12259 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1966 551000 3991725
12260 12260 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1967 383000 2693135
12261 12261 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1968 308000 2092241
12262 12262 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1969 1687000 10959664
12263 12263 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1970 1089000 6717243
12264 12264 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1971 4480000 26292000
12265 12265 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1972 2506000 14038891
12266 12266 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1973 12000 64445
12267 12267 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1974 431000 2160664
12268 12268 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1975 210000 954026
12269 12269 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1976 700000 2973173
12270 12270 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1976tq 2000 8248
12271 12271 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1977 15887000 62924273
12272 12272 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1978 20629000 76563759
12273 12273 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1979 13606000 46719674
12274 12274 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1980 7568000 23902349
12275 12275 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1981 9966000 28665166
12276 12276 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1982 8791000 23642154
12277 12277 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1983 8304000 21398972
12278 12278 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1984 8533000 21227294
12279 12279 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1985 11367000 27362842
12280 12280 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1986 12101000 28489278
12281 12281 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1987 17729000 40825864
12282 12282 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1988 18480000 41217862
12283 12283 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1989 70065000 150207842
12284 12284 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1990 53235506 110106036
12285 12285 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1991 58648000 117113715
12286 12286 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1992 60479458 117822017
12287 12287 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1993 34762900 66170388
12288 12288 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1994 13605690 25344827
12289 12289 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1995 11683683 21312419
12290 12290 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1996 28019651 50166598
12291 12291 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1997 58844451 103518405
12292 12292 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1998 49663857 86286181
12293 12293 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 1999 41697691 71559640
12294 12294 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2000 43866569 73747310
12295 12295 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2001 54802632 89952372
12296 12296 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2002 89229585 144191895
12297 12297 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2003 64371569 102063100
12298 12298 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2004 96879654 149944213
12299 12299 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2005 104241618 156574070
12300 12300 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2006 184918083 269013824
12301 12301 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2007 92815389 131407730
12302 12302 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2008 96403707 133712072
12303 12303 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2009 500569620 687262772
12304 12304 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2010 718087933 977441947
12305 12305 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2011 427409456 570330909
12306 12306 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2012 214337850 280912825
12307 12307 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2013 419094764 539480106
12308 12308 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2014 332284931 420070639
12309 12309 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2015 584785194 731700782
12310 12310 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2016 87681432 108839439
12311 12311 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2017 296265815 361651687
12312 12312 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2018 235941450 281758691
12313 12313 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2019 442886694 519289004
12314 12314 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2020 275876659 319297084
12315 12315 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2021 176186323 197131662
12316 12316 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2022 234607843 245340348
12317 12317 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2023 232214023 232214023
12318 12318 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 2 Obligations 2024 110418145 107546025
12319 12319 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 3 Disbursements 2001 44682690 73341619
12320 12320 MEX Mexico 6 Western Hemisphere UMIC Upper Middle Income Country 3 Disbursements 2002 83051277 134207957

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