./us_foreign_budget_complete

38 rows where International Sector Code = 151 and Managing Sub-agency or Bureau ID = 69

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Activity 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
54869 54869 1002 WLD World 7 World       69 TIP Trafficking in Persons Ending Modern Slavery (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2017 25000000 29218097
54870 54870 1002 WLD World 7 World       69 TIP Trafficking in Persons Ending Modern Slavery (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2018 25000000 28547787
54871 54871 1002 WLD World 7 World       69 TIP Trafficking in Persons Ending Modern Slavery (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2019 25000000 27999377
54872 54872 1002 WLD World 7 World       69 TIP Trafficking in Persons Ending Modern Slavery (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2020 25000000 27630771
54873 54873 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2008 5951000 7932777
54874 54874 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2009 8400000 11084690
54875 54875 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2010 9262000 12116805
54876 54876 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2011 16233000 20816921
54877 54877 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2012 18720000 23574096
54878 54878 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2013 20723000 25627491
54879 54879 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2014 24041000 29166504
54880 54880 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2015 20723000 24856152
54881 54881 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2016 53153000 63230279
54882 54882 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2017 28290000 33063199
54883 54883 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2018 32000000 36541168
54884 54884 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2019 36000000 40319104
54885 54885 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2020 36000000 39788310
54886 54886 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2009 7767000 10249380
54887 54887 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2010 9262000 12116805
54888 54888 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2011 20400000 26160611
54889 54889 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2012 20808000 26203514
54890 54890 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2013 18720000 23150443
54891 54891 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2014 18720000 22711075
54892 54892 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2015 20723000 24856152
54893 54893 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2016 20723000 24651874
54894 54894 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2017 20723000 24219465
54895 54895 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2018 17000000 19412495
54896 54896 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2019 17000000 19039577
54897 54897 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2020 22000000 24315078
54898 54898 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 39 Department of State and U.S. Agency for International Development State/USAID   345040000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2021 22000000 23524327
54899 54899 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 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 11880000 16609841
54900 54900 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 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 8500000 11566944
54901 54901 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 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 11903000 15866887
54902 54902 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 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 12000000 15835272
54903 54903 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 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 12000000 15698733
54904 54904 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 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 6700000 8931206
54905 54905 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 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 7183000 9478730
54906 54906 1002 WLD World 7 World       69 TIP Trafficking in Persons State Office to Monitor and Combat Trafficking in Persons (J/TIP) 3 Governance 151 Government and Civil Society 15130 Legal and judicial development 1 Peace and Security 5 Transnational Crime 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 7183000 9397000

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