./us_foreign_budget_complete

34 rows where Fiscal Year = 2010, Funding Account ID = "72x0306" and International Purpose Code = 31110

✎ 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
1472 1472 8 ALB Albania 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Albania 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 1650000 2158576
1475 1475 8 ALB Albania 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Albania 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 1500000 1962342
2364 2364 31 AZE Azerbaijan 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Azerbaijan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 1100000 1439050
2368 2368 31 AZE Azerbaijan 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Azerbaijan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 1100000 1439050
4089 4089 51 ARM Armenia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Armenia 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 5100000 6671961
4092 4092 51 ARM Armenia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Armenia 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 2700000 3532215
4856 4856 70 BIH Bosnia and Herzegovina 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Bosnia and Herzegovina 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 2300000 3008924
4858 4858 70 BIH Bosnia and Herzegovina 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Bosnia and Herzegovina 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 2300000 3008924
6379 6379 112 BLR Belarus 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Belarus 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 300000 392468
13100 13100 268 GEO Georgia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Georgia 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 4910000 6423398
13109 13109 268 GEO Georgia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Georgia 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 6550000 8568892
19671 19671 398 KAZ Kazakhstan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Kazakhstan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 125000 163528
19674 19674 398 KAZ Kazakhstan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Kazakhstan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 100000 130823
21951 21951 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 10607000 13876371
21956 21956 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 14607000 19109282
27494 27494 498 MDA Moldova 2 Europe and Eurasia 2 Lower Middle Income Country LMIC 55 EUR European and Eurasian Affairs Moldova 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 350000 457880
36021 36021 688 SRB Serbia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Serbia 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 5643000 7382329
36026 36026 688 SRB Serbia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Serbia 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 6771000 8858010
40256 40256 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 12750000 16679903
40266 40266 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 16520000 21611922
41815 41815 795 TKM Turkmenistan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Turkmenistan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 1109000 1450825
41819 41819 795 TKM Turkmenistan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Turkmenistan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 900000 1177405
43142 43142 804 UKR Ukraine 2 Europe and Eurasia 2 Lower Middle Income Country LMIC 55 EUR European and Eurasian Affairs Ukraine 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 2950000 3859272
43148 43148 804 UKR Ukraine 2 Europe and Eurasia 2 Lower Middle Income Country LMIC 55 EUR European and Eurasian Affairs Ukraine 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 2750000 3597626
43430 43430 807 MKD North Macedonia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Macedonia 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 1142000 1493996
43655 43655 807 MKD North Macedonia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs North Macedonia 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 870000 1138158
45632 45632 860 UZB Uzbekistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Uzbekistan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 1404000 1836752
45639 45639 860 UZB Uzbekistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Uzbekistan 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 930000 1216652
51271 51271 1002 WLD World 7 World       57 SCA South and Central Asian Affairs Central Asia Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 500000 654114
60618 60618 1018 EUN Europe Region 2 Europe and Eurasia       55 EUR European and Eurasian Affairs Eurasia Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 48000 62795
60838 60838 1018 EUN Europe Region 2 Europe and Eurasia       55 EUR European and Eurasian Affairs Europe Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 65000 85035
60839 60839 1018 EUN Europe Region 2 Europe and Eurasia       55 EUR European and Eurasian Affairs Europe Regional 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 163000 213241
62891 62891 1071 CS-KM Kosovo 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Kosovo 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 2520000 3296734
62896 62896 1071 CS-KM Kosovo 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Kosovo 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2010 2520000 3296734

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