./us_foreign_budget_complete

15 rows where Country ID = 4, Income Group ID = 1 and International Sector Code = 720

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: International Purpose Code, US Sector Name, Funding Account ID, Funding Account Name, Funding Agency ID, Funding Agency Name, Funding Agency Acronym, Transaction Type ID, Transaction Type Name, Fiscal Year

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
20 20 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian 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 60031000 83931429
21 21 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian 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 29996000 40819065
22 22 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian 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 68106000 90786372
23 23 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian 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 25553000 33719892
24 24 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian 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 42630000 55769748
25 25 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian 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 108913000 139668168
26 26 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian 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 58648000 73855426
27 27 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian 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 41037000 50749184
28 28 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian 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 59503000 72188948
29 29 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian 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 52408000 62860648
30 30 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian 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 27000000 32118931
31 31 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian 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 33957000 44809861
32 32 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian 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 30000000 40824508
1035 1035 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 57 SCA South and Central Asian Affairs Afghanistan 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   344985000 Budget for Economic Support Fund Budget for Economic Support Fund 18 President's Budget Requests 2009 10000000 13196060
1060 1060 4 AFG Afghanistan 4 South and Central Asia 1 Low Income Country LIC 998   Unknown - Budget Data   9 Humanitarian 720 Emergency Response 72010 Material relief assistance and services 7 Humanitarian Assistance 51 Humanitarian Assistance - General 7 Department of Defense DOD   345192000 Budget for Unknown Department of Defense Account Budget for Unknown Department of Defense Account 1 Appropriated and Planned 2013 1670000 2065237

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