home / 2025-02-03_foreign-assistance

./us_foreign_budget_complete

6 rows where Funding Account ID = "19x1121", Funding Agency ID = 39 and Income Group Acronym = "UMIC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Operating Unit, International Purpose Code, US Sector ID

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
18164 18164 364 IRN Iran 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Iran 3 Governance 151 Government and Civil Society 15150 Democratic participation and civil society 2 Democracy, Human Rights, and Governance 10 Civil Society 19x1121 Department of State, Democracy Fund 39 Department of State and U.S. Agency for International Development State/USAID   344974000 Budget for Democracy Fund, Department of State, H.R. 2863 Supplemental Budget for Democracy Fund, Department of State, H.R. 2863 Supplemental 1 Appropriated and Planned 2006 20000000 27962696
18208 18208 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Iraq 3 Governance 151 Government and Civil Society 15111 Public finance management 2 Democracy, Human Rights, and Governance 9 Political Competition and Consensus-Building 19x1121 Department of State, Democracy Fund 39 Department of State and U.S. Agency for International Development State/USAID   344973000 Budget for Democracy Fund, Department of State, H.R. 2206 Supplemental Budget for Democracy Fund, Department of State, H.R. 2206 Supplemental 1 Appropriated and Planned 2007 151800000 206572012
18276 18276 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Iraq 3 Governance 151 Government and Civil Society 15150 Democratic participation and civil society 2 Democracy, Human Rights, and Governance 10 Civil Society 19x1121 Department of State, Democracy Fund 39 Department of State and U.S. Agency for International Development State/USAID   344973000 Budget for Democracy Fund, Department of State, H.R. 2206 Supplemental Budget for Democracy Fund, Department of State, H.R. 2206 Supplemental 1 Appropriated and Planned 2007 57500000 78246974
18323 18323 368 IRQ Iraq 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Iraq 3 Governance 151 Government and Civil Society 15160 Human rights 2 Democracy, Human Rights, and Governance 7 Rule of Law and Human Rights 19x1121 Department of State, Democracy Fund 39 Department of State and U.S. Agency for International Development State/USAID   344973000 Budget for Democracy Fund, Department of State, H.R. 2206 Supplemental Budget for Democracy Fund, Department of State, H.R. 2206 Supplemental 1 Appropriated and Planned 2007 40700000 55385250
22557 22557 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Lebanon 3 Governance 151 Government and Civil Society 15111 Public finance management 2 Democracy, Human Rights, and Governance 9 Political Competition and Consensus-Building 19x1121 Department of State, Democracy Fund 39 Department of State and U.S. Agency for International Development State/USAID   344973000 Budget for Democracy Fund, Department of State, H.R. 2206 Supplemental Budget for Democracy Fund, Department of State, H.R. 2206 Supplemental 1 Appropriated and Planned 2007 2500000 3402042
22608 22608 422 LBN Lebanon 3 Middle East and North Africa 3 Upper Middle Income Country UMIC 56 NEA Near Eastern Affairs Lebanon 3 Governance 151 Government and Civil Society 15150 Democratic participation and civil society 2 Democracy, Human Rights, and Governance 10 Civil Society 19x1121 Department of State, Democracy Fund 39 Department of State and U.S. Agency for International Development State/USAID   344973000 Budget for Democracy Fund, Department of State, H.R. 2206 Supplemental Budget for Democracy Fund, Department of State, H.R. 2206 Supplemental 1 Appropriated and Planned 2007 2500000 3402042

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 8584.791ms