home / 2025-02-03_foreign-assistance

./us_foreign_budget_complete

7 rows where current_amount = 343000

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Region ID, Region Name, Income Group ID, Income Group Name, Income Group Acronym, Managing Sub-agency or Bureau ID, Managing Sub-agency or Bureau Name, International Sector Code

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 Account ID Funding Account 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
2633 2633 44 BHS Bahamas 6 Western Hemisphere 4 High Income Country HIC 998   Unknown - Budget Data   3 Governance 160 Other Social Infrastructure and Services 16063 Narcotics control 1 Peace and Security 4 Counter-Narcotics 97xB001 Department of Defense - Unknown Funding Account 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 343000 431940
13580 13580 275 PSE West Bank and Gaza 3 Middle East and North Africa 2 Lower Middle Income Country LMIC 56 NEA Near Eastern Affairs West Bank and Gaza 3 Governance 151 Government and Civil Society 15150 Democratic participation and civil society 2 Democracy, Human Rights, and Governance 10 Civil Society 72x1027 Agency for International Development, International Assistance Program, Transition Initiatives 39 Department of State and U.S. Agency for International Development State/USAID   345186000 Budget for Transition Initiatives, International Assistance Program Budget for Transition Initiatives, International Assistance Program 1 Appropriated and Planned 2006 343000 479560
32542 32542 600 PRY Paraguay 6 Western Hemisphere 3 Upper Middle Income Country UMIC 998   Unknown - Budget Data Paraguay 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 11x1081 International Military Education and Training 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 2022 343000 343000
36319 36319 694 SLE Sierra Leone 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs Sierra Leone 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 11x1081 International Military Education and Training 39 Department of State and U.S. Agency for International Development State/USAID   345038000 Budget for International Military Education and Training Budget for International Military Education and Training 1 Appropriated and Planned 2013 343000 424177
40902 40902 780 TTO Trinidad and Tobago 6 Western Hemisphere 4 High Income Country HIC 58 WHA Western Hemisphere Affairs Trinidad and Tobago 3 Governance 152 Conflict, Peace, and Security 15210 Security system management and reform 1 Peace and Security 3 Stabilization Operations and Security Sector Reform 11x1081 International Military Education and Training 39 Department of State and U.S. Agency for International Development State/USAID   345038000 Budget for International Military Education and Training Budget for International Military Education and Training 1 Appropriated and Planned 2017 343000 400872
53464 53464 1002 WLD World 7 World       63 IO International Organization Affairs IO - Monitoring and Evaluation 1 Education 114 Post-Secondary Education 11420 Higher education 4 Education and Social Services 21 Higher Education 19x1005 Department of State, International Organizations and Programs 39 Department of State and U.S. Agency for International Development State/USAID   345060000 Budget for International Organizations and Programs, State - IO - Monitoring and Evaluation Budget for International Organizations and Programs, State - IO - Monitoring and Evaluation 1 Appropriated and Planned 2016 343000 408029
61393 61393 1023 MNS Middle East and North Africa Region 3 Middle East and North Africa       998   Unknown - Budget Data Middle East Regional (USAID) 3 Governance 151 Government and Civil Society 15150 Democratic participation and civil society 2 Democracy, Human Rights, and Governance 10 Civil Society 72x1037 Economic Support Fund 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 2021 343000 366766

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
);
Powered by Datasette · Queries took 4704.333ms