./us_foreign_budget_complete

34 rows where Fiscal Year = 2020, International Purpose Code = 15150 and Region ID = 6

✎ View and edit SQL

This data as json, CSV (advanced)

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
8351 8351 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 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 2020 12861000 14214374
8363 8363 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 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 1 Appropriated and Planned 2020 9000000 9947077
8376 8376 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 4648000 5137113
8378 8378 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2020 8000000 8841847
8389 8389 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 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 1 Appropriated and Planned 2020 6000000 6631385
8400 8400 170 COL Colombia 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Colombia 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 1700000 1878892
10062 10062 192 CUB Cuba 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Cuba 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 1 Appropriated and Planned 2020 16418000 18145680
10074 10074 192 CUB Cuba 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Cuba 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 4000000 4420923
10810 10810 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 10 Civil Society 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 1000000 1105231
11137 11137 222 SLV El Salvador 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs El Salvador 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 2020 26730000 29542820
11154 11154 222 SLV El Salvador 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs El Salvador 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 8110000 8963422
11158 11158 222 SLV El Salvador 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs El Salvador 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2020 1525000 1685477
14841 14841 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 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 2020 12000000 13262770
14857 14857 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 14150000 15639016
14868 14868 320 GTM Guatemala 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Guatemala 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 3500000 3868308
15941 15941 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs Haiti 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 2020 1890000 2088886
15966 15966 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs Haiti 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 2000000 2210462
15982 15982 332 HTI Haiti 6 Western Hemisphere 1 Low Income Country LIC 58 WHA Western Hemisphere Affairs Haiti 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 1000000 1105231
16573 16573 340 HND Honduras 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Honduras 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 2020 12723000 14061852
16587 16587 340 HND Honduras 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Honduras 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 17398000 19228806
16601 16601 340 HND Honduras 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Honduras 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2020 4102000 4533657
16614 16614 340 HND Honduras 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Honduras 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 4102000 4533657
26545 26545 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 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 1 Appropriated and Planned 2020 11100000 12268062
26553 26553 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 10000000 11052308
26567 26567 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 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 1 Appropriated and Planned 2020 6000000 6631385
26576 26576 484 MEX Mexico 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Mexico 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 2250000 2486769
29919 29919 558 NIC Nicaragua 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Nicaragua 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2020 7600000 8399754
29931 29931 558 NIC Nicaragua 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Nicaragua 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 5000000 5526154
32391 32391 600 PRY Paraguay 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Paraguay 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 2020 1860000 2055729
32405 32405 600 PRY Paraguay 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Paraguay 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 1000000 1105231
32681 32681 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 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 2020 3500000 3868308
45835 45835 862 VEN Venezuela 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Venezuela 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 1200000 1326277
45852 45852 862 VEN Venezuela 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Venezuela 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 1 Appropriated and Planned 2020 17950000 19838893
45863 45863 862 VEN Venezuela 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Venezuela 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 3600000 3978831

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