This dataset has the following 61 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| row_id | row_id | number | 513907 510955 510182 19106 571143 view top 100 |
| source | source | text | COWASH Ministry of Water Irrigation and Electricity, Ethiopia Farta Water Office Dera Water Office CARE Ethiopia view top 100 |
| lat_deg | lat_deg | number | 11.88138316 11.4 11.31 11.8659794 7.98422779 view top 100 |
| lon_deg | lon_deg | number | 37.80532837 37.08 37.21 37.88678169 37.2 view top 100 |
| report_date | report_date | calendar_date | 2021-01-01T00:00:00.000 2020-07-12T00:00:00.000 2012-07-12T00:00:00.000 2019-05-04T00:00:00.000 2009-07-12T00:00:00.000 view top 100 |
| status_id | status_id | text | Yes No Unknown view top 100 |
| water_source | water_source | text | Hand dug well Protected spring Unprotected Birka HDW Well view top 100 |
| water_source_clean | water_source_clean | text | Protected Well Undefined Shallow Well Borehole Protected Spring Undefined Spring view top 100 |
| water_tech | water_tech | text | Aferdive pump Hand Dug Well Afridev None Spot Spring view top 100 |
| water_tech_clean | water_tech_clean | text | Hand Pump Hand Pump - Afridev Mechanized Pump Rope and Bucket Hand Pump - India Mark view top 100 |
| country_name | country_name | text | Ethiopia view top 100 |
| clean_country_name | clean_country_name | text | Ethiopia view top 100 |
| adm1 | adm1 | text | Amhara Somali Region Oromia SNNP Benishangul-Gumuz view top 100 |
| clean_adm1 | clean_adm1 | text | Amhara Somali Oromia Southern Nations, Nationalities and Peoples Benshangul-Gumaz view top 100 |
| adm2 | adm2 | text | West Gojam East Gojam South Gondar North Gondar Debub Gondar view top 100 |
| clean_adm2 | clean_adm2 | text | Debub Gondar Mirab Gojjam Semen Gondar Misraq Gojjam Metekel view top 100 |
| adm3 | adm3 | text | Farta Dera Quarit North Mecha Gonjqolola view top 100 |
| clean_adm3 | clean_adm3 | text | Farta Dera Yilmana Densa East Esite East Belesa view top 100 |
| activity_id | activity_id | text | a6sg3lyy a6vnlpb7 6xxqcme8 a6vo74wz 73abhd00 view top 100 |
| scheme_id | scheme_id | text | Hand dug well Hdw Gurie Enikuwakuba FTC view top 100 |
| install_year | install_year | number | 2007 2008 2009 2010 2006 view top 100 |
| installer | installer | text | MWA-CARE Community managed project/CMP/ CMP CARE World Vision view top 100 |
| rehab_year | rehab_year | text | view top 100 |
| rehabilitator | rehabilitator | text | view top 100 |
| management | management | text | Community Management WASH co Managed WASHCO No management organisation Oxfam GB view top 100 |
| pay | pay | text | Yes No No payment Fixed tariff per visit Fixed tariff per month view top 100 |
| status | status | text | functional Broken Not enough water non functional Poor management view top 100 |
| fecal_coliform_presence | fecal_coliform_presence | text | Absent Present view top 100 |
| fecal_coliform_value | fecal_coliform_value | text | 1 view top 100 |
| subjective_quality | subjective_quality | text | Within National limits (potable) view top 100 |
| notes | notes | text | East Belesa West Belesa Kanat Awuzet Zara view top 100 |
| orig_lnk | orig_lnk | text | https://cowashdb.org/ view top 100 |
| photo_lnk | photo_lnk | url | view top 100 |
| lat_lon_deg | lat_lon_deg | text | (11.88138316°, 37.80532837°) (11.8659794°, 37.994283°) (7.98422779°, 43.02029884°) (5.55703761°, 44.32162646°) (5.44058237°, 44.43844277°) view top 100 |
| country_id | country_id | text | ET ETH view top 100 |
| converted | converted | text | #water_source #lat_deg, #lon_deg, #status_id, #water_tech #country_id, #install_year #install_year #report_date, #data_lnk, #status_id view top 100 |
| wpdx_id | wpdx_id | text | 7H32PXGH+79X 6HW57P7M+9X7 6HR5HR6C+R52 7G3VMH6V+HCW 7G4VFQ7V+MP2 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 | ETH view top 100 |
| facility_type | facility_type | text | Improved Unknown view top 100 |
| distance_to_primary | distance_to_primary | number | 55445.4652 152308.7201 22429.40827 152557.9398 3232.602589 view top 100 |
| distance_to_secondary | distance_to_secondary | number | 49831.41222 79226.46049 128.9046078 8379.861006 79531.22979 view top 100 |
| distance_to_tertiary | distance_to_tertiary | number | 5772.929566 81567.77666 418.9750635 7426.145864 81863.9721 view top 100 |
| distance_to_city | distance_to_city | number | 55450.30358 152820.9766 35642.55349 153074.0029 10597.74886 view top 100 |
| distance_to_town | distance_to_town | number | 9334.373012 81499.26591 32088.50771 674.7577743 81795.68728 view top 100 |
| location_id | location_id | number | 502688 503151 17541 163152 163148 view top 100 |
| cluster_size | cluster_size | number | 1 2 3 4 6 view top 100 |
| created_timestamp | created_timestamp | calendar_date | 2021-02-19T00:03:00.000 2020-08-07T18:33:00.000 2020-09-10T00:37:00.000 2021-02-20T14:53:00.000 2021-02-20T15:21:00.000 view top 100 |
| updated | updated | calendar_date | 2021-02-19T00:03:00.000 2020-08-07T18:33:00.000 2020-09-10T00:37:00.000 2021-02-20T14:53:00.000 2021-02-20T15:21:00.000 view top 100 |
| count | count | number | 1 view top 100 |
| water_tech_original | water_tech_original | text | hdw with hand pump aferdive pump hand pump non-mechanized borehole rope view top 100 |
| water_source_original | water_source_original | text | well non-mechanized borehole borehole hand dug well mechanized borehole view top 100 |
| lat_deg_original | lat_deg_original | text | view top 100 |
| lon_deg_original | lon_deg_original | text | view top 100 |
| management_clean | management_clean | text | Community Management No Management view top 100 |
| management_original | management_original | text | community management no management organisation view top 100 |
| water_source_category | water_source_category | text | Well Spring view top 100 |
| is_latest | is_latest | checkbox | true false view top 100 |
| water_tech_category | water_tech_category | text | Hand Pump Mechanized Pump Rope and Bucket Hand pump Tapstand view top 100 |
| Location | location | point | {"coordinates":[37.80532837,11.88138316],"type":"Point"} {"coordinates":[37.994283,11.8659794],"type":"Point"} {"coordinates":[43.02029884,7.98422779],"type":"Point"} {"coordinates":[44.32162646,5.55703761],"type":"Point"} {"coordinates":[36.5848159790039,5.93843592078299],"type":"Point"} view top 100 |