./us_foreign_budget_complete

32 rows where current_amount = 5250000

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: International Sector Code, International Purpose Code, Activity 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
4943 4943 70 BIH Bosnia and Herzegovina 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Bosnia and Herzegovina 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   344936000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs 1 Appropriated and Planned 2023 5250000 5007441
4945 4945 70 BIH Bosnia and Herzegovina 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Bosnia and Herzegovina 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   344936000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs 18 President's Budget Requests 2023 5250000 5007441
7696 7696 144 LKA Sri Lanka 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Sri Lanka 5 Economic Growth 331 Trade Policy and Regulations 33110 Trade policy and administrative management 5 Economic Development 26 Trade and Investment 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 2021 5250000 5613760
10398 10398 214 DOM Dominican Republic 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Dominican Republic 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 2009 5250000 6927931
10973 10973 218 ECU Ecuador 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Ecuador 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   344905000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2024 5250000 4891842
13629 13629 275 PSE West Bank and Gaza 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs West Bank and Gaza 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 2010 5250000 6868196
13788 13788 275 PSE West Bank and Gaza 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs West Bank and Gaza 5 Economic Growth 331 Trade Policy and Regulations 33110 Trade policy and administrative management 5 Economic Development 26 Trade and Investment 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 2012 5250000 6611325
14627 14627 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs   6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 18 President's Budget Requests 2009 5250000 6927931
15892 15892 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs Haiti 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 2006 5250000 7340208
17534 17534 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Indonesia 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2009 5250000 6927931
17535 17535 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Indonesia 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2010 5250000 6868196
17536 17536 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Indonesia 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 1 Appropriated and Planned 2011 5250000 6732510
17545 17545 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Indonesia 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   345014000 Budget for Global Health Programs Budget for Global Health Programs 18 President's Budget Requests 2011 5250000 6732510
19042 19042 384 CIV Cote d'Ivoire 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Cote d'Ivoire 3 Governance 151 Government and Civil Society 15150 Democratic participation and civil society 2 Democracy, Human Rights, and Governance 10 Civil Society 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2022 5250000 5250000
20755 20755 404 KEN Kenya 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Kenya 2 Health and Population 130 Maternal and Child Health, Family Planning 13020 Reproductive health care 3 Health 16 Maternal and Child Health 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 5250000 6927931
22482 22482 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Lebanon 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   344996000 Budget for Economic Support Fund, H.R. 2206 Supplemental Budget for Economic Support Fund, H.R. 2206 Supplemental 1 Appropriated and Planned 2007 5250000 7144289
23994 23994 434 LBY Libya 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Libya 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 5250000 5879869
26731 26731 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 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   345002000 Budget for Foreign Military Financing Program Budget for Foreign Military Financing Program 1 Appropriated and Planned 2010 5250000 6868196
28278 28278 504 MAR Morocco 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Morocco 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   344905000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2022 5250000 5250000
30282 30282 562 NER Niger 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Niger 2 Health and Population 122 Basic Health 12240 Basic nutrition 3 Health 19 Nutrition 39 Department of State and U.S. Agency for International Development State/USAID   344902000 Budget for Global Health Programs - USAID Budget for Global Health Programs - USAID 1 Appropriated and Planned 2021 5250000 5613760
31734 31734 586 PAK Pakistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Pakistan 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 5250000 5802462
36882 36882 704 VNM Vietnam 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Vietnam 5 Economic Growth 331 Trade Policy and Regulations 33110 Trade policy and administrative management 5 Economic Development 26 Trade and Investment 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 2017 5250000 6135800
37882 37882 710 ZAF South Africa 5 Sub-Saharan Africa 3 Upper Middle Income Country UMIC 53 AF African Affairs South Africa 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 2008 5250000 6998333
38391 38391 716 ZWE Zimbabwe 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Zimbabwe 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   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 5250000 6927931
44621 44621 834 TZA Tanzania 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Tanzania 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2011 5250000 6732510
50522 50522 1002 WLD World 7 World       56 NEA Near Eastern Affairs Middle East Partnership Initiative (MEPI) 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2008 5250000 6998333
50542 50542 1002 WLD World 7 World       56 NEA Near Eastern Affairs Middle East Partnership Initiative (MEPI) 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 5250000 5802462
57116 57116 1002 WLD World 7 World       998   Unknown - Budget Data DCHA/OTI 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   345186000 Budget for Transition Initiatives, International Assistance Program Budget for Transition Initiatives, International Assistance Program 18 President's Budget Requests 2009 5250000 6927931
58937 58937 1002 WLD World 7 World       998   Unknown - Budget Data USAID 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2020 5250000 5802462
59487 59487 1002 WLD World 7 World       998   Unknown - Budget Data USAID Economic Growth, Education and Environment (E3) 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 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 2011 5250000 6732510
59923 59923 1006 ASN Asia Region 7 World       998   Unknown - Budget Data Asia Regional (USAID) 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2021 5250000 5613760
61250 61250 1022 MEN Middle East Region 3 Middle East and North Africa       56 NEA Near Eastern Affairs State NEA Regional 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 2021 5250000 5613760

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