./us_foreign_aid_country

27 rows where Country Code = "NCN"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type ID, Transaction Type Name, Fiscal Year, current_amount

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
14018 14018 NCN North and Central America Region 6 Western Hemisphere     1 Appropriated and Planned 2022 12911622 12911622
14019 14019 NCN North and Central America Region 6 Western Hemisphere     1 Appropriated and Planned 2023 17814532 16991472
14020 14020 NCN North and Central America Region 6 Western Hemisphere     2 Obligations 2013 200000 257450
14021 14021 NCN North and Central America Region 6 Western Hemisphere     2 Obligations 2014 400000 505676
14022 14022 NCN North and Central America Region 6 Western Hemisphere     2 Obligations 2015 500000 625615
14023 14023 NCN North and Central America Region 6 Western Hemisphere     2 Obligations 2016 301291 373994
14024 14024 NCN North and Central America Region 6 Western Hemisphere     2 Obligations 2017 6470811 7898917
14025 14025 NCN North and Central America Region 6 Western Hemisphere     2 Obligations 2018 352444 420885
14026 14026 NCN North and Central America Region 6 Western Hemisphere     2 Obligations 2019 544770 638748
14027 14027 NCN North and Central America Region 6 Western Hemisphere     2 Obligations 2020 1830807 2118957
14028 14028 NCN North and Central America Region 6 Western Hemisphere     2 Obligations 2021 31711635 35481570
14029 14029 NCN North and Central America Region 6 Western Hemisphere     2 Obligations 2022 48022110 50218955
14030 14030 NCN North and Central America Region 6 Western Hemisphere     2 Obligations 2023 8436523 8436523
14031 14031 NCN North and Central America Region 6 Western Hemisphere     2 Obligations 2024 681414 663690
14032 14032 NCN North and Central America Region 6 Western Hemisphere     3 Disbursements 2014 100000 126419
14033 14033 NCN North and Central America Region 6 Western Hemisphere     3 Disbursements 2015 100000 125123
14034 14034 NCN North and Central America Region 6 Western Hemisphere     3 Disbursements 2016 342271 424862
14035 14035 NCN North and Central America Region 6 Western Hemisphere     3 Disbursements 2017 5792013 7070305
14036 14036 NCN North and Central America Region 6 Western Hemisphere     3 Disbursements 2018 -268744 -320932
14037 14037 NCN North and Central America Region 6 Western Hemisphere     3 Disbursements 2019 -113548 -133139
14038 14038 NCN North and Central America Region 6 Western Hemisphere     3 Disbursements 2020 1378289 1595220
14039 14039 NCN North and Central America Region 6 Western Hemisphere     3 Disbursements 2021 16378922 18326077
14040 14040 NCN North and Central America Region 6 Western Hemisphere     3 Disbursements 2022 45094859 47157791
14041 14041 NCN North and Central America Region 6 Western Hemisphere     3 Disbursements 2023 12913061 12913061
14042 14042 NCN North and Central America Region 6 Western Hemisphere     3 Disbursements 2024 2958735 2881774
14043 14043 NCN North and Central America Region 6 Western Hemisphere     18 President's Budget Requests 2023 13832097 13193031
14044 14044 NCN North and Central America Region 6 Western Hemisphere     18 President's Budget Requests 2024 17580615 16381257

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