home / 2025-02-03_foreign-assistance

./us_foreign_budget_complete

11 rows where current_amount = 427000

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: US Category ID, Funding Account Name, Transaction Type 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 Account ID Funding Account 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
2653 2653 48 BHR Bahrain 3 Middle East and North Africa 4 High Income Country HIC 56 NEA Near Eastern Affairs Bahrain 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 11x1075 Nonproliferation, Anti-Terrorism, Demining and Related Programs 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 427000 528058
8521 8521 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 11x1075 Nonproliferation, Anti-Terrorism, Demining and Related Programs 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 427000 569198
10856 10856 218 ECU Ecuador 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs 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 11x1082 Foreign Military Financing Program 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 427000 528058
12693 12693 268 GEO Georgia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Georgia 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 72x0306 Assistance for Europe, Eurasia and Central Asia (AEECA) 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 2012 427000 537721
15686 15686 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs   9 Humanitarian 740 Disaster Prevention and Preparedness 74020 Multi-hazard response preparedness 7 Humanitarian Assistance 38 Disaster Readiness 12x2278 Public Law 480 Title II Grants 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2010 427000 558613
19467 19467 398 KAZ Kazakhstan 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Kazakhstan 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 11x1075 Nonproliferation, Anti-Terrorism, Demining and Related Programs 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 427000 528058
21750 21750 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 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 11x1075 Nonproliferation, Anti-Terrorism, Demining and Related Programs 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 427000 528058
25451 25451 462 MDV Maldives 4 South and Central Asia 3 Upper Middle Income Country UMIC 57 SCA South and Central Asian Affairs Maldives 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 1 Counter-Terrorism 11x1075 Nonproliferation, Anti-Terrorism, Demining and Related Programs 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 427000 528058
37143 37143 705 SVN Slovenia 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Slovenia 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 11x1082 Foreign Military Financing Program 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 427000 528058
45234 45234 858 URY Uruguay 6 Western Hemisphere 4 High Income Country HIC 58 WHA Western Hemisphere Affairs Uruguay 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 11x1081 International Military Education and Training 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 2009 427000 563472
45238 45238 858 URY Uruguay 6 Western Hemisphere 4 High Income Country HIC 58 WHA Western Hemisphere Affairs Uruguay 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 11x1081 International Military Education and Training 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 2013 427000 528058

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
);
Powered by Datasette · Queries took 5355.376ms