./us_foreign_budget_complete

14 rows where Country ID = 604, International Sector Name = "Trade Policy and Regulations" and Region Name = "Western Hemisphere"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type ID, Fiscal Year, 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
32835 32835 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2006 1520000 2125165
32836 32836 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2007 1240000 1687413
32837 32837 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2008 2200000 2932635
32838 32838 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2009 5843000 7710458
32839 32839 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2010 5443000 7120683
32840 32840 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2012 2617000 3295588
32841 32841 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 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   344980000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2020 10000000 11052308
32842 32842 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2008 4024000 5364055
32843 32843 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2009 5843000 7710458
32844 32844 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2010 5443000 7120683
32845 32845 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2011 5000000 6411914
32846 32846 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 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   344980000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2012 3000000 3777900
32847 32847 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 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 1 Appropriated and Planned 2007 750000 1020613
32848 32848 604 PER Peru 6 Western Hemisphere 3 Upper Middle Income Country UMIC 58 WHA Western Hemisphere Affairs Peru 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 1 Appropriated and Planned 2008 1000000 1333016

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