./us_foreign_aid_dac_sector

88 rows where Fiscal Year = 2007

✎ 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
2 2 1 Education 111 Education, Level Unspecified 1 Appropriated and Planned 2007 6574000 8946010
22 22 1 Education 111 Education, Level Unspecified 2 Obligations 2007 225750698 319617112
46 46 1 Education 111 Education, Level Unspecified 3 Disbursements 2007 269249946 381203205
79 79 1 Education 112 Basic Education 1 Appropriated and Planned 2007 601894000 819067558
102 102 1 Education 112 Basic Education 2 Obligations 2007 548815089 777010642
126 126 1 Education 112 Basic Education 3 Disbursements 2007 481905068 682279590
167 167 1 Education 113 Upper Secondary Education 2 Obligations 2007 8653795 12252012
191 191 1 Education 113 Upper Secondary Education 3 Disbursements 2007 8878004 12569442
210 210 1 Education 114 Post-Secondary Education 1 Appropriated and Planned 2007 152581000 207634810
233 233 1 Education 114 Post-Secondary Education 2 Obligations 2007 41506318 58764511
257 257 1 Education 114 Post-Secondary Education 3 Disbursements 2007 13606827 19264497
301 301 2 Health and Population 121 Health, General 2 Obligations 2007 96333644 136388860
325 325 2 Health and Population 121 Health, General 3 Disbursements 2007 173209466 245229387
347 347 2 Health and Population 122 Basic Health 1 Appropriated and Planned 2007 594637000 809192101
370 370 2 Health and Population 122 Basic Health 2 Obligations 2007 969428658 1372514058
394 394 2 Health and Population 122 Basic Health 3 Disbursements 2007 818044365 1158184570
450 450 2 Health and Population 130 Maternal and Child Health, Family Planning 1 Appropriated and Planned 2007 1134372000 1543672644
473 473 2 Health and Population 130 Maternal and Child Health, Family Planning 2 Obligations 2007 580742537 822213418
497 497 2 Health and Population 130 Maternal and Child Health, Family Planning 3 Disbursements 2007 369902739 523707116
533 533 2 Health and Population 134 HIV/AIDS 1 Appropriated and Planned 2007 3842737000 5229261624
556 556 2 Health and Population 134 HIV/AIDS 2 Obligations 2007 3814552956 5400631863
580 580 2 Health and Population 134 HIV/AIDS 3 Disbursements 2007 2678169215 3791743306
616 616 2 Health and Population 140 Water Supply and Sanitation 1 Appropriated and Planned 2007 133398000 181530256
639 639 2 Health and Population 140 Water Supply and Sanitation 2 Obligations 2007 375508815 531644169
663 663 2 Health and Population 140 Water Supply and Sanitation 3 Disbursements 2007 615440079 871338091
699 699 3 Governance 151 Government and Civil Society 1 Appropriated and Planned 2007 2839502000 3864042429
722 722 3 Governance 151 Government and Civil Society 2 Obligations 2007 3029396888 4289010388
746 746 3 Governance 151 Government and Civil Society 3 Disbursements 2007 2430665891 3441328812
782 782 3 Governance 152 Conflict, Peace, and Security 1 Appropriated and Planned 2007 7485285000 10186102646
805 805 3 Governance 152 Conflict, Peace, and Security 2 Obligations 2007 14591203346 20658178990
829 829 3 Governance 152 Conflict, Peace, and Security 3 Disbursements 2007 13316582611 18853575007
865 865 3 Governance 160 Other Social Infrastructure and Services 1 Appropriated and Planned 2007 1341252000 1825198442
888 888 3 Governance 160 Other Social Infrastructure and Services 2 Obligations 2007 1441412918 2040747778
912 912 3 Governance 160 Other Social Infrastructure and Services 3 Disbursements 2007 1378484741 1951654240
948 948 4 Infrastructure 210 Transport and Storage 1 Appropriated and Planned 2007 723851000 985028704
971 971 4 Infrastructure 210 Transport and Storage 2 Obligations 2007 855851326 1211711574
995 995 4 Infrastructure 210 Transport and Storage 3 Disbursements 2007 466408656 660339897
1036 1036 4 Infrastructure 220 Communications 2 Obligations 2007 23989189 33963813
1060 1060 4 Infrastructure 220 Communications 3 Disbursements 2007 49912980 70666639
1089 1089 4 Infrastructure 230 Energy 2 Obligations 2007 2244739812 3178095444
1113 1113 4 Infrastructure 230 Energy 3 Disbursements 2007 1888567129 2673827275
1138 1138 5 Economic Growth 240 Banking and Financial Services 1 Appropriated and Planned 2007 127044000 172883629
1155 1155 5 Economic Growth 240 Banking and Financial Services 2 Obligations 2007 476714135 674930355
1179 1179 5 Economic Growth 240 Banking and Financial Services 3 Disbursements 2007 327392260 463520908
1221 1221 5 Economic Growth 250 Business and Other Services 2 Obligations 2007 548376179 776389214
1245 1245 5 Economic Growth 250 Business and Other Services 3 Disbursements 2007 720122700 1019547326
1275 1275 5 Economic Growth 321 Industry 2 Obligations 2007 68269543 96655803
1299 1299 5 Economic Growth 321 Industry 3 Disbursements 2007 57621232 81579936
1323 1323 5 Economic Growth 322 Mineral Resources and Mining 2 Obligations 2007 46716421 66140960
1347 1347 5 Economic Growth 322 Mineral Resources and Mining 3 Disbursements 2007 245438293 347490748
1371 1371 5 Economic Growth 323 Construction 2 Obligations 2007 250000 353949
1394 1394 5 Economic Growth 331 Trade Policy and Regulations 1 Appropriated and Planned 2007 331638000 451298609
1417 1417 5 Economic Growth 331 Trade Policy and Regulations 2 Obligations 2007 254182953 359871418
1441 1441 5 Economic Growth 331 Trade Policy and Regulations 3 Disbursements 2007 204875205 290061652
1482 1482 5 Economic Growth 332 Tourism 2 Obligations 2007 973732 1378606
1501 1501 5 Economic Growth 332 Tourism 3 Disbursements 2007 372588 527509
1519 1519 6 Agriculture 310 Agriculture 1 Appropriated and Planned 2007 538095000 732248794
1542 1542 6 Agriculture 310 Agriculture 2 Obligations 2007 931114399 1318268804
1566 1566 6 Agriculture 310 Agriculture 3 Disbursements 2007 451459072 639174306
1602 1602 7 Other 410 General Environmental Protection 1 Appropriated and Planned 2007 337788000 459667633
1625 1625 7 Other 410 General Environmental Protection 2 Obligations 2007 269577185 381666525
1649 1649 7 Other 410 General Environmental Protection 3 Disbursements 2007 346542317 490633490
1685 1685 7 Other 430 Other Multisector 1 Appropriated and Planned 2007 562278000 765157425
1708 1708 7 Other 430 Other Multisector 2 Obligations 2007 1085006991 1536149380
1732 1732 7 Other 430 Other Multisector 3 Disbursements 2007 830956320 1176465228
1773 1773 7 Other 510 General Budget Support 2 Obligations 2007 90639782 128327512
1796 1796 7 Other 510 General Budget Support 3 Disbursements 2007 90639782 128327512
1825 1825 7 Other 998 Unallocated/ Unspecified 1 Appropriated and Planned 2007 2988168749 4066350665
1848 1848 7 Other 998 Unallocated/ Unspecified 2 Obligations 2007 1687156427 2388670665
1872 1872 7 Other 998 Unallocated/ Unspecified 3 Disbursements 2007 1525659011 2160023120
1892 1892 7 Other 998 Unallocated/ Unspecified 18 President's Budget Requests 2007 3000000000 4082450832
1916 1916 8 Commodity Assistance 520 Developmental Food Aid/Food Security Assistance 2 Obligations 2007 516578331 731369953
1940 1940 8 Commodity Assistance 520 Developmental Food Aid/Food Security Assistance 3 Disbursements 2007 520083093 736331985
1964 1964 8 Commodity Assistance 530 Other Commodity Assistance 2 Obligations 2007 196862787 278717703
1975 1975 8 Commodity Assistance 530 Other Commodity Assistance 3 Disbursements 2007 131660735 186404844
1981 1981 9 Humanitarian 720 Emergency Response 1 Appropriated and Planned 2007 2963713000 4033070868
2004 2004 9 Humanitarian 720 Emergency Response 2 Obligations 2007 2939500397 4161735309
2028 2028 9 Humanitarian 720 Emergency Response 3 Disbursements 2007 2970524996 4205659778
2069 2069 9 Humanitarian 730 Reconstruction Relief and Rehabilitation 2 Obligations 2007 251253638 355724089
2090 2090 9 Humanitarian 730 Reconstruction Relief and Rehabilitation 3 Disbursements 2007 251699588 356355458
2105 2105 9 Humanitarian 740 Disaster Prevention and Preparedness 1 Appropriated and Planned 2007 78226000 106451266
2128 2128 9 Humanitarian 740 Disaster Prevention and Preparedness 2 Obligations 2007 36343293 51454718
2152 2152 9 Humanitarian 740 Disaster Prevention and Preparedness 3 Disbursements 2007 6471709 9162620
2210 2210 10 Administrative Costs 911 Operating Expenses 2 Obligations 2007 1417783892 2007293788
2234 2234 10 Administrative Costs 911 Operating Expenses 3 Disbursements 2007 1125369610 1593294519
2269 2269 10 Administrative Costs 912 Program Design and Learning 1 Appropriated and Planned 2007 883186000 1201854471
2284 2284 10 Administrative Costs 912 Program Design and Learning 2 Obligations 2007 48101516 68101962
2302 2302 10 Administrative Costs 912 Program Design and Learning 3 Disbursements 2007 18518688 26218687

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