./us_foreign_budget_complete

29 rows where Activity ID = 345169000, Income Group Name = "Lower Middle Income Country" and International Sector Name = "Water Supply and Sanitation"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country ID, Transaction Type ID, Transaction Type Name, Fiscal Year, current_amount

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
2767 2767 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 1600000 2237016
2768 2768 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 6848000 9318874
2769 2769 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 7000000 9331110
2770 2770 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 2815000 3714691
2771 2771 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 4000000 5232911
2772 2772 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 3930000 5039765
2773 2773 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 2956000 3722491
2774 2774 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 1568000 1865277
2775 2775 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 2417000 2824806
2776 2776 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 1662000 1897857
2777 2777 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 2821000 3159450
2778 2778 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 2020 1300000 1436800
2779 2779 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 18 President's Budget Requests 2008 5000000 6665079
2780 2780 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 18 President's Budget Requests 2010 3000000 3924683
2781 2781 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 18 President's Budget Requests 2011 3000000 3847149
2782 2782 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 18 President's Budget Requests 2012 4000000 5037200
2783 2783 50 BGD Bangladesh 4 South and Central Asia 2 Lower Middle Income Country LMIC 57 SCA South and Central Asian Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 18 President's Budget Requests 2013 3000000 3710007
4269 4269 68 BOL Bolivia 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 1568000 2192275
4270 4270 68 BOL Bolivia 6 Western Hemisphere 2 Lower Middle Income Country LMIC 58 WHA Western Hemisphere Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 2005000 2728438
13975 13975 288 GHA Ghana 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 1650000 2306922
13976 13976 288 GHA Ghana 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 1300000 1769062
17395 17395 360 IDN Indonesia 1 East Asia and Oceania 2 Lower Middle Income Country LMIC 54 EAP East Asian and Pacific Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 5000000 6804085
26253 26253 478 MRT Mauritania 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 2705000 3781955
37978 37978 716 ZWE Zimbabwe 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 381000 462229
37979 37979 716 ZWE Zimbabwe 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 1242000 1489714
37980 37980 716 ZWE Zimbabwe 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 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 2020 1100000 1215754
37981 37981 716 ZWE Zimbabwe 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 18 President's Budget Requests 2015 766000 918777
37982 37982 716 ZWE Zimbabwe 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 18 President's Budget Requests 2016 766000 911226
37983 37983 716 ZWE Zimbabwe 5 Sub-Saharan Africa 2 Lower Middle Income Country LMIC 53 AF African Affairs   2 Health and Population 140 Water Supply and Sanitation 14020 Water supply and sanitation - large systems 3 Health 18 Water Supply and Sanitation 5 Department of Agriculture AGR   345169000 Budget for Public Law 480 Title II Grants Budget for Public Law 480 Title II Grants 18 President's Budget Requests 2017 766000 895243

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