Monitoring of Indicator Bacteria in Drinking Water

Public Utilities Updated Apr 17, 2026 Daily

About this dataset

Results of tests on drinking water for indicator bacteria, including fecal coliform and E. coli

Get the data

Browse the table below for all files available for this dataset

Data Downloads

File name Download actions File Format File size
Latest Drinking Water Tests (Bacteria) Download

Copy URL

CSV

All Drinking Water Tests (Bacteria) Download

Copy URL

CSV

View a data sample

Showing 1 transposed sample row. Download the full dataset or a view to get the data.

Data Sample

Data preview - first row of dataset transposed
Field Sample Value
date_sampled2026-04-16
source185 SYS
sample_idW1904450
t_coliform
cl2_total3.1
e_coli
temperature20.4
ph8.26

Understand the data

Each field in the data is defined in the table below. Use this information to inform usage of the data.

Download dictionary

Data Dictionary

Data dictionary - field definitions for this dataset
fielddescriptionpossible_values
sample_dateDate sample was taken
site_IDUnique identifier for the sample site
temp_celsiusTemperature in Celsius
chlorineChlorine in mg/l or ppm
pHpH of water sample0-14
coliformPresence of Coliform indicator bacteriaA-Absent, P-Present
E.coliPresence of E.coli indicator bacteriaA-Absent, P-Present

Dataset Details

  • PublisherPublic Utilities
  • Last Updated Apr 17, 2026
  • Update Frequency Daily
  • Date Issued May 11, 2016
  • Available Formats .CSV
  • License View License

Tags

References

Contact

Data & Analytics

data@sandiego.gov