./us_foreign_budget_complete

23 rows where Funding Account Name = "Department of State, International Organizations and Programs" and International Sector Code = 240

✎ View and edit SQL

This data as json, CSV (advanced)

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
53611 53611 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345077000 Budget for International Organizations and Programs, State - IO - UN Women Budget for International Organizations and Programs, State - IO - UN Women 1 Appropriated and Planned 2008 3571000 4760199
53612 53612 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345077000 Budget for International Organizations and Programs, State - IO - UN Women Budget for International Organizations and Programs, State - IO - UN Women 1 Appropriated and Planned 2009 4500000 5938227
53613 53613 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345077000 Budget for International Organizations and Programs, State - IO - UN Women Budget for International Organizations and Programs, State - IO - UN Women 1 Appropriated and Planned 2010 6000000 7849366
53614 53614 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345077000 Budget for International Organizations and Programs, State - IO - UN Women Budget for International Organizations and Programs, State - IO - UN Women 1 Appropriated and Planned 2011 6000000 7694297
53615 53615 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345077000 Budget for International Organizations and Programs, State - IO - UN Women Budget for International Organizations and Programs, State - IO - UN Women 1 Appropriated and Planned 2012 7500000 9444750
53616 53616 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345077000 Budget for International Organizations and Programs, State - IO - UN Women Budget for International Organizations and Programs, State - IO - UN Women 1 Appropriated and Planned 2013 7200000 8904016
53617 53617 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345077000 Budget for International Organizations and Programs, State - IO - UN Women Budget for International Organizations and Programs, State - IO - UN Women 1 Appropriated and Planned 2014 7500000 9098988
53618 53618 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345077000 Budget for International Organizations and Programs, State - IO - UN Women Budget for International Organizations and Programs, State - IO - UN Women 1 Appropriated and Planned 2015 7500000 8995857
53619 53619 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345077000 Budget for International Organizations and Programs, State - IO - UN Women Budget for International Organizations and Programs, State - IO - UN Women 18 President's Budget Requests 2009 950000 1253626
53620 53620 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345077000 Budget for International Organizations and Programs, State - IO - UN Women Budget for International Organizations and Programs, State - IO - UN Women 18 President's Budget Requests 2010 1500000 1962342
53621 53621 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345077000 Budget for International Organizations and Programs, State - IO - UN Women Budget for International Organizations and Programs, State - IO - UN Women 18 President's Budget Requests 2011 6000000 7694297
53622 53622 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345077000 Budget for International Organizations and Programs, State - IO - UN Women Budget for International Organizations and Programs, State - IO - UN Women 18 President's Budget Requests 2012 8000000 10074400
53623 53623 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345077000 Budget for International Organizations and Programs, State - IO - UN Women Budget for International Organizations and Programs, State - IO - UN Women 18 President's Budget Requests 2013 7900000 9769685
53624 53624 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345077000 Budget for International Organizations and Programs, State - IO - UN Women Budget for International Organizations and Programs, State - IO - UN Women 18 President's Budget Requests 2014 7500000 9098988
53625 53625 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345077000 Budget for International Organizations and Programs, State - IO - UN Women Budget for International Organizations and Programs, State - IO - UN Women 18 President's Budget Requests 2015 7500000 8995857
53626 53626 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345077000 Budget for International Organizations and Programs, State - IO - UN Women Budget for International Organizations and Programs, State - IO - UN Women 18 President's Budget Requests 2016 7700000 9159843
53627 53627 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345077000 Budget for International Organizations and Programs, State - IO - UN Women Budget for International Organizations and Programs, State - IO - UN Women 18 President's Budget Requests 2017 14000000 16362135
53630 53630 1002 WLD World 7 World       63 IO International Organization Affairs IO - UN Women Trust Fund (formerly UNIFEM Trust Fund) 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345078000 Budget for International Organizations and Programs, State - IO - UN Women Trust Fund (formerly UNIFEM Trust Fund) Budget for International Organizations and Programs, State - IO - UN Women Trust Fund (formerly UNIFEM Trust Fund) 1 Appropriated and Planned 2008 1785000 2379433
53827 53827 1002 WLD World 7 World       63 IO International Organization Affairs IO - United Nations Junior Professional Officer Program (UNJPO) 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345089000 Budget for International Organizations and Programs, State - IO - United Nations Junior Professional Officer Program (UNJPO) Budget for International Organizations and Programs, State - IO - United Nations Junior Professional Officer Program (UNJPO) 1 Appropriated and Planned 2014 1000000 1213198
53828 53828 1002 WLD World 7 World       63 IO International Organization Affairs IO - United Nations Junior Professional Officer Program (UNJPO) 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345089000 Budget for International Organizations and Programs, State - IO - United Nations Junior Professional Officer Program (UNJPO) Budget for International Organizations and Programs, State - IO - United Nations Junior Professional Officer Program (UNJPO) 1 Appropriated and Planned 2015 700000 839613
53829 53829 1002 WLD World 7 World       63 IO International Organization Affairs IO - United Nations Junior Professional Officer Program (UNJPO) 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345089000 Budget for International Organizations and Programs, State - IO - United Nations Junior Professional Officer Program (UNJPO) Budget for International Organizations and Programs, State - IO - United Nations Junior Professional Officer Program (UNJPO) 18 President's Budget Requests 2017 1000000 1168724
53884 53884 1002 WLD World 7 World       63 IO International Organization Affairs International Organizations (IO) 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345092000 Budget for International Organizations and Programs, State - International Organizations (IO) Budget for International Organizations and Programs, State - International Organizations (IO) 1 Appropriated and Planned 2006 4702000 6574030
53885 53885 1002 WLD World 7 World       63 IO International Organization Affairs International Organizations (IO) 5 Economic Growth 240 Banking and Financial Services 24010 Financial policy and administrative management 5 Economic Development 31 Economic Opportunity 39 Department of State and U.S. Agency for International Development State/USAID   345092000 Budget for International Organizations and Programs, State - International Organizations (IO) Budget for International Organizations and Programs, State - International Organizations (IO) 1 Appropriated and Planned 2007 4703000 6399922

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