./us_foreign_aid_dac_sector
22 rows where Fiscal Year = 2020 and Transaction Type ID = 1
This data as json, CSV (advanced)
Suggested facets: International Category ID, International Category Name
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 15 | 15 | 1 | Education | 111 | Education, Level Unspecified | 1 | Appropriated and Planned | 2020 | 23175000 | 25613724 |
| 92 | 92 | 1 | Education | 112 | Basic Education | 1 | Appropriated and Planned | 2020 | 1095000000 | 1210227748 |
| 223 | 223 | 1 | Education | 114 | Post-Secondary Education | 1 | Appropriated and Planned | 2020 | 235000000 | 259729241 |
| 360 | 360 | 2 | Health and Population | 122 | Basic Health | 1 | Appropriated and Planned | 2020 | 1476338000 | 1631694265 |
| 463 | 463 | 2 | Health and Population | 130 | Maternal and Child Health, Family Planning | 1 | Appropriated and Planned | 2020 | 1462571000 | 1616478549 |
| 546 | 546 | 2 | Health and Population | 134 | HIV/AIDS | 1 | Appropriated and Planned | 2020 | 6260000000 | 6918744956 |
| 629 | 629 | 2 | Health and Population | 140 | Water Supply and Sanitation | 1 | Appropriated and Planned | 2020 | 424561000 | 469237902 |
| 712 | 712 | 3 | Governance | 151 | Government and Civil Society | 1 | Appropriated and Planned | 2020 | 3507960000 | 3877105523 |
| 795 | 795 | 3 | Governance | 152 | Conflict, Peace, and Security | 1 | Appropriated and Planned | 2020 | 8324871000 | 9200904029 |
| 878 | 878 | 3 | Governance | 160 | Other Social Infrastructure and Services | 1 | Appropriated and Planned | 2020 | 1007192000 | 1113179643 |
| 961 | 961 | 4 | Infrastructure | 210 | Transport and Storage | 1 | Appropriated and Planned | 2020 | 235992000 | 260825632 |
| 1211 | 1211 | 5 | Economic Growth | 250 | Business and Other Services | 1 | Appropriated and Planned | 2020 | 180970000 | 200013623 |
| 1407 | 1407 | 5 | Economic Growth | 331 | Trade Policy and Regulations | 1 | Appropriated and Planned | 2020 | 127477000 | 140891511 |
| 1532 | 1532 | 6 | Agriculture | 310 | Agriculture | 1 | Appropriated and Planned | 2020 | 2866315000 | 3167939688 |
| 1615 | 1615 | 7 | Other | 410 | General Environmental Protection | 1 | Appropriated and Planned | 2020 | 815847322 | 901699611 |
| 1698 | 1698 | 7 | Other | 430 | Other Multisector | 1 | Appropriated and Planned | 2020 | 1411217000 | 1559720526 |
| 1813 | 1813 | 7 | Other | 600 | Action Relating To Debt | 1 | Appropriated and Planned | 2020 | 15000000 | 16578462 |
| 1838 | 1838 | 7 | Other | 998 | Unallocated/ Unspecified | 1 | Appropriated and Planned | 2020 | 2427205000 | 2682621780 |
| 1994 | 1994 | 9 | Humanitarian | 720 | Emergency Response | 1 | Appropriated and Planned | 2020 | 8714855000 | 9631926369 |
| 2118 | 2118 | 9 | Humanitarian | 740 | Disaster Prevention and Preparedness | 1 | Appropriated and Planned | 2020 | 493069000 | 544955056 |
| 2200 | 2200 | 10 | Administrative Costs | 911 | Operating Expenses | 1 | Appropriated and Planned | 2020 | 1665650000 | 1840927720 |
| 2280 | 2280 | 10 | Administrative Costs | 912 | Program Design and Learning | 1 | Appropriated and Planned | 2020 | 14400000 | 15915324 |
Advanced export
JSON shape: default, array, newline-delimited
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 );