./us_foreign_aid_implementing

18 rows where Fiscal Year = 2023, Managing Agency Name = "Department of Labor" and Transaction Type Name = "Obligations"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ Managing Agency ID Managing Agency Acronym Managing Agency Name Country Code Country Name Transaction Type ID Transaction Type Name Fiscal Year current_amount constant_amount
37166 37166 11 DOL Department of Labor ARG Argentina 2 Obligations 2023 625000 625000
37215 37215 11 DOL Department of Labor BGD Bangladesh 2 Obligations 2023 3000000 3000000
37304 37304 11 DOL Department of Labor CNA Central America Region 2 Obligations 2023 1000000 1000000
37364 37364 11 DOL Department of Labor CRI Costa Rica 2 Obligations 2023 600000 600000
37380 37380 11 DOL Department of Labor DOM Dominican Republic 2 Obligations 2023 3150000 3150000
37448 37448 11 DOL Department of Labor GHA Ghana 2 Obligations 2023 2372579 2372579
37470 37470 11 DOL Department of Labor GTM Guatemala 2 Obligations 2023 550000 550000
37504 37504 11 DOL Department of Labor HND Honduras 2 Obligations 2023 1390765 1390765
37521 37521 11 DOL Department of Labor HTI Haiti 2 Obligations 2023 2600000 2600000
37615 37615 11 DOL Department of Labor KHM Cambodia 2 Obligations 2023 400548 400548
37716 37716 11 DOL Department of Labor MEX Mexico 2 Obligations 2023 18646260 18646260
37738 37738 11 DOL Department of Labor MMR Burma (Myanmar) 2 Obligations 2023 900000 900000
37776 37776 11 DOL Department of Labor MYS Malaysia 2 Obligations 2023 2465500 2465500
37935 37935 11 DOL Department of Labor SMN South America Region 2 Obligations 2023 17000000 17000000
37957 37957 11 DOL Department of Labor SSN Sub-Saharan Africa Region 2 Obligations 2023 4000000 4000000
38087 38087 11 DOL Department of Labor VNM Vietnam 2 Obligations 2023 3907265 3907265
38113 38113 11 DOL Department of Labor WAN West Africa Region 2 Obligations 2023 5000000 5000000
38146 38146 11 DOL Department of Labor WLD World 2 Obligations 2023 7850000 7850000

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "./us_foreign_aid_implementing" (
"Managing Agency ID" INTEGER,
  "Managing Agency Acronym" TEXT,
  "Managing Agency Name" TEXT,
  "Country Code" TEXT,
  "Country Name" TEXT,
  "Transaction Type ID" INTEGER,
  "Transaction Type Name" TEXT,
  "Fiscal Year" INTEGER,
  "current_amount" INTEGER,
  "constant_amount" INTEGER
);