Trying to Roll Up by Date

data.waterpointdata.org | Last Updated 26 Jan 2016

The Water Point Data Exchange (WPDx) is the global platform for sharing water point data. The WPDx data standard was designed by a wide range of stakeholders from across sectors and around the world. The core attributes included in the Water Point Data Exchange are already being collected by governments, researchers, and organizations around the world. To read more about the standard or to contribute water point data visit www.waterpointdata.org.

This dataset has the following 24 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Row IDrow_idnumber
#country_namecountry_nametext
#water_sourcewater_sourcetext
#water_techwater_techtext
#status_idstatus_idtext
#managementmanagementtext
#paypaytext
#installerinstallertext
#install_yearinstall_yearnumber
#statusstatustext
#sourcesourcetext
#adm1adm1text
#adm2adm2text
#wpdx_idwpdx_idtext
#country_idcountry_idtext
#activity_idactivity_idtext
#data_lnkdata_lnkurl
#orig_lnkorig_lnkurl
photo_lnkphoto_lnkurl
#convertedconvertedtext
#lat_deglat_degnumber
#lon_deglon_degnumber
Locationlocationlocation
Countcountnumber1 count per record