./us_foreign_budget_complete

23 rows where Country ID = 608 and International Sector Name = "Other Social Infrastructure and Services"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Managing Sub-agency or Bureau ID, Managing Sub-agency or Bureau Name, International Purpose Code, International Purpose Name, US Category ID, US Category Name, US Sector ID, US Sector Name, Funding Account ID, Funding Account Name, Funding Agency ID, Funding Agency Name, Funding Agency Acronym, Activity ID, Activity Name, Activity Description, Transaction Type ID, Transaction Type Name, Fiscal Year, 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
33505 33505 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2019 3000000 3359925
33506 33506 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2020 3000000 3315692
33507 33507 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 3 Governance 160 Other Social Infrastructure and Services 16010 Social Protection 4 Education and Social Services 23 Social Services 39 Department of State and U.S. Agency for International Development State/USAID   344991000 Budget for Economic Support Fund and Development Fund Budget for Economic Support Fund and Development Fund 18 President's Budget Requests 2021 3000000 3207863
33508 33508 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 2007 100000 136082
33509 33509 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 500000 606599
33510 33510 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 2300000 2736057
33511 33511 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 2050000 2395884
33512 33512 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 2200000 2512205
33513 33513 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 500000 559988
33514 33514 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 360000 397883
33515 33515 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 2008 200000 266603
33516 33516 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 1750000 1998345
33517 33517 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 1400000 1567965
33518 33518 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 1000000 1105231
33519 33519 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 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 600000 641573
33686 33686 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2011 2410000 3090543
33687 33687 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2012 2419000 3046247
33790 33790 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   344905000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2021 725000 775234
33791 33791 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   344905000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2022 400000 400000
33792 33792 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   344905000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 1 Appropriated and Planned 2023 1000000 953798
33793 33793 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   344905000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2022 430000 430000
33794 33794 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   344905000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2023 430000 410133
33795 33795 608 PHL Philippines 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Philippines 3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 39 Department of State and U.S. Agency for International Development State/USAID   344905000 Budget for International Narcotics Control and Law Enforcement Budget for International Narcotics Control and Law Enforcement 18 President's Budget Requests 2024 430000 400665

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