./us_foreign_budget_complete

10 rows where Funding Account Name = "Agency for International Development, International Disaster Assistance" and Income Group Name = "Lower Middle Income Country"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: US Category ID, US Sector ID, US Sector 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
39138 39138 729 SDN Sudan 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Sudan (Pre-July 2011) 2 Health and Population 130 Maternal and Child Health, Family Planning 13020 Reproductive health care 3 Health 16 Maternal and Child Health 39 Department of State and U.S. Agency for International Development State/USAID   345028000 Budget for International Disaster and Famine Assistance Budget for International Disaster and Famine Assistance 1 Appropriated and Planned 2006 2000000 2796270
39190 39190 729 SDN Sudan 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Sudan (Pre-July 2011) 3 Governance 151 Government and Civil Society 15111 Public finance management 2 Democracy, Human Rights, and Governance 9 Political Competition and Consensus-Building 39 Department of State and U.S. Agency for International Development State/USAID   345028000 Budget for International Disaster and Famine Assistance Budget for International Disaster and Famine Assistance 1 Appropriated and Planned 2006 4000000 5592539
39207 39207 729 SDN Sudan 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Sudan (Pre-July 2011) 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   345028000 Budget for International Disaster and Famine Assistance Budget for International Disaster and Famine Assistance 1 Appropriated and Planned 2006 1000000 1398135
39222 39222 729 SDN Sudan 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Sudan (Pre-July 2011) 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   345028000 Budget for International Disaster and Famine Assistance Budget for International Disaster and Famine Assistance 1 Appropriated and Planned 2006 9000000 12583213
39293 39293 729 SDN Sudan 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Sudan (Pre-July 2011) 3 Governance 152 Conflict, Peace, and Security 15220 Civilian peace-building, conflict prevention and resolution 1 Peace and Security 6 Conflict Mitigation and Reconciliation 39 Department of State and U.S. Agency for International Development State/USAID   345028000 Budget for International Disaster and Famine Assistance Budget for International Disaster and Famine Assistance 1 Appropriated and Planned 2006 13750000 19224353
39309 39309 729 SDN Sudan 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Sudan (Pre-July 2011) 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   345028000 Budget for International Disaster and Famine Assistance Budget for International Disaster and Famine Assistance 1 Appropriated and Planned 2006 12250000 17127151
39330 39330 729 SDN Sudan 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Sudan (Pre-July 2011) 6 Agriculture 310 Agriculture 31110 Agricultural policy and administrative management 5 Economic Development 29 Agriculture 39 Department of State and U.S. Agency for International Development State/USAID   345028000 Budget for International Disaster and Famine Assistance Budget for International Disaster and Famine Assistance 1 Appropriated and Planned 2006 5500000 7689741
39358 39358 729 SDN Sudan 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Sudan (Pre-July 2011) 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   345028000 Budget for International Disaster and Famine Assistance Budget for International Disaster and Famine Assistance 1 Appropriated and Planned 2006 117490000 164266856
39359 39359 729 SDN Sudan 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Sudan (Pre-July 2011) 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   345028000 Budget for International Disaster and Famine Assistance Budget for International Disaster and Famine Assistance 18 President's Budget Requests 2008 113500000 151297290
39360 39360 729 SDN Sudan 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs Sudan (Pre-July 2011) 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 39 Department of State and U.S. Agency for International Development State/USAID   345034000 Budget for International Disaster and Famine Assistance, H.R. 2863 Supplemental Budget for International Disaster and Famine Assistance, H.R. 2863 Supplemental 1 Appropriated and Planned 2006 66300000 92696336

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