./us_foreign_aid_dac_sector

35 rows where Fiscal Year = 2001 and Transaction Type ID = 3

✎ View and edit SQL

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
40 40 1 Education 111 Education, Level Unspecified 3 Disbursements 2001 34750376 57038838
120 120 1 Education 112 Basic Education 3 Disbursements 2001 104404359 171368030
185 185 1 Education 113 Upper Secondary Education 3 Disbursements 2001 18560003 30464155
251 251 1 Education 114 Post-Secondary Education 3 Disbursements 2001 24681836 40512465
319 319 2 Health and Population 121 Health, General 3 Disbursements 2001 90779958 149005100
388 388 2 Health and Population 122 Basic Health 3 Disbursements 2001 519381327 852506083
491 491 2 Health and Population 130 Maternal and Child Health, Family Planning 3 Disbursements 2001 434200358 712691124
574 574 2 Health and Population 134 HIV/AIDS 3 Disbursements 2001 143070658 234834396
657 657 2 Health and Population 140 Water Supply and Sanitation 3 Disbursements 2001 94852038 155688949
740 740 3 Governance 151 Government and Civil Society 3 Disbursements 2001 1010748628 1659030354
823 823 3 Governance 152 Conflict, Peace, and Security 3 Disbursements 2001 4435703136 7280708360
906 906 3 Governance 160 Other Social Infrastructure and Services 3 Disbursements 2001 449900309 738460816
989 989 4 Infrastructure 210 Transport and Storage 3 Disbursements 2001 9697758 15917770
1054 1054 4 Infrastructure 220 Communications 3 Disbursements 2001 39233956 64398127
1107 1107 4 Infrastructure 230 Energy 3 Disbursements 2001 135366221 222188438
1173 1173 5 Economic Growth 240 Banking and Financial Services 3 Disbursements 2001 47853318 78545836
1239 1239 5 Economic Growth 250 Business and Other Services 3 Disbursements 2001 296464208 486612679
1293 1293 5 Economic Growth 321 Industry 3 Disbursements 2001 74391231 122104830
1341 1341 5 Economic Growth 322 Mineral Resources and Mining 3 Disbursements 2001 4886409 8020490
1377 1377 5 Economic Growth 323 Construction 3 Disbursements 2001 54000 88635
1435 1435 5 Economic Growth 331 Trade Policy and Regulations 3 Disbursements 2001 317991699 521947646
1495 1495 5 Economic Growth 332 Tourism 3 Disbursements 2001 5000 8207
1560 1560 6 Agriculture 310 Agriculture 3 Disbursements 2001 298204974 489469970
1643 1643 7 Other 410 General Environmental Protection 3 Disbursements 2001 206706075 339284794
1726 1726 7 Other 430 Other Multisector 3 Disbursements 2001 824514017 1353347104
1790 1790 7 Other 510 General Budget Support 3 Disbursements 2001 922878000 1514800558
1817 1817 7 Other 600 Action Relating To Debt 3 Disbursements 2001 5000000 8206938
1866 1866 7 Other 998 Unallocated/ Unspecified 3 Disbursements 2001 1141465983 1873588174
1934 1934 8 Commodity Assistance 520 Developmental Food Aid/Food Security Assistance 3 Disbursements 2001 614256839 1008233592
1969 1969 8 Commodity Assistance 530 Other Commodity Assistance 3 Disbursements 2001 235945802 387278531
2022 2022 9 Humanitarian 720 Emergency Response 3 Disbursements 2001 1412107670 2317816120
2084 2084 9 Humanitarian 730 Reconstruction Relief and Rehabilitation 3 Disbursements 2001 253330641 415813777
2146 2146 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2001 21028731 34516300
2228 2228 10 Administrative Costs 911 Operating Expenses 3 Disbursements 2001 773707081 1269953256
2354 2354 10 Administrative Costs 913 Administration and Oversight 3 Disbursements 2001 2491973 4090293

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