./us_foreign_aid_country

75 rows where Country Code = "JPN"

✎ 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
9758 9758 JPN Japan 1 East Asia and Oceania HIC High Income Country 1 Appropriated and Planned 2022 23951 23951
9759 9759 JPN Japan 1 East Asia and Oceania HIC High Income Country 1 Appropriated and Planned 2023 72483 69134
9760 9760 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1946 106700000 1338629907
9761 9761 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1947 389300000 4404249398
9762 9762 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1948 483700000 4999598560
9763 9763 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1949 501500000 5013767813
9764 9764 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1950 365300000 3703668687
9765 9765 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1951 290300000 2792507565
9766 9766 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1952 63600000 588155455
9767 9767 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1953 91900000 834689955
9768 9768 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1954 83095000 745838725
9769 9769 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1955 214200000 1908568904
9770 9770 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1956 261900000 2275454306
9771 9771 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1957 178780000 1496822675
9772 9772 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1958 98668000 801890996
9773 9773 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1959 48154000 385453035
9774 9774 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1960 143219000 1130837215
9775 9775 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1961 68331000 532301542
9776 9776 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1962 167156000 1288991341
9777 9777 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1963 48120000 366667191
9778 9778 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1964 8129000 61215734
9779 9779 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1965 18165000 134469470
9780 9780 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1966 1672000 12112821
9781 9781 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1967 433000 3044718
9782 9782 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 1972 320000000 1792675539
9783 9783 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2001 316102 518844
9784 9784 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2002 360839 583103
9785 9785 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2003 355752 564054
9786 9786 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2004 326487 505317
9787 9787 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2005 964270 1448365
9788 9788 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2006 258593 376195
9789 9789 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2007 405836 574584
9790 9790 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2008 4228763 5865305
9791 9791 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2009 586327 805004
9792 9792 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2010 1155165 1572375
9793 9793 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2011 93565406 124852741
9794 9794 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2012 585838 767804
9795 9795 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2013 -633069 -814918
9796 9796 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2014 2443191 3088652
9797 9797 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2015 23480 29379
9798 9798 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2016 -2296558 -2850730
9799 9799 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2017 141632 172891
9800 9800 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2018 203067 242500
9801 9801 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2019 338011 396321
9802 9802 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2020 496280 574391
9803 9803 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2021 199552 223276
9804 9804 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2022 1454526 1521067
9805 9805 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2023 1679269 1679269
9806 9806 JPN Japan 1 East Asia and Oceania HIC High Income Country 2 Obligations 2024 1152668 1122685
9807 9807 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2001 395696 649493
9808 9808 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2002 481777 778533
9809 9809 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2003 364309 577624
9810 9810 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2004 317607 491574
9811 9811 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2005 924262 1388270
9812 9812 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2006 256147 372637
9813 9813 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2007 384738 544709
9814 9814 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2008 4128704 5726518
9815 9815 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2009 660842 907315
9816 9816 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2010 1122787 1528300
9817 9817 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2011 57068811 76152059
9818 9818 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2012 27589001 36158358
9819 9819 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2013 4405816 5671392
9820 9820 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2014 3140014 3969568
9821 9821 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2015 629745 787956
9822 9822 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2016 103284 128207
9823 9823 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2017 69595 84955
9824 9824 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2018 198067 236529
9825 9825 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2019 29900 35058
9826 9826 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2020 233649 270424
9827 9827 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2021 163864 183347
9828 9828 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2022 905043 946443
9829 9829 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2023 1697208 1697208
9830 9830 JPN Japan 1 East Asia and Oceania HIC High Income Country 3 Disbursements 2024 1632555 1590090
9831 9831 JPN Japan 1 East Asia and Oceania HIC High Income Country 18 President's Budget Requests 2023 52500 50074
9832 9832 JPN Japan 1 East Asia and Oceania HIC High Income Country 18 President's Budget Requests 2024 64200 59820

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