./us_foreign_budget_complete

11 rows where Income Group Name = "Lower Middle Income Country", International Sector Code = 310 and Operating Unit = "Nicaragua"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type Name

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
29997 29997 558 NIC Nicaragua 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Nicaragua 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 4280000 5984017
29998 29998 558 NIC Nicaragua 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Nicaragua 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 197000 268081
29999 29999 558 NIC Nicaragua 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Nicaragua 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2080000 2772673
30000 30000 558 NIC Nicaragua 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Nicaragua 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2629000 3469244
30001 30001 558 NIC Nicaragua 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Nicaragua 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 6941000 9080409
30002 30002 558 NIC Nicaragua 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Nicaragua 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2011 4000000 5129532
30003 30003 558 NIC Nicaragua 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Nicaragua 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 2360000 3145917
30004 30004 558 NIC Nicaragua 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Nicaragua 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 3684000 4861428
30005 30005 558 NIC Nicaragua 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Nicaragua 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 24300000 31789934
30006 30006 558 NIC Nicaragua 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Nicaragua 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 16476000 21128541
30007 30007 558 NIC Nicaragua 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs Nicaragua 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 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 5000000 6296500

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