A Singapore Government Agency Website

How to identify

Official website links end with .gov.sg

Government agencies communicate via .gov.sg websites (e.g. go.gov.sg/open). Trusted websites

Secure websites use HTTPS

Look for a lock () or https:// as an added precaution. Share sensitive information only on official, secure websites.

Scam alert

Government officers will never ask you to send money or share your details over the phone. When unsure, hang up and call Scamshield at 1799.

Waitlist for API key is now open. Register here for higher rate limits, priority support and maintenance notifications. Rate limits will be rolled out from 1 September 2025 onwards.

ACRA datasets are currently outdated, we’re working with the agency to restore this month’s update. LTA real-time APIs will be unavailable during scheduled maintenance from 12am to 6am on 18 Aug 2025.

Drinking water quality datasets

Data from Jan 2019 to Dec 2022

Last updated: 06 Jun 2024, 15:08 SGT

PUB (PUB, Singapore's national water agency)

Data explorer

Drinkingwaterqualitydatasets.csv (252 rows, 8.3 KB)

Year Year (YYYY)	Water quality parameter Text	Average value Text	Unit Text
(Null)0.0%	(Null)0.0%	(Null)0.0%	(Null)0.0%
2019	Escherichia coli (E. coli)	<1	cfu/100ml
2019	Colour	<5	Hazen
2019	Conductivity	200	uS/cm
2019	Odour	Unobjectionable	TON
2019	pH Value	8.1	Units
2019	Total Dissolved Solid	131	mg/L
2019	Turbidity	0.13	NTU
2019	Gross Alpha	0.043	Bq/L
2019	Gross Beta	0.1426	Bq/L
2019	Radon 222	<0.6	Bq/L

Column legend

Title	Column name	Data type	Unit of measure	Description
Year	year	Year (YYYY)	-	-
Water quality parameter	water_quality_parameter	Text	-	-
Average value	average_value	Text	-	-
Unit	unit	Text	-	-

Analyse this dataset with Colab Notebook

1. Copy this dataset ID: d_f397c39929978d3047e0e32430c6763b
2. Click on the button below

Sample OpenAPI query

This code can be used to test a sample API query. It retrieves the data catalogue of this dataset. For a complete guide on query parameters and syntax, please refer to the API documentation. Try it out on your browser to see the response schema.

import requests
          
dataset_id = "d_f397c39929978d3047e0e32430c6763b"
url = "https://data.gov.sg/api/action/datastore_search?resource_id="  + dataset_id 
        
response = requests.get(url)
print(response.json())

Citation

This dataset can be reused and cited in research publications.

PUB, Singapore's national water agency. (2017). Drinking water quality datasets (2024) [Dataset]. data.gov.sg. Retrieved August 17, 2025 from https://data.gov.sg/datasets/d_f397c39929978d3047e0e32430c6763b/view

About this dataset

Contact

feedback@data.gov.sg

Created on

25 May 2017

Licence

Free forever for personal or commercial use, under the Open Data Licence.

Agency

PUB (PUB, Singapore's national water agency)