This dataset has the following 61 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
row_id | row_id | number | 147077 83970 141747 105796 163069 view top 100 |
source | source | text | Ministry of Water and Environment, Uganda Evidence Action C & D Ugandan Water Project Lifeline view top 100 |
lat_deg | lat_deg | number | 0.093601667 -0.6476041 -0.68506888 -0.55907571 -0.68642845 view top 100 |
lon_deg | lon_deg | number | 30.36568472 32.97693214 30.13616719 31.79705782 30.0307442 view top 100 |
report_date | report_date | calendar_date | 2010-04-29T00:00:00.000 2010-04-21T00:00:00.000 2010-04-22T00:00:00.000 2010-04-28T00:00:00.000 2010-04-30T00:00:00.000 view top 100 |
status_id | status_id | text | Yes No Unknown view top 100 |
water_source | water_source | text | Deep borehole Protected spring Shallow well Rainwater Harvest Tank Public Stand Post view top 100 |
water_source_clean | water_source_clean | text | Borehole Protected Shallow Well Protected Well Piped Water Protected Spring view top 100 |
water_tech | water_tech | text | Manual (hand pump) Pump India Mark II None hand_pump view top 100 |
water_tech_clean | water_tech_clean | text | Tapstand Hand Pump Kiosk Mechanized Pump Hand Pump - India Mark view top 100 |
country_name | country_name | text | Uganda view top 100 |
clean_country_name | clean_country_name | text | Uganda view top 100 |
adm1 | adm1 | text | WAKISO MBARARA KABALE KASESE ARUA view top 100 |
clean_adm1 | clean_adm1 | text | Mbarara Mbale Wakiso Bushenyi Apac view top 100 |
adm2 | adm2 | text | BUSIRO BUKONZO RWAMPARA BUKOTO KASHARI view top 100 |
clean_adm2 | clean_adm2 | text | Busiiro Rwampara Bubulo Bufumbira Bukonjo view top 100 |
adm3 | adm3 | text | Nkoma Busiriba Ntara Kahunge Nyabani view top 100 |
clean_adm3 | clean_adm3 | text | Kacheche Rukoni Nyakayojo Bwera Bwambara view top 100 |
activity_id | activity_id | text | 0 84 398 628 197 view top 100 |
scheme_id | scheme_id | text | BWERA GFS NWSC LUKAYA WATER AND SEWERAGE SYST KAMWENGE TOWN WATER SUPPLY RWENGYENYI view top 100 |
install_year | install_year | number | 2007 2008 2009 2004 2005 view top 100 |
installer | installer | text | Ugandan Water Project World Vision Ugandan Water Project (rehabilitation) other local_govt view top 100 |
rehab_year | rehab_year | text | view top 100 |
rehabilitator | rehabilitator | text | view top 100 |
management | management | text | Community Management Institutional Management Private Operator/Delegated Management water_committee Other view top 100 |
pay | pay | text | Water Committee Collects Fees No tarrif There is a tarrif of 1000 paid Per Month No Yes view top 100 |
status | status | text | Functional Non-Functional Functional (not in use) Decommissioned Improved source, Water is available, Water point has no problem view top 100 |
fecal_coliform_presence | fecal_coliform_presence | text | Absent view top 100 |
fecal_coliform_value | fecal_coliform_value | number | 0 100 30 10 20 view top 100 |
subjective_quality | subjective_quality | text | Good GOOD SALTY SAFE POOR view top 100 |
notes | notes | text | Namunyu Nabar Walumbe Mulukhu Loodoi view top 100 |
orig_lnk | orig_lnk | text | view top 100 |
photo_lnk | photo_lnk | url | view top 100 |
lat_lon_deg | lat_lon_deg | text | (2.19748198°, 32.97693214°) (1.71512136°, 33.71826098°) (3.10604457°, 32.91547315°) (2.24115858°, 33.09887538°) (0.27607091°, 31.98018141°) view top 100 |
country_id | country_id | text | UG UGA view top 100 |
converted | converted | text | #lat_deg, #lon_deg, #status_id, #pay, #management #photo, #status, #water_tech #country_id, #install_year #install_year #report_date, #data_lnk, #status_id view top 100 |
wpdx_id | wpdx_id | text | 6GFGVXJX+RHP 6GFHR95H+MQQ 6GGG9GXH+843 6GGM9Q6H+4CC 6GGJPCF7+3V7 view top 100 |
data_lnk | data_lnk | url | view top 100 |
public_data_source | public_data_source | url | view top 100 |
clean_country_id | clean_country_id | text | UGA view top 100 |
facility_type | facility_type | text | Improved Unknown view top 100 |
distance_to_primary | distance_to_primary | number | 1013.909568 30077.62701 1020.910511 7425.746521 1026.031792 view top 100 |
distance_to_secondary | distance_to_secondary | number | 14600.11722 3303.46132 14588.21007 4607.097909 14590.52257 view top 100 |
distance_to_tertiary | distance_to_tertiary | number | 8114.758483 1702.059722 8126.457723 8123.588029 2601.155519 view top 100 |
distance_to_city | distance_to_city | number | 27526.61983 32367.933 27515.55264 27519.45431 10439.19713 view top 100 |
distance_to_town | distance_to_town | number | 6409.842836 28920.69499 6407.6019 32164.55583 6414.80389 view top 100 |
location_id | location_id | number | 102935 20421 87515 102962 43080 view top 100 |
cluster_size | cluster_size | number | 1 2 3 4 5 view top 100 |
created_timestamp | created_timestamp | calendar_date | 2021-07-12T09:01:00.000 2020-09-30T18:08:00.000 2020-10-01T17:10:00.000 2020-10-12T19:12:00.000 2020-09-30T20:47:00.000 view top 100 |
updated | updated | calendar_date | 2021-07-12T09:01:00.000 2020-09-30T18:08:00.000 2020-10-01T17:10:00.000 2020-10-12T19:12:00.000 2020-09-30T20:47:00.000 view top 100 |
count | count | number | 1 view top 100 |
water_tech_original | water_tech_original | text | public stand post yard tap for public use manual (hand pump) pump kiosk view top 100 |
water_source_original | water_source_original | text | boreholes borehole protected shallow well non-mechanized borehole protected deep borehole view top 100 |
lat_deg_original | lat_deg_original | number | 0.314183333 -0.158589337 -0.158078914 -0.15737098 -0.15691408 view top 100 |
lon_deg_original | lon_deg_original | number | 30.41213667 30.25720352 30.25806 30.25842667 30.25844667 view top 100 |
management_clean | management_clean | text | Community Management Other Institutional Management Private Operator/Delegated Management Other Direct Government Operation view top 100 |
management_original | management_original | text | community management institutional management private operator/delegated management other water_committee view top 100 |
water_source_category | water_source_category | text | Well Piped Water Spring Rainwater Harvesting view top 100 |
is_latest | is_latest | checkbox | true false view top 100 |
water_tech_category | water_tech_category | text | Tapstand Hand Pump Mechanized Pump view top 100 |
Location | location | point | {"coordinates":[30.3656847222222,0.093601666666667],"type":"Point"} {"coordinates":[32.97693214,2.19748198],"type":"Point"} {"coordinates":[33.09887538,2.24115858],"type":"Point"} {"coordinates":[32.91547315,3.10604457],"type":"Point"} {"coordinates":[33.71826098,1.71512136],"type":"Point"} view top 100 |