./us_foreign_budget_complete

21 rows where Country ID = 706, Income Group ID = 1 and International Sector Code = 720

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Activity ID, Activity Description

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
37165 37165 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2006 27377000 38276736
37166 37166 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2007 24701000 33613539
37167 37167 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2008 99170000 132195174
37168 37168 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2009 86148000 113681417
37169 37169 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2010 15003000 19627340
37170 37170 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2011 46489000 59616698
37171 37171 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2012 79943000 100672220
37172 37172 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2013 62898000 77784004
37173 37173 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2014 74218000 90041163
37174 37174 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2015 67732000 81240983
37175 37175 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2016 36607000 43547322
37176 37176 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2017 71957000 84097866
37177 37177 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2018 101776000 116219185
37178 37178 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 1 Appropriated and Planned 2019 123023000 137782696
37179 37179 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   345173000 Budget for Public Law 480 Title II Grants, Bridge Supplemental Budget for Public Law 480 Title II Grants, Bridge Supplemental 1 Appropriated and Planned 2009 37290000 49208108
37180 37180 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   345174000 Budget for Public Law 480 Title II Grants, H.R. 2206 Supplemental Budget for Public Law 480 Title II Grants, H.R. 2206 Supplemental 1 Appropriated and Planned 2007 10000000 13608169
37181 37181 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   345176000 Budget for Public Law 480 Title II Grants, H.R. 2863 Supplemental Budget for Public Law 480 Title II Grants, H.R. 2863 Supplemental 1 Appropriated and Planned 2006 54000000 75499278
37182 37182 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 53 AF African Affairs   9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR 1 345172000 Budget for Public Law 480 Title II Grants - Overseas Contingency Operations (OCO) Budget for Public Law 480 Title II Grants - Overseas Contingency Operations (OCO) 1 Appropriated and Planned 2017 30187000 35280268
37586 37586 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Somalia 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2021 32620000 34880161
37587 37587 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Somalia 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2022 25893000 25893000
37588 37588 706 SOM Somalia 5 Sub-Saharan Africa 1 Low Income Country LIC 998   Unknown - Budget Data Somalia 9 Humanitarian 720 Emergency Response 72050 Relief co-ordination; protection and support services 7 Humanitarian Assistance 37 Protection, Assistance and Solutions 5 Department of Agriculture AGR   344899000 Budget for Food for Peace Title II Budget for Food for Peace Title II 1 Appropriated and Planned 2023 47536000 45339760

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