./us_foreign_budget_complete

34 rows where current_amount = 575000

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country Name, Income Group Acronym, International Sector Code, International Purpose Name, Activity ID, Transaction Type Name

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
2128 2128 31 AZE Azerbaijan 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Azerbaijan 3 Governance 151 Government and Civil Society 15150 Democratic participation and civil society 2 Democracy, Human Rights, and Governance 8 Good Governance 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 2015 575000 689682
4152 4152 51 ARM Armenia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Armenia 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 39 Department of State and U.S. Agency for International Development State/USAID   344894000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) 1 Appropriated and Planned 2022 575000 575000
5038 5038 72 BWA Botswana 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs Botswana 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345038000 Budget for International Military Education and Training Budget for International Military Education and Training 18 President's Budget Requests 2013 575000 711085
5158 5158 76 BRA Brazil 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Brazil 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345038000 Budget for International Military Education and Training Budget for International Military Education and Training 18 President's Budget Requests 2018 575000 656599
5159 5159 76 BRA Brazil 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Brazil 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345038000 Budget for International Military Education and Training Budget for International Military Education and Training 18 President's Budget Requests 2019 575000 643986
8235 8235 158 TWN Taiwan 1 East Asia and Oceania 4 High Income Country HIC 54 EAP East Asian and Pacific Affairs Taiwan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345115000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Export Control and Related Border Security Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Export Control and Related Border Security Assistance 18 President's Budget Requests 2009 575000 758773
8237 8237 158 TWN Taiwan 1 East Asia and Oceania 4 High Income Country HIC 54 EAP East Asian and Pacific Affairs Taiwan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 39 Department of State and U.S. Agency for International Development State/USAID   345104000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs 18 President's Budget Requests 2008 575000 766484
8238 8238 158 TWN Taiwan 1 East Asia and Oceania 4 High Income Country HIC 54 EAP East Asian and Pacific Affairs Taiwan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 39 Department of State and U.S. Agency for International Development State/USAID   345115000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Export Control and Related Border Security Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Export Control and Related Border Security Assistance 1 Appropriated and Planned 2007 575000 782470
8240 8240 158 TWN Taiwan 1 East Asia and Oceania 4 High Income Country HIC 54 EAP East Asian and Pacific Affairs Taiwan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 39 Department of State and U.S. Agency for International Development State/USAID   345115000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Export Control and Related Border Security Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Export Control and Related Border Security Assistance 1 Appropriated and Planned 2009 575000 758773
8241 8241 158 TWN Taiwan 1 East Asia and Oceania 4 High Income Country HIC 54 EAP East Asian and Pacific Affairs Taiwan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 39 Department of State and U.S. Agency for International Development State/USAID   345115000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Export Control and Related Border Security Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Export Control and Related Border Security Assistance 1 Appropriated and Planned 2010 575000 752231
8244 8244 158 TWN Taiwan 1 East Asia and Oceania 4 High Income Country HIC 54 EAP East Asian and Pacific Affairs Taiwan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 39 Department of State and U.S. Agency for International Development State/USAID   345115000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Export Control and Related Border Security Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Export Control and Related Border Security Assistance 18 President's Budget Requests 2010 575000 752231
17289 17289 356 IND India 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs India 7 Other 430 Other Multisector 43010 Multisector aid 9 Multi-sector 52 Multi-sector - Unspecified 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 2007 575000 782470
27350 27350 498 MDA Moldova 2 Europe and Eurasia 2 Lower Middle Income Country LMIC 55 EUR European and Eurasian Affairs Moldova 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 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 2007 575000 782470
29398 29398 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345105000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance 1 Appropriated and Planned 2015 575000 689682
29405 29405 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345105000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance 18 President's Budget Requests 2014 575000 697589
29406 29406 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 39 Department of State and U.S. Agency for International Development State/USAID   345105000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance 18 President's Budget Requests 2015 575000 689682
29418 29418 524 NPL Nepal 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Nepal 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 2 Combating Weapons of Mass Destruction (WMD) 39 Department of State and U.S. Agency for International Development State/USAID   345105000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Antiterrorism Assistance 1 Appropriated and Planned 2014 575000 697589
36486 36486 703 SVK Slovak Republic 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Slovakia 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345038000 Budget for International Military Education and Training Budget for International Military Education and Training 18 President's Budget Requests 2019 575000 643986
36487 36487 703 SVK Slovak Republic 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Slovakia 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345038000 Budget for International Military Education and Training Budget for International Military Education and Training 18 President's Budget Requests 2020 575000 635508
36488 36488 703 SVK Slovak Republic 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Slovakia 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   345038000 Budget for International Military Education and Training Budget for International Military Education and Training 18 President's Budget Requests 2021 575000 614840
36510 36510 703 SVK Slovak Republic 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data Slovakia 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   344904000 Budget for International Military Education and Training Budget for International Military Education and Training 18 President's Budget Requests 2022 575000 575000
36511 36511 703 SVK Slovak Republic 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data Slovakia 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   344904000 Budget for International Military Education and Training Budget for International Military Education and Training 18 President's Budget Requests 2023 575000 548434
36512 36512 703 SVK Slovak Republic 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data Slovakia 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   344904000 Budget for International Military Education and Training Budget for International Military Education and Training 18 President's Budget Requests 2024 575000 535773
40306 40306 762 TJK Tajikistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Tajikistan 7 Other 430 Other Multisector 43010 Multisector aid 9 Multi-sector 52 Multi-sector - Unspecified 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 575000 635508
42679 42679 804 UKR Ukraine 2 Europe and Eurasia 2 Lower Middle Income Country LMIC 55 EUR European and Eurasian Affairs Ukraine 3 Governance 151 Government and Civil Society 15110 Public sector policy and administrative management 5 Economic Development 25 Macroeconomic Foundation for Growth 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 2007 575000 782470
49500 49500 1002 WLD World 7 World       54 EAP East Asian and Pacific Affairs State East Asia and Pacific Regional 3 Governance 151 Government and Civil Society 15160 Human rights 2 Democracy, Human Rights, and Governance 7 Rule of Law and Human Rights 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 2013 575000 711085
50054 50054 1002 WLD World 7 World       55 EUR European and Eurasian Affairs Europe and Eurasia Regional 3 Governance 151 Government and Civil Society 15110 Public sector policy and administrative management 5 Economic Development 25 Macroeconomic Foundation for Growth 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2019 575000 643986
50055 50055 1002 WLD World 7 World       55 EUR European and Eurasian Affairs Europe and Eurasia Regional 3 Governance 151 Government and Civil Society 15110 Public sector policy and administrative management 5 Economic Development 25 Macroeconomic Foundation for Growth 39 Department of State and U.S. Agency for International Development State/USAID 1 344992000 Budget for Economic Support Fund and Development Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund and Development Fund - Overseas Contingency Operations (OCO) 18 President's Budget Requests 2018 575000 656599
51437 51437 1002 WLD World 7 World       57 SCA South and Central Asian Affairs State South and Central Asia Regional 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 35 Natural Resources and Biodiversity 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 2016 575000 684014
51674 51674 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs State Western Hemisphere Regional 3 Governance 151 Government and Civil Society 15111 Public finance management 2 Democracy, Human Rights, and Governance 9 Political Competition and Consensus-Building 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 2014 575000 697589
53130 53130 1002 WLD World 7 World       62 INL International Narcotics and Law Enforcement Affairs INL - International Organizations 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2018 575000 656599
55438 55438 1002 WLD World 7 World       125 LAB Global Development Lab IDEA - Mobile Solutions 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 2012 575000 724098
61011 61011 1022 MEN Middle East Region 3 Middle East and North Africa       37 ANE Bureau for Asia and Near East Asia Middle East Regional 1 Education 112 Basic Education 11220 Primary education 4 Education and Social Services 20 Basic Education 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 2007 575000 782470
62003 62003 1033 SSN Sub-Saharan Africa Region 5 Sub-Saharan Africa       998   Unknown - Budget Data Africa Regional (DOS) 7 Other 430 Other Multisector 43010 Multisector aid 9 Multi-sector 52 Multi-sector - Unspecified 39 Department of State and U.S. Agency for International Development State/USAID   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2021 575000 614840

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