./us_foreign_budget_complete

39 rows where current_amount = 475000

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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 Account ID, Funding Account Name, Funding Agency ID, Funding Agency Name, Funding Agency Acronym, Activity ID, Activity Name, Activity Description, Transaction Type ID, Transaction Type Name, Fiscal Year, constant_amount

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
2403 2403 31 AZE Azerbaijan 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Azerbaijan 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 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 2012 475000 598168
6878 6878 116 KHM Cambodia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Cambodia 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 2013 475000 587418
10768 10768 218 ECU Ecuador 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Ecuador 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 2006 475000 664114
15876 15876 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs Haiti 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2015 475000 569738
17901 17901 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Indonesia 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 1 Appropriated and Planned 2011 475000 609132
17904 17904 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Indonesia 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 1 Appropriated and Planned 2014 475000 576269
17905 17905 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Indonesia 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 1 Appropriated and Planned 2015 475000 569738
17906 17906 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Indonesia 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 1 Appropriated and Planned 2016 475000 565055
17917 17917 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Indonesia 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 2014 475000 576269
17918 17918 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Indonesia 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 2015 475000 569738
17919 17919 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Indonesia 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 2016 475000 565055
21555 21555 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 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 475000 626813
21556 21556 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 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 475000 621408
21558 21558 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 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 2010 475000 621408
21559 21559 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 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 475000 609132
21560 21560 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 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 2012 475000 598168
21660 21660 417 KGZ Kyrgyzstan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Kyrgyz Republic 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 1 344948000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) - International Narcotics and Law Enforcement - Overseas Contingency Operations (OCO) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) - International Narcotics and Law Enforcement - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2016 475000 565055
24595 24595 450 MDG Madagascar 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Madagascar 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 1 Appropriated and Planned 2018 475000 542408
27095 27095 496 MNG Mongolia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Mongolia 10 Administrative Costs 912 Program Design and Learning 91020 Program Design and Learning 8 Program Support 41 Direct Administrative Costs 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 2007 475000 646388
27638 27638 499 MNE Montenegro 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Montenegro 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   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 475000 646388
28874 28874 512 OMN Oman 3 Middle East and North Africa 4 High Income Country HIC 56 NEA Near Eastern Affairs Oman 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 2013 475000 587418
32432 32432 600 PRY Paraguay 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Paraguay 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 2007 475000 646388
34160 34160 626 TLS Timor-Leste 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Timor-Leste 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 2007 475000 646388
34319 34319 642 ROU Romania 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Romania 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 2006 475000 664114
34610 34610 643 RUS Russia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Russia 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   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 2011 475000 609132
36366 36366 694 SLE Sierra Leone 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Sierra Leone 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 2009 475000 626813
36407 36407 694 SLE Sierra Leone 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Sierra Leone 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   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2022 475000 475000
43461 43461 807 MKD North Macedonia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs North Macedonia 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 475000 646388
43641 43641 807 MKD North Macedonia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs North Macedonia 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 2010 475000 621408
45409 45409 860 UZB Uzbekistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Uzbekistan 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2014 475000 576269
45416 45416 860 UZB Uzbekistan 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs Uzbekistan 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 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2013 475000 587418
48165 48165 1002 WLD World 7 World       53 AF African Affairs USAID Africa Regional 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2007 475000 646388
49363 49363 1002 WLD World 7 World       54 EAP East Asian and Pacific Affairs State East Asia and Pacific 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2010 475000 621408
50100 50100 1002 WLD World 7 World       55 EUR European and Eurasian Affairs Europe and Eurasia Regional 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 1 344948000 Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) - International Narcotics and Law Enforcement - Overseas Contingency Operations (OCO) Budget for Assistance for Europe, Eurasia and Central Asia (AEECA) - International Narcotics and Law Enforcement - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2016 475000 565055
50701 50701 1002 WLD World 7 World       56 NEA Near Eastern Affairs Trans-Sahara Counter-Terrorism Partnership (TSCTP) 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   345132000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Terrorist Interdiction Program Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Terrorist Interdiction Program 1 Appropriated and Planned 2013 475000 587418
52429 52429 1002 WLD World 7 World       58 WHA Western Hemisphere Affairs USAID Latin America and Caribbean 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2009 475000 626813
60020 60020 1006 ASN Asia Region 7 World       998   Unknown - Budget Data East Asia and Pacific 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 475000 507912
60831 60831 1018 EUN Europe Region 2 Europe and Eurasia       55 EUR European and Eurasian Affairs Europe Regional 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 2013 475000 587418
60909 60909 1019 EUS Eurasia Region 2 Europe and Eurasia       998   Unknown - Budget Data Defense Nuclear Nonproliferation (DNN) 7 Other 430 Other Multisector 43082 Research/scientific institutions 9 Multi-sector 52 Multi-sector - Unspecified 13 Department of Energy DOE   344858000 Budget for Office of Nuclear Verification (NA-243), Seismic Cooperation Program Budget for Office of Nuclear Verification (NA-243), Seismic Cooperation Program 18 President's Budget Requests 2024 475000 442595

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