./us_foreign_budget_complete

38 rows where Fiscal Year = 2009, International Sector Code = 122 and Region ID = 4

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Funding Account ID, Transaction Type ID

Link rowid ▼ Country ID Country Code Country Name Region ID Region Name Income Group ID Income Group Name Income Group Acronym Managing Sub-agency or Bureau ID Managing Sub-agency or Bureau Acronym Managing Sub-agency or Bureau Name Operating Unit International Category ID International Category Name International Sector Code International Sector Name International Purpose Code International Purpose Name US Category ID US Category Name US Sector ID US Sector Name Funding Agency ID Funding Agency Name Funding Agency Acronym OCO Flag Activity ID Activity Name Activity Description Transaction Type ID Transaction Type Name Fiscal Year current_amount constant_amount
111 111 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 14 Pandemic Influenza and Other Emerging Threats (PIOET) 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2009 500000 659803
118 118 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2009 500000 659803
156 156 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 2 Health and Population 122 Basic Health 12262 Malaria control 3 Health 13 Malaria 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2009 500000 659803
160 160 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2009 5234000 6906818
164 164 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 18 President's Budget Requests 2009 1500000 1979409
2919 2919 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Bangladesh 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2009 5000000 6598030
2932 2932 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Bangladesh 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 18 President's Budget Requests 2009 2200000 2903133
16956 16956 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs India 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2009 10000000 13196060
16969 16969 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs India 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 18 President's Budget Requests 2009 4700000 6202148
19279 19279 398 KAZ Kazakhstan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Kazakhstan 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2009 417000 550276
19281 19281 398 KAZ Kazakhstan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Kazakhstan 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 18 President's Budget Requests 2009 350000 461862
19283 19283 398 KAZ Kazakhstan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Kazakhstan 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2009 864000 1140140
19295 19295 398 KAZ Kazakhstan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Kazakhstan 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2009 650000 857744
19300 19300 398 KAZ Kazakhstan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Kazakhstan 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 18 President's Budget Requests 2009 1100000 1451567
21481 21481 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2009 798000 1053046
21485 21485 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 18 President's Budget Requests 2009 600000 791764
21492 21492 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2009 595000 785166
21519 21519 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2009 846000 1116387
21524 21524 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 18 President's Budget Requests 2009 825000 1088675
31267 31267 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2009 2000000 2639212
31281 31281 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2009 3968000 5236197
31284 31284 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 18 President's Budget Requests 2009 2200000 2903133
31292 31292 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   344993000 Budget for Economic Support Fund, Bridge Supplemental Budget for Economic Support Fund, Bridge Supplemental 1 Appropriated and Planned 2009 500000 659803
39775 39775 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2009 812000 1071520
39778 39778 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 18 President's Budget Requests 2009 1250000 1649507
39798 39798 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2009 495000 653205
39825 39825 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2009 910000 1200841
39830 39830 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 18 President's Budget Requests 2009 800000 1055685
41516 41516 795 TKM Turkmenistan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Turkmenistan 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2009 230000 303509
41518 41518 795 TKM Turkmenistan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Turkmenistan 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 18 President's Budget Requests 2009 450000 593823
41522 41522 795 TKM Turkmenistan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Turkmenistan 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2009 407000 537080
41530 41530 795 TKM Turkmenistan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Turkmenistan 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2009 378000 498811
41535 41535 795 TKM Turkmenistan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Turkmenistan 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 18 President's Budget Requests 2009 400000 527842
45300 45300 860 UZB Uzbekistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Uzbekistan 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2009 218000 287674
45302 45302 860 UZB Uzbekistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Uzbekistan 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 18 President's Budget Requests 2009 250000 329901
45306 45306 860 UZB Uzbekistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Uzbekistan 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   345013000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2009 615000 811558
45333 45333 860 UZB Uzbekistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Uzbekistan 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2009 840000 1108469
45337 45337 860 UZB Uzbekistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Uzbekistan 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 39 Department of State and U.S. Agency for International Development State/USAID   344946000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 18 President's Budget Requests 2009 840000 1108469

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "./us_foreign_budget_complete" (
"Country ID" INTEGER,
  "Country Code" TEXT,
  "Country Name" TEXT,
  "Region ID" INTEGER,
  "Region Name" TEXT,
  "Income Group ID" INTEGER,
  "Income Group Name" TEXT,
  "Income Group Acronym" TEXT,
  "Managing Sub-agency or Bureau ID" INTEGER,
  "Managing Sub-agency or Bureau Acronym" TEXT,
  "Managing Sub-agency or Bureau Name" TEXT,
  "Operating Unit" TEXT,
  "International Category ID" INTEGER,
  "International Category Name" TEXT,
  "International Sector Code" INTEGER,
  "International Sector Name" TEXT,
  "International Purpose Code" INTEGER,
  "International Purpose Name" TEXT,
  "US Category ID" INTEGER,
  "US Category Name" TEXT,
  "US Sector ID" INTEGER,
  "US Sector Name" TEXT,
  "Funding Account ID" TEXT,
  "Funding Account Name" TEXT,
  "Funding Agency ID" INTEGER,
  "Funding Agency Name" TEXT,
  "Funding Agency Acronym" TEXT,
  "OCO Flag" INTEGER,
  "Activity ID" INTEGER,
  "Activity Name" TEXT,
  "Activity Description" TEXT,
  "Transaction Type ID" INTEGER,
  "Transaction Type Name" TEXT,
  "Fiscal Year" INTEGER,
  "current_amount" INTEGER,
  "constant_amount" INTEGER
);