./us_foreign_budget_complete

32 rows where Country ID = 818, Fiscal Year = 2017 and Region ID = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: International Category ID, International Category Name, 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, Activity ID, Activity Name, Activity Description, Transaction Type ID, Transaction Type Name, current_amount, 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
43764 43764 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 18 President's Budget Requests 2017 13000000 15193411
43792 43792 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2017 35000000 40905336
43794 43794 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2017 35000000 40905336
43817 43817 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 2 Health and Population 122 Basic Health 12220 Basic health care 3 Health 15 Other Public Health Threats 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 2017 2000000 2337448
43843 43843 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2017 3000000 3506172
43860 43860 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 2 Health and Population 130 Maternal and Child Health, Family Planning 13030 Family planning 3 Health 17 Family Planning and Reproductive Health 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 2017 5000000 5843619
43862 43862 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 2 Health and Population 130 Maternal and Child Health, Family Planning 13030 Family planning 3 Health 17 Family Planning and Reproductive Health 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 2017 5036000 5885694
43876 43876 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 2017 8000000 9349791
43892 43892 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 18 President's Budget Requests 2017 5000000 5843619
43902 43902 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 18 President's Budget Requests 2017 750000 876543
43926 43926 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 18 President's Budget Requests 2017 8550000 9992589
43948 43948 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2017 1000000 1168724
43960 43960 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 18 President's Budget Requests 2017 2000000 2337448
43965 43965 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 1 345042000 Budget for International Narcotics Control and Law Enforcement - Overseas Contingency Operations (OCO) Budget for International Narcotics Control and Law Enforcement - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2017 2000000 2337448
43987 43987 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 18 President's Budget Requests 2017 4700000 5493002
43989 43989 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2017 5826000 6808985
44006 44006 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 2017 1500000 1753086
44018 44018 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 2017 1500000 1753086
44043 44043 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 2017 1500000 1753086
44052 44052 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 2017 1500000 1753086
44088 44088 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 2017 1739000 2032411
44101 44101 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 2017 1800000 2103703
44117 44117 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 2017 1039300000 1214654747
44130 44130 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 18 President's Budget Requests 2017 1300000000 1519341067
44136 44136 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 1 345003000 Budget for Foreign Military Financing Program - Overseas Contingency Operations (OCO) Budget for Foreign Military Financing Program - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2017 195000000 227901160
44143 44143 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 24 Social Assistance 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 2017 8000000 9349791
44158 44158 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 18 President's Budget Requests 2017 10776000 12594169
44182 44182 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 18 President's Budget Requests 2017 10611000 12401329
44205 44205 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2017 4000000 4674896
44207 44207 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2017 3500000 4090534
44240 44240 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 18 President's Budget Requests 2017 30613000 35778145
44243 44243 818 EGY Egypt 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs Egypt 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 1 344986000 Budget for Economic Support Fund - Overseas Contingency Operations (OCO) Budget for Economic Support Fund - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2017 63138000 73790889

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