./us_foreign_budget_complete

20 rows where current_amount = 1320000

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: International Category ID, US Sector ID, Funding Account Name, 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
1173 1173 8 ALB Albania 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Albania 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   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 2011 1320000 1692745
1177 1177 8 ALB Albania 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Albania 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   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 1320000 1692745
1627 1627 12 DZA Algeria 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Algeria 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 1320000 1507323
1797 1797 24 AGO Angola 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Angola 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 2007 1320000 1796278
6353 6353 112 BLR Belarus 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Belarus 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   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 2018 1320000 1507323
9797 9797 180 COD Congo (Kinshasa) 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Democratic Republic of the Congo 2 Health and Population 130 Maternal and Child Health, Family Planning 13030 Family planning 3 Health 17 Family Planning and Reproductive Health 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 1320000 1411460
10420 10420 214 DOM Dominican Republic 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Dominican Republic 2 Health and Population 122 Basic Health 12263 Tuberculosis control 3 Health 12 Tuberculosis 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 2007 1320000 1796278
12101 12101 231 ETH Ethiopia 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Ethiopia 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   344905000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2022 1320000 1320000
13199 13199 268 GEO Georgia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Georgia 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   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 1320000 1796278
17690 17690 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Indonesia 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   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2016 1320000 1570259
25134 25134 454 MWI Malawi 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Malawi 5 Economic Growth 250 Business and Other Services 25010 Business Policy and Administation 5 Economic Development 30 Private Sector Competitiveness 39 Department of State and U.S. Agency for International Development State/USAID   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2008 1320000 1759581
27852 27852 499 MNE Montenegro 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Montenegro 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 2023 1320000 1259014
32517 32517 600 PRY Paraguay 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Paraguay 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 2009 1320000 1741880
34546 34546 643 RUS Russia 2 Europe and Eurasia 3 Upper Middle Income Country UMIC 55 EUR European and Eurasian Affairs Russia 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 2009 1320000 1741880
36734 36734 704 VNM Vietnam 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Vietnam 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   345104000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs 1 Appropriated and Planned 2011 1320000 1692745
36745 36745 704 VNM Vietnam 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Vietnam 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   345104000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs 18 President's Budget Requests 2011 1320000 1692745
36758 36758 704 VNM Vietnam 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Vietnam 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   345119000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Humanitarian Demining Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Humanitarian Demining 1 Appropriated and Planned 2009 1320000 1741880
36760 36760 704 VNM Vietnam 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Vietnam 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   345119000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Humanitarian Demining Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Humanitarian Demining 18 President's Budget Requests 2009 1320000 1741880
36761 36761 704 VNM Vietnam 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Vietnam 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   345119000 Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Humanitarian Demining Budget for Nonproliferation, Anti-Terrorism, Demining and Related Programs - Humanitarian Demining 18 President's Budget Requests 2010 1320000 1726861
54486 54486 1002 WLD World 7 World       67 PRM Population, Refugees, and Migration PRM, Administrative Expenses 3 Governance 151 Government and Civil Society 15190 Facilitation of orderly, safe, regular and responsible migration and mobility 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   345096000 Budget for Migration and Refugee Assistance, Department of State Budget for Migration and Refugee Assistance, Department of State 1 Appropriated and Planned 2019 1320000 1478367

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