./us_foreign_budget_complete

15 rows where Country ID = 598, Fiscal Year = 2023 and Region Name = "East Asia and Oceania"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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 Account ID, Funding Account Name, Activity ID, Activity Name, Activity Description, Transaction Type ID, Transaction Type Name, current_amount, 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
32313 32313 598 PNG Papua New Guinea 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Papua New Guinea 2 Health and Population 122 Basic Health 12250 Infectious disease control 3 Health 14 Pandemic Influenza and Other Emerging Threats (PIOET) 39 Department of State and U.S. Agency for International Development State/USAID   344902000 Budget for Global Health Programs - USAID Budget for Global Health Programs - USAID 1 Appropriated and Planned 2023 4000000 3815194
32316 32316 598 PNG Papua New Guinea 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Papua New Guinea 2 Health and Population 134 HIV/AIDS 13040 STD control including HIV/AIDS 3 Health 11 HIV/AIDS 39 Department of State and U.S. Agency for International Development State/USAID   344901000 Budget for Global Health Programs - State Budget for Global Health Programs - State 1 Appropriated and Planned 2023 5095000 4859603
32318 32318 598 PNG Papua New Guinea 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Papua New Guinea 2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2023 2600000 2479876
32320 32320 598 PNG Papua New Guinea 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Papua New Guinea 3 Governance 151 Government and Civil Society 15150 Democratic participation and civil society 2 Democracy, Human Rights, and Governance 8 Good Governance 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2023 750000 715349
32322 32322 598 PNG Papua New Guinea 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Papua New Guinea 3 Governance 151 Government and Civil Society 15150 Democratic participation and civil society 2 Democracy, Human Rights, and Governance 10 Civil Society 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2023 1000000 953798
32324 32324 598 PNG Papua New Guinea 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Papua New Guinea 3 Governance 151 Government and Civil Society 15150 Democratic participation and civil society 2 Democracy, Human Rights, and Governance 10 Civil Society 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2023 750000 715349
32332 32332 598 PNG Papua New Guinea 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Papua New Guinea 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   344904000 Budget for International Military Education and Training Budget for International Military Education and Training 1 Appropriated and Planned 2023 441000 420625
32334 32334 598 PNG Papua New Guinea 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Papua New Guinea 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 39 Department of State and U.S. Agency for International Development State/USAID   344904000 Budget for International Military Education and Training Budget for International Military Education and Training 18 President's Budget Requests 2023 450000 429209
32339 32339 598 PNG Papua New Guinea 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Papua New Guinea 4 Infrastructure 210 Transport and Storage 21010 Transport policy and administrative management 5 Economic Development 28 Infrastructure 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2023 640000 610431
32342 32342 598 PNG Papua New Guinea 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Papua New Guinea 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2023 7200000 6867348
32344 32344 598 PNG Papua New Guinea 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Papua New Guinea 7 Other 410 General Environmental Protection 41010 Environmental policy and administrative management 6 Environment 44 Environment 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2023 12830000 12237233
32347 32347 598 PNG Papua New Guinea 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Papua New Guinea 7 Other 410 General Environmental Protection 41030 Bio-diversity 6 Environment 35 Natural Resources and Biodiversity 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 1 Appropriated and Planned 2023 3500000 3338294
32349 32349 598 PNG Papua New Guinea 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Papua New Guinea 7 Other 410 General Environmental Protection 41030 Bio-diversity 6 Environment 35 Natural Resources and Biodiversity 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2023 12000000 11445581
32351 32351 598 PNG Papua New Guinea 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Papua New Guinea 7 Other 410 General Environmental Protection 41030 Bio-diversity 6 Environment 35 Natural Resources and Biodiversity 39 Department of State and U.S. Agency for International Development State/USAID   344898000 Budget for Economic Support Fund Budget for Economic Support Fund 1 Appropriated and Planned 2023 2000000 1907597
32353 32353 598 PNG Papua New Guinea 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 998   Unknown - Budget Data Papua New Guinea 7 Other 430 Other Multisector 43010 Multisector aid 9 Multi-sector 52 Multi-sector - Unspecified 39 Department of State and U.S. Agency for International Development State/USAID   344897000 Budget for Development Assistance Budget for Development Assistance 18 President's Budget Requests 2023 1280000 1220862

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