./us_foreign_aid_dac_sector

17 rows where International Sector Name = "Other Social Infrastructure and Services" and Transaction Type ID = 18

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ International Category ID International Category Name International Sector Code International Sector Name Transaction Type ID Transaction Type Name Fiscal Year current_amount constant_amount
930 930 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2008 1075867000 1434147682
931 931 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2009 2463177000 3250423137
932 932 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2010 1995387000 2610420576
933 933 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2011 1612405000 2067720586
934 934 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2012 1190453000 1499137463
935 935 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2013 945145000 1168831479
936 936 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2014 911737000 1106117924
937 937 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2015 1005082000 1205543160
938 938 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2016 989125000 1176653232
939 939 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2017 2010944000 2350238309
940 940 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2018 476588000 544221316
941 941 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2019 491958000 550980707
942 942 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2020 520968000 575789891
943 943 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2021 600658000 642276151
944 944 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2022 727460000 727460000
945 945 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2023 712109000 679208411
946 946 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2024 710674000 662191473

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "./us_foreign_aid_dac_sector" (
"International Category ID" INTEGER,
  "International Category Name" TEXT,
  "International Sector Code" INTEGER,
  "International Sector Name" TEXT,
  "Transaction Type ID" INTEGER,
  "Transaction Type Name" TEXT,
  "Fiscal Year" INTEGER,
  "current_amount" INTEGER,
  "constant_amount" INTEGER
);