./us_foreign_aid_country

60 rows where Country Code = "CAN"

✎ 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
2909 2909 CAN Canada 6 Western Hemisphere HIC High Income Country 1 Appropriated and Planned 2022 20231 20231
2910 2910 CAN Canada 6 Western Hemisphere HIC High Income Country 1 Appropriated and Planned 2023 98623 94066
2911 2911 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 1951 2700000 25972340
2912 2912 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 1952 6000000 55486364
2913 2913 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 1953 7800000 70844197
2914 2914 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 1954 4900000 43981103
2915 2915 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 1961 9100000 70889407
2916 2916 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 1999 23000 39472
2917 2917 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2000 40000 67247
2918 2918 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2001 33000 54166
2919 2919 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2002 40000 64639
2920 2920 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2003 23716034 37602496
2921 2921 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2004 21229165 32857156
2922 2922 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2005 20993398 31532717
2923 2923 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2006 22759157 33109407
2924 2924 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2007 23837626 33749232
2925 2925 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2008 26832356 37216516
2926 2926 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2009 26253998 36045726
2927 2927 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2010 25749966 35050161
2928 2928 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2011 27367007 36518262
2929 2929 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2012 23269540 30497238
2930 2930 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2013 21223849 27320419
2931 2931 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2014 24797829 31349122
2932 2932 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2015 10007115 12521202
2933 2933 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2016 3390362 4208473
2934 2934 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2017 32004675 39068109
2935 2935 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2018 23585775 28165873
2936 2936 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2019 30931228 36267169
2937 2937 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2020 35113031 40639498
2938 2938 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2021 24574226 27495656
2939 2939 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2022 32000295 33464199
2940 2940 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2023 7358732 7358732
2941 2941 CAN Canada 6 Western Hemisphere HIC High Income Country 2 Obligations 2024 253850 247246
2942 2942 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2001 33000 54166
2943 2943 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2002 40000 64639
2944 2944 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2003 23716034 37602496
2945 2945 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2004 21226897 32853647
2946 2946 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2005 20980664 31513593
2947 2947 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2006 22768116 33122441
2948 2948 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2007 23840578 33753412
2949 2949 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2008 92968356 128947246
2950 2950 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2009 26262398 36057259
2951 2951 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2010 25685303 34962143
2952 2952 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2011 37285952 49754003
2953 2953 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2012 106635 139755
2954 2954 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2013 549855 707801
2955 2955 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2014 373189 471781
2956 2956 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2015 47022919 58836487
2957 2957 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2016 21053249 26133517
2958 2958 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2017 5817102 7100934
2959 2959 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2018 -24268891 -28981651
2960 2960 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2019 -14132337 -16570302
2961 2961 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2020 -1498106 -1733897
2962 2962 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2021 -10133316 -11337981
2963 2963 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2022 -21343173 -22319552
2964 2964 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2023 -18446323 -18446323
2965 2965 CAN Canada 6 Western Hemisphere HIC High Income Country 3 Disbursements 2024 253850 247246
2966 2966 CAN Canada 6 Western Hemisphere HIC High Income Country 18 President's Budget Requests 2018 400000 456765
2967 2967 CAN Canada 6 Western Hemisphere HIC High Income Country 18 President's Budget Requests 2023 139000 132578
2968 2968 CAN Canada 6 Western Hemisphere HIC High Income Country 18 President's Budget Requests 2024 203600 189710

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