./us_foreign_budget_complete

22 rows where Fiscal Year = 2009, International Sector Code = 210 and Region ID = 4

✎ View and edit SQL

This data as json, CSV (advanced)

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
853 853 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 137000000 180786021
856 856 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 147060000 194061257
861 861 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 126000000 166270355
3350 3350 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Bangladesh 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2009 2744000 3620999
3353 3353 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Bangladesh 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2009 2743000 3619679
17210 17210 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs India 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2009 1000000 1319606
17215 17215 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs India 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2009 900000 1187645
19622 19622 398 KAZ Kazakhstan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Kazakhstan 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 491000 647927
19631 19631 398 KAZ Kazakhstan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Kazakhstan 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 1464000 1931903
21892 21892 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 1083000 1429133
21899 21899 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 992000 1309049
21903 21903 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344953000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA), H.R. 2346 Spring Supplemental Budget for Assistance for Europe, Eurasia and Central Asia (AEECA), H.R. 2346 Spring Supplemental 1 Appropriated and Planned 2009 30000000 39588180
31776 31776 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 73479000 96963329
31782 31782 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 17500000 23093105
31789 31789 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 16000000 21113696
31790 31790 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344997000 Budget for Economic Support Fund, H.R. 2346 Spring Supplemental Budget for Economic Support Fund, H.R. 2346 Spring Supplemental 1 Appropriated and Planned 2009 135000000 178146809
31791 31791 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344997000 Budget for Economic Support Fund, H.R. 2346 Spring Supplemental Budget for Economic Support Fund, H.R. 2346 Spring Supplemental 18 President's Budget Requests 2009 21500000 28371529
40210 40210 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 1142000 1506990
40217 40217 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 603000 795722
41778 41778 795 TKM Turkmenistan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Turkmenistan 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 190000 250725
41781 41781 795 TKM Turkmenistan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Turkmenistan 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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
45607 45607 860 UZB Uzbekistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Uzbekistan 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 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 120000 158353

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