./us_foreign_budget_complete

31 rows where Funding Account ID = "72x1037", Income Group Acronym = "HIC" and Region ID = 2

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country Code, Managing Sub-agency or Bureau ID, Operating Unit, International Sector Name, International Purpose Name, US Sector ID, 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
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
18776 18776 372 IRL Ireland 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Ireland 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2008 500000 666508
18777 18777 372 IRL Ireland 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Ireland 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 1 Appropriated and Planned 2006 1386000 1937815
18778 18778 372 IRL Ireland 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Ireland 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 1 Appropriated and Planned 2007 1387000 1887453
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
33824 33824 616 POL Poland 2 Europe and Eurasia 4 High Income Country HIC 55 EUR European and Eurasian Affairs Poland 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 2016 3000000 3568770
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
);