./us_foreign_aid_country

85 rows where Country Code = "ESP"

✎ 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
6122 6122 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1951 17200000 165453428
6123 6123 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1952 35600000 329219091
6124 6124 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1953 9800000 89009375
6125 6125 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1954 223699000 2007863010
6126 6126 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1955 125991000 1122607399
6127 6127 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1956 304300000 2643836369
6128 6128 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1957 191869000 1606409385
6129 6129 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1958 147480000 1198594114
6130 6130 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1959 154629000 1237741772
6131 6131 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1960 145368000 1147805418
6132 6132 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1961 110480000 860644134
6133 6133 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1962 70676000 545004380
6134 6134 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1963 41228000 314151183
6135 6135 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1964 40930000 308224868
6136 6136 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1965 14626000 108271427
6137 6137 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1966 31015000 224688490
6138 6138 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1967 22239000 156377576
6139 6139 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1968 30517000 207301625
6140 6140 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1969 2172000 14110486
6141 6141 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1970 40978000 252763237
6142 6142 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1971 25023000 146853732
6143 6143 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1972 80135000 448925170
6144 6144 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1973 60763000 326323776
6145 6145 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1974 28627000 143511207
6146 6146 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1975 5484000 24913728
6147 6147 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1976 602000 2556929
6148 6148 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1976tq 1000 4124
6149 6149 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1977 143595000 568742430
6150 6150 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1978 141747000 526088667
6151 6151 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1979 171640000 589369756
6152 6152 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1980 133017000 420113459
6153 6153 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1981 132564000 381293297
6154 6154 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1982 149559000 402217827
6155 6155 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1983 414726000 1068727102
6156 6156 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1984 414975000 1032321139
6157 6157 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1985 414867000 998675108
6158 6158 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1986 396560000 933617728
6159 6159 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1987 112825000 259810370
6160 6160 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1988 5633000 12563865
6161 6161 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1989 1887000 4045418
6162 6162 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1990 1955000 4043491
6163 6163 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1991 1507000 3009316
6164 6164 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1992 928000 1807867
6165 6165 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1993 240000 456835
6166 6166 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1994 49000 91278
6167 6167 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1995 52000 94854
6168 6168 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 1996 49000 87730
6169 6169 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2004 1000 1548
6170 6170 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2006 12000 17457
6171 6171 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2007 2557649 3621111
6172 6172 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2008 10000 13870
6173 6173 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2009 2456700 3372954
6174 6174 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2010 16370809 22283505
6175 6175 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2011 17863819 23837301
6176 6176 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2012 1382321 1811680
6177 6177 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2013 1519318 1955743
6178 6178 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2014 3147730 3979323
6179 6179 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2015 220292 275637
6180 6180 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2016 80772 100263
6181 6181 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2017 237067 289387
6182 6182 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2018 204907 244697
6183 6183 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2019 149298 175054
6184 6184 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2020 100218 115991
6185 6185 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2021 16631 18608
6186 6186 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2022 309169 323312
6187 6187 ESP Spain 2 Europe and Eurasia HIC High Income Country 2 Obligations 2023 132682 132682
6188 6188 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2004 1000 1548
6189 6189 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2006 12000 17457
6190 6190 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2007 3756000 5317732
6191 6191 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2008 10000 13870
6192 6192 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2009 1560788 2142902
6193 6193 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2010 7118777 9689887
6194 6194 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2011 14928349 19920240
6195 6195 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2012 2156853 2826788
6196 6196 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2013 1083433 1394650
6197 6197 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2014 2080186 2629745
6198 6198 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2015 160292 200563
6199 6199 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2016 114772 142467
6200 6200 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2017 -1690 -2064
6201 6201 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2018 455339 543760
6202 6202 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2019 -187884 -220296
6203 6203 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2020 -34671 -40127
6204 6204 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2021 843099 943328
6205 6205 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2022 3479536 3638712
6206 6206 ESP Spain 2 Europe and Eurasia HIC High Income Country 3 Disbursements 2023 799838 799838

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