./us_foreign_budget_complete

39 rows where International Purpose Code = 15111 and Managing Sub-agency or Bureau ID = 59

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Funding Account Name, Activity Name, current_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
52632 52632 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor DRL - China 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2008 1749000 2331445
52633 52633 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor DRL - China 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2009 1000000 1319606
52634 52634 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor DRL - China 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2010 1500000 1962342
52635 52635 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor DRL - China 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 2009 6120000 8075989
52636 52636 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor DRL - China 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 2010 1500000 1962342
52637 52637 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor DRL - China 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 2011 1000000 1282383
52658 52658 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor DRL - Global Funds 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2008 1212000 1615615
52659 52659 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor DRL - Global Funds 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2009 7450000 9831065
52660 52660 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor DRL - Global Funds 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2010 4000000 5232911
52661 52661 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor DRL - Global Funds 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 2009 4080000 5383992
52662 52662 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor DRL - Global Funds 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 2010 4000000 5232911
52663 52663 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor DRL - Global Funds 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 2011 4000000 5129532
52683 52683 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor DRL - Muslim World Outside the Middle East 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2009 650000 857744
52684 52684 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor DRL - Muslim World Outside the Middle East 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2010 1500000 1962342
52685 52685 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor DRL - Muslim World Outside the Middle East 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 2010 1500000 1962342
52686 52686 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor DRL - Muslim World Outside the Middle East 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 2011 2000000 2564766
52705 52705 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2006 8544000 11945664
52706 52706 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2007 8544000 11626820
52707 52707 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2011 1250000 1602979
52708 52708 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2012 500000 629650
52709 52709 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2013 975000 1205752
52710 52710 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2014 750000 909899
52711 52711 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2015 1600000 1919116
52712 52712 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2016 3900000 4639401
52713 52713 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2017 9250000 10810696
52714 52714 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2018 22650000 25864295
52715 52715 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2019 25050000 28055376
52716 52716 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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   344972000 Budget for Democracy Fund, Department of State Budget for Democracy Fund, Department of State 1 Appropriated and Planned 2020 47000000 51945849
52717 52717 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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 2008 6000000 7998095
52718 52718 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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 2012 2037000 2565194
52719 52719 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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 2013 1750000 2164171
52720 52720 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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 2014 1600000 1941118
52721 52721 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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 2015 1880000 2254961
52722 52722 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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 2016 1880000 2236429
52723 52723 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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 2000000 2337448
52724 52724 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2018 2500000 2854779
52725 52725 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2019 2500000 2799938
52726 52726 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 11700000 12931201
52727 52727 1002 WLD World 7 World       59 DRL Democracy, Human Rights, and Labor State Democracy, Human Rights, and Labor (DRL) 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   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2021 15983000 17090424

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