./us_foreign_budget_complete

29 rows where Income Group Acronym = "HIC" and International Purpose Name = "Civilian peace-building, conflict prevention and resolution"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country Code, Operating Unit, Funding Account 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 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
10122 10122 196 CYP Cyprus 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Cyprus 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 2006 19800000 27683069
10123 10123 196 CYP Cyprus 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Cyprus 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 2007 17800000 24222542
10124 10124 196 CYP Cyprus 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Cyprus 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 2008 10911000 14544535
10125 10125 196 CYP Cyprus 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Cyprus 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 2009 11000000 14515666
10126 10126 196 CYP Cyprus 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Cyprus 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 2010 11000000 14390505
10127 10127 196 CYP Cyprus 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Cyprus 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 2011 8362000 10723286
10128 10128 196 CYP Cyprus 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Cyprus 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 2012 3500000 4407550
10129 10129 196 CYP Cyprus 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Cyprus 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 2013 2925000 3617257
10130 10130 196 CYP Cyprus 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Cyprus 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 11000000 14663173
10131 10131 196 CYP Cyprus 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Cyprus 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 11000000 14515666
10132 10132 196 CYP Cyprus 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Cyprus 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 11000000 14390505
10133 10133 196 CYP Cyprus 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Cyprus 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 11000000 14106212
10134 10134 196 CYP Cyprus 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Cyprus 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 3500000 4407550
10135 10135 196 CYP Cyprus 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Cyprus 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 3200000 3957341
18772 18772 372 IRL Ireland 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Ireland 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 2006 2079000 2906722
18773 18773 372 IRL Ireland 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Ireland 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 2007 2078000 2827778
18774 18774 372 IRL Ireland 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Ireland 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 2008 992000 1322352
18775 18775 372 IRL Ireland 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Ireland 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 500000 666508
18779 18779 372 IRL Ireland 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data International Fund for Ireland (USAID) 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 39 Department of State and U.S. Agency for International Development State/USAID   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2021 2500000 2673219
18780 18780 372 IRL Ireland 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data International Fund for Ireland (USAID) 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 39 Department of State and U.S. Agency for International Development State/USAID   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2022 3000000 3000000
18781 18781 372 IRL Ireland 2 Europe and Eurasia 4 High Income Country HIC 998   Unknown - Budget Data International Fund for Ireland (USAID) 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 39 Department of State and U.S. Agency for International Development State/USAID   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2023 4000000 3815194
33877 33877 616 POL Poland 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Poland 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 2012 3000000 3777900
33878 33878 616 POL Poland 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Poland 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 3000000 3777900
33879 33879 616 POL Poland 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Poland 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 2013 5893000 7287690
33880 33880 616 POL Poland 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Poland 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 2014 5893000 7149379
33881 33881 616 POL Poland 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Poland 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 2015 3000000 3598343
33882 33882 616 POL Poland 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Poland 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 3000000 3710007
33883 33883 616 POL Poland 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Poland 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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 3000000 3639595
33884 33884 616 POL Poland 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Poland 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 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

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