./us_foreign_aid_dac_sector

108 rows where Fiscal Year = 2017

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: International Category ID, International Category Name, Transaction Type ID, Transaction Type 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
12 12 1 Education 111 Education, Level Unspecified 1 Appropriated and Planned 2017 39364000 46005648
32 32 1 Education 111 Education, Level Unspecified 2 Obligations 2017 127458405 155588477
56 56 1 Education 111 Education, Level Unspecified 3 Disbursements 2017 142358887 173777502
73 73 1 Education 111 Education, Level Unspecified 18 President's Budget Requests 2017 19962000 23330067
89 89 1 Education 112 Basic Education 1 Appropriated and Planned 2017 961917000 1124215381
112 112 1 Education 112 Basic Education 2 Obligations 2017 1138036872 1389201606
136 136 1 Education 112 Basic Education 3 Disbursements 2017 1211750746 1479184134
153 153 1 Education 112 Basic Education 18 President's Budget Requests 2017 772782000 903168794
177 177 1 Education 113 Upper Secondary Education 2 Obligations 2017 115879891 141454584
201 201 1 Education 113 Upper Secondary Education 3 Disbursements 2017 15264693 18633612
220 220 1 Education 114 Post-Secondary Education 1 Appropriated and Planned 2017 249910000 292075790
243 243 1 Education 114 Post-Secondary Education 2 Obligations 2017 354776061 433075141
267 267 1 Education 114 Post-Secondary Education 3 Disbursements 2017 230879463 281834551
284 284 1 Education 114 Post-Secondary Education 18 President's Budget Requests 2017 226352000 264542994
311 311 2 Health and Population 121 Health, General 2 Obligations 2017 578005999 705571918
335 335 2 Health and Population 121 Health, General 3 Disbursements 2017 486318896 593649465
357 357 2 Health and Population 122 Basic Health 1 Appropriated and Planned 2017 1545269000 1805992811
380 380 2 Health and Population 122 Basic Health 2 Obligations 2017 1768088944 2158306178
404 404 2 Health and Population 122 Basic Health 3 Disbursements 2017 1907987533 2329080314
421 421 2 Health and Population 122 Basic Health 18 President's Budget Requests 2017 1376942000 1609265028
460 460 2 Health and Population 130 Maternal and Child Health, Family Planning 1 Appropriated and Planned 2017 1521425000 1778125761
483 483 2 Health and Population 130 Maternal and Child Health, Family Planning 2 Obligations 2017 1151997410 1406243238
507 507 2 Health and Population 130 Maternal and Child Health, Family Planning 3 Disbursements 2017 1143837051 1396281849
524 524 2 Health and Population 130 Maternal and Child Health, Family Planning 18 President's Budget Requests 2017 1675200000 1957846278
543 543 2 Health and Population 134 HIV/AIDS 1 Appropriated and Planned 2017 6000200000 7012577132
566 566 2 Health and Population 134 HIV/AIDS 2 Obligations 2017 6053337862 7389309490
590 590 2 Health and Population 134 HIV/AIDS 3 Disbursements 2017 6444004214 7866195820
607 607 2 Health and Population 134 HIV/AIDS 18 President's Budget Requests 2017 6054200000 7075688219
626 626 2 Health and Population 140 Water Supply and Sanitation 1 Appropriated and Planned 2017 450922000 527003322
649 649 2 Health and Population 140 Water Supply and Sanitation 2 Obligations 2017 417253131 509340900
673 673 2 Health and Population 140 Water Supply and Sanitation 3 Disbursements 2017 503614785 614762555
690 690 2 Health and Population 140 Water Supply and Sanitation 18 President's Budget Requests 2017 231548000 270615682
709 709 3 Governance 151 Government and Civil Society 1 Appropriated and Planned 2017 3865502000 4517704574
732 732 3 Governance 151 Government and Civil Society 2 Obligations 2017 3396169709 4145704485
756 756 3 Governance 151 Government and Civil Society 3 Disbursements 2017 2914335792 3557529695
773 773 3 Governance 151 Government and Civil Society 18 President's Budget Requests 2017 3936000000 4600097283
792 792 3 Governance 152 Conflict, Peace, and Security 1 Appropriated and Planned 2017 9450827000 11045407387
815 815 3 Governance 152 Conflict, Peace, and Security 2 Obligations 2017 13446880709 16414607286
839 839 3 Governance 152 Conflict, Peace, and Security 3 Disbursements 2017 12245110796 14947606773
856 856 3 Governance 152 Conflict, Peace, and Security 18 President's Budget Requests 2017 15124483000 17676344733
875 875 3 Governance 160 Other Social Infrastructure and Services 1 Appropriated and Planned 2017 969504000 1133082495
898 898 3 Governance 160 Other Social Infrastructure and Services 2 Obligations 2017 704228658 859651925
922 922 3 Governance 160 Other Social Infrastructure and Services 3 Disbursements 2017 755448898 922176443
939 939 3 Governance 160 Other Social Infrastructure and Services 18 President's Budget Requests 2017 2010944000 2350238309
958 958 4 Infrastructure 210 Transport and Storage 1 Appropriated and Planned 2017 330451000 386205981
981 981 4 Infrastructure 210 Transport and Storage 2 Obligations 2017 20255294 24725636
1005 1005 4 Infrastructure 210 Transport and Storage 3 Disbursements 2017 77903869 95097259
1022 1022 4 Infrastructure 210 Transport and Storage 18 President's Budget Requests 2017 660337000 771751633
1046 1046 4 Infrastructure 220 Communications 2 Obligations 2017 1883073 2298666
1070 1070 4 Infrastructure 220 Communications 3 Disbursements 2017 10811042 13197041
1099 1099 4 Infrastructure 230 Energy 2 Obligations 2017 960867831 1172931359
1123 1123 4 Infrastructure 230 Energy 3 Disbursements 2017 864449532 1055233572
1133 1133 4 Infrastructure 230 Energy 18 President's Budget Requests 2017 338631000 395766146
1148 1148 5 Economic Growth 240 Banking and Financial Services 1 Appropriated and Planned 2017 434397000 507690156
1165 1165 5 Economic Growth 240 Banking and Financial Services 2 Obligations 2017 99649057 121641611
1189 1189 5 Economic Growth 240 Banking and Financial Services 3 Disbursements 2017 101004185 123295811
1206 1206 5 Economic Growth 240 Banking and Financial Services 18 President's Budget Requests 2017 264778000 309452379
1231 1231 5 Economic Growth 250 Business and Other Services 2 Obligations 2017 249958402 305124220
1255 1255 5 Economic Growth 250 Business and Other Services 3 Disbursements 2017 237679587 290135439
1285 1285 5 Economic Growth 321 Industry 2 Obligations 2017 48847378 59627998
1309 1309 5 Economic Growth 321 Industry 3 Disbursements 2017 82888306 101181752
1333 1333 5 Economic Growth 322 Mineral Resources and Mining 2 Obligations 2017 728057 888739
1357 1357 5 Economic Growth 322 Mineral Resources and Mining 3 Disbursements 2017 1645105 2008180
1391 1391 5 Economic Growth 323 Construction 3 Disbursements 2017 381030 465123
1404 1404 5 Economic Growth 331 Trade Policy and Regulations 1 Appropriated and Planned 2017 134621000 157334777
1427 1427 5 Economic Growth 331 Trade Policy and Regulations 2 Obligations 2017 103148557 125913445
1451 1451 5 Economic Growth 331 Trade Policy and Regulations 3 Disbursements 2017 124349634 151793587
1468 1468 5 Economic Growth 331 Trade Policy and Regulations 18 President's Budget Requests 2017 263747000 308247422
1511 1511 5 Economic Growth 332 Tourism 3 Disbursements 2017 29579 36107
1529 1529 6 Agriculture 310 Agriculture 1 Appropriated and Planned 2017 2720710000 3179758796
1552 1552 6 Agriculture 310 Agriculture 2 Obligations 2017 1193805309 1457278101
1576 1576 6 Agriculture 310 Agriculture 3 Disbursements 2017 1307779596 1596406503
1593 1593 6 Agriculture 310 Agriculture 18 President's Budget Requests 2017 1300067035 1519419414
1612 1612 7 Other 410 General Environmental Protection 1 Appropriated and Planned 2017 686229590 802012919
1635 1635 7 Other 410 General Environmental Protection 2 Obligations 2017 1407515123 1718153730
1659 1659 7 Other 410 General Environmental Protection 3 Disbursements 2017 1369198410 1671380479
1676 1676 7 Other 410 General Environmental Protection 18 President's Budget Requests 2017 1003714087 1173064639
1695 1695 7 Other 430 Other Multisector 1 Appropriated and Planned 2017 1449591208 1694171889
1718 1718 7 Other 430 Other Multisector 2 Obligations 2017 561905960 685918601
1742 1742 7 Other 430 Other Multisector 3 Disbursements 2017 519463716 634109374
1759 1759 7 Other 430 Other Multisector 18 President's Budget Requests 2017 1905770000 2227318943
1783 1783 7 Other 510 General Budget Support 2 Obligations 2017 517679044 631930811
1806 1806 7 Other 510 General Budget Support 3 Disbursements 2017 492057888 600655064
1835 1835 7 Other 998 Unallocated/ Unspecified 1 Appropriated and Planned 2017 2675577148 3127010954
1858 1858 7 Other 998 Unallocated/ Unspecified 2 Obligations 2017 1759953929 2148375743
1882 1882 7 Other 998 Unallocated/ Unspecified 3 Disbursements 2017 1748958684 2134953847
1902 1902 7 Other 998 Unallocated/ Unspecified 18 President's Budget Requests 2017 3285021148 3839282721
1926 1926 8 Commodity Assistance 520 Developmental Food Aid/Food Security Assistance 2 Obligations 2017 445193164 543447280
1950 1950 8 Commodity Assistance 520 Developmental Food Aid/Food Security Assistance 3 Disbursements 2017 668536817 816082867
1991 1991 9 Humanitarian 720 Emergency Response 1 Appropriated and Planned 2017 8879632000 10377838124
2014 2014 9 Humanitarian 720 Emergency Response 2 Obligations 2017 8341844101 10182889140
2038 2038 9 Humanitarian 720 Emergency Response 3 Disbursements 2017 6688705263 8164902490
2055 2055 9 Humanitarian 720 Emergency Response 18 President's Budget Requests 2017 6224719000 7274977852
2100 2100 9 Humanitarian 730 Reconstruction Relief and Rehabilitation 3 Disbursements 2017 443 541
2115 2115 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2017 219617000 256671639
2138 2138 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2017 177931123 217200514
2162 2162 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2017 141575184 172820796
2179 2179 9 Humanitarian 740 Disaster Prevention and Preparedness 18 President's Budget Requests 2017 154857000 180985077
2197 2197 10 Administrative Costs 911 Operating Expenses 1 Appropriated and Planned 2017 1643274000 1920533594
2220 2220 10 Administrative Costs 911 Operating Expenses 2 Obligations 2017 2672031338 3261748483

Next page

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