home / 2025-02-03_foreign-assistance

./us_foreign_aid_country

20 rows where Country Code = "ECN"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type ID, Transaction Type Name, Fiscal Year, current_amount, constant_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
5545 5545 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     2 Obligations 2012 102600 134468
5546 5546 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     2 Obligations 2015 1275000 1595318
5547 5547 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     2 Obligations 2016 35000 43446
5548 5548 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     2 Obligations 2017 92696 113154
5549 5549 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     2 Obligations 2018 155950 186233
5550 5550 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     2 Obligations 2019 495971 581530
5551 5551 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     2 Obligations 2021 1002769 1121979
5552 5552 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     2 Obligations 2022 1527000 1596855
5553 5553 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     2 Obligations 2023 1665514 1665514
5554 5554 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     2 Obligations 2024 61148560 59558006
5555 5555 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     3 Disbursements 2012 102600 134468
5556 5556 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     3 Disbursements 2015 452000 565556
5557 5557 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     3 Disbursements 2017 -20000 -24414
5558 5558 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     3 Disbursements 2018 120950 144437
5559 5559 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     3 Disbursements 2019 465471 545768
5560 5560 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     3 Disbursements 2020 -19500 -22569
5561 5561 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     3 Disbursements 2021 49996 55940
5562 5562 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     3 Disbursements 2022 234728 245465
5563 5563 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     3 Disbursements 2023 2020615 2020615
5564 5564 ECN Eastern and Central Africa Region 5 Sub-Saharan Africa     3 Disbursements 2024 61620340 60017514

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
);
Powered by Datasette · Queries took 6608.992ms